crystal parameters

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

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.

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????

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

could you send me a copy of your command file, post here please so i can look at it.

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