Hi,
I have used SQL command object (Add Command in DB expert) get some numbers grouped on a column. I have two such sets of data which I want to display in the report, one group below the other. (use CR XI and Oracle 9i)
I can display one of the two group of results in the details section properly. If I place the data in other sections, I can see only one of row of data (even when I increase the height of the filed.
I have issues displaying the second set also here in the det. If I create the data in a subreport, I am sure this will work. When I add the second set of data here, the group headings start repeating here and the report runs into number of pages. (My original report has only 5 groups and 6 groups of data to be displayed (a total of 11 lines to be seen in the report)
I tried adding a second detail line and it did not get any better.
Is there any other way I can / should do this?
If I get the numbers without grouping, I should be able to display them in the details section, suppress the section and display only the group data and repeat this for the second section. I can also create two subreports and use them in the main report. Are these the only way to go? I already have all the data / query, etc and want to see if I can keep all this in a single report.
Thank you.
I have used SQL command object (Add Command in DB expert) get some numbers grouped on a column. I have two such sets of data which I want to display in the report, one group below the other. (use CR XI and Oracle 9i)
I can display one of the two group of results in the details section properly. If I place the data in other sections, I can see only one of row of data (even when I increase the height of the filed.
I have issues displaying the second set also here in the det. If I create the data in a subreport, I am sure this will work. When I add the second set of data here, the group headings start repeating here and the report runs into number of pages. (My original report has only 5 groups and 6 groups of data to be displayed (a total of 11 lines to be seen in the report)
I tried adding a second detail line and it did not get any better.
Is there any other way I can / should do this?
If I get the numbers without grouping, I should be able to display them in the details section, suppress the section and display only the group data and repeat this for the second section. I can also create two subreports and use them in the main report. Are these the only way to go? I already have all the data / query, etc and want to see if I can keep all this in a single report.
Thank you.