Prologika (Teo Lachev's Weblog) - All Comments

re: Maintaining State in Reporting Services 2008

ASP808 — Tue, 22 Jun 2010 20:10:07 GMT

Hi, need some further detail.

What should the expression be for the text box that is storing the data?

And what should the expression be for the text box that is retrieving the data?

What is id and column ?

Where should the rest of the function be called? such as the onInit() OR is it called automatically on each render?

re: Yet Another Relative Dates Implementation

Mike Honey — Thu, 17 Jun 2010 07:43:50 GMT

This is a great improvement Teo - thanks!

While I am now deeply into the MS BI stack, I come from a Cognos background so I agree wholeheartedly with your business analyst (and "agree to disagree" with 99% of the MS BI techies).

I've just been testing a conversion from the "whitepaper" approach to yours (the "Teo YARDI" approach?), and it appears to be about 10 times faster (on identical hardware, source data etc). And it also works naturally in Excel filters (like a regular dimension), which was a shortcoming of the "whitepaper" approach and other variants.

So I think this is definitely the winner - IMO.

I think there was one (trivial) step missing in the procedure - after creating the named calculation called RelativeDateKey, you have to add it to your Dates dimension as an Attribute Hierachy (with AttributeHierarchyVisible = False).

re: Microsoft SQL Server 2008 R2 Feature Pack Available

undymorex — Wed, 16 Jun 2010 06:37:47 GMT

Depends on whether you do web hosting using SQL Server as your client database software...if not, probably won't matter

re: Microsoft SQL Server 2008 R2 Feature Pack Available

Jay — Tue, 01 Jun 2010 21:06:02 GMT

Thnx Microsoft I want to have the package.

re: Reporting Services Lookup Functions

Ness — Wed, 28 Apr 2010 18:13:48 GMT

So informative..Thanks for sharing, Teo! :)

re: Hacking MDX Query Designer Parameters

mikehoney — Fri, 23 Apr 2010 02:04:35 GMT

Nice hack Teo - can you post a link to your Connect "wish" - I'd like to vote for it.

re: Heat Maps as Reports

Teo Lachev — Thu, 11 Feb 2010 13:12:07 GMT

Good to know. Here is another one that uses a similar approach:

blogs.technet.com/.../heat-maps-in-sql-server-reporting-services-2005.aspx

re: Heat Maps as Reports

JagvinderReehal — Wed, 10 Feb 2010 13:03:26 GMT

Hi Teo,

I've also done a blog post on how to create Heat maps in SQL Server Reporting Services that works without having R2.

www.arrangeactassert.com/how-to-create-heat-maps-in-sql-server-reporting-services

Cheers,

Jag

re: Report Parts

Teo Lachev — Sun, 17 Jan 2010 14:19:58 GMT

Hi TeeDubs,

You can add custom properties to your report by calling SetProperties API and retrieve them using the GetProperties API. Or, you can append them inside the report definition (CustomProperties element) but you need to parse the report definition to get them. You can use the RDL Object Model to simplify the latter task.

re: Report Parts

TeeDubs — Sun, 17 Jan 2010 00:36:48 GMT

Great post, thank you for clearing up some of my misunderstandings.

I think the best part of the publish reports parts process is the ability to capture rich metadata about the report part. Is there a way to create custom metadata, or query additional metadata from the ReportServer database?

Thanks for all your posts, and your book, one of my favorites!

re: Report Builder 3.0 Enhancements in R2 and SharePoint 2010 Mode

workerthread — Wed, 13 Jan 2010 15:54:32 GMT

Thanks for the clarification. I can say that apart from some manual config of Report Builder the other R2 features work fine with SharePoint 2007.

There is a separate download for the 2007 integration bits but once installed, use in multiple zones, connections to SharePoiint lists etc all seem to work fine.

re: Report Builder 3.0 Enhancements in SharePoint 2010 Mode

Teo Lachev — Wed, 13 Jan 2010 14:18:36 GMT

Hi,

Sorry for not making this clearer but this applies to SharePoint 2010, R2, and Report Builder 3.0. With SharePoint 2010, the latest cummulative update pack configures ClickOnce automatically so you don't have to manually copy the folders, as I explained here prologika.com/.../report-builder-2-0-clickonce.aspx.

re: Report Builder Enhancements in SharePoint Mode

workerthread — Wed, 13 Jan 2010 13:25:56 GMT

Hi Teo,

For me, this didn't work. In my case Reporting Services R2 is on a different server to the SharePoint 2007 web front end. The Open with Report Builder option went to URL sharepointserver/.../ReportBuilder.application which would not open the correct version (or any version come to that).

I needed to copy the ReportBuilder folder from the Reporting Services server into an accessible location on the web front end then set up a custom launch URL as in previous version, except pointing to ReportBuilder_3_0_0_0.application.

Are you running a single server configuration?

re: Implementing Smart Reports with the Microsoft Business Intelligence Platform

lalitrajput — Sat, 02 Jan 2010 11:03:21 GMT

sql

re: Cumulative Update Package 5 for SQL Server 2008 Service Pack 1

Teo Lachev — Mon, 28 Dec 2009 20:01:32 GMT

1) No, R2 is the next release of SQL Server after 2008.

2) Yes, I believe this issue is resolved in the msi included in CU5.