December 27, 2007
Filtering data in a SQL Server Report Model is rather persnickety, and there is limited instruction available online or in BOL.You use Report Models in Report Builder to develop ad-hoc SQL Reporting Services reports. This is a followup to the bug I discovered in Model Item Security as posted here and...
December 27, 2007
There seems to be a bug or miscommunication as it pertains to securing SQL Server Report Models using model item security from SQL Server Management Studio. There is a fairly sparce Tutorial regarding row-level security on MSDN. Their Tutorial 3 goes over Row Level Security on Report Models. It states...
December 26, 2007
I've run into this annoyance a few times in SSRS. Instead of seeing your image on a deployed report, you see only a Red X. This typically occurs when your image is in a virtual directory. The workaround is to make the virtual folder available to ANONYMOUS access. Microsoft has acknowledged the bug...
December 21, 2007
I've got an article over at SQL Server Central that describes how to get Gantt charts in SSRS using native controls, not third party. And it has a holiday spin. This is the abstact: Gantt charts in SSRS aren’t included in the 2005 release. You can purchase a third-party add-on, or, if you can wait...