Summary Query in Report

[chris.williams]

Hello all got an interesting one here:

I have report which is a summary report of many different queries. What I need is a checklist of sorts (true/false results) based on counts of the detail sub-queries.

eg: Master Ticket record has no computers
Facility Ticket records have computers

I need a true/false flag on the master report that returns whether or not a computer was of a particular configuration (such as Windows, Linux, etc). So basically, if on the detail query something like this: iif(count(OS="Windows")>0,True,False). The problem I am running into is that the true/false field is not linked to a sub-query to get any numbers as it's part of the summary report, not a detail sub-query.



Thanks...

[June7]

Maybe do the counts in the subreport, try: Count(IIf([OS]="Windows",[OS],Null))

Then a textbox on main report can reference the subreport textbox to return a True or False if the value is >0.

[chris.williams]

Thanks for the reply. I guess that's what I need help with. How would one go about referring to a field in a sub report?

[June7]

Try:

=subreportcontainername.Forms.textboxname

I always name the subform/subreport container control different from the object it holds, like ctrDetails.