manual cross tab 1

[inspi]

I'm using a manual cross tab for one of my reports. It has 11 columns including the total column. Some users need to see the report as
USer 0-1 2-3 4-5 6-7 8-9 10-11 >12......Total
user1 x x x x x x x x
user2 x x x x x x x x

Some users want it this way

USer 0-10 11-15 16-20 21-30 31-40 41-50 >50 ......Total
USerx x x x x x x x x
usery x x x x x x x x

Please help me with this. I think I need to create a parameter asking users to enter what type of report they need to see, is it first of kind or second kind. Didnt get any idea how to produce this kinf of report whether i should create 20+ formulas?

 

[Madawc]

Given the size of the difference, why not two reports? Or a report with a subtreport, placed in the report header or footer and a virtual copy of the main report, done by 'Save As' and re-import as a subreport to change. Then use the parameter to suppress one or the other.

Also which version of Crystal? In Crystal 10, you can create automatic Crosstabs that use a formula field, provided it only tests data based on individual detail lines.

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

 

[inspi]

I'm using CR v9. I tried using automatic cross tab. But its suppressing those columns which doesnt have any data to show for the user. if atlease one user has some data for a particular column then its displaying 0 otherwise if none of the users has nothing for a particular column then its suppressing that column.
Columns represent document age in days. so i had to use manual cross tab for this report. some users need to see document age over a 120 day period and some over a 18 day period.

 

[Madawc]

OK, use a report and subreport. I think that this will be easier than trying to get one report to do two very different things.

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

 

[synapsevampire]

Your notion of a parmeter makes sense to me, although it's not clear WHAT you are displaying.

Posting "if at lease one user has some data" doesn't mean anything. And theis "But its suppressing those columns which doesnt have any data to show for the user." doesn't make sense, one can't suppress what doesn't exist. You might be able to create zero rows for all users by using the proper joins or SQL, but you don't supply any technical information.

Successful posts tend to include:

Database/connectivity
Example data
Expected output

As a Crystal solution, you can create multiple sections by right clicking the sections and selecting insert section below.

Then suppress the appropriate sections based on the parameter.

I often create a single report for numerous layouts in this fashion.

-k

 

[lbass]

Expanding on the use of different sections, I would create two sets of formulas, using detail_a and detail_b sections (these will be suppressed anyway). One set will have intervals like:

//{@0-1}:
if {table.col} in 0 to 1 then {table.amt} //etc.

The other will have formulas like:
//{@0-10}:
if {table.col} in 0 to 10 then {table.amt} //etc.

Then insert summaries on all formulas, dragging one set into group footer_b. Then you can use a parameter {?interval} to conditionally suppress each group footer.

-LB

 

[inspi]

LB : Thanks a lot for your reply. I tried it and its working. I have to appreciate you, even though its not clear as snapsevampire mentioned, you got to know what I'm actually trying to say. Once again thanks a lot for your answer.
Madawc: I tried to insert a copy of the same report into the same report but I'm not able to get the required output as there are many columns and rows in the report. May be my approach isnt good. I will try it again but.