I don't know of a tool but here are a couple of thoughts if there isn't one.

1. Create a stored procedure which loops through all the tables and uses a...

Thank you so much, Ant-Green.

• This reply was modified 2 years, 9 months ago by  callen-557064.

Thank you for the quick reply. I'll give it a shot. I must have been thinking Excel.

Tim,

Thank you for your help.

Thank you. I'll give it a shot.

This question may be oversimplifying your need but why not use the matrix report in SSRS which automatically creates the column headings based on the data?

Also, what is the point...

I found an article about this topic. https://www.mssqltips.com/sqlservertip/3453/sql-server-reporting-services-reports-with-optional-query-parameters/#:~:text=Optional%20Query%20Parameters%20are%20not,show%20all%20of%20the%20data.

Thank you for the response. Unfortunately, I do not have any footers. I'm including a screenshot of the report design.

To be clear, when selecting the option to Save as CSV,...

Thank you for the response. It looks like your example has the subtotals and grand total based on amounts in the detail row.

In this case, the amount that is being...

This is an SSRS Report Builder question. The image was taken from Excel to show how the report is structured and what I'm trying to get from it.

I've used derived tables to create a report that included actuals and budget data from various periods such as MTD and YTD.