sql server reporting services: DrillThrough Link Only when there is data. -- sql server reporting services

You're in the

sql server reporting services

group:

DrillThrough Link Only when there is data.

Ravi R
3/11/2005 4:59:41 PM

sql server reporting services:

Hello All

My app has a central report that takes name as a param and returns all
names matching and has a table of databases, where there are data
regarding the particular person.
So I print mark in the column for the particular DB for the row of the
person. From here I provide a Drillthrough to the data present in the
particular db.

What I want to achieve is that How can I supress the drillthrough from
the cells that dont have data.
Currently I have the link active even in empty cells and on click I am
taken to the report with no data obviously.

Is there a way to suppress the drillthrough when say the result of
search is 0 for the person-database combo. ?

Thankx in advance
Ravi

Re: DrillThrough Link Only when there is data.

Lev Semenets [MSFT]
3/11/2005 10:08:03 PM

Use expression for drillthrough report name. If expression returns Nothing,
then link will be suppressed.
i.e.
=iif(Fields!Person.Value = 0,Nothing,"MyDrillthroughReport")

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: DrillThrough Link Only when there is data.

Ravi R
3/14/2005 8:03:31 AM

Lev

Thanks for the help.

Ravi

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn