Hi guys,

I am glad to see that Telerik has released a new version of report viewer based on HTML 5. However, I hit a technical issue when I try to start using new version of Telerik report viewer.

Okay, let me talk about what I want to do with Telerik.

1. On back-end, I have built a custom reporting service in WCF, which will be implementing advanced business logic. You can think that I will do below steps on back-end in general. 

     a. Bind data to report - Receive UI request and load proper data for a report. I assume that report is a very basic report which doesn't has any sub-report, groups and other advanced features. 

     b. Render a report - Contact Telerik reporting engine to render a report. 

     c. Response - Send result to UI 

2. On front-end, I have built a MVC web project for displaying reports. But I don't want to use ASPX to display reports. Okay,instead of using aspx and Iframe, I want to use new version of HTML 5 report viewer and RESTFUL service (Personally, I don't like Teleirk restful service but I have to use it if there is no way to use HTML 5 report viewer without restful service). My questions shows as below:

 

Q1: After I sent the report result to UI, how to feed the reportSourceData or we say, report object, to HTML5 report viewer? In an old way, I used aspx page to do the data binding and displaying a report. Is there any small demo or steps to show me how to use new report viewer to display report without using Telerik restful service? If answer is no, please look at next question.

 

Q2: In my opinion, Telerik restful service seems like a build-in reporting engine which could be a black box. I don't have full control on restful service or we say its not easy to get full control on restful service. I think restful service may does similar things like my backend service does. If so, I believe there is a way to feed a report result to html 5 report viewer ? Can you please send me demo code to show me how to do that pls?

 

Thank you.

F9

 

 

I have a simple line chart report, and what I'd like to do is split the data across multiple charts.

I'm using an ObjectDataSource which returns a list of class objects with relevant fields: SampleTime, Value. 

 The chart uses SampleTime as the category and Value as value.

The samples come in at 30 minute intervals, but the charts need to be instanced by date; so two days of data would be 96 data points which would split over two charts. The range of days in the data is arbitrary so it might be 2 days data or it might be 31.

The best I've managed so far is to split the data into different coloured lines on the one chart by adding SampleTime.Date as a series group, but I feel there must be a way to have an arbitrary number of charts on the report, one for each day. In an ideal world the individual charts would populate multiple charts to one report section.

Anyone have any insight or examples to share? I've included an image below that may clarify what I'm looking for.

Hello, I have a report that I am exporting to Excel, and everything looks great except for one thing. When the text in a cell is somewhat lengthy, the last line or two get cut off because the cell is not big enough to fit it all. The report looks fine when rendered and when exporting to PDF, but for some reason Excel is not fitting the text to the cells correctly. Is there something I can do to make the text fit? I am using 2009 Q2 SP1.

Hi,

