Singletons not appearing in excel

[cognosryan]

Hi everyone,

I'm having a strange issue, ive created a report which shows different counts for day/month/year etc mutliple queries. the client was adament it had to be in a certain format which could only be achieved by creating a table and inserting singletons.

Everything works data wise. However one issue i've found. When the report is exported as excel the data shows up as blank.

I'm guessing i've created a rod for my own back with this one due to the use of the singletons. Anyone know a way i can get the count data to show?

Thanks in advance

Ryan

[Lynn]

What Excel format are you trying to use? Singletons work fine in Excel 2007 format. You won't get them in CSV or Excel 2007 Data format.

[cognosryan]

Hi Lynn,

Thanks for the reply

I tried the 2007 excel format and the screen shot below is what i get. Its weird i get the percentage calcs but not the counts. ???

Ryan

[Lynn]

Try something with a sample package to isolate whether there is an issue in your report or some other problem in your environment. I am on 10.2.2 FP 2 and have no issues with singletons in Excel 2007 output so I'm not sure what else to suggest.