Percent of Total in Crosstab

rbuser

Is it possible to display a Percent of Total in a Crosstab report.

I would like to report multiple tests and the percent positive per test.

Example:

Test 1 Test 2
Total Pos %Pos Total Pos %Pos

10 2 20% 10 1 10%



Is this possible using the crosstab component?

Thanks in advance,

Andy

nicocizik

Hi Andy,

Unfortunately the CrossTab component does not contain any logic to make
these types of calculations. It should not be too difficult to create this
type of report manually either making the calculations inside your dataset
or using TppVariables to calculate the percentages. There are also a couple
good third party grid components available from our web site that you might
want to check out. They could be useful for the type of report you need to
create.

--

rbuser

ok. Im a another user......... But, following this case. Who can display 1,
2 or 3 totals in the same horizontal line?...

In the last example, i wil remark (in bold) my interest...

Test 1 Test 2
COL1 COL2, COL3, COL4 TOTAL_COLS COST TOTAL,
35 10 10 0 55 12.69
697.95




Note that Costo is a colum repeat bye each col, but it show at end (prior
that last colum). then, in the las colum, it show acumulative of field TOTAL
(TOTAL = COL * COST)

thanks.

nicocizik

Hi Ricardo,

Unfortunately this type of formatting is not supported in the TppCrossTab
component. You may try checking out Grid Pack by William Yu. It is a third
party addon to ReportBuilder and may have the features you need.

http://www.planit-tech.com/

--