While I've never needed to represent that many values in a parameter selection, I've only done perhaps 75-100 in each parameter I've found that most users seem to want either...

True and kudo's to whoever made the decision to allow download of the comic book without having to proceed through the data collection...

This seems to be an issue with 2008 R2... see the following connect issue and vote for it if you agree.

https://connect.microsoft.com/SQLServer/feedback/details/598564/2008r2-excel-unable-to-be-opened-in-pda-or-iphone?wa=wsignin1.0#tabs

You might be able to do this with the rs.exe utility, or perhaps by creating a commandline application with VB/C# etc that makes a call to the resportserver2005 web service....

Any chance that it's just a formatting issue? Make certain the datatype is set to the correct format and such (fixes numbers stored as text issues)? Also that...

If you have an MSDN subscription you may be able to download SQL Server 2005 but if not and you are looking to learn you may find downloading the Trial...

I'm not really sure what you are asking. Have a look at the first article in my signature for how to help us help you for an idea of...

At what point do they see the access denied message? When they try to load the report or when they try to run it?

Also, you may be having some...

Kit G (12/27/2010)

---

That's an interesting combination. At...

SQLNW (12/23/2010)

---

Hi Gurus,

I am developing reports on reporting services 2005. I need to provide a daily report which has

@startdate & @end date from query

Q....I want to make...

I would check the help files for the Count() and CountDistinct() functions. I beleive they would be useful here.

Any chance that the the dataset credentials are set to use integrated security and the users from the XYZ domain don't have appropriate rights to that datasource?

Additionally, you could use the built-in authenticated users group from active directory. It's...

Seems like perhaps you might need to add an appropriate Group BY Clause to the query in your dataset.

If that is not an option, you could also experiment...

Ninja's_RGR'us (12/21/2010)

---

Thanks for the link.

But the more I think about it, it's the same as the report. Any half decent dba will be able to reverse engineer the cubes...