Yes, you can have multiple detail lines on a report table. Make the source dataset is a single query that pulls all the columns required, in the first row place the...

No, I think you cannot remove dinalycally the groups. Otherwise you'll get the exception you did.

But sure you can hide them. All you got to do is make the...

Are you trying to make a report that will be Detailed or Summarized, toggled by a user's parameter?.

What we did was setup the report with all the groupings, and then...

 I'm sorry: we had this issue on RS 2000 and this trick worked; do not know the fix for 2K5.

But check the BOL and...

Open Enterprise Manager, select the Security folder, next Logins, and double-click on the account that you're using to manage RS. Click on the last tab (Data Accces), and do for...

But did you re-assign the permissions to the account you are using to manage and run the RS?.

That's all you need to do.

Check the account that you are using to start the RS services belongs to the RSExecRole on both the ReportServer and ReportServerTempDB databases.

I had that same error message once before,...

Try adding another column with the value of MaxCapacity only when the usage reaches it. For the rest of the items leave it as null.

Then add this series to the...

For long-running reports like this, why don't you run the SP on a separate process (SQL Agent schedule or something), and save the resultset to a static table. Then you...

When I tried what I said, it did not worked on one particular report I have. This because RS did not know the value of the Grand Total until the...

No, you can't. No tables are allowed on the Header or footer. But you may want to calculate in your report the gran total for all transactions, name that cell...

Try this:

1. Add a subreport in the location where you want the totals to appear. The subreport will show only the totals the way you want them.

2. Set the visible...

Try this:

1. Execute the stored procedure from the data tab, and make sure you're not getting a null record. I have seen this error when the SP returns no values...

Do you want the report to print the totals only on the first page, or is the report always one page long?

Do you have the ReportServer and ReportServerTempdb databases created already or not?.