Print Page - little dashes in excel report out put

Title: little dashes in excel report out put - need help
Post by: pooja on 24 Feb 2012 09:16:41 AM

To remove /0 in excel report output, we did format by applying Divide by zero characters-0 and report looks fine.

But the problem is after doing that we are getting little dashes on left top corner of the each cell where the values is 0. (report output in excel)

Is there any way to remove those dashes.

thanks,
P

Title: Re: little dashes in excel report out put - need help
Post by: Grim on 24 Feb 2012 09:43:25 AM

Zero suppression:

http://www-01.ibm.com/support/docview.wss?uid=swg21370735

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.pwr_ppweb.8.4.0.doc/pwr_ppweb_id2506suppressvalues.html

http://www-01.ibm.com/support/docview.wss?uid=swg21342856

http://www-01.ibm.com/support/docview.wss?uid=swg21339598

Title: Re: little dashes in excel report out put - need help
Post by: pooja on 24 Feb 2012 11:07:04 AM

But my question is, how to resolve dashes in excel.

Title: Re: little dashes in excel report out put - need help
Post by: Grim on 24 Feb 2012 01:08:00 PM

Root cause is due to divide by 0 issue right? Then zero supress and you won't have that problem in the first place.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pooja on 24 Feb 2012 09:16:41 AM