Hmm yes maybe change away from time to number and see how that affects it. If that doesn't solve it, can you attach the RDL?

Can you show me where you're switching between these views?

So you have the white space which you place items on, that is the Body element, the empty space around the Body element is the report.

Easiest way to access these...

in the execute package tasks, how are you linking to the packages? I'd hazard a guess that you're pointing to a file system location, which you're able to see from...

I'm 99% sure this cant be done with a standard flat file destination as the columns are actually bound in the connection manager rather than the destination for a start.

You...

Hi, try changing the interval type to number rather than hours, as hours is a special type and is handled a bit differently

wendy elizabeth (12/6/2015)

---

I can use a 'fake' parameter like today's date. Could an update on the report server or the database need to be made? Would being behind in report...

Hi, the size of the Body element of the report must be smaller than (fit within) the report PageSize minus the report Margins or you'll get this odd page breaking...

Hi Andy, I'm not entirely sure I understand the problem but for exporting reports, the Size of the (report) Body has to be smaller (fit within) the PageSize minus the...

I blogged on this a few years back including some of my favs 🙂

https://tsqlninja.wordpress.com/2012/07/25/tools-of-the-trade/

Should really update it 🙂

DuncEduardo (12/7/2015)

---

First thing I checked.

Even did a ltrim(rtrim()) but to no avail.

Original data came via flat file and imported via SSIS.

Data Types were nvarchar but I changed these and loaded...

Can you post a copy of the rdl? Or even just a screen shot of the setup?

Could this be a network traffic issue? If the run the same query on the new and old server do they both return in roughly the same amount of time?

Is...

Hi, what you need to do is add the relevant parameters you want the user to enter as report parameters. Then in the data set for report, edit the query,...

Hi, this sounds like you need parameter defaults?