Convert a report with 5 tables to use a view

[darahw]

Hello!

How do I change a report that is currently using 5 tables to use a single SQL view that has all the same fields?

Is there an easy way to do it with out having to do a new report?


Thanks so much!

Dara

 

[rhinok]

If your report only had 1 table, I'd suggest that you create the View and then use the 'Set Location' option in Crystal. Because you are using multiple tables, however, you will need to do the following:[ol][li]Create the View with all of the necessary fields and record selection criteria[/li][li]Add the View to the Report, but don't link it[/li][li]Substitute View fields in all Report Fields, Formulas, SQL Expressions, Running Totals, etc... Unless the report has parameters, you should be able to delete the Record Selection Criteria[/li][li]Delete all tables from the report[/li][/ol]If one of your existing tables has the majority of report fields in it, then you might want to 'Set Location' from that table to the View as step two. This way, most of the fields on the report can be mapped. If you do this, remember to use the same field names and case in the View so that the mapping occurs automatically.