It really depends on how you want to present your data in the report, but one method I can give you is the following:

Create a table for the report.

Create a...

The question is, how does the user change the datasource dynamically? This might give a clue as to how to show the datasource on the report.

This is relatively easy, you simply add the two sub-reports to your main report, then on each sub-report right click and go to properties; go to the visibility tab; then...

The way I would do this is to use a sub-report.

Set up a table on your report and decide which dataset will populate the left side of the report, and...

Why not try using an expression that utilises the PREVIOUS function.

For example:

= Fields!TotalAmount.Value - PREVIOUS(Fields!TotalAmount.Value)

You might wish to take a little care about when PREVIOUS points to nothing, i.e. it...

AssetID AssetCode Pcode DepID ...

That's it, but the really important part (I think I worked out how to not have the line across the bottom), is that the line should not start at zero...

I could certainly modify the dataset, the problem with that is that the end user still wants to see Jan, Feb, Mar on the chart, even though no value existed....

Hi

Thanks for the response but I'm not sure I understand the answer, I have a dataset already that returns Jan, Feb, Mar, Apr, May etc and there is no value...

Nothing I can think of I'm afraid, sorry!

As far as I know this is not possible, the idea of the viewer is to show pages that have no length limit, they simply keep going until a ThrowPage...

Hi

Thanks for the suggestion, however, we are already using the document map for on-screen navigation either through SSRS or PDF.

The purpose of the TOC is specifically for a 50 Page...

Add a table to your report.

Normally you would have one details line and all of your columns would go into the details line, however, in the case you are talking...

Pleased to be able to help, glad it worked for you.

There could be quite a large number of reasons for this, in order to help you out on this I would need more information on how you have put your...