Printing Reports with Multiples in Subreports

paddo2002 · Post by **paddo2002** » Wed Mar 25, 2009 5:21 am

This was an interesting one, that I cannot work out. In fact I am not sure how to even start on it.

I have a BO called Audits, which has an attribute called Auditors. This attribute allows you to select multiple Users from the list. '

I have a report, which is a basic "Printout" of Audits. Using multiple BOs I naturally made a subreport for the Users which will be in the Auditors attribute. It is a simple 1 line report with

Audits.Auditors.FirstName + ' ' +Audits.Auditors.LastName
and uses the query

FIND Users WHERE Users IN Audits.Auditors ORDER BY Users.LastName

I enter 2 different Users at data entry and print out, but when it prints I get the first user printed twice and no second User.

Can anyone tell me where to go from here?

Cheers
PM

tford · Post by **tford** » Wed Mar 25, 2009 12:20 pm

Does this help: http://www.awareim.com/forum/viewtopic. ... =subreport

paddo2002 · Post by **paddo2002** » Thu Mar 26, 2009 5:44 am

Hi Tom,
No that sounds very similar, but it didn't solve my problem. i am amazed how you can find these topics in the forum. I have terrible time using the search engine.

Cheers and thanks

PM