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. 

 

I'm new to telerik reporting and have been assigned a case that looks hasn't been discussed before, in specific I need to put a simple image on the left border which must be repeated on each page and is dependant from PageNumber and PageCounter, but is part of the detail section. I already know page related elements are bound to be for header and footer only, but this image must be in that specific point because is needed for an automatic envelope machine.

The only thing that comes to my mind would be to have an unbound group header have this image inside, so to be able to place the right one for each page, and make the detail section override it somehow, because it wouldn't really go over any element, just blank space left because of the required image.

 Are there some solutions you could suggest me to get over this?

Many thanks in advance, kind regards.