Hey blog, how are you? I know I haven't been here for quite some time now... I guess I needed a break. Some time for myself. And I know you were waiting here for me all that time. Being patient and understanding. Knowing that one day, I'll come back. Thank you. I missed you. I think this time, I'm here to stay. So, the topic for today is how to not work automatically and adding a table to your database. About a year ago, I created a report in SSRS for a user of mine on the distribution...

Although Reporting Services can use all available memory, you can override default behavior by configuring an upper limit on the total amount of memory resources that are allocated to Reporting Services server applications. You can also set thresholds that cause the report server to change how it prioritizes and processes requests depending on whether it is under low, medium, or heavy memory pressure. At low levels of memory pressure, the report server responds by giving a slightly higher priority...

So yes, I'm still thinking about RB 1.0 vs. RB 3.0 . We've made the move a few months ago from SQL Server 2005 to SQL Server 2008 R2 . Most of our projects in the team, if they're not cubes, are Report Builder 1.0 models. I was really looking forward to seeing how we can move our users from Report Builder 1.0 to Report Builder 3.0 . My conclusion? Except for a few very specific cases - we can't. We actually still have Report Builder 1.0 as a click once application from our Report...

Technorati Tags: SSRS , Report Builder , SQL Server 2008 R2 I’ve been trying the new Report Builder 3.0, which ships with the SQL Server 2008 R2 November CTP and among the various new features, I want to write  a bit about the Shared Data Sets feature. Up until this version, report authors could create a data source, and when deploying the report could make the decision whether the data source for this report is shared among other users/authors or be linked only to the individual report they...

Technorati Tags: SSRS , Report Builder I thought I’d write about this topic, even though it’s a bit of an old news item, because I keep getting questions about this when I visit clients. As part of the SQL Server 2005 Reporting Services product, many of us were really enthusiastic about the Report Builder tool. This tool enabled the organisation's power users to create their own custom-made reports, using a pre-defined Report Model. This Report Model was simply a logical “map” of specific database...

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...

Filtering a Parameter with a Long List of Values in SSRS I've been developing quite a few reports in Reporting Services lately (as you may have noticed from the blog). While showing one of the reports to my user, my user asked me to field he wanted me to add to the report had a very long list of values to it. Reporting Services gives parameters only the option of a drop down list. I knew that using a drop down list on a field which had so many values in it would mean that my user most of the...

Reporting Services gives you several ways to navigate within your report or navigating to external item (i.e. Navigating to other reports or any web URL). You can use a feature called "Jump to URL". Use the following steps to set "Jump to URL" Method-1 - Drag a datafield on the report - Click on the Textbox - Find the Action property of Textbox the property window - Select Jump to URL option - Type any valid URL (i.e. http://blogs.microsoft.co.il/blogs/bilive ), valid URL must...

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...

Report Viewer for Visual Web Developer Express The Visual Web Developer Express is one of my favorites , both the previous 2005 & 2008 versions as well as the new and shining all around fully functional – Visual Web Developer 2008 SP1 Express Edition ( which has support for ClassLibrary & Silverlight 2.0 projects as part of the Solution – Single Environment ! ) It seems that only a few days a go the Microsoft Report Viewer Add-on for Visual Web Developer 2008 Express has been released Microsoft...