cancel
Showing results for 
Search instead for 
Did you mean: 

Design two table in crytal report from 2 data tables

Former Member
0 Kudos

Hi,
I have two data table first record student mark details and other record grading rules. I have designed student marksheet from first data table and working as expected. Now I have to put grading rule table just below marksheet table. I have assigned records to grading rule data table. Both data table have data.

But when I try to add cross tab table for second data table then crystal report doesn't show anything but if cross tab of second data table is remove record are shown.

As sheen above I have shown exam mark sheet but if I add cross tab for second data table then I just get blank page. I want to print grading system exactly as shown in above picture. My crystal report Database field is shown as below

I can't merge these two datatables into one because one is rule table while other is actual data container table and moreover I have other rules to print in tabular format beside Grade rule.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Bhuban,

Use a Crosstab.

Choose the Percentage field as the Row and Grades field as the Summarized field. Set its Summary function to 'Max'.

If this still doesn't work, you'd need a Subreport.

-Abhilash

Former Member
0 Kudos

Hi Abhilash,

I tried both cross-tab and subreport but none helped me. I am trying subreport approach now. I have completed designing main report and supreport and have tested both and working individually but when I add subreport on main-report group footer#1 it displays rectangle like structure without data. I have datasource for both report but not getting output.

AS you can see in main report sub-report location there are 2 rectangles but if I run only sub-report it is displaying correctly.

Where did I do wrong can you please point me out.

Thank you

Answers (2)

Answers (2)

abhilash_kumar
Active Contributor
0 Kudos

Hi Bhuban,

Would you be able to attach the report with saved data please?

Also, what went wrong with the Crosstab approach?

-Abhilash

abhilash_kumar
Active Contributor
0 Kudos

Hi Bhuban,

Would you be able to attach the report with saved data please?

Also, what went wrong with the Crosstab approach?

-Abhilash

Former Member
0 Kudos

Hi Abhilash,

I have solved the issue using sub-report it was due to different data source instance in database field (I guess).

Thanks.