Cross Tab Report, Lables for summary field
I am creating cross tab report in ASP.Net
for stock ledger. In row i have
select `Dept`, `Store` and in columns i have
selected `month`. Summry fields are
Opening_Stock,Net_Sales_Retails,Net_Sales,Pur chases, open_po, Purchase_returns,net transfer, shrinkage, Adjustments, Average_stock,stock_turns , Closing stock.
My report is working fine with all summary
fields monthwise.
But how can i insert the lables for all
summary fields. So that report should show me all lables with related data.
Please help me.
I tried all options.
Thanks in advance
It should look like this way
Jan Feb Mar YTD
Dept
Store 015
Opening stock 20 25 23 20
Net sales at retail 10 15 13 38
Net sales 8 12 11 31
Purchases 13 10 5 28
Open PO 0 0 5 5
Purchase returns 0 0 0 0
Net transfers 0 0 0 0
Shrinkage 0 0 0 0
Adjustments 0 0 0 0
Average stocks 23 24 20 19
Stock turns 0 .36 0.50 0.55 1.68
Closing stock 25 23 17 17
Store 015
Re: Cross Tab Report, Lables for summary field
Hi
I also faced the same problem .
I tried with Crystal Report 9, but could not find any solution for it ...I think there is no way to display labels over summary fields in cross tabs.
To solve my problem I finally converted my datatable in the form I was getting with cros tab and then used simple report.
After executing it looks like a cross tab report.