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

To know how to have Running summary in crosstab

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Hi, I am trying to have a running sum count in a cross
tab report. Whenever I try it is going across with entire
block rather then single frame..

Please help me
 
not my own words - but this is an answer from a similar thread....


I think that you want a reset context on your running sum.
Suppose you do a running sum om quantities over several months. If you want the running sum to start again with each new month , the syntax will be:

RunningSum(<quantity>;<month>)

this resets the counter.

The column that does the running sum should be directly to the left or right of the quantity column.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top