Print Page - urgent requirement on list report excel output

Title: urgent requirement on list report excel output
Post by: karthikeya on 17 Mar 2011 04:10:58 AM

hi guys,
i have a list report ( showing 20 records ), and the output format is EXCEL,
my requirement is i need to display my 20 records in 60 rows of my excel output, i need to display 2 blank rows between the records, i worked on crystal reports long back and i'm sure that this requirement can be solved using crystal reports. but this requrement needs to be solved using COGNOS.
thanks in adv...
karthi....

Title: Re: urgent requirement on list report excel output
Post by: Gopinath on 17 Mar 2011 06:32:21 AM

Unlock your report and insert a table with 2 rows into list column

Title: Re: urgent requirement on list report excel output
Post by: Arsenal on 17 Mar 2011 10:34:16 AM

Think Gopinath's solution will work, but you might also want to use White borders for the table cells (overall and the 2 individual rows) otherwise they will show up with the default borders in the Excel outout which won't look natural

Title: Re: urgent requirement on list report excel output
Post by: PRIT AMRIT on 18 Mar 2011 11:54:21 AM

I think, no need to used white border for table cell. By default the table would in dotted lines and in excel it would come OK...

Title: Re: urgent requirement on list report excel output
Post by: karthikeya on 20 Mar 2011 11:29:53 PM

thank you guys............. :) its working.......

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: karthikeya on 17 Mar 2011 04:10:58 AM