Hi All,
I have been working with reports now for a while. The examples and some
help from Fabien proved to be very useful.
I managed porting the most simple reports made in Ms Access to
gb.report.
But at the moment I'm stuck with something I can't figure out.
Since the project is big and data confidential I'll try and explain
using some sample data.
Imagine I have following data
Code Description Amount
103 Table 0
103 Table 20
103 Table 12
105 Chair 46
105 Chair 34
106 Bed 0
106 Bed 0
106 Bed 9
203 Pool table 2
203 Pool table 3
I'm trying to group by code and make a total for each group.
In Ms Access I based the report on a query that filters out the Amount
fields equal to 0. The grouping on the Code field could be done in the
report design.
With gb.report I have tried all kinds of different combinations of
controls and property settings and never managed to get the desired
result.
I would like the report to like this:
Articles produced <-- header of the report (only on page 1)
Code Description Amount
------------------------------
103 Table 20
103 Table 12
Total: 32
Code Description Amount
------------------------------
105 Chair 46
105 Chair 34
Total: 80
Code Description Amount
------------------------------
106 Bed 9
Total: 9
Code Description Amount
------------------------------
203 Pool table 2
203 Pool table 3
Total: 5
The number of groups is no fixed number, meaning there can be more
groups than shown above. In the reports I need this grouping we are
talking multi paged reports.
An example doing this would be very helpful and help me get quite some
of the left over Ms Access reports ported to Gambas.
P.S. Using Gambas 3.5.2
--
Kind regards,
Willy (aka gbWilly)
http://gambasshowcase.org/
http://howtogambas.org
http://gambos.org
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
