Need advice on Linked Subreports [message #244365] |
Fri, 22 June 2007 16:10 |
Nisha![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=nagarwal%40healthhero.com) Messages: 97 Registered: July 2009 |
Member |
|
|
Hi,
I am using scripted dataset where I have a list of entries. For each entry
in this list, I have a nested list of secondary entries.
I need to create a report where I present the entry from 1st list followed
by all the entries from the list.
Example of display that I want: PrimaryEntry1
secEntry11
secEntry12
PrimaryEntry2
secEntry21
secEntry22
Example of my data structure for the object:
List1: name, id, List of List2
List2: e1, e2, id(from List1)
I create a master report that iterates over the outer list of primary
entries.
I display these in a table. In the detail row of this table, I create
another table to display the secondary entries from the nested list. I
have the following options to link these tables
1) There is a common parameter between outer and nested list. I can use
that parameter, but then how do I access the secondary list which is one
of the entry in the outer list
2) I can use List2 as a link parameter. This way I can iterate over List2
easily. However, if I do that, then I need to create an output column for
it in the dataset for master report. Is that ok? What data type should I
use for this column?
Which is a better solution out of the 2?
Can I represent the data in any other way to make the problem easier?
Regards,
Nisha
|
|
|
Powered by
FUDForum. Page generated in 0.02880 seconds