Who's On?

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

	People Online:
	Visitors: 377
	Members: 1
	Total: 378

	Online Now:
	Jen

New Topics

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

Crystal Parameters for QB 9.0.3

4 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

Phil Simon

Veteran Member Send Private Message

Posts: 135

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

John Henley

Posts: 3351

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

Phil Simon

Veteran Member Send Private Message

Posts: 135

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.

John Henley

Posts: 3351

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

187165436171.jpg

Phil Simon

Veteran Member Send Private Message

Posts: 135

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!