For this you need to make changes in your dataset query.

Make some changes in the WHERE clause

i,e

Where

(@Param is NULL) or (@Param is not NULL and (yourfield=@Param))

yes I have three temp tables in my stored procedure.

Won't it work if I have temp tables in SP?

The output column names are not getting refreshing.

Even I tested this one as well.

Than in SSRS it is displaying me a Null row with column headers.

So here I introduced a text box with the text I want...

Am able to display like below in SSRS report result page if it executes second IF statement(i,e when the function returns N)

Attached the screenshot.Please help me out to handle this...

Now I can return a NULL row if it goes to second IF condition.How to add a label for that in SSRS??

Many thanks for all your help.

Many thanks for your replies.

Could you please explain me with an example please??

Hi Guys,

Thank you so much for your replies.Your replies and suggestions helped me to gain more knowledge.Thanks for that.

I have also googled from my end and I found that we...

Hi All,

Sorry i have reposted the same question due to some confusion, please ignore this

Hi Scott,

Thanks for your reply.

I will explain again my query to you.

We have one report in portal --- Report 1.

When you clicked this report ----variable screen will appear -...

Kindly let me know if any one of you need some additional information on this to understand?

Oh is it,

Could you please kindly let me know when I am happy with the response and when i feel the solution is correct then how can i mark this...

Hi Folks,

Before closing this thread just informing you all that this option is not possible through SSRS.

If any one have not agree with this then kindly let me know so...

Sorry for that

I am new to this fourm hence i just sent reply for some help.

generally i will post in sdn and will get reply in less than 5 minutes,...

Thanks Jack,

I have also with same idea but would like to cross check with experts like you.

thanks for your kind response.