Hi, I'm working using Telerik standalone (trial) to create a report, using JsonDataSource.

In my model i have "complex" data, like object arrays. Creating the report the first issue is that all these objects are shown ad System.Object, and i need to use some data for tables (and using bindings solved problem for tables).

The problem is that i need to show charts, and i can't find a way to make it work.

Hi,

    I was trying to create a new data source with MySQL connection string in Telerik Report Designer Standalone tool. While trying to preview the datasource results on clicking 'Execute Query' button I am getting an error message "An error has occurred.
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application."  When tried to connect with SQL server connection string, I am able to view the results.

   Then I set the same MySQL connection string as shared connection and was able to create and run a report using the Telerik Report Designer. But when tried to execute the same report from Angular report viewer using Telerik Rest service, I'm getting the same error mentioned above. It would be helpful if anybody can provide a solution for this issue. Please find attached files to get more details about the error.

Thanks.

I am trying to create a sample project to test reporting in
our Universal windows App(UWP). However i am unable to get the basic test going.

Do you have any reporting template for universal platform..

Please help me for creating report in universal platform(UWP)

Thanks in advance

Dhaneesh

I had exported the excel file from my report. while opening , the excel file prompt a warning message "We found a problem with some content in <filename>.xlsx . Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes" but after click Yes, the report show successfully without any problem.

what can I do to avoid the excel to prompt such warning message ?

Hi

I'm new to telerik and I'm trying to figure out how best to approach this problem.

I have a datasource that contains rows for individual ice cream sales for people by date. So a person could have multiple rows under different date (e.g. John could buy chocolate ice cream on 02/02/2020 and vanilla on 02/03/2020).

I have a column that stores the total number of ice creams a person has bought in history, my report shows the total number of ice creams a persons bought between two dates and the total in history like so:

Name | Total Ice Creams Bought | Ice Creams For Date |

John   |                  5                     |              2                    |

Max    |                 10                    |              5                    |

So in the data returned there's 2 rows for "John" and 5 rows for "Max". Now in the report the "Total Ice Creams Bought" is the First of that column while "Ice Creams For Date" is a Sum.

I want to add another column that will have the sum of these rows in the report,however because the "Total Ice Creams Bought" is aggregated in the datasource (it's 5 for "John" in every row) when I sum it it will sum it for every row.

So in the above example the aggregate row after I created it returns 60 instead of 15 (10 for "John's" two 5's and 50 for "Max's" five 10s), is there a way to aggregate just the values as they're shown in the report instead of the aggregate values of the datasource?

Cheers!

I am trying to write an inventory report, which is using two databases.

The primary site uses the database InvA, and where the product is in the secondary facility this database has a secondary code which is basically the key for the inventory line in the InvB database.

I have written a SQL statement that connects to the two databases and collects the data they want, combining where needed and the data matches what they want.  A single table combining the product quantity by product code and lot code, regardless of facility.

1) The problem I'm having is how do I create a report that uses my SQL statement which connects to two databases?  Is there a way of assigning two connection strings to a single SqlDataSource?  Is there an example for this?

2) Do I have to programmatically "merge" my datasources into a single data table, and then use an ObjectDataSource?  Is there an example of this?

3) Does Telerik use DataSource and Database interchangeably, meaning I can only use one database per report?  Should I be asking the client if I can modify the database to include a table valued function?

Hi,

I have Telerik report designed in Telerik Report Designer.

It contains two object data sources.

I programmatically load trdp file and initialize DataSource property of Report object by two Object Data Source Instances.

In generated report I see strange behavior: table is bound to first data source is duplicated.
Questions:
1.Why report object contains DataSource property = null?
2.in the spec. it's written, that DataSource should be initialized by object derived from IEnumerable interface as well, but when report is rendered, it doesn't take all instances of passes Object Data Sources, but just duplicate first one.

Source code: