crystal parameters

Sort:
You are not authorized to post a reply.
Author
Messages
sharonmt
Basic Member
Posts: 9
Basic Member
    I am a crystal advanced user(using since 1987 every version)

    i have an issue with 2008 and the parameters
    it appears that i have to use dynamic paramters, but concerned there will be rpt maintennace when not useing a lookup table to retrieve the values(datasets are sql stored procedures)

    i would like to be able to use a static parameter where i can use and ALL option or the user can enter a value or multiple

    with the dynamic parameters i can only use what is from the database values and not use an all option to retrieve all records.

    has anyone had this issue is there a work around?
    Char
    Veteran Member
    Posts: 62
    Veteran Member
      You can in fact use static parameters and since we're talking Lawson here, if you're using LBI you don't have a repository so you can't scheduled the LOV to update periodically so you're users will feel the impact of the query if it's a complicated query or long list. You can create a command just to drive the list as a separate object than the report's data source. Let's use Accounting Unit for example and assume you want to also have an "ALL" - my command to drive that might look like this (I'm doing it from memory because I'm not logged in to a Lawson client at the moment so I may have some field names/sytax a little off but you'll get the picture)


      (SELECT
      A.ACCT_UNIT,
      A.DESCRIPTION
      FROM LAWSON.GLUNITS A
      WHERE
      A.ACTIVE_STATUS = 'A'
      AND POSTING_LEVEL = 1)

      UNION

      (SELECT
      '*' AS ACCT_UNIT,
      'ALL' AS DESCRIPTION
      FROM LAWSON.GLUNITS B)

      ORDER BY ACCT_UNIT
      amynelson
      Advanced Member
      Posts: 25
      Advanced Member
        Try this formula in the Record Selection:

        IF {?AUC} <> 'All' THEN {GLNAMES.ACCT_UNIT} IN {?AUC}
        ELSE IF {?AUC} = 'All' THEN TRUE

        With this formula, the end user can key in the AUC, multiple AUC's and All.

        Hope this helps.
        sharonmt
        Basic Member
        Posts: 9
        Basic Member
          the real issue here, is not getting the values into crystal, that is not the real problem, it is how the lawson viewer interpertates the parameters

          i have 2 attachments

          static
          is static parameters with all, set with select multiple, custom etc. but if you see the screen shot it does not allow me to select anything besides ALL

          dynamic
          from database, no option for ALL and no option to add custom value

          if i dont have the repository set up to update daily my parameter values, is there another way?

          I would paste ss but file size limitation and doesnt accept word docs or xls????

          Char
          Veteran Member
          Posts: 62
          Veteran Member
            In order to have an ALL with a dynamic parameter you must create a command and use the type of sytax I gave you in my first post which will union an ALL with your chosen dynamic dataset. That's the only way to accomplish what you want with a dynamic parameter - I have a ton of reports just like that in production LBI for my clients.

            If you want to email me the attachment, I'm ccraig@crystaladvantage.com - I can't imagine why you could only select ALL from a static parameter - I've never experianced that but I'm happy to look at it with you
            sharonmt
            Basic Member
            Posts: 9
            Basic Member
              could you send me a copy of your command file, post here please so i can look at it.
              sharonmt
              Basic Member
              Posts: 9
              Basic Member
                installed sp2 that was my problem, mostly. unistalled
                there is also a setting under parameters to select crystal paramter window that needs to be checked off
                You are not authorized to post a reply.