Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
542 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Showing blogs 1-14 (out of 14)
Posted by Shaun Wantling on 28 October 2022
Posted by Andy Brown on 23 December 2020
Posted by Andy Brown on 18 October 2019
Posted by Andy Brown on 11 June 2019
Posted by Andy Brown on 02 May 2019
Posted by Andy Brown on 16 February 2018
Posted by Andy Brown on 16 February 2018
Posted by Andrew Gould on 23 April 2013
Posted by Andy Brown on 01 October 2012
Posted by Andy Brown on 06 August 2012
Posted by Andy Brown on 06 August 2012
Posted by Andy Brown on 06 August 2012
Posted by Andy Brown on 21 June 2012
Posted by Andrew Gould on 11 May 2012
Some other pages relevant to the above blogs include:
From: | MJF1 |
When: | 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?
From: | RADII |
When: | 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.
From: | Andy B |
When: | 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.
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.