Page 1 of 1

Subreports in Nubuilder

Posted: Tue Nov 23, 2021 8:47 pm
by slobodan
Do you have any plans to include subreports in to nuBuilder reports ?

Re: Subreports in Nubuilder

Posted: Thu Dec 09, 2021 7:44 am
by kev1n
I'm afraid it's not on the roadmap currently due to other priorities.

Re: Subreports in Nubuilder

Posted: Thu Dec 09, 2021 10:02 am
by nac
Hello slobodan,

You can approximate a subreport by using the grouping feature in the report design. Subforms/reports are just a visual representation of one-to-many relationships and so here is what I do.

Create a 1:n view with all the data columns needed for the report and use this as the data source. Use one of the columns on the '1' side to create a grouping in the report design. Put the objects from the '1' side of the join in the group header and put those from the 'many' side in the detail section. This will give you the master:detail (report:subreport) output when the report is generated.

Neil

Re: Subreports in Nubuilder

Posted: Tue Dec 14, 2021 10:44 pm
by slobodan
It is very interesting what you are proposing, but unfortunately I did not fully understand it. I would like to see that proposal on the example of a simple invoice with items, which has a separate recapitulation according to tax rates.

Re: Subreports in Nubuilder

Posted: Wed Dec 15, 2021 9:58 am
by Janusz
Hi,
Some example of the report with subsections you can find here:
viewtopic.php?p=23312#p23312
maybe it can help somehow.