COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gvraocognos on 29 Jun 2012 04:47:48 AM

Title: Problem in downloading report output in CSV in cognos 8.1
Post by: gvraocognos on 29 Jun 2012 04:47:48 AM
Hi All,
Currently i am working on cognos 8.1, i am facing a problem for downloading report output in csv format.
In my report dynamically selection measures columns using prompt page. i have A,B,C,D columns in prompt I have selected A and C columns in prompt and run the report. In HTML and Excel I am getting A and C columns only. But when i download CSV format i am getting A,B,C and D columns, selected columns are displayed with data and non selected columns are displayed with out data. And also data not same.

For example:
HTMT Output result is 100%
Excel Output result is 100%
CSV Output result is   1



Many thanks in advance.
Venkata Rao  :'(
Title: Re: Problem in downloading report output in CSV in cognos 8.1
Post by: MFGF on 29 Jun 2012 05:07:22 AM
When rendering to CSV, you get all the data and no formatting. Your report works by hiding the measures you don't want to see using conditional rendering (I'm guessing) but this part of the formatting options which get ignored when rendering as CSV. Similarly with the values, you have a data item which contains real values such as 0.76, but the report is configured to format these as percentages so you see 76%. Again, formatting gets ignored when rendering as CSV - you just get the data.

If you want to render as CSV and show only a specific set of measures, you will need to change the way your report works - perhaps have calculated fixed columns which use an if-then-else construct to decide which measure to display, and have a calculation for each percentage measure that physically multiplies the underlying number by 100 so you see the percentages in your CSV.

It's not an error - it is just a facet of the way your particular report is written.

Regards,

MF.