-
by David Leibowitz
| December 30, 2007
|
I use the following tools, all free.. Visual Web Developer 2008 Express Edition SQL Server Express Management Studio Visual Basic 2008 Express Edition Paste a code snippet in any of the applications above and you'll get some friendly color coding. Then simply copy and paste into MS Word, or directly into your blog post. Then top it off with Noah...
-
by David Leibowitz
| December 30, 2007
|
I posted a while ago about a neat CS 2007 add-in that automatically adds referrer tags to your posts. The code is pretty slick, and the author, Christopher Even made the module so you could add as many new referers as you'd lke. By default, in his example he uses text so you'd have: Technorati | Yahoo! | Google etc, I wanted to dress up my posts...
-
by David Leibowitz
| 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. A workaround is included for the bug that allows Content Managers to see all data....
-
by David Leibowitz
| 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 "Security filters are always applied, even...
-
by David Leibowitz
| 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 and released a HotFix for it.
-
by David Leibowitz
| 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, these powerful project tools might make it in the...
-
by David Leibowitz
| December 20, 2007
|
The following table lists examples of connections string for various data sources. Data Source Example Description SQL Server OLTP database data source="(local)";initial catalog=AdventureWorks Set data source type to SQL Server . Analysis Services database data source=localhost;initial catalog=Adventure Works DW Set data source type to SQL...
-
by David Leibowitz
| December 18, 2007
|
When launching SSRS reports by URL, it is often necessary to include parameters. To do so, simply include the parameter name, an equal sign, followed by the parameter. So param=value for a report where CustomerID is 1 would look like: http://localhost/ReportServer/Pages/ReportViewer.aspx?%2ReportFolder%2DemoReport&rs:Command=Render& CustomerID...
-
by David Leibowitz
| December 17, 2007
|
&rc:Parameters=Collapsed • This collapses the parameter bar but sends the parameters in the URL in the browser &rc:Parameters=true • This shows the parameter bar and is the default &rc:Parameters=false • This prevents the parameters from being passed in the browser and expanded &rc:toolbar=false • This hides the toolbar &rc:format...
-
by David Leibowitz
| December 17, 2007
|
Expression properties can be used to provide a great deal of flexibility in runtime changes to SQL Server Integration Services pacakges. Unfortunately, their usage in Data Flow Transformations is limited. The only Data Flow tasks in SSIS that can be modified using expression properties are: Conditional Split Derived Column The only other option is to...
-
by David Leibowitz
| December 16, 2007
|
Often you'd like to view a row number, or rank on a report in SQL Server Reporting Services. This is simple enough on a line item detail report with the RowNumber function. The reference to Nothing sets our scope. Just use: =RowNumber(Nothing) But now how about something a little more challenging. Perhaps we have a list of 1000 Customers and we...
-
by David Leibowitz
| December 15, 2007
|
Typically you'll lock down access to a SQL Reporting Services Model by creating a Perspective, either for security or to limit the amount of attributes available for a report. By default, the main model will be available in Report Builder with children listed for your available Perspectives. But Report Builder is meant for ad-hoc generation by non...
-
by David Leibowitz
| December 14, 2007
|
This seems to be an issue with Office 2007 when installed after a previous version. Do the following on the client computer to resolve: In Windows Explorer, navigate to C:\Program Files\Microsoft Office\Office12 Rename owssup.dll to owssup.dll.deleteme Run the Office diagnostics by selecting Start > All Programs > Microsoft Office Diagnostics...
-
by David Leibowitz
| December 13, 2007
|
Input Parameters should refresh on your SSRS report if there are dependencies, for instance a list of valid Sales Reps might be dependent upon a selection of Sales Territory first. It makes sense that a change in Territory would trigger a refresh or postback in order to regenerate a list of valid values. However, you may notice some strange behavior...
-
by David Leibowitz
| December 13, 2007
|
I've just installed a fresh copy of VS 2005 on an XP Pro laptop. Right out of the gate I have an error trying to get to the Administrative page. This is the error message in IE: HTTP 401.3 - Access denied by ACL on resource Internet Information Services. To fix, I went over to IIS Properties, the Virtual Server site and over to the Directory Security...