Reporting Services Archives -

About us

Shock horror !!! Guess what are your most valuable assets… your DATABASES! BICG’s SQL Server On Premise and Cloud Database experience is exemplary. BICG have been developing solutions in SQL SERVER, REPORTING SERVICES, ANALYSIS SERVICES and POWER BI since the get go. We’ve helped organisations architect National Data Sharing portals and we’ve trained people to transform their own business taking them from Zero to Hero.

We’ve got plenty of track record too. BICG’s portals are already providing bottom line benefits to dental and medical practices around Australia. BICG’s Data Cloud is already streaming source data out of Health, Financial and Education enterprises, into the cloud where the fast moving world of cloud analytics can work its magic. BICG’s Vault accelerates your Data Warehouse development by 90% over traditional approaches with clever Data Warehouse generation for on premises or cloud. BICG’s Cohort Power BI Widget demonstrates our passion and importance of finding the right visual for the right purpose. BICG’s SAP BO to SSRS converter accelerates your Business Objects migration effort by transforming every business objects report into a Reporting Services report shell. BICG’s Health Analytics provide subscription access to tried and tested predictive models that have been proven to solve real world problems in the Health sector. Products with tangible and proven benefits leading to lowering costs and promoting revenue growth.

With many forces and trends rapidly changing the face of business intelligence and spearheaded by cloud-based real time and mobile BI, BICG are the face to the new eco-system and methodology for future state data and analytics. Our products and experience take the heat and the cost out of data initiatives bringing bottom line benefits to the business from the start.

Reporting Services

Creating SQL Server Reporting Services Reports

by Melvin Black June 14, 2015 in Melvin Black, Reporting Services 0 comments

SQL Server Reporting Services (SSRS) is Microsoft most accomplishing reporting tool. No matter which tool you decided to use in the Microsoft Business Intelligence offerings, SSRS will likely play a part if you really want one solution that does most of what you need. SSRS is part of the SQL […]

Toggle Visibility Show As Expanded + – in SSRS

by PETER O’GORMAN February 4, 2015 in Reporting Services, Training 7 comments

Watch this video demonstration for how to Toggle Visibility as Expanded in your SSRS Report, BICG Training Channel. Reporting Services provides some nice options to allow user’s to feel like they are interacting with the data, by expanding lower levels of detail when they click on the plus (+) sign […]

How to check is null in a Reporting Services Expression

by PETER O’GORMAN February 3, 2015 in Reporting Services, Training 3 comments

Watch this video demonstration for how to check is null in a Reporting Services Expression http://youtu.be/k2P4Qi20jkA. To perform the equivalent of isnull in a Reporting Services Expression use the IsNothing command. Begin by using IsNothing to determine if your measure is null, wrap it in a conditional IIf statement. […]

SSRS – How to Add a Column Group to an existing Table

by PETER O’GORMAN February 1, 2015 in Reporting Services, Training 1 comment

Watch this video demonstration for how to add a Column Group to an existing table in SSRS, i.e. converting your table from a Tablix to a Matrix http://youtu.be/zM5DRsnH3E0. You have created a table i.e. tablix control in SSRS which is working well however now you want to pivot the dates […]