Skip to Content

Hiding or Suppressing On-Demand Subreport text

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Oct 14, 2016 at 06:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 14, 2016 at 06:59 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 14, 2016 at 07:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 01, 2016 at 04:36 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 14, 2016 at 08:21 PM

    I think I figured it out. Thank you!

    Add comment
    10|10000 characters needed characters exceeded