Group your list. Add a table/tablix to the list. Put your group level fields in the list outside the table, put your detail inside the table.

I would put your query in SSMS and then EXECUTE AS the user instance under which the Report Manager runs. You will probably get the same problem. Then...

A kind of a sideways way to do...

Create the group.

Rather than use the column the group created, delete the title of the group and collapse (do not delete) the column to a zero width. Put your...

A quaint concept, many of us have forgotten. 🙂

Then probably the easiest way to go would be to add a couple of columns to your dataset query. One for a T-SQL Row_Number, and another for a field...

I am not quite clear on what you are trying to accomplish. Are you trying to get exports to Excel to be limited to 65000 rows per tab regardless...

Monkey

What happens when you directly execute the dataset with the same parameters?

A lot of people use ASP.Net to host a website and call reports from the report manager, so no, SSRS does not need to be on the same server as...

deluge

I figured that was probably the case, but it was all I could think of. Good luck.

Once you have that view, you can select the report properties - then select the Edit option from the General page. This will allow you to save the rdl file...

If you don't have and can't get the original source, then I think the only way you can get what you need is to start pulling apart the catalog table...

As you load your fact table the startdate should be in this format: 20070101, not this format 01/01/2007.