Who's On?

	Membership:
	Latest: Chris Radcliffe
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5187

	People Online:
	Visitors: 236
	Members: 0
	Total: 236

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

Crystal parameters - defaulting

Sort:

You are not authorized to post a reply.

Author

Messages

Phil Simon

Veteran Member

Posts: 135

8/8/2007 6:24 PM

Hello

I was wondering if anyone figured out how to do this.

I have a parameter at the command level for PRTIME that will limit the records pulled, since that table gets to be big.

TR-DATE =?

To compare paychecks, I have another command set to PRTIME with the same parameters:

TR-DATE =?

Ideally, someone can put in parameter 1 = 7/1/07 and parameter s 7/15/07 so you can compare both paychecks.

However, OLEDB's command builder isn't liking adding the same parameter twice. The second one never appears in Crystal. I would think that you could do this.

Thank you,

ps

John Henley

Senior Member

Posts: 3348

8/8/2007 6:44 PM

Phil, are you using two different OLEDB/ADO commands in the report?

Phil Simon

Veteran Member

Posts: 135

8/8/2007 6:48 PM

Yes, I am using separate commands.

"Undocumented" feature? <img src='desktopmodules/ntforums/images/emoticons/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>

John Henley

Senior Member

Posts: 3348

8/8/2007 7:28 PM

Not undocumented, just not well-understood.
I demonstrated it back in 2005 as a way to "JOIN" when Lawson doesn't support the join:
https://www.danalytics.co.../archive/2005-03.htm

Phil Simon

Veteran Member

Posts: 135

8/14/2007 6:54 PM

Thanks, John.

I was away from this one for a bit, focusing on little victories.

You're right; the order of the joins matters. Adding the table with the prompted date fields first, then doing a left OJ on the 2nd table, resulted in success!

You the man!

You are not authorized to post a reply.