Skip to Content
0

Hiding or Suppressing On-Demand Subreport text

Oct 14, 2016 at 04:57 PM

37

avatar image

I am adding multiple On-Demand subreports over top of some fields so the user can hyperlink to it from those values. I've modified the subreport font to be white, but when you view the report, you can still see the On-Demand subreport link overtop of the field so it's blurry. How can I make the link completely invisible so I can place it overtop of other fields without it affecting the visual?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Abhilash Kumar
Oct 14, 2016 at 06:13 PM
0

Hi Mercedes,

Instead of overlapping the subreport on another field, here's what you should do:

1. Right-click the Subreport > Format Subreport > Subreport tab > Click the formula button beside 'On-Demand Subreport Caption'.

Inside the formula editor, refer to the field whose value you wish to be displayed as the hyperlink text.

2. Remove the field that you originally had beneath the subreport.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Mercedes Green Oct 14, 2016 at 06:59 PM
0

Thank you for the suggestion and almost have it working. I've entered it, however, it says a "string is required here" when I try and enter my field. The field that I'm displaying is a sum of a number field. I've converted it to Text then removed the decimals, but I can't right-align it so all the vlaues that are subreports aren't aligning. Is there a right-align function?

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Oct 14, 2016 at 07:04 PM
0

You'd need to handle that in a formula.

Modify the formula like so:

Right(replicatestring(' ',10)&totext({Sum Field},'#'),20)

Increase or decrease the two numbers 10 & 20 depending on how large the subreport is.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
Mercedes Green Nov 01, 2016 at 04:36 PM
0

How large the subreport is? I'm not understanding. I only want a hyperlink to open the Subreport on a summary field. What does the size of the summary field have to do with teh size of the subreport?

Share
10 |10000 characters needed characters left characters exceeded
Mercedes Green Oct 14, 2016 at 08:21 PM
0

I think I figured it out. Thank you!

Share
10 |10000 characters needed characters left characters exceeded