Tags » SSRS

Expression to hide/unhide column and Text box in SSRS

Hi Axaptians,

This is second post on 5th Feb and eager to update regarding expressions used in SSRS reports to hide/unhide column or text boxes. In AX 5.0, reports are configured in Morphx but in AX 6.0, reports are being design in VS which is termed as SSRS reports. 98 more words


BI-NSIGHT – Power BI (Publish in Web App, Enterprise Gateway GA, Desktop Update, Troux Content Pack, New Visuals) – SQL Server 2016 (CTP3.3, eBook, R)

So from last week to almost having nothing to talk about, to this week having a whole host of updates.

Just to quickly mention I attended the first local Power BI User Group meeting in Brisbane this evening ( … 902 more words


Updating Default Parameters in SSRS RDL Not Working

Problem Statement

I’ve updated some default parameters of an RDL file and deployed it to SSRS (SQL Server 2008 R2).  I’ve tested the report and everything works fine in Visual Studio using the preview, yet the default parameters won’t update on the server when I deploy the report. 100 more words


Report Migration

During a licencing cull we needed to reduce the number of reporting servers we were running. One target was an enterprise edition of SSRS for SCCM (Not recommended as standard is free but I inherited it). 138 more words

SSRS Dashboarding: a 'webdesign-look'

Couple of weeks ago, I shared my SSRS dashboard with the community on LinkedIn:

Koos van Strien asked for the source (RDL) and restyled the dashboard with his ‘webdesign-look’. 32 more words

SQL Server 2012

SSRS: Cannot create a connection to data source (rsErrorOpeningConnection)

In the report server data source–>Properties page. In the connect using option, I was using the option: “credentials supplied by the user running the report”. I should have used the credentials stored securely in the report server and supply the username and password.