Subreport within sub report

rbuser

Hello

I have a report with 3 levels

Level 1 - Main Report - 1 Item
Level 2 - Accounts
Level 3 - Account Lines

Accounts is a sub report within level 1

Account Lines is a sub report within Level 2

I am using JIT pipelines. Each account in the account pipeline (used for
level 2) has a corresponding TAccount object. Each TAccount object has a
Lines property. How do I use the Lines property with the pipeline for Level
3,

I know it is possible to do a big list of lines and use master detail links
but I would rather avoid this if possible?

Cheers

Paul

nicocizik

Hi Paul,

From what I can tell, this is more or less a Master-Detail style report done
manually. Though we have never tried anything like this before, it should
be possible.

Inside the OnGetFieldValue of the thrid JITPipeline, you need to find a way
to determine which TAccount object to access. This could be done by perhaps
taking a look at the second JITPipeline's current record. Once you have
access to the proper TAccount object, you can then access and display the
data you need.

Note: As you mentioned below, this would also be possible by creating a big
list of lines and using the built-in ReportBuilder Master-Detail logic. In
my opinion, this would be much easier as all the work I mention above is
already done for you. All you would need to do is loop through every
TAccount object and create the big list.

--
Regards,

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