I wanted to know the best method to have Crystal Reports pull data from SQL Server without causing great strain on an existing network?
I saw a method of which a stored procedure was accessed through the connection and was considering doing that again. I'm much more familiar with Access Reports and am wondering why can't I just make something similiar to the Access queries in my SQL Server machine? I guess a View is similiar to Access' queries in that its a view of the data and that may be quite faster.
I am currently under the impression that the only way I'm going to get a SQL Server query to show up through an ODBC connection is having it as a stored procedure and that I really couldn't run queries except through Query Analyzer. Since this part of the question relates to SQL Server - I am asking it here even though it involves Crystal Reports also. Please correct my faulty reasoning! Thank you.