Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Crystal Parameters for QB 9.0.3

Sort:
You are not authorized to post a reply.
Author
Messages
Phil Simon
Veteran Member
Posts: 135
Veteran Member
8/6/2007 10:49 AM
    Hello

    I saw the KB article on Crystal Parameters called:

    Passing parameters from Crystal to OLE DB Object Services


    Description:
    How do I pass a Crystal Parameter to an OLE DB Object Services DME query?

    ****

    A few things here:

    Note: Date fields and certain conditional fields cannot be used.

    ***

    I was able to add a date prompt and it worked like a charm. Is this simply a matter of Lawson's documentation not being updated?

    The performance improvement is huge for tables such as PRTIME but I'm still stuck with the generic Param1 name. Has anyone figured out a way to put in meaningful text and still have the report work?

    Thanks in advance, all.

    ps
    Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
    John Henley
    Senior Member
    Posts: 3348
    Senior Member
    8/7/2007 12:05 AM
      Lawson's documentation may be out of date. I know I tried date parameters a while ago (see https://www.danalytics.co...archive/2005-04.htm) and they didn't work...so they may have updated the OLE DB provider to handle them.

      If you're use Crystal 10 or XI, you can use text "prompts" for the parameters to at least provide some user meaning to your users, but I think you're stuck with the Param1, Param2 naming...
      Thanks for using the LawsonGuru.com forums!
      John
      Phil Simon
      Veteran Member
      Posts: 135
      Veteran Member
      8/7/2007 9:35 AM
        I searched the OLEDB UG for text prompts via commands (even before getting to the generic Crystal Parameter screen), but couldn't find anything. If you know how to add these, then I'd love to know! Thanks.
        Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
        John Henley
        Senior Member
        Posts: 3348
        Senior Member
        8/7/2007 11:16 AM
          It's not a Lawson feature; it's a Crystal feature. After you've defined the parameter it's added to the Parameters in Crystal. If you right click it and select 'Edit' you can enter "prompt text" so that a user will see that text instead of 'Enter Param1'.
          Attachments
          Thanks for using the LawsonGuru.com forums!
          John
          Phil Simon
          Veteran Member
          Posts: 135
          Veteran Member
          8/7/2007 11:29 AM
            Oh, I was looking in Query Builder for that.

            Gotcha. Works like a charm. For really large tables, I'm building the prompts at the command level so they return records quickly. This is excellent!
            Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
            You are not authorized to post a reply.