Musings on Data

A blog for data, apis, and all things Power BI by Lukasz Pawlowski.

October, 2005

  • Musings on Data

    Reporting Services Webcasts

    • 0 Comments
    Andrew Watt, an MVP for InfoPath, has a great post on his blog that lists the SQL Server 2005 Reporting Services weblogs. Check them out here: http://www.tfosorcim.org/archives/000409.html
  • Musings on Data

    Scripting Actions in Reporting Services (Also, copy my server to another server)

    • 0 Comments
    I am sometimes asked how to automate actions on the report server. The answer is to use the rs.exe scripting utility. The utility gives you a host to run VB based script files easily against the Report Server SOAP API. The utility in SQL Server 2005, supports both the 2005 and 2000 endpoints. These are accessed through a command line parameter. The default is the 2005 management SOAP endpoint. Probably the most common task I'm asked about is how to publish a report using a script. Here's a sample. You'll note that I'm reading the RDL from a file. First add yourself to the lukaszpblog group on http://groups.msn.com/lukaszpblog . Then click this link: Sample File The second thing folks ask me about is how to copy the contents of a report...
  • Musings on Data

    How to click in a report to show/hide (toggle) multiple items

    • 0 Comments
    Many people want the user to be able to click an area of a report and have items in the report be shown based on this interaction. For example, I might want to toggle between a table view and a chart view of some data. The way to do this is to use a report parameter in combination with a drill-through link back to the same report. Once you have this infarstructure, you can use an expression to drive the 'Hidden' property of a report item. If you have one or two items to show/hide you can probably do this inline. However, if you have many items, the logic is complex, or the logic needs to be repeated across reports, it would be better to centralize the logic so you can better maintain your reports. The way to do this is to put your...
  • Musings on Data

    SQL PASS 2005 musing and picture!

    • 1 Comments
    SQL PASS was held in Dallas, TX the week before last. At the event I gave 3 talks - one end-to-end RS talk, an upgrade talk on both RS and NS, and an NS breakout drilling a little more into the inner workings of NS. All the presentations went well and were well attended. All this is well and good, but really this article is an excuse to show you how many Microsofties it takes to screw in a light bulb. To give you the scenario - Michael Raheem (left most in the photo) was organizing a live upgrade session during the David Campbell's keynote. To do that, he recruited a set of customers at PASS. That's right - no preparation, just whoever wanted to give it a try and had he mix of components (various features of SQL Server, interesting uses of...
  • Musings on Data

    Using Active Directory Groups with Reporting Services

    • 0 Comments
    I have received several questions from customers, the latest in a conference call today, wondering how Reporting Services works with Active Directory groups The question goes along the lines - How do I configure Reporting Services to use Active Directory groups?, or Do I need to write a custom security extension to use Active Directory groups with Reporting Services? There are two kinds of groups in Active Directory: 1) Security Groups 2) Distribution Groups In both cases you should be able to use these groups out of the box, so long as your computer is a member of the Domain or a Trusted Domain of the Active Directory server in question. So by default you should have to do exactly nothing to get this to work. Here comes the...
  • Musings on Data

    How to trigger a subscription in Reporting Services 2000

    • 2 Comments
    RS 2000 doees not support custom events. What this means is you cannot, on the face of it, trigger a subscription on demand. Luckly, we thought of this. The method of doing this is not particularly pretty, but it does work. Eventing in Reporting Services is currently (2000 and 2005) limited to two events: SnapshotCreated and TimedSubscription. The TimedSubscription event is interesting because it can be submitted to the report server using the FireEvent SOAP API. You can use this property to programmatically submit events to Reporting Services. What you need: 1) A shared schedule that will never fire. This is easy – just create a shared schedule that executes once and that starts in the past (e.g. yesterday). Take a note of the schedule...
Page 1 of 1 (6 items)