grouping data in a report footer

[Daniel Collison]

The detail section of a insurance claim report provides information related
to service procedure codes. Each procedure code has a Claim Status [Claim
Status 2] of 1 (allowed) or 3 (not allowed). The claim status data element
has a numeric data type (long integer).

I would like to summarize data in report footers by claim status. For
instance, I would like to show an unduplicated count of clients associated
with allowed claims and unallowed claims. I have created one query that
provides an unduplicated client count, by claim status, for each of the
procedure codes. Instead, do I need to set up two separate queries…on that
shows an unduplicated count for claim status 1 and a second for claim status
2...and then add the two separate fields/controls to the report? Is there an
easier way of doing this?

Any suggestions would be greatly appreciated.

 

[Allen Browne]

Depending on how you are sorting/grouping the report, you may be able to add
a text box the the Claim Status header section, and give it properties like
this:
Control Source =IIf([Claim Status] = 1, 1, 0)
Running Sum Over All
Visible No
Name txtStatus1RS

Then in the Report Footer, you could show a text box with Control Source:
=[txtStatus1RS]

The alternative would be to use a subreport in the Report Footer to show a
summary row for each status (or a pair of DCount() expression if there are
only 2.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...