Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 346
	Members: 0
	Total: 346

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

XTRA: parameters

1 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

cricketeer1

New Member Send Private Message

Posts: 0

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 Send Private Message

Posts: 514

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