1

Description

enter image description here

I want to disable links (Go to report action) when data is Zero or Nothing.

I used below expression in go to Report section:

=IIf(IsNothing(Fields!HighwayLampCounts.Value)=0, "rpt_Highway_Online_Koli_Detail","rptNoData")

But, it doesn't work :(

Pedram
  • 6,256
  • 10
  • 65
  • 87
Nahid
  • 95
  • 2
  • 9
  • why you have written `IsNothing(Fields!HighwayLampCounts.Value)=0` ? do you know what it will do? – Pedram Jan 06 '16 at 06:43
  • Oh, I found it. It should be : IsNothing(Fields!HighwayLampCounts.Value)=TRUE – Nahid Jan 06 '16 at 06:53
  • Yes it should be true OR `Fields!HighwayLampCounts.Value=0` – Pedram Jan 06 '16 at 06:55
  • But, How I can disable link if it is Null, That way I just linked Zero to an empty page. I want Zero Value doesn't have link. – Nahid Jan 06 '16 at 07:00
  • simply set expression to textbox properties inside visibility. – Pedram Jan 06 '16 at 07:16
  • I set visibility of TextBox to =IIf(IsNothing(Fields!HighwayLampCounts.Value)=True, True, False) But it hide the Zero items I want to show Zero Items with no link – Nahid Jan 06 '16 at 07:23
  • you should put one rectangle over there and then inside that put two text boxes with condition - and show hide as per condition. that could be the solution in this problem. - Does it make sense? OR use `Nothing` inside expression where you don't want to set link it will work. – Pedram Jan 06 '16 at 07:32
  • YES.. It worked fine... Thank you very much... – Nahid Jan 06 '16 at 07:47
  • you're welcome. btw what you tried at last? you can answer to your own question here, so it can helps to other. thanks – Pedram Jan 06 '16 at 08:30
  • =IIf(IsNothing(Fields!HighwayLampCounts.Value) = True, Nothing, "rpt_Highway_Online_Koli_Detail") – Nahid May 29 '16 at 09:58

2 Answers2

1

You should put one rectangle over there and then inside that put two text boxes with condition - and show hide as per condition. that could be the solution in this problem.

Many Thanks to rajeshpanchal

Community
  • 1
  • 1
Nahid
  • 95
  • 2
  • 9
1

I found a better way! Using Nothing in Go to Report works... Use below expression in Specify a report:

=IIf(IsNothing(Fields!HighwayLampCounts.Value) = True, Nothing, "rpt_Highway_Online_Koli_Detail")

This way link would be eliminated from Null Values...

Nahid
  • 95
  • 2
  • 9
  • Thanks! This disables the link cursor/action, plus also e.g. a dummy underlined space that it seemed to insist on showing. So this works and is far easier and cleaner than the other method. You should mark this as accepted! – underscore_d Nov 02 '17 at 10:50