
Can someone tell me how to set Autosum in reports so I can see a total for my query.
*This post is locked for comments
I have the same question (0)Hi Mike,
Are you refering to the report wizard or to a SQL Server Reporting Services? If you are refering to a SQL Server reporting services report, you can add a footer row and drag and drop the column into the cell. It will create a expression similar to this:
=Sum(Fields!YourField.Value)
The reporting wizard allows for summarized data as well, but its formatting is limited. You can create a report using the reporting wizard, export the RDL and edit it in Reporting Services to make it look the way you want.
-Andrew