Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

One crystal report executing another crystal report ?

Sort:
You are not authorized to post a reply.
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
Veteran Member
4/16/2009 7:22 PM

    Has anybody accomplished one report executing another crystal report and passing a parameter .

    I know this can be done by adding an hyperlink to the report and passing a parameter. Can somebody share the excat sysntax after publishing both on lbi.

     

    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    4/16/2009 7:40 PM
      something like this:

      "http://lbiserver/efs/FSRemote?fsid=FSRemote?fsid=RS:RS-Reporting Services:12&parametername=parametervalue "

      you can see more options in the RS user guide, Chapter 8: Scripting Reports
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      Ruma Malhotra
      Veteran Member
      Posts: 412
      Veteran Member
      4/17/2009 1:45 PM

        Instead of executing the crstal report when a parameter is passed, I would like to bring up the latest instance of the report via the parent report.

        According  to chapter 8 of the reporting services manual & InstanceId=Latest should be added. Has anybody tried this ? Does this work ?

        Matthew Nye
        Veteran Member
        Posts: 514
        Veteran Member
        4/17/2009 2:22 PM
          yeah, just append that to the end of the URL. Keep in mind that if there is no historical instance it will run the report with Data Refresh.
          If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
          Ruma Malhotra
          Veteran Member
          Posts: 412
          Veteran Member
          4/17/2009 2:50 PM

            This is very helpful. Is there anyway i can prevent the whole report to run with report refresh if there is no historical instance created.

            Matthew Nye
            Veteran Member
            Posts: 514
            Veteran Member
            4/17/2009 3:07 PM
              the only way would be to explicitly define the numbered instance. Instance=##
              If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
              You are not authorized to post a reply.