• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

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 Send Private Message
Posts: 412
Veteran Member
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 Send Private Message
Posts: 514
Veteran Member
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
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
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.