sql server reporting services: Avoid Drill trough for zero value -- sql server reporting services

You're in the

sql server reporting services

group:

Avoid Drill trough for zero value

Mahesh Gaware
8/26/2005 12:17:02 PM

sql server reporting services:

Hi,

I am using Drillthrough in table Cell in one of my report.

Table cell displays sum which is sometimes Zero. And when sum is zero, I
don't want Drillthrough featur at that point, so that I can avoid unnecessary
click.

I tried using expression =IIF( sum =0, "", ReportName)
but this then take me report server and displays all the avaialble report on
RS, which is big security hole.

Please let me know the solution.

Many Thanks,

How to Avoid Drill trough for zero value

Mahesh Gaware
8/26/2005 3:21:03 PM

Re: How to Avoid Drill trough for zero value

Robert Bruckner [MSFT]
8/26/2005 6:47:20 PM

Instead of "", use the keyword Nothing: =iif( Sum(...) = 0, Nothing,
ReportName)

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

[quoted text, click to view]

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