Hmmm. I did some testing here with a main report and 1 subreport ans I only see one RPC:Completed for the stored procedure in the main report. The...

Are all the calls on the same SPID?

Your issue is that, in the ON clause B.anotherid is never null so you are never getting to anotherid + 1 or anotherid + 2 as the evaluation is only...

Select the textbox, select the properties window and change the color property. Or, select the textbox and on the file menu select Format -> Foreground color. Or, if...

We need more information than what you have provided. What are the steps in your current process? What do you mean when you say "Performance can't go down"?...

Can you post the Profiler results?

Are you seeing this behavior on a deployed report or in BIDS?

It's been awhile since I have done anything with SQL Agent mail, but do you have any errors in the SQL Server or SQL Agent Logs? Can you send...

Bru has provided some good advice. The 20% of database file size is a guideline to get you started, but if you have a terabyte database do you really...

As has been mentioned, best, at least in this case, is a a subjective term. For me the key is WORKS, not best. If I have a solution...

Robin,

Glad you found it. I would have caught the issue had you not done so before I got here.

You are not the only one to have that issue. ...

Okay so you are all set with access to the report server. That eliminates permissions. Now the question is are you correctly connecting to the report server when...

All the N does is specify that the string you are passing is unicode. If the columns in your database are already defined as NCHAR/NVARCHAR then you shouldn't have...

Did you deploy the control to the report server or do you just have it on your development machine?

Duplicate post. Please post answers here.

Okay, that's good I think as I have never seen it grayed out. This could be a permissions issue.

Can you connect to the report server (http://server name/reports is the...