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
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.
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
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.