creating sql statement "where" at the report server

bs"d
While creating the report I looked for a way of filtering the data by
"WHERE" to compare two attributes such as ( customers.name = friends.name )
Is there a way to do it by the gui setup?
--
daiOn Jun 28, 10:00 am, dai <daikad...@.gmail.commm> wrote:
> bs"d
> While creating the report I looked for a way of filtering the data by
> "WHERE" to compare two attributes such as ( customers.name = friends.name )
> Is there a way to do it by the gui setup?
> --
> dai
If you have at least one group and either a table or matrix control,
you can try modifying the filter properties via: right-click the table/
matrix control -> select Properties -> Groups tab -> Edit... button ->
Filters tab. Then add an expression similar to: Fields!
CustomersName.Value = Fields!FriendsName.Value -or- possibly have the
Friends.Name as part of a hidden parameter set to a default and use:
Fields!CustomersName.Value = Parameters!FriendsName.Value
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant