Telerik Forums
Reporting Forum
6 answers
592 views

Hi everyone!

I'm trying to design a report in the Visual Studio integrated designer but I don't quite understand how to use the table object...

I have a query in a DAO object in my program that is doing a very complicated transaction to fetch the necessary data to plug into the table...

how can I either add row by row the data with a variable number of rows or bind something like a datatable object to the table in the report?

the wizard asks me to input sql connection strings and stuff but I don't want to do that. I have a class that is taking care of the interactions with the various databases and tables needed to build the full report...

I used JasperReports before and I could just pass to the report builder a hashmap (something like a dictionary in C#) with the object as key and the value bound to that key and it worked flawlessly can I do something like that here too?

Otherwise I may just have to ditch this reporting mechanism and make a jar to launch on the side... I really would love to avoid that because until now the whole telerik suite has been a breeze to work with...

 

thanks for any help!

 

Fabio

Fabio
Top achievements
Rank 1
 answered on 22 Jun 2020
2 answers
483 views
Hi,

First of all I am posting this question because mostly all other questions related to the issue are kind of not uptodate.
I need to deliver reports those support both English/Arabic languages, which needs support for RTL direction,
to elaborate: if I have a table with three columns ProductID, ProductName, ProductPrice, I hope to get them in reverse order for Arabic language (ProductPrice, ProductName, ProductID)
would anybody please help me with this issue, is there a way to adjust the report layout to flow in RTL direction, I don't just need that for Table reports,
I also need it for Crosstab reports
I understand there is a limitation in RTL support, but would this be overcomed in the near future?

Thanks
Aseman
Top achievements
Rank 1
Veteran
 answered on 21 Jun 2020
6 answers
573 views
Hi All,

I need to pass a session variable to a report.  If I could access the session variables from the report that would be good too.  Any ideas how to do that?

Thanks,
Darren
Todor
Telerik team
 answered on 19 Jun 2020
0 answers
598 views

In a very few specific places in the product my company has built, we are using Telerik Reports in C#.

Report is trying to reach a stored procedure with 2 params: @languageCode and @invoicePaymentReceiptID

Creating a PDF Report however is giving me the below error:

ERROR

Value cannot be null.
Parameter name: type

STACK TRACE

   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.Activator.CreateInstance(Type type)
   at Telerik.Reporting.Processing.TypeReportDocumentResolver.Resolve(IProcessingContext context, TypeReportSource rs)

DLL VERSION

Telerik.Reporting, Version=9.1.15.731, Culture=neutral, PublicKeyToken=a9d7983dfcc261be

CODE

 Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
 System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();
 Telerik.Reporting.TypeReportSource typeReportSource = new Telerik.Reporting.TypeReportSource();
 typeReportSource.TypeName = frmR.reportName;
 typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("languageCode", frmMain.language));
 typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("invoicePaymentReceiptID", 20421));
 //typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("reportID", tsbReportList.ComboBox.SelectedValue));
 Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", typeReportSource, deviceInfo);

 

It hits in the last line, trying to create the PDF report. 
Any ideas on the topic would be much appreciated.

Thank you.

 

Konstantinos
Top achievements
Rank 1
 asked on 19 Jun 2020
1 answer
1.3K+ views

Hi!

I'm not sure if this is the right place to post this. I'm trying to figure out how to implement custom user functions for use with the reporting server. I was successfully able to implement custom aggregate functions as per this documentation: https://docs.telerik.com/reporting/expressions-user-aggregate-functions

However, when attempting to implement custom functions using this documentation, I cannot get it to work: https://docs.telerik.com/reporting/expressions-user-functions

The functions implemented in this way show up for use in the standalone report designer, but when using them they return an error: "function not defined in current scope"

Am I missing something obvious? Any help would be appreciated! 

Thanks

     

Todor
Telerik team
 answered on 19 Jun 2020
1 answer
98 views

Hello,

I am currently working on a project that requires me to generate a report then turn it into a pdf and send it in a email. I currently understand how to generate a report for a report viewer using uriReportSource, but I don't understand how to generate the report in the code behind then turn it into a pdf.

Todor
Telerik team
 answered on 18 Jun 2020
1 answer
195 views

How to localize Rich Text Editor component displayed by the Send Mail Message Dialog in the HTML5 Telerik Report Viewer?

 

 

Todor
Telerik team
 answered on 17 Jun 2020
3 answers
1.0K+ views
HI,

I want to share my experience with binding an IEnumerable<String> to a report.

Normally, you bind a collection of complex objects with public properties:
public sealed class MyType
{
  public String FirstName { get; set; }
  public String LastName { get; set; }
}
 
 
report.DataSource = new List<MyType>();

Then, in a report's textbox, you specify this expression to load the data from MyType object:
= Fields.FirstName + " " + Fields.LastName



But what if you want to just bind a list of strings without creating redundant wrapper types?
report.DataSource = new List<String>();

You can't just set "= Fields" expression to a textbox, it will produce "Incorrect use of Fields" exception. But you can set following expression and it will work (RawData is of type Object, so I guess it calls ToString() method internally):
= ReportItem.DataObject.RawData
Vic
Top achievements
Rank 2
 answered on 17 Jun 2020
1 answer
162 views

Hi all,

We are using Report Web Designer. We have implemented custom storage (IDefinitionStorage). We have implemented SaveDefinition method where it saves the edited report in a custom way.

There can be some validations and save can fail. For this I am just throwing a new Exception.  

The question is, which kind of exceptions needs to be thrown so that the message of exception shows in a report designer?

In an attachment you can see that the error message is showing in a general way, and it doesn't show my custom message.

 

Thanks,

Todor
Telerik team
 answered on 17 Jun 2020
2 answers
348 views

Hello,

I'm trying to test Telerik Report with .NET Core 3.1 and object data source.

The report is working correctly when running from Visual Studio but when I publish and put it in IIS, I see the below error in every binding.
"An error has occurred while processing TextBox 'textBox15': The expression contains object 'OpeningBalanceDate' that is not defined in the current context"

I'm using the report designer and the assemblies that has the object datasource are netstandard2.0

What could be the issue?

Katia
Telerik team
 answered on 17 Jun 2020
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?