Don't quote me but I believe if you are redirecting rows to an error output then it needs to be handled in the dataflow. The OnError is triggered by...

You say you have the parameters set up like this:

[AccountCode] [AccountCode]

[StartDate] [@StartDate]

[EndDate] [@EndDate]

Shouldn't it be like this:

[AccountCode] [@AccountCode]

[StartDate] [@StartDate]

[EndDate] [@EndDate]

Assuming this formula is happening on multiple rows within the detail of the report. Try something like this:

SWITCH(count(fields!id.value) <= 50,"1-50",count(fields!id.value)<=200,"51-200",count(fields!id.value)<=500,"201-500",1=1,"Greater than 500")

In the report project properties you should see all the deployment targets. These must be filled in to deploy. Once deployed there is no file deployed so there...

Are you actually getting 2 sub reports, or is the data showing twice in one sub report?

anthony.green (5/28/2012)

SQLDBA360 (5/28/2012)

anthony.green (5/25/2012)

Bill and Ben the...

Does your report have a header right now or just a body? If no, go to report properties >> Add Report Header and drop your header elements there.

records

Ah, it is not that you don't have it now, it is that you won't have it after the upgrade. That is unfortunate.

one armed bandit

I agree with some of the other posts that express frustration that this is the default setting that seems rather contrary to an explicit transaction.

So the take away...

Use this formula to make sure your data is not spilling over onto a blank page.

body size + left margin + right margin <= page width.

You can get...

I would probably create a master package that checked for the existence of the updated data and schedule it to run maybe every 5 minutes. If the data is...

donuts

I am not sure the print layout is what you want, it sounds like your columns have their visibility turned off. Right click on the column and go to...