Thanks Eddie I appreciate you responding.

All the best, Duncan

Thanks for the responses, I appreciate it.

I set db_chaining across both databases to on.

Added the SQL authenticated account to the public role on the target databases.

on selecting from one of...

Hi Jeff, fortunately I am only processing a few thousand rows. Big data it ain't.
Thanks

Thanks guys, your responses have given me food-for-thought.
One other idea I had been playing about with in my head is to stuff each complete row into a single column,...

Hi Thom, thanks for getting back to me so quickly.
I have tested the idea you suggest however it will not work in this particular situation and I will try...

Hi, first time I ever encountered this and I have deployed the same content to maybe thirty different customers over the last two years.
Re-started SSRS service from SSRS Configuration...

Steve hi, thanks for the contribution
At the moment the main report passes an ID and two dates to the sub-report. Are you suggesting passing another value, the page number...

Hi, I have successfully used list control grouped by account Id. This works, each account statement is rendered one after the other and will export to PDF - great

Thanks for getting back to me on this Neil. I'm about to experiment with the list control. I'll post on what happens
Thanks

Hi, it's horses for courses
Tableau, PowerBI class themselves as 'self-service BI' applications. Providing tools for non-technical users to construct their own content (known as visualisations). So, providing the user...

Just had a thought
I can use sub-accounts as groups on a single tablix and force page-break between groups
Sorted...................I think!

Hi, thanks to everyone who contributed here. I had the same problem and solved it by re-starting the service using the Report Server Configuration Manager

Thom hi thanks for the quick reply

Following your thoughts I changed the text-box properties to decimal to two pleaces, each and every value returned a whole number

I cast the column...

Shawn hi, thanks for getting back to me so quickly I appreciate it

Have a good weekend

Hi, you need a licence for BIDS 2008 R2 installed. This can be used to develop, maintain and deploy models

It's fiddly though

I've used it a couple of times successfully

But what...