Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
crystal parameters
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
NonnieBear1776
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5161
People Online:
Visitors:
186
Members:
0
Total:
186
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
crystal parameters
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
sharonmt
Basic Member
Posts: 9
7/7/2010 4:50 PM
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
7/7/2010 5:04 PM
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
7/7/2010 5:46 PM
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
7/7/2010 6:14 PM
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
7/8/2010 12:45 PM
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
7/8/2010 1:53 PM
could you send me a copy of your command file, post here please so i can look at it.
sharonmt
Basic Member
Posts: 9
7/8/2010 4:28 PM
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.