Skip to Content
avatar image
Former Member

Stacking Sub Report Links

Hello, I am currently stacking multiple subreport links on top of each other. These all link to different subreports. The subreport links are suppressed based on field value such that only one link appears per record. The new tab in the viewer that pops up has the correct tab name corresponding to the link but the report that is shown is the incorrect one. If I unstack all the links all of them will display the correct report when clicked. The form that shows is the one that is at the front of the report. Can anyone explain this behavior and how to correct it?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    Nov 24, 2017 at 04:18 PM

    When you conditionally suppress ondemand subreport, it makes the object invisible, but it is still click-able.

    When you stack objects on top of each other it makes only the top one always available for click.

    Solution is to place ondemand subreports into separate subsections (Details a, Details b, Details c, etc.)

    Then use your Conditional formulas to Suppress subsections.

    I just tested the solution and have a sample report.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2017 at 10:03 PM

    I am using Crystal Reports version 13.0.35 for Visual Studio and this is Windows based with the subreport links being Subreports on Demand.

    Add comment
    10|10000 characters needed characters exceeded

    • OK, so you are using SP 21 and 13.0.3500.0 assemblies, that is the version of the framework is uses. Not the same as the version of the dll's.

      Is it possible to get an example of the report based on XML so I can test what you are doing?

      You will need to upload it to a FTP server I can get to.

      Don

  • avatar image
    Former Member
    Nov 23, 2017 at 08:39 AM

    I am using Crystal Reports Version 13.0.3500.0 on Visual Studio 2013. This is a windows based app. The subreports links are Subreports on Demand.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 23, 2017 at 08:53 PM

    Link is here:

    https://www.dropbox.com/s/fjob8niy0dgx8mb/Generic%20Test%20Report.xml?dl=0

    Let me explain real quick what is going on. So for each Part Number there is a test report associated with it. All the view buttons are the links to the reports.The Links in question are the ones associated with Part Number 699629. That subreport link is stacked on top of the subreport link to the report for Part Number 699910. If you click on the the link with part number 699629(the top part with where the word 'view' is) it will open up the report associated with 699910. The view buttons are scattered about currently cause I was testing if they were destacked if they were linked to the right place.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2017 at 09:48 PM

    Need more info on the SDK used and Patch being used?

    Windows or WEB app?

    When you say subreport links do you mean URL's or Subreports on Demand?

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2017 at 06:35 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 24, 2017 at 03:51 PM

    Hi Connor,

    I see now what it is you are wanting to produce. We don't need your MDB's, we can dup the report layout using Xtreme sample or any data source.

    I talked to Vitaly and he's going to see if he can figure out how to make this logic work for you.

    A few suggestions, is it possible to move all of the subreport data into one MDB and then use Record Selection filtering to pass the single value to a single subreport that is linked using the value form the main report?

    The reason it does not work is because each ondemand subreport object gets layered on top of the last one. So the last one stacked is the one that is always going to run. You can see this by right clicking on any object and selecting "Move", you'll see you can move it to the back, to the front etc.... This is why you always get the last one stacked, it's in front of all others.

    Thanks again

    Don

    Add comment
    10|10000 characters needed characters exceeded