Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert dummy row in list ,cross tab report

Status
Not open for further replies.

aa44

Programmer
Oct 16, 2002
19
0
0
US
Hi ,

I have report like the following

dept name Jan Feb Mar ..... Dec

IT -- -- -- --
Finance
AUTO
Manufactu..

Here i would like to insert row between Finance and
Auto dept name and all the column values are o or null .
I am using cognos 6 series .. this i wanted to implemnet in
both list and cross tab reports

Thanks
Khanna


 
I'm afraid this is not possible, because impromptu is column based and displays only info from your database in the rows. As you probably noticed is it possible to add a column to your report "insert-calculation" point a position in your table and select value in your calculation box. Select string for null or number for 0.

and click OK than you'll see this value in a cloumn for every row.

Martijn
 
Thanks for your help .

Suppose if add dept name in the database level ,then report will pick it up randomly and it displays some where else . is there any way i could sort that row wherever i needed in the report .Could please help me out .

Regards
Khanna


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top