Guess the Subject line is misleading : It should be Count and Distinct and not countdistinct.

Since I am using lookup for 2 other datsets , I need to get all values. Its only after its displayed , I want the Nulls to go away

Thanks.

The Thing is the IIF Clause returns blank row if the value is not meeting the condition. I am looking for it to not to display that row if the...

No Worries...

This Link was really helpful : http://www.bidn.com/blogs/ChrisAlbrektson/bidn-blog/1797/ssrs-action-to-open-outlook-email

No Worries. I went into series properties and changed the value to the respective one.

Worked for me

That does help.

Thank you so much

No Worries.

Found an easier way to get it ...

Expression : ="https://abc.com/?SystemID = "&Fields!SystemID.value

I tried using Split , But somehow its only using the first one in the list...

Split("Production,development",",")

The problem with the current query is that it gives me a total of both where clauses , where as I need it separately as per the subcategory

Output expected:

Configuration_Item ...

Thank you.

Here is what I was looking for

Select *

from SomeTable

where (table_id LIKE '%' + @ID+ '%' OR @ID = '*')

Select *

from SomeTable

where table_id LIKE '%' + @ID+ '%' OR table_id LIKE '%'

Well, it always give all values irrespective of parameter.

It will be passed through a dataset so the values will be entered at runtime.

So, I wont declare in the dataset...

Yes, I see that. But how can I also see all the values through wildcard.

I mean I should be able to pass "*" and see all aswell

You're right. So, I just added four lines outside to form a rectangle coz I had already added all the text boxes first.