user selected values to diaplay

[friend]

Hi Friends


I need to display only the user selected fields in the report output, so I used the condition formatting for hiding the no required columns. The logic is working fine, but while exporting the data into CSV file all the columns with the data are exported. Hence conditional formatting logic is not getting applied in the CSV output, because the main output SQL is getting executed on to the CSV file.

So kindly let me know is there any way to hide and show only the required fields in the CSV file.


Thanks in Advance

[Amritchik]

hi

If i understood your quest correctly, think better to use a 'Case Statment' instead of 'conditional formatting'. Or else you could restrict the Data using parameter value as a Filter condition.

Let me know if it is of any help.

thanks.
amritchik

[friend]

Hi........

Hi thanks for the reply. My requirement is that the prompt page will contain list box (multi-select) of all the field name of the reporting table. For example if the list box contains Field-1, Field-2 and Field-3, the user selects only Field-1 and Field-3. Then the report output will contain data related to Field-1 and Field-3 only. But if the output is exported to CSV Field-1, Field-2 and Field-3 data is listed. Since the conditional formatting is not applying for the CSV files.

Please let me know for any alternative

[sridhar_world]

If I am not wrong, the csv output just runs the sql and brings in all the columns that are present in the fact items. It doesn't consider any formatting that is done on the report page.

If there is a way to capture the output type the user is running in, we could use that and conditionally make those columns null so that no data is displayed in the csv even though column is shown.

Regards,
Sri