CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6

Hybrid View

  1. #1
    Join Date
    Jul 2013
    Posts
    4

    open a subreport from mainreport by a link

    How to open a subreport from the mainreport by a hyperlink

  2. #2
    Join Date
    Jul 2005
    Posts
    1,083

    Re: open a subreport from mainreport by a link

    You could use an on-demand subreport
    On-demand subreports can be especially useful when you want to create a report that contains multiple subreports. In this case, you can choose to have these subreports appear only as hyperlinks.

    The actual data is not read from the database until the user drills down on the hyperlink. This way only data for on-demand subreports that are actually viewed will be retrieved from the database. This makes the subreports much more manageable.

    To create an on-demand subreport:
    1 Place an ordinary subreport in your primary report.
    2 Click the Format button on the Expert Tools toolbar.
    3 The Format Editor dialog box appears.
    4 Click the Subreport tab and select the On-demand subreport (similar to a hyperlink) check box.
    5 Click OK.
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

  3. #3
    Join Date
    Jul 2013
    Posts
    4

    Re: open a subreport from mainreport by a link

    thankyou for your reply

    i would also like to know how to supress/hide the detail section if the group name(from group tree) is not selected

  4. #4
    Join Date
    Jul 2005
    Posts
    1,083

    Re: open a subreport from mainreport by a link

    As far as I know, the Group Tree is a kind of explorer to easyly navigate thru all the displayed Groups...
    I think that You should search about Record or Group Selection, that only will display the selected one(s)
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

  5. #5
    Join Date
    Jul 2013
    Posts
    4

    Re: open a subreport from mainreport by a link

    thankyou JG,

    can you also explain how to write a formula to show the detail section when the groupname is selected in group selection.

  6. #6
    Join Date
    Jul 2005
    Posts
    1,083

    Re: open a subreport from mainreport by a link

    You could use a parameter field to ask for the desired item
    Then use that parameter field in the RecordSelectionFormula
    Visit next place to start ---> http://www.informit.com/articles/art...83066&seqNum=3
    or
    https://www.google.com.mx/?gws_rd=cr...w=1024&bih=625
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured