Skip to Content

Design two table in crytal report from 2 data tables

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.

record.png (17.9 kB)
datasource.png (8.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 18, 2017 at 01:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

      report.png (54.2 kB)
  • Dec 19, 2017 at 07:24 AM

    Hi Bhuban,

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

    Also, what went wrong with the Crosstab approach?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2017 at 07:24 AM

    Hi Bhuban,

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

    Also, what went wrong with the Crosstab approach?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded