Who's On?

	Membership:
	Latest: Julie
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5312

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

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

Mapping a crystal report that uses a sql command

2 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

Ruma Malhotra

Veteran Member

Posts: 412

3/9/2011 8:14 PM

Has anyone been able to map a crystal report that uses a sql command that has the schema name hardcoded from one environment to another? Th problem in this lies where the schema name is diffrent in 2 environments. Like for example the schema name is prod and test in 2 different envirormnrts and it is difficult to map theses crystal reports.

On LBI when you publish these reports the datasource override will not work since the objects will not be found because of the schema name being hardcoed in the SQL.

What is the best way around this or is there one ?

Matthew Nye

Veteran Member

Posts: 514

3/9/2011 8:28 PM

create a crystal parameter that then passes its value to the SQL command. You can set the parameter to be hidden from the end user and hardcode it as you migrate from one env to the other. may have some performance implications so it might not be the best solution for all reports but perhaps its a good starting point.

hth
Matt

Ruma Malhotra

Veteran Member

Posts: 412

3/9/2011 9:42 PM

Thanks! This is a great way to start after trying to change a dozen reports that have the schema name hardcoded and wondering how to make the report execute in different environments.

I am going to try and redesign the rpeort and may have follow up questions.