on 12-17-2017 2:44 PM - last edited on 02-04-2024 1:00 AM by postmig_api_4
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Bhuban,
Would you be able to attach the report with saved data please?
Also, what went wrong with the Crosstab approach?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhuban,
Would you be able to attach the report with saved data please?
Also, what went wrong with the Crosstab approach?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.