Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Subreports in Nubuilder
-
- Posts: 25
- Joined: Sat May 08, 2021 1:20 pm
-
- nuBuilder Team
- Posts: 4292
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 444 times
- Contact:
-
- Posts: 115
- Joined: Tue Dec 12, 2017 11:28 pm
- Location: Aberdeen, UK
- Has thanked: 9 times
- Been thanked: 12 times
Re: Subreports in Nubuilder
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
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
-
- Posts: 25
- Joined: Sat May 08, 2021 1:20 pm
Re: Subreports in Nubuilder
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.
-
- nuBuilder Team
- Posts: 506
- Joined: Fri Dec 28, 2018 1:41 pm
- Location: Krakow, Poland
- Has thanked: 8 times
- Been thanked: 18 times
Re: Subreports in Nubuilder
Hi,
Some example of the report with subsections you can find here:
viewtopic.php?p=23312#p23312
maybe it can help somehow.
Some example of the report with subsections you can find here:
viewtopic.php?p=23312#p23312
maybe it can help somehow.
If you like nuBuilder, please leave a review on SourceForge