on 09-08-2008 8:36 PM
Hi All
I am using Crystal X! R2 for the report development. I have an issue in developing one report. I am getting the data for the report from the stored procedure listed below.
RoleName PersonName Activity Name Shift
R1 P1 - -
R2 P2 - -
.
.
.
R50 P50 PPPPPP 10am-4pm
R51 P51 SSSSS 11am-5pm
.
.
.
R55 P55 GGGGG 5am-10pm
.
.
.
I need to display the above data in the below format.
RoleName PersonName RoleName PersonName Activity Name Shift
R1 P1 R50 P50 PPPPPP 10am-4pm
R2 P2 R51 P51 SSSSS 11am-5pm
R55 P55 GGGGG 5am-10pm
I need to display on the left side only the Rolename and Person Name whose Rolenames are less than 50.
On the right side I need to display the RoleName PersonName Activity Name Shift whose rolenames are greater than 50.
I have an idea that I can do it by creating 2 subreports one for the left side data and other for the right side data. As I am already displaying the data in the subreport, I canu2019t go for nested subreport option due to crystal limitation .
Please help me how to display the left section data and right section data side by side.
Appreciated ur help in advance.
Thanks
-Kumar
Kumar,
In the first subreport return your Rolenames that are < = 50 using record selection.
In the second subreport return Rolenames that are > 50.
Place both subreports in the Report Header or Footer.
Ensure that the main report returns one record, the datasource is irrelevant, and then suppress that record. This just ensures that the subreports will process.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for ur reply Graham. But here the thing is different.
In the main report I am not accessing any datasource.And I am not supposed to do according to my requiremnt. SO in the main report nothing is there its just a blank.
I forgot to mention that I have a grouping on date for the data I have shown earlier in this post.
So If I place both subreports in any header or footer in main, the data in the subreports will not be grouped by date, as we don't have that date field in the main report.
SO subreport 1 will display the data for all thedates and the subreport2 also will display for all the dates.
But for each date I need to display subreport1 and subreprot2 data.
Is there anyother way.
Thanks
Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.