I have 2 issues when I am using Telerik Report and export to Excel.
(Everything is good in Report viewer, but after it's exported to excel, there are some problems.)

1, After the report is exported to Excel, there is no grid lines in excel, the whole back ground is white, I did not set any border in report, how can I turn on the default grid line in Excel, not make them be white background. (Our report is not full of table, so I did not set any border in my report, it will looks strange in exported Excel, parts of the report has grid line, and others don't. So I think the default Excel grid line will solve my problem, how can I get it?)

2, In the cell of table, I set it to CanGrow=True, CanShrink=False, Multiline=True, TextWrap=True, it works fine in Report Viewer, The long text string will be turned into another line. But after export to excel, the row height is not enough, it will make half of text be cut off in second line, the user have to manually adjust the hight of row to see the whole text. I do see some of threads discussed this issue, it's caused by line spacing in Excel, I want to know is there any alternative solution I can use to solve this problem, because it looks really not good.

I appreciated any help from you.
Thank you very much.

I'm currently using the legacy reportviewer and have modified the session state to use stateserver. All reports were running fine just prior to this update. After this update, for most of my reports, I've been able to just add the needdatasource event within the report itemdatabinding event and the results work fairly well (as long as they're serializable).

 

I have a report with a graph in it, which has its own needdatasource. I've performed the same operation with it default constructor > report itemdatabinding in which I find the graph item and add the needdatasource event > needdatasource event runs with all appropriate parameters passed in. I don't receive an error, but no results are displayed on the graph. Within the needdatasource the parameters of the sqldatasource are updated and applied to the graphs datasource.

 

I've added in a separate graph itemdatabinding event after the report binding, but the results are the same with no data displayed. All of the events, default constructor > report databinding > graph databinding > graph needdatasource run and seem to apply the parameters as needed.

 

Any idea of what the problem could be or at least how I can debug this issue?

Is there a way to do something like the image?

 

thanks in advance

I want call PROCEDURE for trdx reports  

 <Report DataSourceName="ET_OMS_v4" Width="6.46in" Name="FSBOInvoice" SnapGridSize="0.1in"xmlns="http://schemas.telerik.com/reporting/2012/3">
  <DataSources>
    <SqlDataSource ConnectionString="ETOMSv4" SelectCommand="dbo.ETSP_FSBO_GET_INVOICES_FOR_LISTING"SelectCommandType="StoredProcedure" Name="ET_OMS_v4">
      <Parameters>
        <SqlDataSourceParameter DbType="Int64" Name="@invoiceID" />
      </Parameters>
      <DefaultValues>
        <SqlDataSourceParameter DbType="Int64" Name="@invoiceID">
          <Value>
            <String>21</String>
          </Value>
        </SqlDataSourceParameter>
      </DefaultValues>
    </SqlDataSource>
    <ObjectDataSource Name="objectDataSource1" />
    <EntityDataSource Name="entityDataSource1" />
  </DataSources>

you help me

thank a lots

I'm trying to set up a report to list different numbers off, ill use a fake model to show.

public class FakeModel

{

      public string Name {get; set;}

      public int Age {get; set;}

      public IEnumerable<ParentModel> Parents {get; set;}

}

 

public class ParentModel

{

      public int Age {get; set;}

      public string JobName {get; set;}

      public DateTime DateOfBirth {get; set;}

}

 

My problem is I'm using FakeModel as my DataSource and it works fine for the first part of my report for the information I need. Then later in the report I need to use the list of ParentModels to display all the information listed and when I try to use the normal way for selecting values with the ... button, it shows a option to expand the list but I click and nothing changes except the button going away. The goal is to display the list of ParentModels on my report.

 

I'm using the Telerik Report Q3 2015 Wizard.

Hello,

Few days ago, my customer asked me to modify his reports (he has like 70) created like 2 years ago with Report Designer. Just at the beginning I have encountered an error connected with passing parameters and i do not know the cause. On one of my computers, where I have Windows 10 and Q3.2015 i cannot pass a parameter to a stored procedure and by cannot i mean:

- in database there is a procedure dbo.proc which is expecting parameter @ID

- In Report Designer, after chosing stored procedure as data source I create data source parameters by adding parameter ID and i set its design time value to some number. 

- Then i click Execute Query, the popup window of Parameter Values Editor is being shown and just as i click OK I receive an error message:

"ERROR[42000] ....  Procedure or function 'proc' expects parameter '@ID', which was not supplied. "

 

I have found some info about this being connected with Glimpse, but I do not have anything like that installed (in fact, I only have Telerik products as extensions to VS). What is more,I can edit the same report without any problem on my other PC where I have Windows 7. What can be the cause of this problem? How can i trace it down to the source?

 

The other problem is also connected with Parameters, but this time it does not work on both Win10 and Win7. I am editing a data source of existing report (so it was working in previous versions of Telerik Report Designer - I have checked and it is working on Q2.2015). If I create Data Source based on SELECT statement like this:

SELECT column1, column2 FROM dbo.Table WHERE ID = @Param 

clicking "Next" brings me straight into Preview Data Source Results window and Executing Query show an error "Must declare the scalar variable "@Param". "

On Q2.2015 if you click Next in the same situation "Configure data source parameters" window will be shown and after that "Configure design time parameters", which in the end allows you to have a SELECT based data source with parameters declared in this way.

I know i can do it like this:

SELECT column1, column2 FROM dbo.Table WHERE ID = ?

and then declare parameters in exact order but if you have more of them it is not friendly for editing. 

 Can i get any help in any of those issues? Now i would have to edit sources for all the reports and due to the fact that some other customers are also using this I do not like the situation when I have to change everything just because something which was working is not supported anymore (or maybe it is?).

 

Regards,

Mateusz

 

 

 

Is it possible to create a single Telerik Reporting file that will get passed to it a SQL Recordset and it will output the results in Excel automatically?  The ultimate goal is to use this one page multiple times without having to recreate with each new report we want the output to be in Excel.