Straight table without aggregation in Report Builder

[Philipp_A]

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?

[Anonymous]

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.

[d_gosbell]

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.