Newbie questions?

rbuser

Hi all,

I have been using Crystal Reports (yes please don't stone me) for the last 3
years and I am now checking out some other reporting solutions which has
lead me here.

One of the main frustations I have experienced with CR is trying to use its
Cross-Tab components to create reports that grow dynamically across the
page.

My question to you kind people is how effective does Report Builder handle
Cross-Tabs in reports? In particularly manipulating the Totals. (E.G. if my
Cross-Tab shows 2 amounts, say "Sales" and "Credit", throughout the cells
and in the Total fields can I add in another Total field to show the % of
"Credit" to "Sales") a sample might look like this:

Col-1 Col-2 Totals
StockA 100 200 300 <---- Sales
10 30 40 <---- Credit
StockB 350 75 425
50 10 60
Totals 450 275 725
60 40 100
13.3% 14.5% 13.8% <--- Extta Total column
showing Credit %


Thanks
Scott Kent-Collins

nicocizik

Hi Scott,

Unfortunately I do not believe what you want to accomplish can exactly be
done in ReportBuilder. There is an InsertRows method in the TppMatrix class
that allow you to add a row to a Crosstab component, but this row will act
as any other row in the Crosstab in that you will have to preprocess the
data that gets entered to the cells of the row to see anything. I would
recommend playing around with our CrossTab demos and see if you can find
something that may work as an alternative.

--