I'm trying to integrate Telerik reporting functionality into Orchard. I've created a custom module that serves up a view containing the ReportViewer syntax, as below:

    <div id="reportViewer1" class="k-widget">
        loading...
    </div>
    
    <script type="text/javascript">

    $("#reportViewer1")
        .telerik_ReportViewer({
            serviceUrl: "/api/CustomReports/reports",
            templateUrl: "/Modules/CustomReports/Reports/templates/telerikReportViewerTemplate.html",
            reportSource: {
                report: "~/Modules/CustomReports/Reports/PlayerCurrentContract.trdx",
                parameters: {
                    /*ReportYear: "2003"*/
                }
            },
            viewMode: "ViewModes.INTERACTIVE",
            scaleMode: "ScaleModes.SPECIFIC",
            scale: "1.0"
        });

    </script>

The module attempts to implement the Telerik REST Api in a controller, indentical to the ReportsController in this guide.
 
My problem is that the ReportViewer's requests to the controller aren't getting through in most cases (verified using Fiddler that the requests are formatted correctly). So for example:

    http://localhost:30301/api/CustomReports/reports/clients/     // Works, response contains a client ID
    http://localhost:30301/api/CustomReports/reports/clients/124902-a308/parameters     // returns a 404

I'm almost certain this is a routing issue, but I'm not sure how to solve it. Orchard doesn't easily give you access to a HttpContext for the ReportsControllerConfiguration.RegisterRoutes() call, so I set up a little hack in Orchard.WebApi.DefaultOrchardWebApiHttpHttpControllerActivator class:

            private bool _reportsRoutesRegistered;
            public IHttpController Create(HttpRequestMessage request, HttpControllerDescriptor controllerDescriptor, Type controllerType) {

            if (!_reportsRoutesRegistered) {
                _reportsRoutesRegistered = true;
                _configuration.Routes.MapHttpRoute(
                    name: "CustomReportsApi",
                    routeTemplate: "api/{controller}/reports/{id}",
                    defaults: new { id = RouteParameter.Optional }
                );
                ReportsControllerConfiguration.RegisterRoutes(_configuration);
            }
            ...

I don't seem to get any exceptions doing this, but obviously something isn't working correctly. I understand that this is a fairly obscure issue (not many posts about using Telerik Reporting in Orchard on the web), but I would greatly appreciate any assistance. Thanks!

I changed one of my report parameters to allow Null, the data query returns valid data when the parameter is Null, and yet I keep getting an error in Telerik report designer when attempting to do a report preview with the parameter set to Null. I'm using Q1 2014. Is this a bug with the system? I've never had this issue before.

Hi,

I am new to Telerik report viewer. I am trying to pass parameters programmatically to a report viewer report on an asp.net web form. I found the article "Using Report Parameters programmaticall", but I can't see an ".add" function for the control.

ReportViewer1.Report.ReportParameters.

I also can't do: ReportViewer1.Report.ReportParameters["ManagerID"].Value = "123";

Can you please tell me what I am doing wrong.

Regards

Dave

Is it possible to deserialized and run a report created with standalone report designer where the report uses a user function?  Note that I was able to deserialize and run a report created without a user function. I have reports created by end users using the report designer that are using user functions and I am looking for a way to run them using a command line application that I am building.

Thank you, Dan

I am evaluating the Telerik Report Designer at the moment. But I have found very little documentation on using the Standalone Report Designer. In addition, the Standalone Report Designer seems to have very little functionality compared to what I've found in the Demos and other Documentation (which appear to be using Telerik Reporting inside Visual Studio).

Is Telerik Reporting *intended* to be used within a development environment? Is it more scalable/extensible inside VS?

So far, I haven't seen the Standalone Report Designer be able to compare with the flexibility of other Report Designers. I find this difficult to digest since I've read nothing but raves about Telerik.

Any information and points in the right direction would be much appreciated. Thanks!

Hello,
when i export my Reports to XLS, the Column "A" in Excel is mergde with Column "B".
I only have a table on my Report.....

Whats going wrong?

Hello,

currently evaluating Telerik Reports. I try to use Telerik Reports hosted by the Telerik Reporting REST Services in an existing Web API project bound to the HTML5 viewer.

It works basically, but in my ObjectDataSource that is bound to the report I have to load data async from an existing backend service. The method gets triggered but the result is never awaited. All I get is the following error:


How do I load data asynchronous to bind them to the report? Possible at all?

I recently disabled PDF font embedding on the reports i generate.  Since then, i've had reports from a couple clients that the text doesn't show up in PDFs when viewed with Chrome or IE's native PDF viewers.  I've tried Times New Roman, Arial and Georgia, but none of them work for the client.  Has anyone run into this before?  

Here's what i added to my web.config:

  <Telerik.Reporting>
    <Extensions>
      <Render>
        <Extension name="PDF">
          <Parameters>
            <Parameter name="FontEmbedding" value="None"/>
            <Parameter name="DpiX" value="600"/>
            <Parameter name="DpiY" value="600"/>
          </Parameters>
        </Extension>
      </Render>
    </Extensions>
  </Telerik.Reporting>

Hello,
I started off with the ReportCatalog used in the CSharp.ReportExamples.VS2010 solution from which reports hosted in an asp.net class library are loaded. I went ahead and created a custom parameter UI above my Silverlight reportviewer, but i cannot seem to get the target report (using the Navigate to Report action) to receive the passed parameters from the custom ui. I can navigate to the reports but only the default parameter values set for the reports are used. I have tried using the RenderBegin method but it seems the passed parameters are being ignored. I have read a number of blogs on this, but somehow, things are not working.

How can I wire up the parameters from my Silverlight application to the reports?

Below are snippets of my code:

In the code behind of the page hosting the reportviewer, I have:

One thing I noticed is that the sender is ALWAYS the ReportCatalog. I was expecting that after navigating to ReportX the Sender would be ReportX. So is it that I am trying to apply parameters to the wrong report?

Please help!!!

My last option would be to abandon the idea of custom parameters UI.

Thanks

I am working on an ASPX page where the user enters some information. When the user click the save button I want to save the entered data then call Telerik’s report passing to it the record_id of the new saved data. I cannot find any information on how to pass parameter to a report. Could someone help me on this issue?

 

Thanks

Maher