dynamic Grouping Levels

  • Thread starter Thread starter Peter Hafner
  • Start date Start date
P

Peter Hafner

Hi there,

I want to create reports which have a dynamic number(1 to 4) of grouping
levels depending on a user action (listbox).

With CreateGroupLevel I have to create the layout of headers, footer,
details etc. by code (too difficult).

Therefore I tried to create a Report with 4 grouping levels and deleting
the unneeded levels on the open event with Me.GroupLevel(n).GroupFooter
= False which is not working.

Hiding the Footers etc. still requires to set a controlSource for the
grouping level (which one if the user don´t want one??).

Any ideas how to solve this problem?

Thanx,

Peter
 
Peter said:
I want to create reports which have a dynamic number(1 to 4) of grouping
levels depending on a user action (listbox).

With CreateGroupLevel I have to create the layout of headers, footer,
details etc. by code (too difficult).
Click to expand...

A bad idea anyway.

Therefore I tried to create a Report with 4 grouping levels
Click to expand...
[snip]

On the right track now.

Hiding the Footers etc. still requires to set a controlSource for the
grouping level (which one if the user don´t want one??).
Click to expand...

Use the report's Open event to change the group level's
ControlSource property and make the unused ones invisible.
If you don't want a group level to do any sorting, then set
its control source to a constant expression such as =1. For
example:

Me.GroupLevel(0).ControlSource = "thisfield"
Me.GroupLevel(1).ControlSource = "thatfield"
Me.GroupLevel(2).ControlSource = "otherfield"
Me.GroupLevel(3).ControlSource = "=1"
Me.Section(11).Visible = False 'hide header
Me.Section(12).Visible = False 'hide footer
 
Marshall said:
Peter said:
I want to create reports which have a dynamic number(1 to 4) of grouping
levels depending on a user action (listbox).

With CreateGroupLevel I have to create the layout of headers, footer,
details etc. by code (too difficult).
Click to expand...


A bad idea anyway.


Therefore I tried to create a Report with 4 grouping levels
Click to expand...

[snip]

On the right track now.


Hiding the Footers etc. still requires to set a controlSource for the
grouping level (which one if the user don´t want one??).
Click to expand...


Use the report's Open event to change the group level's
ControlSource property and make the unused ones invisible.
If you don't want a group level to do any sorting, then set
its control source to a constant expression such as =1. For
example:

Me.GroupLevel(0).ControlSource = "thisfield"
Me.GroupLevel(1).ControlSource = "thatfield"
Me.GroupLevel(2).ControlSource = "otherfield"
Me.GroupLevel(3).ControlSource = "=1"
Me.Section(11).Visible = False 'hide header
Me.Section(12).Visible = False 'hide footer
Click to expand...
Hi Marsh,

thanks a lot.
It looks like it is working. I just thought that I have missed a more
elegant way to do that.
Maybe you can explain why setting ControlSource to =1 is working, i.e.
is doing nothing but also not generating any error?

Thanks again for the help,

Peter
 
Peter said:
Marshall said:
Peter said:
I want to create reports which have a dynamic number(1 to 4) of grouping
levels depending on a user action (listbox).

With CreateGroupLevel I have to create the layout of headers, footer,
details etc. by code (too difficult).
Click to expand...


A bad idea anyway.


Therefore I tried to create a Report with 4 grouping levels
Click to expand...

[snip]

On the right track now.


Hiding the Footers etc. still requires to set a controlSource for the
grouping level (which one if the user don´t want one??).
Click to expand...


Use the report's Open event to change the group level's
ControlSource property and make the unused ones invisible.
If you don't want a group level to do any sorting, then set
its control source to a constant expression such as =1. For
example:

Me.GroupLevel(0).ControlSource = "thisfield"
Me.GroupLevel(1).ControlSource = "thatfield"
Me.GroupLevel(2).ControlSource = "otherfield"
Me.GroupLevel(3).ControlSource = "=1"
Me.Section(11).Visible = False 'hide header
Me.Section(12).Visible = False 'hide footer
Click to expand...
Hi Marsh,

thanks a lot.
It looks like it is working. I just thought that I have missed a more
elegant way to do that.
Maybe you can explain why setting ControlSource to =1 is working, i.e.
is doing nothing but also not generating any error?
Click to expand...


It is perfectly legal to group on an expression. For
example, it's not uncommon to sort/group on something like
=[LastName] & "~" & [FirstName]

The expression:
=1
is just about the simplest expression you can get and since
it doesn't change from one record to another, it will not
have any effect on the order of the records. Your use of it
is only one of several situations where this can be useful.
 
Marshall said:
Peter Hafner wrote:

Marshall Barton wrote:

Peter Hafner wrote:


I want to create reports which have a dynamic number(1 to 4) of grouping
levels depending on a user action (listbox).

With CreateGroupLevel I have to create the layout of headers, footer,
details etc. by code (too difficult).


A bad idea anyway.




Therefore I tried to create a Report with 4 grouping levels

[snip]

On the right track now.




Hiding the Footers etc. still requires to set a controlSource for the
grouping level (which one if the user don´t want one??).


Use the report's Open event to change the group level's
ControlSource property and make the unused ones invisible.
If you don't want a group level to do any sorting, then set
its control source to a constant expression such as =1. For
example:

Me.GroupLevel(0).ControlSource = "thisfield"
Me.GroupLevel(1).ControlSource = "thatfield"
Me.GroupLevel(2).ControlSource = "otherfield"
Me.GroupLevel(3).ControlSource = "=1"
Me.Section(11).Visible = False 'hide header
Me.Section(12).Visible = False 'hide footer
Click to expand...

Hi Marsh,

thanks a lot.
It looks like it is working. I just thought that I have missed a more
elegant way to do that.
Maybe you can explain why setting ControlSource to =1 is working, i.e.
is doing nothing but also not generating any error?
Click to expand...



It is perfectly legal to group on an expression. For
example, it's not uncommon to sort/group on something like
=[LastName] & "~" & [FirstName]

The expression:
=1
is just about the simplest expression you can get and since
it doesn't change from one record to another, it will not
have any effect on the order of the records. Your use of it
is only one of several situations where this can be useful.
Click to expand...

Now we know! Thank you,

Peter
 
Back
Top