Hi, I'm a DBA supporting a SQL Server application. I'm not familiar with Crystal Reports. Developers wish to create and use views with Crystal Reports. We allow them to initially create the views with them as owners. Creating reports on this view apparently inserts the development database name and their owner id in the Crystal report. Problem is upon implementation. When DBA creates the view with DBO owner id., developers are saying that their report won't run against the DBO owner id view. Since user owner id is imbedded in the Crystal Report... developer says they have to go and change every reference to field individually, replacing their user id with DBO owner id. Is there a better way?
Thanks in advance for your help, Guy
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.