Crystal Command and RDBMS

[bubu2006]

One can design Crystal Report using different technique. What is the advantage of using database view over Crystal Command? I know stored procedure is a better approach because the code is already compiled. Anyone has any clue about view and command?

 

[synapsevampire]

A View is a reusable object in that all tools can use it, and it will allow for multiple parameters, so if given the choice, don't consider embedding rules into the client.

A Stored Procedure won't allow for multiple parameters either (well, not without parsing), so if the performance is similar between the View and SP, I prefer the View.

-k

 

[bubu2006]

Is there any performance issue between view and command? Right now I am using view considering the fact that we can use it even if we switch to new reporting tool. But View supposed to maintain by Data group. So there is a maintenance issue. But we can maintain report our self.

 

[bubu2006]

And I am not sure how do I change data source name if I use command. I don't have repository. But I have three different environments for development, QA and production.