Newbie questions?
How well does FastReports handle CrossTabs? I am having problems in Crystal Reports is with CrossTabs and I wanted to know if FastReports can handle CrossTabs better.
My specific problem is getting multiple total fields in a CrossTab. Say I have a CrossTab showing the Stock sales for each Area and then shows Totals for Stock and Areas... this part can be easily created and shown like this:
Area1, Area2,..., AreaN, Totals
Stock1 100, 50,..., 50, 200
Stock2 200, 100,..., 100, 400
...
Stock3 75, 75,..., 50, 200
Total 375, 225,..., 200, 800
But I want a reporting application that can do the following... say I want to now show the total Credited Sales for each Area as a seperate Total and as a % of the totals sales... to show the following
Area1, Area2,..., AreaN, Totals
Stock1 100, 50,..., 50, 200
Stock2 200, 100,..., 100, 400
...
Stock3 75, 75,..., 50, 200
Total 375, 225,..., 200, 800
Credits 100, 75,...., 30, 205
% 26.7, 33.3,...., 15, 25.6
The above example would obviously sum the Sale and Credit Values, but only show the Sale value in the cells.
Can FastReports do this or can anyone suggest a reporting application that can do this?
Thankyou in advance
Scott Kent-Collins
My specific problem is getting multiple total fields in a CrossTab. Say I have a CrossTab showing the Stock sales for each Area and then shows Totals for Stock and Areas... this part can be easily created and shown like this:
Area1, Area2,..., AreaN, Totals
Stock1 100, 50,..., 50, 200
Stock2 200, 100,..., 100, 400
...
Stock3 75, 75,..., 50, 200
Total 375, 225,..., 200, 800
But I want a reporting application that can do the following... say I want to now show the total Credited Sales for each Area as a seperate Total and as a % of the totals sales... to show the following
Area1, Area2,..., AreaN, Totals
Stock1 100, 50,..., 50, 200
Stock2 200, 100,..., 100, 400
...
Stock3 75, 75,..., 50, 200
Total 375, 225,..., 200, 800
Credits 100, 75,...., 30, 205
% 26.7, 33.3,...., 15, 25.6
The above example would obviously sum the Sale and Credit Values, but only show the Sale value in the cells.
Can FastReports do this or can anyone suggest a reporting application that can do this?
Thankyou in advance
Scott Kent-Collins