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?
>