Extend Details section

[Strannik]

Hi, all!

I have three tables in my MSSQL database: one base(A) and two sub-tables(B,C) with 1:n relation. It would be nice to have such report: one group section(A table) and two details sections where firstly all records from B table are displayed and after that all linked records from C table are displayed.
Is it possible to do so ?

Thanks in advance!

 

[lbass]

I think the easiest approach would be to create a subreport of information from each "subtable" and link each to the main report based on the fields you used to link the tables, probably an ID field. You should group on the ID field in the main report and then place each subreport in a separate group footer section (group footer#1a or group footer#1b).

You can eliminate borders if you want, and suppress various sections within each subreport to get the look you want.

-LB

 

[synapsevampire]

Rather than a subreport (which are slower and cumbersome), Group or Sort on a column which reflects the table being displayed.

If you don't have this, create a SQL Expression to fake it.

-k

 

[Strannik]

Thanks, lbass!

I've inserted sub-report and have linked both reports on primary key. Everything works!