how do i filter any expression in the data region
e.g. i want all users for just New York?
how to apply that filter condition in the expression in data region?See BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_3diq.asp
Example:
Filter expression: =Fields!City.Value
Operator: =Value expression: ="New York" or just New York (because it is a string)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <Raj@.discussions.microsoft.com> wrote in message
news:D5F8D505-BC13-4F20-887A-62BC1BF2A669@.microsoft.com...
> how do i filter any expression in the data region
> e.g. i want all users for just New York?
> how to apply that filter condition in the expression in data region?|||Sorry, but based on your questions I thought you want to filter data.
However, you actually want to calculate some aggregates. Try this
expression:
=Count( iif(Fields!City.Value = "New York", 1, Nothing) )
The count aggregate also takes a scope parameter, so depending on where you
use this expression in the report, you might need to add a scope for the
aggregate (e.g. the dataset name or containing reportitem name). E.g.:
=Count( iif(Fields!City.Value = "New York", 1, Nothing), "DataSet1" )
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <Raj@.discussions.microsoft.com> wrote in message
news:7031923E-DD39-4A21-9721-F9CEF898D707@.microsoft.com...
> hi robert
> i am still confused
> i have a field but i dont want to use filter on the fields.city.value
> i want to count users where city is new york
> 1 field in my table is userid
> 1 field is their residing city
> what shall i do?
> "Robert Bruckner [MSFT]" wrote:
> > See BOL:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_3diq.asp
> >
> > Example:
> > Filter expression: =Fields!City.Value
> > Operator: => > Value expression: ="New York" or just New York (because it is a string)
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Raj" <Raj@.discussions.microsoft.com> wrote in message
> > news:D5F8D505-BC13-4F20-887A-62BC1BF2A669@.microsoft.com...
> > > how do i filter any expression in the data region
> > > e.g. i want all users for just New York?
> > > how to apply that filter condition in the expression in data region?
> >
> >
> >|||i want to count the same thing
but count(nuserid) which is userid
in a text box in table
how will the box understand using this query
=Count( iif(Fields!City.Value = "New York", 1, Nothing), "DataSet1" )
that i want to count userid?
i dont have any parameters in my report
"Robert Bruckner [MSFT]" wrote:
> Sorry, but based on your questions I thought you want to filter data.
> However, you actually want to calculate some aggregates. Try this
> expression:
> =Count( iif(Fields!City.Value = "New York", 1, Nothing) )
> The count aggregate also takes a scope parameter, so depending on where you
> use this expression in the report, you might need to add a scope for the
> aggregate (e.g. the dataset name or containing reportitem name). E.g.:
> =Count( iif(Fields!City.Value = "New York", 1, Nothing), "DataSet1" )
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Raj" <Raj@.discussions.microsoft.com> wrote in message
> news:7031923E-DD39-4A21-9721-F9CEF898D707@.microsoft.com...
> > hi robert
> > i am still confused
> > i have a field but i dont want to use filter on the fields.city.value
> > i want to count users where city is new york
> > 1 field in my table is userid
> > 1 field is their residing city
> > what shall i do?
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > See BOL:
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_3diq.asp
> > >
> > > Example:
> > > Filter expression: =Fields!City.Value
> > > Operator: => > > Value expression: ="New York" or just New York (because it is a string)
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > > "Raj" <Raj@.discussions.microsoft.com> wrote in message
> > > news:D5F8D505-BC13-4F20-887A-62BC1BF2A669@.microsoft.com...
> > > > how do i filter any expression in the data region
> > > > e.g. i want all users for just New York?
> > > > how to apply that filter condition in the expression in data region?
> > >
> > >
> > >
>
>
