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.

In my report group section at the bottom of my report, totals are calculated.  Some calculations are dividing based on the Sum() of fields shown in the detail section.

If the textbox is defined with value at design time as follows: 

=IIF(Sum(Fields.NumberOfReceipts1) = 0,
   0,
   Sum(Fields.Sales1) / IIF(Sum(Fields.NumberOfReceipts1) = 0, 1, Sum(Fields.NumberOfReceipts1))
)

This works fine and there is no error.  However, because of the number of total boxes in the report - I ended up getting a Stack Overflow message just on entering the component.Initilializer() (First { bracket).  So decided to create these boxes at runtime:

textBox.Value = "=IIf(Sum(Fields.NumberOfReceipts1) = 0, 1, Sum(Fields.NumberOfReceipts1))";

But this now causes the following error:

"An error has occurred while processing TextBox 'rtNoSales12': An error has occurred while executing function IIf(). Check InnerException for further information. ------------- InnerException ------------- Exception has been thrown by the target of an invocation. ------------- InnerException ------------- Index (zero based) must be greater than or equal to zero and less than the size of the argument list."

How can I avoid the Divide by 0 error by defining report textbox values at runtime?

According to the telerik reporting documentation,  Subscript, Superscript (<sub>,<sup>) HTML tags are supported in the HTMLTextBox control. However I cannot seem to get them to render correctly when I export to PDF or WORD. I couldn't find anything in the documentation saying it wouldn't render for those formats. I am trying to debug my code but am stumped at the moment and just wanted an official word on whether this is even supported.

Hello,

I need to Create Table which displays nested List.

Kindly find attached image to see required design.

Thank you.