I am using CR 8.5. I have a main report with 2 subreports that have exactly the same tables and selection criteria but group the data differently. Subreport 1 summarizes at Group 3 of the main report and subreport 2 summarizes at Group 1 of the main report. I want to eliminate duplicate records in all reports by using the formula (@ad price):
If Previous(ad.ad_id) = ad.ad_id
then 0
else ad.price
@ad price is then used in a number of other formulas.
This works fine in the main report but the subreports bring back blank information. If I remove the Previous function from the formulas in the subreports they return data but it includes the duplicate price.
Help!!!
If Previous(ad.ad_id) = ad.ad_id
then 0
else ad.price
@ad price is then used in a number of other formulas.
This works fine in the main report but the subreports bring back blank information. If I remove the Previous function from the formulas in the subreports they return data but it includes the duplicate price.
Help!!!