Crosstab & record selection

[draganss]

VS.Net 2002
builtin Crystal Reports
SQL
************************************

I have crosstab with data like this:

..... Col1 Col2 Col3 Total
_______________________________
Name_a 1 2 3 6
Name_b 2 5 7 14
Name_c 6 0 15 21
Name_d 0 12 22 34
_______________________________
Total 9 19 47 75

I would like to select(show) only records which row total
values are between 7 and 30.
In the example that would be rows 2 and 3.

Any sugestions?
Thank you.

Marin

 

[lbass]

Do you have the option of creating SQL expressions?

-LB

 

[draganss]

LB thanks for your response.

I don't have option for SQL expressions within CR.
Changing the "original" stored procedure which gives back my data would be my last resort.

I'm looking for a way to do this with data that I already have.

 

[Madawc]

You could do a subreport in report footer, saving the main report with a different name and then importing it as a subreport.

Get the 'look' of a crosstab with group totals, details suppressed. Groups can be suppressed, provided you use summary totals.

It will double the report run time, but may be the simplest solution.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You either need to change the stored procedure so that it returns the row totals directly or you need to create a manual crosstab.

-LB