Finance | Project Operations, Human Resources, ...

Customer Open Transactions Report Headers show "Textbox #" for Headers

(0) Share

Report

Posted on by Paul V

166

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:

I have the same question (0)

All responses (10)

Answers (0)

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Can you tell us what customizations are done on it?

If no customizations, you can try building that model.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

Hi Paul V

How do you export this data? Can you provide some screenshot from the system?

Thanks,

Was this reply helpful? Yes No
Paul V 166 on at

Like (0)

Report

I run the process to CSV since I need all fields in a row.

Was this reply helpful? Yes No
Paul V 166 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Paul V 166 on at

Like (0)

Report

running the report in CSV format

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Paul V 166 on at

Like (0)

Report

Yes, excel is fine. Try running as CSV, it's not a very user friendly output format

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Paul V 166 on at

Like (0)

Report

Business Analysts requesting this for analysis. Also integration to banking system

Was this reply helpful? Yes No