Grouping data in a report based on a boolean field

odrap

Registered User.
Local time
Today, 14:53
Joined
Dec 16, 2008
Messages
156
In a report , two type of productitems has to be displayed: dangerous and non-dangerous products.
The difference between this two type of products is determined by the field "ADR' present in each product record which is of type "boolean".
For dangerous products the field "ADR" is True, for all the others False.The dangerous products must be grouped together as well as the non -dangerous ones. In the section where the dangerous products will be displayed, a fixed text must preceed the records, and of each of the products the content of the field "weight" must be displayed . The total weight of all these products must be displayed on the bottom of this section.In most of the cases, the report doesn't have to display dangerous products, and in such a cases, the surface on the report reserved for displaying dangerous products must be released in favor of the non- dangerous products.
1) How can this grouping be done ?
2)Is a can grow and schrink of all controls of the dangerous section sufficient , so tha t when no dangerous products are present, this sections doesn't occupy surface on the report?
 
Thank you very much for the help.
I wish you all the best for 2009 and a lot of fun with computing.
Greetings from Belgium
 

Users who are viewing this thread

Back
Top Bottom