Report Designer is a report authoring tool. When you design a report, you specify where to get the data, which data to get, and how to display the data. When you run the report, the report processor takes all the information you have specified, retrieves the data, and combines it with the report layout to generate the report. You can preview your reports in Report Designer, or you can publish your report to Report Server, where others can run it.
Report Server supports SQL and CSV data sources.