BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Restrict hyperlink by value in crystal report


 
Search this topic... | Search Crystal Reports... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Author Message
Blowers
Senior Member
Senior Member



Joined: 30 Sep 2009

Posts: 87



PostPosted: Fri Apr 05, 2019 8:22 am 
Post subject: Restrict hyperlink by value in crystal report

I have a hyperlink in a crystal report that I want to not display when the value being populated is 0.
I still want the value to appear on the report, but I don't want it to create a hyperlink to the other report as it has no data on this other report, and generates an error when clicking on the hyperlink. Any ideas if this can be done?
Thanks!
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Tue Apr 09, 2019 9:25 am 
Post subject: Re: Restrict hyperlink by value in crystal report

I don't think there is a way to do this using a single field object, so what I would do is this:

1. Put the value field on the report and set the hyperlink. In the object format, set the suppress formula to something like:

{value field} = 0

2. Put the value field on the report again without setting a hyperlink (initially, do no put this on top of the field from step 1). In the object format, set the suppress formula to something like:

{value field} <> 0

3. Select both fields, right-click to make them the same size and right-click again to align the top and left.

This will show the field with the hyperlink when the value is > 0 and the one without the hyperlink when the value is 0.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
Blowers
Senior Member
Senior Member



Joined: 30 Sep 2009

Posts: 87



PostPosted: Tue Apr 09, 2019 10:21 am 
Post subject: Re: Restrict hyperlink by value in crystal report

Thanks for the reply! I ended up suppressing the field to prevent the hyperlink, but I will also try your trick of putting the field in again so the 0 value is displayed, as currently its blank icon_biggrin.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0296 seconds using 17 queries. (SQL 0.0030 Parse 0.0009 Other 0.0257)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo