Tips and Tricks for Building Rich Reports in Microsoft SQL Server 2012 Reporting Services

Play Tips and Tricks for Building Rich Reports in Microsoft SQL Server 2012 Reporting Services

Description

You know how to create a basic Reporting Services report. Now, learn some tips and tricks for designing rich reports that encourage immediate understanding and make insights pop!

Day:

3

Session Type:

Breakout

Code:

DBI-B320

Room:

New Orleans Theater B

Embed

Download

The Discussion

  • User profile image
    khaos13

    Are there any disadvantages to using this from Visual Studio as opposed to SQL Server?

  • User profile image
    jjb80

    Looking forward to this to improve my report writing.

  • User profile image
    hkwoelf

    I would like to see something about wrapping a single column report on a page. I want to do this to save paper.

  • User profile image
    ykasan

    This was a very informative. I only wish we could spend a little more time on "drill-down"

    Overall strong "A" session

  • User profile image
    riccardomuti

    @khaos13: I'm not sure whether you mean Visual Studio (Report Designer) as opposed to (SQL Server) Report Builder, or Visual Studio client/local-mode reports (RDLC) versus SSRS server-mode reports (RDL).

    For using Report Designer as opposed to Report Builder, no, there's no real disadvantage. The report design functionality is the same. Report Designer is for developers and enables things like projects and source control, whereas Report Builder is easier to use.

    For RDLC versus RDL, yes, there are differences. RDLC reports execute within your application process, don't connect to a report server or require a SQL Server license for one. Your application is responsible for querying data and feeding it into the report. Also, only some export formats are supported (PDF, Word, and Excel). RDL reports execute within a report server, can query many different types of data sources, and export to any format.

  • User profile image
    riccardomuti

    See my Twitter feed @riccardomuti for answers to the questions about the catalog database edition requirements and role-based security in AS Tabular models.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.