If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Insert Crosstab Cells in Crosstab Report

Started by phani1979, 01 Feb 2006 11:21:23 AM

Previous topic - Next topic

phani1979

Hai
How to Insert Crosstab cells in the corss tab report
I wanna insert in both columns and rows of crosstab
In the rows i wanna display one cell as crosstab footer

And to insert cells in columns of crosstab , to display it as aggregated data..

Help me guys
Sudhakar

bdybldr

Click the cell that you want to aggregate.  Click the summation (greek "E") button on the toolbar.  This will insert totals in your crosstab.

Can't really understand your requirements.  You can insert columns the same as a list report (drag and drop them in).  If this isn't what you're looking for, please provide more details.

phani1979

Hai
Let me clarify MySelf
I had crosstab
With rows --product line ,product type
columns as -- order year
Measures -- Returned Quantity..
I wanna insert a footer in rows of a crosstab..and (ex. In list report, we will select "Insert List row cells above" from
the structure menu of ReportStudio..
Like that is there any option  to cell b/w the rows of crosstab and the measures column
how can we do that
sudhakar

CoginAustin

Click on your measure then click on the Create Footer or Create Header button

phani1979

Hai Austin

Can u have look at the Specfications..Which i attached in the notepad

Thank u
sudhakar


CoginAustin

I modified yours to add the totals to the top and bottom. I am not sure if this is what you want.

phani1979

Hey Austin.
You did a great job, Thank u.. :o :o :)
I had see the report.
Inserted a crosstab, and unlocked the cells and when iam selecting the measures and selecting create footer option
it says"One of the object must be selected before You can create a header or footer"like"list column, crosstab level, page header,pagebody,page" now where can i select...???
Can u explain me how u did the crosstab..I prefer(step wise)
Once Again Thanku
Sudhakar

CoginAustin

Applaud me ! :)

Step by step
Click on one of your dimensions (column or row grouping)
Click the Create Header or Create Footer button

phani1979

Hey Autin
I done it. :),I had one more issue, let me post in forum  today... later.
Thank u again..
sudhakar