OK, so my last stab at this one is as follows:

Find a value (any value) that you can use as an outer grouping in your table. This value should not...

Now I'm just throwing ideas around, but........

Try adding a text box into the footer, and add just the page number to it.

Name the Textbox CurrentPageNum.

In the group footer of table...

I am guessing here that you have somehow added your fields into the table at a group level, and if so, perhaps what you are printing is First(Fields!Column.Value).

If this is...

OK, so this is where SSRS starts getting a little bit tricky compared to Crystal Reports, where you have access to page numbers wherever you are in the report flow.

Anyway,...

I think I understand it now...

So why don't you simply move the second table out of the footer of the first table and create it on it's own below the...

Not sure I understand why you would want the headers if there is no more detail to show in that table, even though you obviously have your reasons, if I...

Thanks for the advice, at first sight it appears as though the combination of SOUNDEX and DIFFERENCE might give me the answer I'm looking for, however, having run a few...

Hi Noel

I apologise, I've never had cause to use it before and it really didn't make sense to use both, but having thought about it..............maybe it does have some use.

You...

Not sure what the hell is going on in this thread.

The answer is .....

You cannot do a DISTINCT when you are already doing a TOP 5, the two are mutually...

This seems a little complex at first glance, but it's not really.

First, add a list box to your empty report.

The list box should be grouped on your product...

Where do you want to throw a page?

Do you have specific information for page 1, then more information for page 2?

=IIF(Sum(Fields!Contacts.Value)=0,0.00,IIF(Sum(Fields!DiallingTime.Value)<=0.00,0.00,(Sum(Fields!Contacts.Value)/Sum(Fields!DiallingTime.Value))))

The odd thing about SSRS is that it really doesn't allow you to cope with division by zero errors within the expression, I have often tried to use the...

I will assume that as an expert SQL writer, you are using a stored procedure for the dataset, if this is wrong let me know and I'll alter the hints...

I'm not sure I fully understand what you are aiming for here, but my first question would be, are you expecting to deal with more than one treatment id in...

OK, so the way to do this is as follows:

1. move the data down to the detail level so that nothing is printed at the group header level.

2. ...