Hi,
I am trying to use Group record selection to narrow my results down to only those records whose sum of past due accounts + any adjustments > 25.
The code in the Group record selection formula is as follows:
- whileprintingrecords;
- shared currencyvar adjAmt;
- Sum ({@306090}, {@subNumber}) + adjAmt > 25.00
The problem is with adjAmt. adjAmt is a completley seperate subreport that queryies a different database. (as a side note: it can't be joined becuase I am in 8.5 and need a left join with a where clause. I have tried work arounds for this and none worked. This is the closest I have gotten with the subreport.) The problem is that some of my details disappear when I add the adjAmt to the Group record selection. I can't figure it out. The group record selection seems to be selecting the correct records, but I am missing some lines of my details.
Thanks,
Barb
I am trying to use Group record selection to narrow my results down to only those records whose sum of past due accounts + any adjustments > 25.
The code in the Group record selection formula is as follows:
- whileprintingrecords;
- shared currencyvar adjAmt;
- Sum ({@306090}, {@subNumber}) + adjAmt > 25.00
The problem is with adjAmt. adjAmt is a completley seperate subreport that queryies a different database. (as a side note: it can't be joined becuase I am in 8.5 and need a left join with a where clause. I have tried work arounds for this and none worked. This is the closest I have gotten with the subreport.) The problem is that some of my details disappear when I add the adjAmt to the Group record selection. I can't figure it out. The group record selection seems to be selecting the correct records, but I am missing some lines of my details.
Thanks,
Barb