Thnks u guys for ur quick resopnces....

You can try below:

Format->New Fiels->Functions->Information->getusr()

try this...hope it will work.

Yes...actually b4 few months i did thsi and at that time it was working fine ...But now im not able to create ..

use query like this in where clause of your dataset

( column_name=@para1 or @para1 is null )

and also set allow null value and blank value in report parameter..

Hi,

Can you expain it briefly whatever you done in Union clause?pls it will helpful for me too much.

i have sam eproblem for about columns not row.Can you provide me any solution?

Hi,

i didnt get your que.but if you want to display all records for particular branch in one hyperlink then you can change your query for same.

Hi,

As per my knowledge there is no such tool is available.We also moved BO reports into SSRS by fresh development in SSRS.We tried to find any tool for that.But we...

I am also having same problem..Can anybpdy suggest on this?

hey,

im nt getting....this is related to SSRS to pass multiple values.But in database how procedure take the multiple values if i have selected multiple values in report?

In in parameter...

thanks for your help....this table valued function is very mch helpful for me...thnks guys.....

can you explin JOIN built in function in SSRS?i am not aware about this fn.

Thnks 4 ur help!!!!!!!!!!!!

hi....

i did it for upto 100 column.

but if u want to try it then take copy of that report..and u can try..

i used it for most of the reports...

hey..for this set page size to width:14in and height:11in.