Forum Discussion
Straight table without aggregation in Report Builder
Hello,
I've been fiddling around with the Report Builder because I want to create a report, that has to be sent via mail every day to certain people in my organization.
The report should show errors, that happened in an ETL job, that is running every night.
Columns are REPORTING_DATE, JOB_NAME, ERROR, ERROR_TYPE and so on. So no aggregation, no totals or subtotals needed here. No sum(Sales) or something like that. Just a straight table.
Is that even possible? It always wants me to add at least one field, that contains an aggregation of some kind.
If thats not possible, is there another way to periodically send a mail containing a table based on a report at the Report Server?
2 Replies
Where did you drag the fields when you created your report? If you just want a plain list with no aggregations or subtotals then you should drag all the fields into the "Values" area. If you add fields to the rows or columns areas the wizard is expecting to generate some sort of totals or subtotals which is why it's looking for an aggregate of some kind.
Hi, Philipp_A
You can add the dataset you need
Select Query Designer
Then select Insert on the master page, and then select Table View
Create the table view, and put fields in it
You can put in multiple fields, or you can put in a single field. If you want to add a column, just right-click on the table and select Insert Column.
If you want to reduce the number of columns, you can also right-click to delete the columns
It's just a straightforward table and doesn't have any aggregate values. Select the run and see the preview:
For subscriptions, you can manage paginated reports in the Report server by selecting Manage
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
