Hello Team,
I am generating a BI Publisher report scheduled through an ESS Job with the output format as CSV.
When the report returns no data, I need the output file to contain only the column headers. However, the generated CSV contains the headers followed by an additional first data line with delimiters only, which is not the expected output.
The delimiters are defined in the Data Model, not in the eText template. The eText template is attached for reference.
Data Model:
CSV Output:
From the Report Properties > CSV Output section, no delimiter is selected.
Note: Bursting cannot be used as a solution.
Is there a way to generate a CSV file with headers only when no data is returned, without the extra delimiter line?
Thank you.
