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

Cross-Tab Sum per Page

Status
Not open for further replies.
Sep 29, 2003
28
BY
I have two tables in MSSQLServer:
Sales
saleID Customer Pay currencyID SaleDate

and
Currency
CurrencyID CurrencyName

The report have to look like
(PH) SaleDate| Customer| CurrencyName1| CurrencyName2| CurrencyName3| ...
(Details) Date |Customer |AmountPayedinthisCurrency|
______________________________________________________
(PF) SumPerPage | Sum in currency1 | sum in currency2 | ...


I've created three subreports with crosstab and placed them :
firts to pageheader to show currencies names
second to detail section two show amount payed
third to pagefooter to sum amount payed in every currecny
the problem is :
third cross-tab shows sum for all report and i need to view the sum for every page
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top