cancel
Showing results for 
Search instead for 
Did you mean: 

Design Report with multiple table structure

Former Member
0 Kudos

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

  1. I have only two subject (Math and Sciene)
  2. I have only two academic skill(Nepali Handwriting and Classroom Participation)
  3. I have only two personal skills(Discipline and Drawing)

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

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Abhilash,

Thank you for your detail instruction. I had implemented sub-report for all required tables that needs to display in report and placed them in Group Header Section 1 and managed each width and height so that all looks nice and clean.

Thank you

Former Member
0 Kudos

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