Can I have two subreports using the one dataset

rbuser

Hi,

I've had a request from a customer where they would like a report to
show in the format below. The top half of the report is simply a summary
of the bottom grouped by date.

What I was wondering is whether it's possible to use two seperate
subreports linked to the same datasource to display this data (where one
uses a group and summary and hides the detail, and the other doesn't) in
the same report?

[Subreport 1]
Month Revenue
~~~~~~~~~~~~~~~~~
Jan $1,000
Feb $1,200
Mar $1,300


[Subreport 2]
Date
~~~~~~~~~~~~~~~~~~
1-Jan $ 20
2-Jan $ 30
3-Jan $ 10
...
31-Jan $ 10
_______
$1,000 (Total for group month)

1-Feb $ 15
2-Feb $ 20
3-Feb $ 15
...
28-Feb $ 10
_______
$1,200 (Total for group month)
etc...


The reason I ask is that the data isn't as clear-cut as this and is
sourced from multiple locations using an involved procedure, so being
able to use the same end dataset result would be quite helpful if possible.

Thanks & Regards

Adam.

nicocizik

Hi Adam,

Yes it is possible to use the same dataset with multiple subreports on a
report, however there are a couple scenarios where the engine will
become confused if you try to access a single dataset for multiple
reports simultaneously (ex. nested subreports). If you keep each
subreport independent from each other, there should be no problem. Are
you experiencing a certain issue with this?

rbuser

Hi Niko

Fantastic - I was wondering if their may have been any traps, but I can
keep the subreports seperate, so that works fine.

Thanks once again for your help!

Adam