Hello:
The Customer Open Transactions Report is showing Textbox & and Number for headers.
Also, many extraneous fields with header names.
Is there a way to fix this?
See below:
Business Analysts requesting this for analysis. Also integration to banking system
Oh yeah, I see what you mean. That is ugly. The Column headers are being exported as rows with the row detail on the same rows as the headers. Can I ask, why do you need it in csv format?
Yes, excel is fine. Try running as CSV, it's not a very user friendly output format
Paul, this report exports fine to Excel for me in a demo environment. That report may need to be recompiled by a technical resource for your environment.
Also, this is an SSRS (SQL Server Reporting Services) report. As such, in order to get the Customer name on the lines, the report would need to be modified by a developer. Only then would it export in the format you desire. Or, you could write a macro in Excel to reformat the sheet after exporting it.
running the report in CSV format
Excel is fine, but the customer # and name are listed above the detail information. need in CSV where all data )including customer # and name are in one row
I run the process to CSV since I need all fields in a row.
When you export SSRS report to excel - You will find something like this.
I don't think there is any other option fix to this.
Thanks,
Girish S.
Can you tell us what customizations are done on it?
If no customizations, you can try building that model.
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156