• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

Reports - GroupLevel (ACC97)

Hi,
I have a report that has 2 GroupLevels defined in design mode.
In the help I see that I can edit these group levels or add more using CreateGroupLevel, but how can I remove a group level?
thanks
0
jacy_m
Asked:
jacy_m
1 Solution
 
jacy_mAuthor Commented:
In run mode using vb i mean
0
 
DrHCommented:
Show the Sorting and Grouping box from the view menu
Highlight the row of the group you wish to remove by Left Clicking to the left of the field name
Make certain that Num Lock is off and press the DEL key
Confirm deletion
0
 
jacy_mAuthor Commented:
I need to do this in VB code, during run time

I have figured out a way to (sort of) remove the 2nd grouping level now myself... this is to set the ControlSource of GroupLevel1 to be the same as the ControlSource of GroupLevel0 and then hide the header and footer of the second grouping level

I will try and get this question closed...
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jonathan KellyCommented:
i got around this problem by using a report with no grouping levels - ReportSource.
at runtime i copy ReportSource,
paste it as ReportActual,
add grouping levels to ReportActual using CreateGroupLevel,
and load ReportActual as the report.

when the process begins again ReportActual is overwritten effectively removing the grouping levels.






0
 
dbase118Commented:
Are you specifically wanting to do this in code? I ask because in the Sorting and Grouping dialog box in report design veiw, you can click the grey square at the beginning of whichever line you want to delete and press delete once it highlights.
0
 
MindphaserCommented:
jacy_m

points refunded and question moved to PAQ since you provided your own solution.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now