Prologika (Teo Lachev's Weblog) - All Comments

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.

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

rbenavides — Mon, 28 Dec 2009 19:08:01 GMT

2 questions:

1) is this update the same as sql server R2, if not wich one should I install

2) has this issue been addressed in any of the updates?

Note (7/15/09): There is a known issue that RB2ClickOnce.msi fails to install on x64 environment. Microsoft should fix this in Cummulative Update 3 for SQL Server 2008 Service Pack 1.

re: Heat Maps as Reports

Teo Lachev — Sun, 27 Dec 2009 22:04:26 GMT

You can run the application by just running HeatMap.exe. Then you copy the generated INSERT statements and execute them in SQL Server Management Studio to populate the Test table. Then, you use Report Builder 3.0 to create a map from the test results.

re: Heat Maps as Reports

odeddror — Sun, 27 Dec 2009 19:03:59 GMT

Hi there,

I follow the instruction but my VS 2008 don't open Report in local mode I had to open it with Report builder 3.0

When I ran the project it generate DOS consul with the xml records and the map shoing only two recods from test table

What did I do wrong?

P.S I have SQL Server 2008 not R2 butit works with Report builder (Vista x64)

Thanks,

Oded Dror

re: Web ReportViewer and Multi-value Parameter Bug (or how I spent my weekend)

Teo Lachev — Fri, 30 Oct 2009 01:18:55 GMT

Hi John,

Thanks for not blaming my book :-) You didn't say which version of Reporting Services you are using but AWReportViewer is obsolete. Use the Visual Studio ReportViewer. You can hide the parameter area and implement your own. I demonstrate this in my latest book "Applied Microsoft SQL Server 2008 Reporting Services".

HTH

re: Web ReportViewer and Multi-value Parameter Bug (or how I spent my weekend)

jtobey — Thu, 29 Oct 2009 21:29:44 GMT

I've been struggling to integrate the AWReportViewer custom control, from the sample code accompanying your Reporting Services in Action book, into my application without success. I could really use some help with this.

My web application delivers a variety of reports to law enforcement agencies. When complete, I will have a couple hundred reports, in 3 major categories, available online. What I originally did was create the individual reports on the report server, then programmed individual aspx pages to access each report. This was fine when there were only a few reports, but it has become something of an issue to maintain now that the reporting feature is gaining wider use.

What I am attempting to do is create 3 tabs on my menu (for the 3 different categories of reports), each with a datagrid from your AWREPORTVIEWERDEMO page to access that category of reports, and using the AWReportViewer control to display the report.

I have successfully integrated your code sample into my application except for the AWReportViewer control. It doesn't display the report. It doesn't appear to do anything. There are no error messages. When I step through the code the RenderReport() function is run, the visible property is set to true, but no report. Any help you could provide would be greatly appreciated!!! What can I provide to you that would be of assistance in debugging this issue?

I can't even begin to tell you how many questions I have on an hourly basis. Does there need to be changes to the libraries and recompile the assemblies? Is the code for those assemblies available as part of this sample? Can I use the native ReportViewer control instead (it doesn't take into account the parameters though, although I did program individual pages to enter and validate the parameters before passing them to the report server)? There are questions I haven't even begun to formulate. I've been programming for 25 years. I've been programming in "classic asp" (the term I recently found - which makes me feel like a freaking "golden oldie") for the past 7 years, SQL Server and Oracle for the past 10 years. I started using VS about a year ago. C# is relatively new to me, but not entirely different from other languages I've worked with. And VB.NET isn't your ordinary VB (as the name would loosely imply) but I'm managing that as well. I've found the Visual Studio interface to be fairly standard with other products I've used, and I've taken several official Microsoft training courses this last year to help me ramp up on Visual Studio and Reporting Services specific features. I'm one of those people that now knows enough to be dangerous, but still can't see the big picture, so I've been programming this application in bite-sized chunks. Not the way I like to do things, but the only way that I can make it manageable. I'd be happy to share the code with you if that would make things easier.

Any advice you could share with me on getting over this learning hump would also be appreciated. Your book is very organized and thorough. I blame Microsoft for my confusion. =)

Thank you for your time.

John F Tobey

Systems Analyst

Oregon State Police,

Law Enforcement Data System

(503) 378-3055 x55039

john.tobey@state.or.us

re: RDL Object Model on the Horizon

Andrew — Fri, 18 Sep 2009 08:33:34 GMT

Teo,

How can I know (using RdlObjectModel) to which TablixColumn represerts some ReportItem?

Thanks.