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

group running total reverts back to 1 in drilldown details

Status
Not open for further replies.

pamaley

Technical User
Nov 19, 2008
5
US
My report [ver 9] is a 2 grouped drilldown (State-grp 1, County-grp 2, drilldown detail-Cities). The running total is actually a numbering list on the counties which starts over at 1 for each state. This list works fine however when the city drilldown detail is expanded the county's number reverts back to 1. Is there anyway to retain the county's number on the list when its city detail is expanded?
Here's the code:
In grp 1 footer; [WhilePrintingRecords;Global Numbervar s:= 0;]
In grp 2 header; [WhilePrintingRecords;global Numbervar s; s:= s + 1;]

Thank you for your help.
 
I wanted to add another question with this report. Whenever a city detail is expanded and it is more than 1 page, a blank page precedes it. This doesn't happen unless it's more than 1 page.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top