Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View not Updating SQL Query in Report

Status
Not open for further replies.

ltidquist

MIS
Sep 28, 2007
45
US
I have a Crystal report (CR9) that has tables and one view in it. I've added the view via the Database Expert and linked it to one of the tables. I Verify the database but the SQL Query never joins the view into the report and I get an error that the field(s) from the view cannot be bound. If I copy the SQL Query into Query Analizer and manually add the view linking into the script it runs without error.

How can I get this to update correctly?

Thanks.
 
Can you see 'Views' (File, Options, Database tab)? I not a 100% certain, but this might be the case.
 
Try to use the same connection settings in Query analyzer as in CR9.

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top