Hide group sections

[robert12]

Is there a way to hide group sections based on a parameter defined by the user ?
For example, suppose that a report is grouped by
Country
Region
Town
--details

Based on the parameter, the reports will show only the totals by country or the totals by country and region etc...

Is there an elegant way to do this ?

 

[h0h0h0]

Yep - There's an example in one of the ERD sample reports that come with the IDE. Look at some of the grouping reports.

 

[johnberchmans]

Based on parameter, if you set the key of group Region to that of Country, then you can 'hide' the Region group.

For example, override the Start method of Region group section as follows (assuming you have already specified the Key property of the two groups).

Sub Start()
if Parameter = 1 then ' condition
KeyColumnName = "CountryCode" ' the key of Country group
else
' keep the key assigned
end if
Super::Start()
End Sub