I need to display the name of an expanded group

Hi everyone,
I want to display the name of an expanded group within a seperate text
box. The problem is that it doesn't work because my seperate text box
is "not part of the group area" which the name/field belongs to. What
should I do?
How can I access report items of a group outside that group? I though
I could temporarily copy values from a field of a group into a 'global
parameter' (if it's possible, of course) and then make my text box
display the value by referencing that parameter. But since I don't
know how to do that either, I have run out of ideas.On Mar 14, 11:01 am, "mailfo...@.googlemail.com"
<mailfo...@.googlemail.com> wrote:
> Hi everyone,
> I want to display the name of an expanded group within a seperate text
> box. The problem is that it doesn't work because my seperate text box
> is "not part of the group area" which the name/field belongs to. What
> should I do?
> How can I access report items of a group outside that group? I though
> I could temporarily copy values from a field of a group into a 'global
> parameter' (if it's possible, of course) and then make my text box
> display the value by referencing that parameter. But since I don't
> know how to do that either, I have run out of ideas.
If I'm understanding you correctly, you could use something like the
following:
To access a parameter, use an expression like: =Parameters!
ParameterName.Value
To access a dataset outside of it's normal scope, use an expression
like: =Max(Fields!FieldName.Value, "DataSetName")
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Its not possible to have a report item placed outside the group. It can be
placed only on header, footer or in the grouping. One option is that in your
grouping you can insert as many blank rows and then place the report items,
but that too static headers not the details of any rows. ie you can refer one
value and not multiple.
Amarnath,MCTS
"mailforpr@.googlemail.com" wrote:
> Hi everyone,
> I want to display the name of an expanded group within a seperate text
> box. The problem is that it doesn't work because my seperate text box
> is "not part of the group area" which the name/field belongs to. What
> should I do?
> How can I access report items of a group outside that group? I though
> I could temporarily copy values from a field of a group into a 'global
> parameter' (if it's possible, of course) and then make my text box
> display the value by referencing that parameter. But since I don't
> know how to do that either, I have run out of ideas.
>|||Thank you very much, guys.
Is there any other way to determine whether a group has been expanded
or not? I don't necessarily have to display a value of a field of a
specific group area in a seperate text box, but rather something like
"oh, you have just expanded group xyz, so I let you know that in that
text box you see over there"...?
The code might probably look like this:
textbox.Value:
=IIF(groupXYZ.Expanded,"Group XYZ is expanded","nothing or something
else is expanded")
Is that possible?