Who's On?

	Membership:
	Latest: cat andrews
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5215

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

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

two Crystal/Add-in questions

2 Replies

0 Subscribed to this topic

23 Subscribed to this forum

Sort:

Author

Messages

Phil Simon

Veteran Member

Posts: 135

7/18/2007 1:01 PM

Hello

I seem to recall that you can point previously-created .dme's to different product lines so you don't have to recreate them. Any idea about how to do this?

Also, I also vaguely recall that you can create a .dme and use that as the basis for a Crystal report. We're running Crystal XI off of LSF on SQL Server 2005. For some reason, I thought that you could cut and paste it but can't for the life of me remember how to do that.

Thanks.

John Henley

Posts: 3364

New Poster

Engaged Reader

Avid Reader

7/18/2007 1:27 PM

- Change the product line via the PROD= parameter in the DME query string.

- You can paste the DME query into the Crystal report by connecting via OLEDB/ADO and selecting the 'OLE DB Connector for Lawson Object Services'. When you get connected, and select 'Add Command' you should be able to access the Query Builder. If you don't see the Query Builder, you may be missing a registry setting (see https://www.lawsonguru.co...Crystal-Reports.aspx for more details).

Phil Simon

Veteran Member

Posts: 135

7/18/2007 1:36 PM

Excellent. Thanks.