If you have multiple parameters, say parameter 1 is Country, parameter 2 is City, and you add a where clause to parameter 2 dataset (City), to check Country first, then...

I use the STR function where I can, it works like a charm.

I agree, there was a grouping issue in the report.

Plenty people copy a report, rename it, use it. This sometimes causes problems because its like the cache of report copied...

As for the where clause, I agree with Burninator.

Remember, if using a parameter (say Area), and you want users to select 5 out of 10 areas (multivalue parameter), then you...

happycat59 answer with script - not sure if it will work.

from my experience with subscriptions, the best way to prevent them from running is to open report manager (web page...

Question: Can reports developed in SSRS 2008 R2 be deployed to SSRS 2008 R1 servers?

Answer:

Under target of Project Properties (Visual Studio), select SQL 2008.

Then click on deploy.

If you don't select...

Prior to deploying report, can you run the report successfully in Visual Studio.

If you can then the issue lies with the datasource in Report Manager (where you are deploying the...

If I understand correctly you want a parameter such as Area (divisions in company) to display depending on user running the report. So if finance user runs report it will...

Try any of these:

1. Add reportserver URL to trusted sites in internet explorer.

2. Enable Windows Authentication (Advanced TAB of internet explorer).

3. If deploying to IP address, change it to server...

I agree with Syed.

The clocks on the client and server machines are skewed".

Had same issue, seems some servers were losing time sync with domain controller/s.

Affected browsing certain in-house websites, also...

View the following website URL.

http://msdn.microsoft.com/en-us/library/ms160330.aspx

Had same issue when running SQL Reports, using Impersonation with Stored Credentials for Data Source or using Windows Integrated Security for Data Source.

Firstly you did not specify clearly what you want to prevent. If you want to prevent users from running the report, simply dont add them to security in Report Manager....

Hi Veeren,

I have setup subscriptions, the problem is once you dont require say half of them, you cannot really disable them (if you disable the job or the schedule once...

If the report is for CRM (Microsoft Dynamics ERP Solutions), use a calendar table, you can then allow the users to select a week (1-53 for example), make week start...