CrazyManiac
MIS
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
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