| Iain Sharp 2006-03-28, 4:08 am |
| On Fri, 24 Mar 2006 16:28:12 -0600, Larry__Weiss <lfw@airmail.net>
wrote:
>For data access efficiency reasons, I am trying to convert a report
>that is currently based on a view to one based on a stored procedure.
>
>The stored procedure returns the same named fields as the view.
>
>Is there a way to replace every reference to the view with a reference
>to the new stored procedure?
>
>I tried adding the stored procedure, removing the view and then creating
>an alias to the stored procedure as the name of the view, but that
>didn't work. In fact saving the report after removing the view always
>crashed my Crystal Reports 8 development system.
>
>I have Crystal Reports 10 available, and if needed I'll install that
>and do the conversion.
>
>It's a complex report, and I hope not to have to recreate it from
>scratch with the stored procedure.
>
> - Larry
Hmm in 10 and XI there's a Database->Set datasource location, option.
This allows you to connect a table in the report to a different
datasource/table in the database and will allow mapping of fields if
the names aren't quite right.
Does this exist in 8?
Iain
|