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!

Previous Function in Subreport

Status
Not open for further replies.

gtf

Programmer
Oct 1, 2002
16
CA
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!!!
 
Alter the suppression formula of the sections containing the subreports to:

{@ad price} = 0

-k
 
I don't understand what you mean. Could you explain it in more detail.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top