Hi everyone,
I have a report where I have a rectangle witha bunch of lists and
textboxes on it which I hide on a certain case. The problem is, its
still taking space on the report page when the report is generated. It
doesn't appear, but I get a big empty space...
Is there any way to let the other items move up a little bit so I don't
have a big gap on my report?
Note: I can't add it to another table since I have lists on the
rectangle...
Thank you,Anyone has any ideas about how to accomplish this by any chance? I am
pretty stuckk...|||Can you try turning "Can Shrink" to true so that when there is no data that
it will shrink to a smaller size and let everything else move up?
"Spartacus" wrote:
> Anyone has any ideas about how to accomplish this by any chance? I am
> pretty stuckk...
>|||If it possible on Image or Rectangle?
Image and Rectangle doesn't have CanShrink.
Any idea?
Thanks!
Angi
"KimB" <KimB@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:7DB5C4A0-0C88-4CE1-99A9-BB5BAE2E0F14@.microsoft.com...
> Can you try turning "Can Shrink" to true so that when there is no data
> that
> it will shrink to a smaller size and let everything else move up?
> "Spartacus" wrote:
>> Anyone has any ideas about how to accomplish this by any chance? I am
>> pretty stuckk...
>>
Showing posts with label lists. Show all posts
Showing posts with label lists. Show all posts
Friday, March 23, 2012
Hidden Expression enquiry
Help!!!
I have a group that is grouped on a category code...
Under that group is a details line that lists the transactions of that
grouped code
I then have a group footer that has a subtotal...
On my report I also have two parameters Date From and Date To...
In order to show only the category codes and details that are in the user
defined period I have entered the following into the hidden expression
dialog box on the three rows..
=iif(Fields!DATE.Value >= Parameters!Report_Parameter_FROM.Value AND
Fields!DATE.Value <= Parameters!Report_Parameter_To.Value,False, True)
Now for my question:
On my report the details is correct... it shows only the details that fall
between the two data parameters. However, the categoryID sometimes will be
displayed and other times will not. I think it has something to do with the
grouping... but I cannot for the life of me solve it.
Can anyone assist?All,
I have got around the problem through the use of a subreport... but can
anyone explain why this happened?
"AshVsAOD" <.> wrote in message
news:u3tcSIbhEHA.1644@.tk2msftngp13.phx.gbl...
> Help!!!
> I have a group that is grouped on a category code...
> Under that group is a details line that lists the transactions of that
> grouped code
> I then have a group footer that has a subtotal...
> On my report I also have two parameters Date From and Date To...
> In order to show only the category codes and details that are in the user
> defined period I have entered the following into the hidden expression
> dialog box on the three rows..
> =iif(Fields!DATE.Value >= Parameters!Report_Parameter_FROM.Value AND
> Fields!DATE.Value <= Parameters!Report_Parameter_To.Value,False, True)
> Now for my question:
> On my report the details is correct... it shows only the details that fall
> between the two data parameters. However, the categoryID sometimes will
be
> displayed and other times will not. I think it has something to do with
the
> grouping... but I cannot for the life of me solve it.
>
> Can anyone assist?
>
I have a group that is grouped on a category code...
Under that group is a details line that lists the transactions of that
grouped code
I then have a group footer that has a subtotal...
On my report I also have two parameters Date From and Date To...
In order to show only the category codes and details that are in the user
defined period I have entered the following into the hidden expression
dialog box on the three rows..
=iif(Fields!DATE.Value >= Parameters!Report_Parameter_FROM.Value AND
Fields!DATE.Value <= Parameters!Report_Parameter_To.Value,False, True)
Now for my question:
On my report the details is correct... it shows only the details that fall
between the two data parameters. However, the categoryID sometimes will be
displayed and other times will not. I think it has something to do with the
grouping... but I cannot for the life of me solve it.
Can anyone assist?All,
I have got around the problem through the use of a subreport... but can
anyone explain why this happened?
"AshVsAOD" <.> wrote in message
news:u3tcSIbhEHA.1644@.tk2msftngp13.phx.gbl...
> Help!!!
> I have a group that is grouped on a category code...
> Under that group is a details line that lists the transactions of that
> grouped code
> I then have a group footer that has a subtotal...
> On my report I also have two parameters Date From and Date To...
> In order to show only the category codes and details that are in the user
> defined period I have entered the following into the hidden expression
> dialog box on the three rows..
> =iif(Fields!DATE.Value >= Parameters!Report_Parameter_FROM.Value AND
> Fields!DATE.Value <= Parameters!Report_Parameter_To.Value,False, True)
> Now for my question:
> On my report the details is correct... it shows only the details that fall
> between the two data parameters. However, the categoryID sometimes will
be
> displayed and other times will not. I think it has something to do with
the
> grouping... but I cannot for the life of me solve it.
>
> Can anyone assist?
>
Subscribe to:
Posts (Atom)