I know that it has been a while, and I apologize. I have been traveling around the U.S. evangelizing SQL Server to public schools, colleges and universities. Now that does not excuse my time away from the blog, but that is my excuse and I am sticking to it. Anyway, back to SSRS. If you have been following along you are ready to create your first report. That is exactly what I am going to demonstrate in this blog post.
To get started open the solution from the last post in this series, SSRS 101 – Creating a Shard Dataset. If you don't have the project click HERE to download it. SSRS allows you create very simple reports and very complex reports. In this post I am going to create a very simple report that contains a single object and displays some data. In future posts I will expand on this report by adding additional visualizations.
Watch video if you prefer:
Creating Your First Report
That's it, your first report is created. In the next post I will explain how to customize the parameter to make it a little more user-friendly. Until then, happy report writing. As always, if you have any questions or concerns regarding this posts or any of the preview posts please feel free to email me at firstname.lastname@example.org.
Talk to you soon,
Patrick LeBlanc, Microsoft, Technical Solutions Professional SQL Server and Business Intelligence
You may want to mention that this post uses BIDS, but reports can also be created easily using Report Builder.
Is there a way to display SSRS reports on a mobile device? App's?
Thanks Laura. I will be sure to mention this in the next post. I will reference this post.
William SQL Server 2012 Service Pack 1 (SP1), Reporting Services supports viewing and basic interactivity with reports on Microsoft Surface devices, and devices with Apple iOS 6 and Apple Safari browser such as the iPad. Here is the link msdn.microsoft.com/.../jj659023.aspx.