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

Creating Notepad file through SQL Server 2005

Hi friends,

Is there any way to create a text file or word file through sql server 2005.

If you have any source please suggest me..

P.Kumaran

The question is vague at this point. Can you explain more details?

|||

Hi Dinakar,

Actually I want to write the output result (which i get from a select statement) to a notepad file.

Is it possible to write the select query result in a notepad from sqlserver 2005.

P.Kumaran

|||

You can use BCP utility to create a text file with the results of a query. Check out Books Online (or even google) on how to use the BCP tool.