End Google Ads 201810 - BS.net 01 --> I have been thinking of using crystal reports over Microsoft Report Viewer but both of them confuse me a little.
Here is why...
SQL Server already has the tables so in my logic of building reports in the past is I provide the following:
1) the sql connection string
2) The SQL Statement containing the fields names the report is wanting
3) Identify the report file
Then the report is generated.

But What I am noticing is I have to add an extra step I do not want to do. Which is creating a dataset.xsd file to have my sql statement load the data directly into.

What I want to know is how to build a report in a c# application that will use the applications connection string (because the database and or server will change names) and Allow me to pass a SQL statement directly into the report. What would be real nice is if I could have the report file external to the application so I can simply replace the report file when changes need done instead of having to recomplile the whole application, as well as dynamically call a report if the file exists and if not ignore the report.