Subreport help

rbuser

Hi.

I have a Invoice report with a couple of sub reports that show detail data
using pipelines with master-detail relationship.
The report is organized so that the report shifts/is grouped by the
invoice number, detail data is also found using the Invoice number as a
master-detail key.
However, I have been asked that every invoice should also have a summary
of all past invoices for the actual customer so far this Year on the
report.
I have set up a SQL that makes the selection I'm after, but obviously the
master-detail relationship above can not be used.
What I can do however is to define a m-d relationship for this
sql/pipeline that uses the customerID as a key.

Will this work when my report shifts with the Invoice number for the other
sub reports?

Are there other ways of handling this?

I would very much like to avoid using events on the report it self...

I find this case to be somewhat hard to describe, so I'm sorry for being
unclear or missing out on something.

Br
Petter Topp
D2010 RB 11



--
Sendt med Operas revolusjonerende e-postprogram: http://www.opera.com/mail/

nicocizik

Hi Petter,

I assume the query that selects the summary information is completely
separate from the query that is connected to the existing detail subreport?
If so, you could place another subreport below the first one and set its
ShiftRelativeTo property. Then connect the summary dataset to the second
subreport and display the information.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks Nico.

I have implemented the functionality, and it works...





--
Sendt med Operas revolusjonerende e-postprogram: http://www.opera.com/mail/