I have a Connections By Meter report. The report lists accounts that have been connected to a particular meter. The turn on dates for the accounts must be within parameters set by the user.
We are using XML for this report. The meter information is stored in D0, account information in D1 and account deposit information in D2. The accounts may have multiple deposits. Also, there is the possibility that the same account was connected to the same meter multiple times in the same day(lets call this a user error). Regardless of the error, if it was connected between the parameter dates, it needs to display on the report.
The problem I'm running into is Crystal wants to redisplay the Meter and Account information for each meter when an account has multiple D2s(deposits).
I remedied this by suppressing the detail when:
(not isnull({table.d2deposit})
and
{table.meternumber}=next({table.meternumber})
and
{table.accountnumber}=next({table.accontnumber})
and
The problem I'm having with this suppression formula is when I come accros a meter that has one of the errors or same account connected to the same meter on the same day, then it wants to suppress that as well. Can I get some insight please?
Thanks!