COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: phani1979 on 01 Feb 2006 11:21:23 AM

Title: Insert Crosstab Cells in Crosstab Report
Post by: phani1979 on 01 Feb 2006 11:21:23 AM
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
Title: Re: Insert Crosstab Cells in Crosstab Report
Post by: bdybldr on 01 Feb 2006 11:44:29 AM
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.
Title: Re: Insert Crosstab Cells in Crosstab Report
Post by: phani1979 on 01 Feb 2006 12:50:02 PM
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
Title: Re: Insert Crosstab Cells in Crosstab Report
Post by: CoginAustin on 01 Feb 2006 03:29:00 PM
Click on your measure then click on the Create Footer or Create Header button
Title: Re: Insert Crosstab Cells in Crosstab Report
Post by: phani1979 on 01 Feb 2006 03:49:56 PM
Hai Austin

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

Thank u
sudhakar

Title: Re: Insert Crosstab Cells in Crosstab Report
Post by: CoginAustin on 01 Feb 2006 04:02:41 PM
I modified yours to add the totals to the top and bottom. I am not sure if this is what you want.
Title: Re: Insert Crosstab Cells in Crosstab Report
Post by: phani1979 on 02 Feb 2006 09:49:27 AM
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
Title: Re: Insert Crosstab Cells in Crosstab Report
Post by: CoginAustin on 02 Feb 2006 10:29:32 AM
Applaud me ! :)

Step by step
Click on one of your dimensions (column or row grouping)
Click the Create Header or Create Footer button
Title: Re: Insert Crosstab Cells in Crosstab Report
Post by: phani1979 on 02 Feb 2006 11:43:13 AM
Hey Autin
I done it. :),I had one more issue, let me post in forum  today... later.
Thank u again..
sudhakar