1 / 13

SQL Reporting Services – Building the Report

SQL Reporting Services – Building the Report. Kevin Ford Services Consaultant Accela, Inc. Tools. Before continuing please make sure that you have downloaded and installed Microsoft SQL Server 2005 Express Edition Toolkit http://go.microsoft.com/fwlink/?linkid=65111

kuper
Download Presentation

SQL Reporting Services – Building the Report

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Reporting Services – Building the Report Kevin Ford Services Consaultant Accela, Inc. Insert Presentation Title Here

  2. Tools • Before continuing please make sure that you have downloaded and installed • Microsoft SQL Server 2005 Express Edition Toolkit http://go.microsoft.com/fwlink/?linkid=65111 • Additionally make sure that you have SQL Server Management Studio Express installed (this is also a part of the above package) • A good text editor • I use gVIM • Text Edit Pro • Anything with Syntax Highlighting is good Insert Presentation Title Here

  3. Sample of my Editor

  4. Quick note about SQL Server Management Studio Express • SQL Server Management Studio is going to be very useful in programming your queries and checking them before you put them into the report developer tool and is highly suggested for use.

  5. Report Development Life Cycle • Idea • Mockup • Development • Read through spec • Develop queries for report • Layout Report with queries in place • Test Test Test • Deliver for peer-review (this may happen more than once) • Deliver To Client

  6. Creating your Database connection • All connections to the database will be handled through the “Shared Data Sources” location in “Microsoft Visual Studio” so lets create one.

  7. Creating your database Connection Cont. • Right-click on “Shared Data Sources” and select “Add New Data Source” TOOLS9” • You will now be prompted with a screen to configure your new data source. Type “Training Class” for the name .

  8. Creating your Database Connection Cont. • Select edit to the right of the “Connection String” box, this will help you create the database connection string for the server that you are wanting to connect to. • DEMO

  9. Managing Files • When developing reports for a client it would be best that each client have their own project in Visual Studio this way you don’t get files/reports confused between clients. • When you send a file to a client to deploy look for the “.rdl” file this is the file that the client will need when deploying a report to a report server.

  10. SQL • Structured Query Language • Who here has written SQL?

  11. Query against 1 table • SELECT B.B1_ALT_ID FROM B1PERMIT B

  12. Query against a table for more than one value. • SELECT COUNT(*) FROM B3PARCEL B3P

  13. Query against 2 tables SELECT B.B1_ALT_ID, B3A.* FROM B1PERMIT INNER JOIN B3ADDRES B3A ON B.SERV_PROV_CODE = B3A.SERV_PROV_CODE AND B.B1_PER_ID1 = B3A.B1_PER_ID1 AND B.B1_PER_ID2 = B3A.B1_PER_ID2 AND B.B1_PER_ID3 = B3A.B1_PER_ID3 AND B.REC_STATUS = B3P.REC_STATUS LEFT OUTER JOIN B3PARCEL B3P ON B.SERV_PROV_CODE = B3P.SERV_PROV_CODE AND B.B1_PER_ID1 = B3P.B1_PER_ID1 AND B.B1_PER_ID2 = B3P.B1_PER_ID2 AND B.B1_PER_ID3 = B3P.B1_PER_ID3 AND B.REC_STATUS = B3P.REC_STATUS WHERE 1=1 AND B.B1_ALT_ID = '' AND B.SERV_PROV_CODE = ''

More Related