Wise Owl Training - SSRS blogs (page 2 of 2)

Showing blogs 21-31 (out of 31)

Making Reporting Services reports refresh automatically

Posted by Andy Brown on 30 January 2012

A little nugget of information - how to arrange it so that a report written using SQL Server Reporting Services will keep refreshing automatically, to display the latest data.

Tags:   SSRS | Designing reports

Differences between Report Builder and Reporting Services

Posted by Andy Brown on 07 November 2011

Report Builder and BIDS (the Visual Studio add-in for creating Reporting Services reports) are essentially the same underneath their very different looking skins. This blog lists the small number of differences.

Tags:   SSRS | Report Builder

Multivalue parameters in Reporting Services

Posted by Andy Brown on 07 November 2011

This blog shows how to create multivalue parameters based on dropdowns, whether in SQL Server Reporting Services or Report Builder 3.0.

Tags:   SSRS | Parameters    |    SSRS | Report Builder

Install Report Builder 3.0 despite .NET 3.5 Framework error

Posted by Andy Brown on 31 October 2011

Struggling to install Report Builder 3.0 because of a message about the .NET 3.5 framework? The problem is more likely to be to do with Internet Explorer 9.0, as this blog explains.

Tags:   SSRS | Report Builder

Gradient Fill Colours for SSRS 2008 Chart Data Series

Posted by Andy Brown on 08 August 2011

You can change the fill colour of data series in Reporting Services in a number of different ways, as explained in this article - but none of them allows you to set gradient or other effects. This blog is a rare appeal for help!

Tags:   SSRS | Charts

Fixing page titles during scrolling in SSRS 2008 R2

Posted by Andy Brown on 26 July 2011

As you scroll down a report, the titles at the top of the page will disappear - this blog shows how to prevent this happening. It's not as easy as you would think!

Tags:   SSRS | Pages and preview

Repeating Page Headers in Reporting Services 2008 R2

Posted by Andy Brown on 26 July 2011

Getting rows of a table to repeat at the top of each page of a report in SSRS 2008 R2 is anything but straightforward. This blog shows the red herring to avoid and a way to solve this thorny problem.

Tags:   SSRS | Pages and preview

Exporting SSRS Reports to Excel using RenderFormat

Posted by Andy Brown on 25 July 2011

SQL Server Reporting Services 2008 R2 includes (among many other features) the ability to detect a report's rendering format, together with a facility for naming report pages. You can combine these two features to create Excel workbooks with individually named worksheets for each member of a group, as shown in this blog.

Tags:   SSRS | Expressions    |    SSRS | Pages and preview

Free tutorial - Gauges in SSRS Reporting Services

Posted by Andy Brown on 25 July 2011

SQL Server Reporting Services 2008 introduced gauges, in all their dazzling compexity. This free tutorial blog shows how to create gauges, format their pointers and scales, add labels and much else besides.

Tags:   SSRS | Gauges, indicators

Free Tutorial in Indicators in SSRS 2008 R2

Posted by Andy Brown on 25 July 2011

Indicators are one of the nicest new features of SSRS 2008 R2 (or SQL Server Reporting Services, to give the software its full name). This blog shows how to add indicators to a table, format them and set scaling correctly.

Tags:   SSRS | Gauges, indicators

Problems with Outlining in SSRS 2008 R2

Posted by Andy Brown on 17 May 2011

Outlining grouped data in Reporting Services 2008 should be straightforward: you just set the ToggleItem property of rows, and away you go! Unfortunately this owl can't get this to work - along with a lot of other people it seems - so we offer this solution.

Tags:   SSRS | Tables
This page has 2 threads Add post
09 Aug 18 at 17:35

My company has changed a major software package. I have been asked to recreate a report in SSRS 2017. The report has two parts. The first part has 12 lines, each line has 4 fields and these 4 fields in a line are populated with a separate TSQL Query.  I inserted an SSRS List into the body, into which I inserted a rectangle then inserted 4 textboxes. Once the textboxes were positioned within the rectangle correctly, I copied the rectangle with the intention of pasting 11 copies into the list. To avoid disturbing the contents of each rectangle, I used the rectangle's location property fields to position it within the list. I noticed textboxes had moved within its rectangle and other odd behaviors. Is there a technique to create a report of textboxes that can be arranged in an orderly way?

04 May 17 at 06:24

Building a user-friendly GUI for Report Builder

I have a specific reporting requirement and would be very grateful for comments on the best way achieve it.

Schools currently produce a large number of reports in Excel for internal management purposes — these tend to be unique to each school — which is the rationale as to why I am looking to build a friendly application — they also require repetitive wrangling every time an updated report is required. The reports contain a combination of tables, visuals, and text.

The data for the reports will exist in an Azure SQL DB.

At present I am seeking advice about whether it is possible to develop an easy-to-use interface for MS Report Builder for schools to build and distribute reports based on a schedule specified by the user — these reports will be produced as pdfs and as MS Powerpoint and Word documents.

A number of specific templates will be designed for schools to adapt to their requirements — Is it feasible to consider developing an interface for report Builder/SSRS that is useable by school staff who have no technical knowledge???

Is there a better way to tackle this problem?? 

I’ve tried PowerBI, but it is too complex for most staff in schools, and last time I looked at it, there was very limited ways to reconfigure the UI to make it approachable for non-technical users.

04 May 17 at 09:26

There are already a number of systems out there, as I'm sure you know - we've done a fair amount of training for people selling and using Progresso, for example. 

Report Builder won't help you, I think - it's designing for creating single reports.  Its big brother, Reporting Services, will.  If you use SQL Server 2016, you can create an impressive looking web-based dashboard and publish reports to it.  More importantly, subscriptions allow you to use SQL Server Agent behind the scenes to send emails containing reports out to people, and these reports can be in pretty much any format (Excel, Word, PDF, etc).

Two other options to consider are Power BI Desktop, which allows you to create reports and publish them to the cloud, and Tableau.  I know very little about this, except that it has a good user base among at least our clients, and seems popular.