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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detail/Summary Reports

Status
Not open for further replies.

pvje

Programmer
Feb 19, 2003
6
US
I have a report that is grouped by CounterPartyIds (multiple counterparties in report). Each counterparty information is printed in the header followed by the detail information. If there is a change in one of the detail lines based on some criteris, it prints an asterisk next to this detail showing this line has been changed since the last printing. What I want to do is, for each counterparty, after (or before if this is easier) the total line, jump to a new page and print the changed lines only. I can get the queries, but I can't make a subreport work for me in this way. Can this be done??
example

CounterParty A
detail1
detail2
detail3 *
total CounterParty A
<page>
summary for CounterParty A
detail3
total for this page
<page>
CounterParty B
detail1
detail2
detail3
Total CounterParty B
No changed details to print

etc,etc,etc
Thanks in advance for any help :)



 
I doubt it. Certainly there's no way in code to tell the Report to do what you are asking. The only thing I can think of is to have two CounterParty Footers. Put your Total CounterParty in the first footer and put the subreport in the second one, with a pagebreak before the subreport (or possibly use the Force New Page property). To get the second footer you would just add the Field to the Field/Expression list in the Sorting and Grouping as second time and set the Footer property to Yes.

Paul
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top