sql server reporting services: Filter does not work on a group? -- sql server reporting services

You're in the

sql server reporting services

group:

Filter does not work on a group?

Ben Holcombe
3/1/2005 3:31:04 PM

sql server reporting services: I must be missing something. I have a table with two groups. One groups on
the user who created the record the other on the date the record was created.
I sort on the username group by name and the createdate group with a
category type.

My dataset pulls information for the current year however in this table I
want to only display data for the last week. If I apply the filter to the
table I receive expected results however if I apply the filter to the group
nothing comes back.

For either group if I put "= #2/22/2005#" for the expression "<=" as the
operator and "= Fields!CreateDate" as the Value I return 0 records despite
having some. I know my syntax is correct becaus this works at the table
level.

Re: Filter does not work on a group?

Jeff A. Stucker
3/1/2005 5:59:07 PM

And you have date values in there more recent than 2/22/2005?

2/22/2005 <= Fields!CreateDate

I would try "= Fields!CreateDate" in the expression and "= #2/22/2005#" in
the value.

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
[quoted text, click to view]

Re: Filter does not work on a group?

Ben Holcombe
3/2/2005 6:47:13 AM

Same result. I know there are values past 2/22/2005 because I see them
without the filter applied. The filter works at the table level just not the
group level. This is strange.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn