Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Cognos_Jan2017 on 26 Oct 2017 10:19:19 AM

Title: "1" in LONG Column, of Row 1, Running Report to Excel
Post by: Cognos_Jan2017 on 26 Oct 2017 10:19:19 AM
Anyone encountered this?

After we run the Report, we just Delete Row 1.

Would be very cool if we can prevent that "1" in LONG column in Row 1 from occurring.

TIA, Bob
Title: Re: "1" in LONG Column, of Row 1, Running Report to Excel
Post by: MFGF on 26 Oct 2017 11:26:50 AM
Quote from: Cognos_Jan2017 on 26 Oct 2017 10:19:19 AM
Anyone encountered this?

After we run the Report, we just Delete Row 1.

Would be very cool if we can prevent that "1" in LONG column in Row 1 from occurring.

TIA, Bob

Hi Bob,

This just seems to be an issue when you're running the report from Design Mode (ie when you're authoring the report). Once the report is saved and run from the portal or via a schedule, it doesn't happen.

See the below post:

http://www.cognoise.com/index.php/topic,32830.msg109600.html#msg109600

Cheers!

MF.
Title: Re: "1" in LONG Column, of Row 1, Running Report to Excel
Post by: Cognos_Jan2017 on 26 Oct 2017 08:01:31 PM
Thank you MFGF.

I run the vast majority of Excel testing in Design mode, and still using widgets running HTML.

Will test at work tomorrow and return back here.
Title: Re: "1" in LONG Column, of Row 1, Running Report to Excel
Post by: Cognos_Jan2017 on 27 Oct 2017 10:03:42 AM
MFGF - You, and the Cognoise thread, are definitely correct.

"1" when run from Design Mode, BUT ...
when run from Portal, NO "1".

Thanks again, Bob
Text only | Text with Images