09 Dec 2011
By Allen
0 Comments

SSRS Data Driven Subscription Troubleshooting

SSRS, , , , , ,
Microsoft SQL Server Reporting Services (SSRS) 2008 R2 will only allow data driven subscriptions under certain conditions, including data source security and server configuration options.   SSRS Subscriptions always work great and easy in the demos and training classes.  The following is the list of requirements to actually get them to work with in a data driven environment. You must have SSRS configured to run with an 'Execution Account' Data Sources must not have your Data Sources folder hidden with the option 'Hide in tile view'.  If you check that box, you will be unable to select a data for…
Read More
02 Aug 2011
By Allen
0 Comments
SSRS Adding “Image Not Available” as Alternate Image

SSRS Adding “Image Not Available” as Alternate Image

Microsoft SQL Server, SSRS, , , ,
I just had a requirement to build a report which had images stored in the database. SSRS handles that fine by just setting the image object to 'database' and then selecting the field. The challenge was adding an alternate image or text when there was no image stored in the database. SSRS makes it difficult because there is no method to dynamically change the image type on the image container itself, such as changing from 'database' to 'external' image on a web server. OPTIONS: Store the 'Not Available' image in the table and write a query which pulled only that…
Read More
01 Jul 2011
By Allen
0 Comments

Using SQL to Build MDX parameters

SSAS, SSRS, , , , , ,
I had a client report which needed a parameter list to default to the previous closed financial period date. The SSAS cube includes reporting periods into the future which have data entries even if the month has not been 'closed' by accounting department. Without a 'Month Closed' flag in the cube, the only way to build the parameter list was by querying the date dimension database table. When adding a date parameter to the report dataset, SSRS will automatically build a hidden dataset which pulls the list of available dates from the cube. For this example, I left that data…
Read More