Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

XTRA: parameters

Sort:
You are not authorized to post a reply.
Author
Messages
cricketeer1
New Member
Posts: 2
New Member
6/16/2006 5:25 PM
    Scenario:
    I am trying to build a Report in Crystal XI from a Lawson report. Customer runs a Lawson Report, I pick up the data using a "xtra:... " Lawson Query that the user has provided. Once the report is successfully developed, the customer would like to run the same report against similar Lawson Reports which may use a different Department etc. To accomplish that I would like to create a parameter which allows the user to choose which values are used in the "xtra" command for the following parameters:

    _USR, _JOB, _STEP, _PTH, _FN

    Is it possible to create parameters for these values? I have tried to use parameters in the Lawson Query builder for _PTH and _FN values, but get the following error:

    "Error retrieving report schema from IOS"

    Please help.
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    9/27/2006 8:25 PM
      Lawson Query Builder wont let you edit the command object it creates, so I would suggest using a Selection Statement to filter the records. Performance wont be as great as it would be if you could pass parameters directly to the command obect but it should accomplish what youre looking ot do.

      hth
      matt
      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.