Report Builder 1.0 vs. Report Builder 3.0

Tuesday, May 4, 2010

The municipality has been planning to move to SQL Server 2008 R2. Now obviously I'm happy about it, but it also made me wonder about our Report Builder 1.0 models. I know Report Builder 3.0 doesn't have all the functionality that Report Builder 1.0 has. In some ways Report Builder 3.0 outdoes version 1.0 and in other ways it's lacking. I was deliberating on how the move of upgrading to SQL Server 2008 R2 may affect us in the municipality. I mean, does that make our Report Models from 1.0 obsolete? Maybe there's no point in continuing to develop...

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

Sunday, 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

Performance Point integration in SharePoint 2010

Monday, November 2, 2009

Microsoft had released not too long ago, the last Service Pack for the standalone version of PerformancePoint Services - PerformancePoint Server 2007 SP3. From here on out, all development for PPS is going to be part of SharePoint Server. This is again part of Microsoft's strategy of empowering SharePoint as a product, as it also connects to Excel Services, Reporting Services (including Report Builder) and Visio Services.So what's new to PerformancePoint 2010? SharePoint Server 2010 as the repository - meaning PerformancePoint Services stores data sources in document libraries and all other dashboard content in lists. PerformancePoint Services uses SharePoint Server 2010...

Flexible grouping on data from your DW in Excel 2007

Friday, May 15, 2009

I have recently built a data mart containing all the data of budgeting and accounting in SQL Server 2005 and created a Report Model in Report Builder for it. My users were looking for a flexible way to define different grouping on the data, without having to ask for my assistance. Defining new formulas in Report Builder isn't the most comfortable thing to do (specifically if they get complex and long), so we had to find another way.   There was a suggestion of creating a view in the database with their definitions for the grouping straight to SQL, but I...

Filtering on a lookup attribute in Report Model

Wednesday, January 21, 2009

I've recently created a Report Model with a Lookup Entity in it. I saw to it that I had only one default detail attribute for it, and I gave that attribute a ValueSelection of list. When I used the Report Model, I saw the attribute fine (as if it was inside the main Entity) but when I tried to filter on it I saw the Lookup Entity I was trying to hide and a filtered list. I couldn't understand why that was. I went back to check the attribute. Its ValueSelection was of type list. I went to the...

SQL Server SP3 Beta and more news

Tuesday, October 28, 2008

Well apparently, you can miss out on a lot of things during a two weeks vacation. Luckily I came back in time to see SP3 Beta for SQL Server 2005 get released! But I'll talk about that in a bit... The announcement of Project Gemini in SQL Server 2010 sparked a very heated debate in the BI Community, over how much it might be abused by users as an alternative to an organized DW \ OLAP solution. The discussion did not go unnoticed by Microsoft. I guess I can only sum up by saying that we'll see what happens in...

Report Builder 2.0 RC1

Tuesday, August 26, 2008

My favorite "toy" in SQL Server 2008 just got a brand new spanking release! Report Builder 2.0 just went RC1 after it didn't appear in the feature pack of SQL Server 2008 RTM. When I tried it out first, as a Report Designer Preview in CTP6, I loved it so much that I even decided to make a webcast out of it (both in Hebrew and in English).  Later, I found out this would become the "next generation" of Report Builder. When I downloaded the feature pack that came with SQL Server 2008 RC0 I admit I was a...

The Lookup Entity and the Friendly Name in the Report Builder

Tuesday, July 15, 2008

Did you, just like me, define a Lookup Entity in your Report Model? And did you, just like me, define friendly names in your Report Model's DSV? If you have, then you may have come across a problem similar to mine… So how did we get there? First and foremost, when you click the relevant tables and columns in your Report Model's DSV, you defined a FriendlyName property for them. That way, when you generate a Report Model based on the DSV with the friendly names, you get the Model with the user – friendly names you defined. In...

How to avoid breaking reports based on your Report Model

Sunday, June 8, 2008

Almost every post I made about Report Builder, be it the pros and cons of creating a report model on a cube or refining a report model based on a cube, brought the same question - what makes reports based on a report model to break and how can you avoid it? Well I didn't know the answer as I admit it never happened to me, (sigh of relief), but the question did bother me enough for me to try and research it a bit more on the internet. And yes, I'm happy to say there is more than...

Creating a Report Model based on an Analysis Cube – Pros and Cons

Thursday, May 15, 2008

Creating a Report Model based on an Analysis Cube – Pros and Cons If you follow my blog, you probably know by now that I developed a report model based on the Analysis Services cube I already had. I even got around to updating the report model. And then, my users started using it. And you know, whatever we do just seems so wonderful to us, until our users find all sorts of flaws with what we did… so yes, my users did open my eyes to...