This one doesn't work unless the @testdate is the 1st day of the month. E.g. with @testdate = '2011-01-30' it incorrectly returns 29.

You wouldn't know how to do this in SQL 2008 R2 by any chance? In Report Manager, there is no Hide in List View checkbox. Instead, there is Hide in...

Hi,

Thanks for your input. The version of BIDS reported when I go to Help About is:

Microsoft Visual Studio 2008

Version 9.0.30729.4462 QFE

Microsoft .NET Framework

...

MostInterestingMan, this is the same suggested method that Niraj-627298 posted above. This does not work for SQL 2008 R2, as I posted above.

People, can you please, please, PLEASE read the...

Has anyone else got a solution to this problem?

Hi,

This doesn't work. When I select the Hide In Tile View option, the users can still see the Datasets folder.

Hi,

I don't have a Hide In List View option. There is a Hide In Tile View option, though.

I'm using SQL Server 2008 R2.

Thanks for your input.

It is definitely not an issue with the speed of execution of the SQL code. I know this because:

1) The report is not executing a stored procedure....

I am still getting terrible performance. I've measured the report execution times for both Chrome and IE with varying number of rows. Please see the results below.

(The SQLServerCentral forum does...

Many thanks for the reply, SSCrazy. I found the microsoft article explaining this and have pasted it below for others who might want to read up more on this issue.

Lowell, from your last post I think you have assumed that the problem is fixed. This is not the case - nothing I have tried so far has made...

Thanks for the link, it was very useful.

I used the Developer Tool (by pressing F12 from Internet Explorer) to do a profile trace of my report in all the eight...

Very interesting! Do you know where in Internet Explorer's settings I can set this? I can't seem to find it.

Hi,

Yes, 'Keep together on one page if possible' is selected, so all the 1000 rows appear on one page.

The issue is that the same report takes 90 seconds when viewed...

It was the handling of Report Parts that raised my interest in this issue. My understanding is that Report Builder 3.0 is required to publish Report Parts, and that Business...