Comments on flowmarks: Experiences with Telerik Reporting

As a report specialist of many years, I concur wit...

2012-01-27T01:31:42.667-08:00

As a report specialist of many years, I concur with your comments at the ed of your blog. Report should developed against a dimensional model. Too many times I have written reports against an OLTP database and the challenge is wrapping my head around the schema. If I am lucky, it is sort of normalised. Writing 'spider web' queries is not fun and prone to strange results. I have used various reporting technologies over the past 15 years with an emphasis one the good favourites, Crystal (and it's various incarnations) and SSRS. Telerik looks ok, but it seems to require a more developer expertise to compile and deploy. Deployment does not look straight forward compared to SSRS. I am about to embark on using Telerik reporting for the same reasons as you - my company has a Telerik license. I'll see if this ends in tears or not...

Mau, Do you mean that the report designer (BIDS) i...

2011-11-23T13:48:37.979-08:00

Mau, Do you mean that the report designer (BIDS) is slow, or is it runtime generation of the reports that is slow?

I remember that the BIDS UI could be slow, but I never remember that generating a report would be much slower than the SQL query the report is running.

Opening SSRS reports from the server with an url is convenient and powerful with all the parameters available. This level of control I am missing in my current DevExpress-based reporting system.

Matthew, sorry for the late answer. Last time I te...

2011-11-23T13:37:50.640-08:00

Matthew, sorry for the late answer. Last time I tested Telerik reporting about a half a year ago. There were improvements, like more control for custom totals, but the overall experience had not improved. We still use Telerik reporting for a single report in production, but that's it.

Your requirements are hard to satisfy. But if you have only a few databases to report from, and all are in your control in the same network, then I would experiment with SSRS.

Btw, what is wrong with Active Reports? I can't tell because I haven't tried it yet.

Hi Mika, I have been working since 2004 in Cognos ...

2011-11-22T13:21:21.698-08:00

Hi Mika, I have been working since 2004 in Cognos BI a tool that I really love but very expensive.
Currently I am about to finish a product and need a reporting tool, either embedded or a server, but one that can render through a web url.
Since I will be using SQL Server 2008 my first thought was SSRS. Have tried to work in my local machine but it is way too slow.
I know this is an old post, but could you give me your feedback about working with SSRS? Is really that good? Was I doing something wrong?
Thanks a lot.

Has Telerik Reporting improved? We desperately nee...

2011-11-03T15:52:43.313-07:00

Has Telerik Reporting improved? We desperately need a reporting tool in our enterprise asp.net stack that:
* rapid development of complex reports - good flexible power like Active Reports
* rich reporting UI design that renders perfectly in MS Word (NOT RTF), PDF, Excel
* scalable/fast reports

Hi Aldrie, First, I would recommend is to ask thi...

2010-03-16T11:14:21.250-07:00

Hi Aldrie,

First, I would recommend is to ask this in the Telerik Forums:

http://www.telerik.com/community/forums/reporting.aspx

There are few things you'll need to specify:
- Are you using MS Dataset Generator datasets? If so, which method did you use, Fill or GetData?
- Did you verify with a debugger that the dataset is filled in the runtime processing (NeedDataSource event)?
- Did you set the report's datasource in runtime procesisng?

I've had the least trouble when using a NeedDataSource event, running an SqlCommand there to get the data, and setting the report's datasource to this data.

A pseudo-VB example:

Sub Report_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles MyBase.NeedDataSource

'Take the Telerik.Reporting.Processing.Report instance
Dim report As Telerik.Reporting.Processing.Report = CType(sender, Telerik.Reporting.Processing.Report)

'Read parameters
Dim param = report.Parameters("param")

'Fetch data
Dim commandText As String = "SELECT... "
Dim conn As SqlConnection = New SqlConnection(ConnectionString)
Dim cmd As New SqlCommand(commandText, conn)

cmd.Parameters.Add("@param").Value = param
Dim adapter As New SqlDataAdapter(cmd)

Dim ds As New DataSet()
adapter.Fill(ds)

'Set datasource
report.DataSource = adapter

End Sub

Hi Mika! It seems you're well experienced wit...

2010-03-14T18:09:37.624-07:00

Hi Mika!

It seems you're well experienced with Telerik reporting. I hope you can help me out with a bug that has been keeping me awake for several nights now.

I'm trying to fix a web application that i've inherited from a previous developer. The Telerik Reports don't seem to work. Everytime a report is generated, the report comes up but with no data in it. This is true to all the existing reports in the application. I've checked the datasets and they are not empty. I created a test application with different set of reports and they work just fine. Since i'm new with Telerik, I'm not so sure what's wrong with the existing application.

A user even reported that the reports only work the first time around. Once she successfully viewed one, any other reports she will be opening from then on would have no data in them.

I'm not sure if you've encountered this problem, but any help would be very much appreciated.

Thanks!

Hi Rick! In IIS6 you have to put Telerik ReportVi...

2009-12-11T11:21:18.042-08:00

Hi Rick!

In IIS6 you have to put Telerik ReportViewer in the <httpHandlers> section:

<add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.1.9.701, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>

As you can see, it is version specific. If you upgrade, you'll have to change web.config.

In IIS7 and above, RportViewer is in the <handlers> section:

<add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=3.1.9.701, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode,runtimeVersionv2.0"/>

Hope this helps,
-mika-

I'm about to embark on Telerik Reporting in DN...

2009-12-11T10:44:34.046-08:00

I'm about to embark on Telerik Reporting in DNN. I wondered what you put in the web.config to make this work? If you could answer it would be appreciated. Rick@GolkoConsulting.com.