on 07-15-2018 12:06 PM - last edited on 02-04-2024 4:50 AM by postmig_api_4
Hi,
I need to design a report as submitted below
I tried to achieve this but something is wrong with my report as below
as you can see there
but the problem here is all these information has been repeated in a following manner record * total record in table 1 * total record in table 2
for e.g. for subject record table 1 is academic skill and table 2 is personal skill so for math subject its 1 * 2 * 2 = 4 so we get math 4 times
similarly for Nepali handwriting = 1 * 2 subjects * 2 personal skills = 4 nepali handwriting records.
My report design looks like this
here DetalSection3(Detail b) is for Academic Skills table and DetailSection4(Details c) is for Personal Skill
For every Detail section I have enabled Keep Together and Absolute position in section expert.
How should i design this report?
Thanks
Hi Bhuban,
As there is no relationship between the tables, it results in a "cross-join". You'd need a subreport to display the "Academic Skills" table and another Subreport to display the "Personal Skills" table.
1. Setup a Main Report that connects to the Grades table. This is table that contains data for Subjects, Theory, Practical, etc
2. Place all fields you need on the Details Section.
3. Insert a Subreport that points to the Academic Skills table and place this on the Report Footer section to the extreme right.
Edit the Subreport and format it the way you need with lines, boxes etc
4. Insert a Report Footer b section.
5. Insert a Subreport that points to the Personal Skills table and place this on the Report Footer b section to the extreme right.
Edit and format the subreport.
6. Go to the Section Expert > Highlight Details section > Check "Underlay following sections".
-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
The report generated is not what I expected when I tried in larger dataset (multiple student). There is relationship between all tables except Grading System.
Left marksheet is loaded in one table the right Academic Skill and Personal Skill are loaded in their respective table. These three tables have one common column Admission No. So per page I need one student marksheet, academic skills, personal skills and grading system is common for all and one table at the bottom (Attendance) , it record are available in main table(marksheet)
As per above your instruction I am getting record of every student on each page for Academic and Personal skills.
Need to solve this ASAP.
Thanks
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.