I have a report in SSRS that has two tables, the table on top has the detailed data for my client to see, the table on the bottom displays totals for the details. The reason I have two tables is due to the fact that i want the totals to be displayed at the bottom of a csv file. Here is the issue, as far as the table on top is concerned I want the column headers to be displayed but when it comes to the table on the bottom, I dont want the column headers to be displayed. How would I go about solving this? I cannot change the config file because I am just doing this for one csv file, I cannot place a blank value into the DataElementName because that is not allowed, and I cannot use an expression as a name that would set the value of the textbox name to null.
If you can modify the query in the data set, you can add the the total row directly to the query. then it will be exported correctly and the totals will be last row in the table and exported correctly also into the CSV. SELECT Col1, Col2 FROM aTable UNION ALL AVG(Col1), SUM(Col2) FROM aTable I know, it's not optimal as it needs to read the data twice, but if the amount of data isn't too big, it could be a workaround for this problem.