Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Make Header Appear for 0 Check # Claims

Status
Not open for further replies.

mwake

Programmer
Feb 12, 2004
151
US
I'm using Crystal for Enterprise, so I have a universe as a data source. I've created a report that shows a statement of benefits for each check produced in a batch. The report is grouped by check number and claim id, with check line items in the detail section. There is one claim id per check Everything looks great for all claims with check numbers, but there are 3 checks at the beginning of the batch with a 0 check number. There were no benefits paid on these claims, so no check was produced. Since my report is grouped by check, the header displays info from the first claim and the detail section has the line items from all three checks. How do I get the report to display the header info for each of the 0 checks?? There must be a way to create a formula that compares check number and claim number(if previous check # = check number and previous claim # <> claim # then next page??)so that the report creates a separate page for the 3 0 check number claims. Can anyone help me out??
 
Can you create a formula which contains
[tt]{checknumber}&" "&{claimid}[/tt]
and group on that formula?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top