Can’t see all the rows in your drillthrough report in report builder?

December 13, 2009

I'm developing a report model in Report Builder 1.0 at the moment. I felt like it was finished and started testing the model with some sample reports I knew my client needed. And then I got the oddest thing…I would get a report saying something like:   Gender              Marital Status                Amount of SalesNA                    NA                                865Male                 Single                            30Female             Single                            36NA was what I chose to put in case I was using referential integrity. I was looking at the sales table and the employees table and if I found a sale which didn't have an employee, then I created a fictitious employee for...
no comments

Using the Dallas Project in Excel and an SSRS Report

December 7, 2009

I read a while ago in Chris Webb's blog about project Dallas which really got me interested. Quoting from the site itself: "Microsoft® Codename "Dallas" is a new service allowing developers and information workers to easily discover, purchase and manage premium data subscriptions in the Windows Azure platform." So what does it mean? Basically that you have a public data source in the cloud that you can connect to and use for your own applications. And why am I so psyched about this? I have to admit that I am constantly looking for data I can use for demos....