Wednesday, March 7, 2012

Expanding All groups

Is there any way to expand all of the collapsed groups in a report?
TIA
DeanOn Aug 9, 3:46 pm, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> Is there any way to expand all of the collapsed groups in a report?
> TIA
> Dean
You have a few options here. By default, when exporting to PDF, all
groups are expanded. Otherwise, you can either set 'Visibility can be
toggled by another report item' as part of the report control's
Properties: (via right-clicking the control) -> Visibility tab and set
all of the controls to the same Report item. Also, you could set all
of the control's 'Initial Visibility' (via: right-clicking Properties -
> Visibility) to the same Expression (possibly a parameter value or
value in a dataset, etc). Also, note that exporting to Excel, etc
normally defaults the groups to collapsed, which most likely cannot be
overwritten. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I guess I was not very clear so i'll try again.
In the browser, i'd like to be able have an Expand ALL choice so that if I
have mutiple subgroupings they can all be opened at once. Something similar
what can be done in Outlook when changing the views.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1186713038.011504.276300@.x40g2000prg.googlegroups.com...
> On Aug 9, 3:46 pm, "Dean" <deanl...@.hotmail.com.nospam> wrote:
>> Is there any way to expand all of the collapsed groups in a report?
>> TIA
>> Dean
>
> You have a few options here. By default, when exporting to PDF, all
> groups are expanded. Otherwise, you can either set 'Visibility can be
> toggled by another report item' as part of the report control's
> Properties: (via right-clicking the control) -> Visibility tab and set
> all of the controls to the same Report item. Also, you could set all
> of the control's 'Initial Visibility' (via: right-clicking Properties -
>> Visibility) to the same Expression (possibly a parameter value or
> value in a dataset, etc). Also, note that exporting to Excel, etc
> normally defaults the groups to collapsed, which most likely cannot be
> overwritten. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

No comments:

Post a Comment