Page 1 of 1

Groups in Groups with Filter in Conditions

Posted: Wed Jan 04, 2012 8:47 am
by klinsi
hey everyone,

i need to create a report where i have to list different variants of an offer. each variant hast two sublists. in the first sublist of an variant have to be all articles which are not declared as accessoires, and in the second sublist have to all articles which are declared as accessoires.
all articles are in one datatable, where each article has a columns with a variant-id (vid) and a declaration (category).

if you have any questions on understanding what i mean, please don't hesitate to ask!

i'm thankful for every help!

here are the screens of the datatable and the report-designer:

Image

Image

best regards :)

Groups in Groups with Filter in Conditions

Posted: Wed Jan 04, 2012 9:52 am
by HighAley
Hello.
klinsi wrote:i need to create a report where i have to list different variants of an offer. each variant hast two sublists. in the first sublist of an variant have to be all articles which are not declared as accessoires, and in the second sublist have to all articles which are declared as accessoires.
all articles are in one datatable, where each article has a columns with a variant-id (vid) and a declaration (category).

if you have any questions on understanding what i mean, please don't hesitate to ask!

i'm thankful for every help!

here are the screens of the datatable and the report-designer:
You should set the filter of DataBand5 to Offerte_NeuVars.category != "zubehoer" and the filter of DataBand7 to Offerte_NeuVars.category == "zubehoer".
Or just leave one Group Header and set the Group Condition to Offerte_NeuVars.category and the sort order to Descending.

Thank you.