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.

Hello,

I am looking ahead for options in telerik reporting tool that can help me digitally sign a PDF generated from the telerik report.

Please give me your suggestions for means to achieve this.

Thanks,

Amit

 

I want desing trdx to image:

 

Hi,

I am trying to show the teleik report with objectdatasource available only at runtime. 

Following is the code which I used. 

                             object jsonobj = getJsonObject();

                            SearchbyCondition oSearch = new SearchbyCondition();
                            List<SearchbyCondition> oListCond = oSearch.getSearchbyConditionReportFields(jsonobj);

                            // Creating and configuring the ObjectDataSource component:
                            Telerik.Reporting.ObjectDataSource objectDataSource = new Telerik.Reporting.ObjectDataSource();
                            objectDataSource.DataSource = oListCond;// GetData returns a DataTable

                            // Creating a new report
                            Telerik.Reporting.Report report = new Telerik.Reporting.Report();
                            
                            // Assigning the ObjectDataSource component to the DataSource property of the report.
                            report.DataSource = objectDataSource;


                            System.Xml.XmlReaderSettings settings = new System.Xml.XmlReaderSettings();
                            settings.IgnoreWhitespace = true;
                            string localPath = Request.ApplicationPath + "Report/" + ReportName;
                            localPath = Server.MapPath(localPath);
                            XmlReader xmlReader = XmlReader.Create(localPath, settings);
                            Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
                            report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);

                            // Use the InstanceReportSource to pass the report to the viewer for displaying
                            Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
                            reportSource.ReportDocument = report;

                            // Assigning the report to the report viewer.
                            ReportViewer1.ReportSource = reportSource;

                            // Calling the RefreshReport method in case this is a WinForms application.
                            ReportViewer1.RefreshReport();

I can see the report but without any data.

I tried using value="[Fields.BOPropertyName]" 

value="Fields.BOPropertyName" as well in trdx file

 In trdx file how can I give Objectdatasource TAG as while design it is not available.

as mentioned at http://www.telerik.com/help/reporting/connecting-to-data-working-with-data-at-design-time.html

"Data source available only at runtime" passage.

 

I've used the designer with SQL and that works fine but I need to use a business object as a data source. I see under the Data tab the Object Data Source but Available data source types is empty (not surprisingly). How can I tell the designer where to find my objects?

Thanks,
Don Rule
http://tranlslationalsoftware.com

OK, I think that I have found a section of the config file but still not able to see 

<Telerik.Reporting>
<AssemblyReferences>
<add name="C:\PortalApp\ReportLibrary\bin\Debug\ReportLibrary.dll" version="1.0.0.0" />
      <add name="C:\PortalApp\ReportLibrary\bin\Debug\CdssModels.dll" version="1.0.0.0" />
      <add name="C:\PortalApp\ReportLibrary\bin\Debug\Utilities.dll" version="1.0.0.0" />
</AssemblyReferences>
</Telerik.Reporting>