Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recursive Grouping

Status
Not open for further replies.

CrysGuy

Programmer
Mar 11, 2008
2
IN
My main report contains a group on SITE_NAME. I have created five Group Headers and have placed five subreports, one in each Group Header. Each subreport has details
aboout the SITE, say INPUT, OUTPUT, THRESHOLD etc.
My requirement is to get the SITE_DETAILS for each SITE(whihc is already grouped) with
all the DETAILS mentioned above.

Let's discuss with an example:

OUTPUT 1:
---------

Group1:

SITE A

SITE B: INPUT, OUTPUT, THRESHOLD
SITE C: INPUT, OUTPUT, THRESHOLD
SITE D: INPUT, OUTPUT, THRESHOLD

SITE B

SITE A: INPUT, OUTPUT, THRESHOLD
SITE C: INPUT, OUTPUT, THRESHOLD
SITE D: INPUT, OUTPUT, THRESHOLD

SITE C

SITE A: INPUT, OUTPUT, THRESHOLD
SITE B: INPUT, OUTPUT, THRESHOLD
SITE D: INPUT, OUTPUT, THRESHOLD

SITE D

SITE A: INPUT, OUTPUT, THRESHOLD
SITE B: INPUT, OUTPUT, THRESHOLD
SITE C: INPUT, OUTPUT, THRESHOLD

The number of SITEs may vary for different user inputs.
So, I have a group on SITE_NAME, but my report shows as follows:

OUTPUT 2:
---------
SITE A

SITE A: INPUT, OUTPUT, THRESHOLD
SITE B: INPUT, OUTPUT, THRESHOLD
SITE C: INPUT, OUTPUT, THRESHOLD
SITE D: INPUT, OUTPUT, THRESHOLD

SITE B

SITE A: INPUT, OUTPUT, THRESHOLD
SITE B: INPUT, OUTPUT, THRESHOLD
SITE C: INPUT, OUTPUT, THRESHOLD
SITE D: INPUT, OUTPUT, THRESHOLD

SITE C

SITE A: INPUT, OUTPUT, THRESHOLD
SITE B: INPUT, OUTPUT, THRESHOLD
SITE C: INPUT, OUTPUT, THRESHOLD
SITE D: INPUT, OUTPUT, THRESHOLD

SITE D

SITE A: INPUT, OUTPUT, THRESHOLD
SITE B: INPUT, OUTPUT, THRESHOLD
SITE C: INPUT, OUTPUT, THRESHOLD
SITE D: INPUT, OUTPUT, THRESHOLD

To avoid this I created a formula to get the CurrentSITE from the main report and tried using it in Select Expert with "is not equal to=CurrentSITE". This does the job and gives me the desired output as shown in Output 1:

But this also blocks the data of the CurrentSITE. The data shown in the sub reports are actually "LINKS" between SITES, i.e in SITE A group, INPUT shown against
SITE B is the value of INPUT LINK between SITE A and SITE B.

So, I require all the data corresponding to all the SITES and hence cannot use Select Expert. How can I get this done?

Please help me. I am a newbie.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top