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.
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.