How to get this Layout displaying data both on left and right side
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.
Graham Cunningham replied
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.