You could probably do this using the Subscriptions method, but it would be wise to set up the subscriptions so that every copy is not stored on the server (i.e....

Hello Dave

Great bit of code that! Actually there was another entry in the last ten days on this forum that would benefit from that code.

I'm trying to find it...

Hi

Not sure it makes much sense to me to simply truncate data just because it goes over to a second page, however, that's probably none of my business! I...

It sounds very much like a matrix report would do it for you, but can you post a small sample of the data you are retrieving and how you want...

OK, I have managed to do this.

First, normally you would have two row groups in this matrix, the first based on the outer grouping (in my case County) and the...

How would you go about dealing with a variable number of columns in a table?

You can use exactly the same code in the Query Text of a dataset in SSRS.

I prefer to use calls to an SP for every dataset in a report, it...

So the thing to do probably is to create a third stored procedure that executes an inner join on the output of the other two stored procedures......

Does this make sense

For...

There are several ways to use more than one stored procedure and it depends on what you want to achieve that pushes you through to one method or another.

If, as...

OK, I did some work on this and found that, as difficult to believe as it is, this is not possible directly in SSRS.

My advice is to do the calculation...

Sorry, didn't think about the use of Previous along side SUM, I'll have a bit of a re-think.

If I understand it correctly you have something like this

Desc WK ...

Hi

This is a problem with sub-totalling in SSRS when using conditions/expressions. The trick is to ensure that both results of the expression are the same data type.

Your expression:

=IIF(Fields!DCs.Value-Previous(Fields!DCs.Value)= Fields!DCs.Value,"",Fields!DCs.Value-Previous(Fields!DCs.Value))

Should be...

Well I've tried a number of different things this morning and I absolutely cannot get it to repeat these group values. I'm with you, it's pretty unbelievable really.

I am...

Sorry about that, my (very silly) mistake.

Glad it's working now though.

Can you also paste the exact expression you are using.

Thanks,