I got the answer:

select * from mytable

where class='something'

AND ISNULL(xyz,0) = CASE WHEN @abc = 1 THEN 1 ELSE ISNULL(xyz,0) END

Here @abc is the stored procedure parameter...

select * from mytable

where class='something'

and ISNULL(xyz, 99) = 1);

What is 99?

Thats why you have OR in between to cover both cases (OR im not getting it [Hehe] )

But that I...

select * from mytable

where class='something'

and (xyz is null OR xyz = 1);

But xyz can either be NULL or 1. I mean

select * from mytable

where class='something'

and xyz IS NULL

and

select * from...

Thanks for help.

Is it necessary to outlook be configured on the report server.

I made changes to rsconfig.

<SMTPServer>smtp.mycompanydomain</SMTPServer>

<SMTPServerPort>25</SMTPServerPort>

<SMTPServerPickupDirectory>C:\Inetpub\mailroot\Pickup</SMTPServerPickupDirectory>

<SendUsing>1</SendUsing>

And the mail is successfully sent to the pickup folder but it is not sent to outside servers. It says "Failure sending mail: The...

I have done it in my report. But it was on columns.

iif(Fields!abc.IsMissing,True,False)

If the field doesn't has data then the corresponding column was hided. leaving no traces. You have to...

Sorry, It was my fault. I was giving the wrong path in the database. It is working great.

I have got the remote report server url and I can successfully...

I am returning a table from database which contains customers and their bills paid. In SSRS, I make groups. First is "customer" which opens up to another subgroup of "month"...

Yeah, its happens for me too. The display is not correct in Firefox. Maybe Microsoft built it that way so that it cant be opened in another browser. 😉

Thanks to all. They will help in my presentation. 🙂

I did it by passing a default date in it always. Now the default date shows everytime and when if user wants to change then click the calender.

Like I said...

Thanks I got it working as you said. 🙂

I am doing like there are 4 parameters A,B,C,D. When A,B are selected then C or D comes alive. It depends on...