Hi,

I am using the Query Designer in the SQL DataSource component in my report. In the Database view section I can see the view I need and its columns but when I select one of them I get the error Object reference not set to an instance of an object. 

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.Reporting.Design.QueryDesigner.Form.DataModelManager.CreateEntity(String path)
   at Telerik.Reporting.Design.QueryDesigner.Form.DataModelManager.FindOrCreateEntity(String path, Boolean refreshRelations)
   at Telerik.Reporting.Design.QueryDesigner.Form.DataModelManager.AddProperty(Property sourceProperty)
   at Telerik.Reporting.Design.QueryDesigner.Form.DataModelTreeViewController.TreeViewAfterCheck(Object sender, TreeViewEventArgs e)
   at System.Windows.Forms.TreeView.OnAfterCheck(TreeViewEventArgs e)
   at System.Windows.Forms.TreeView.WndProc(Message& m)
   at Telerik.Reporting.Design.Common.Controls.TreeViewEx.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

The same error is attached as a screenshot. When I click Continue, the column is not added to the Selected fields section. 

I am using other views for other SQL Data Source components and I have no problem with them. 

The only difference I can see with this view is that its query contains pivot statements. 

How can I resolve this issue?

Best Regards

Is there a place on here for a novice willing to learn, 

I use Telerik Report Designer to provide templates to a reporting system i use for work, pulling the source from the report system (i'm sure this is simple stuff to most on here).

I'm getting familiar with the system however i often come across issues that I'm sure are fairly quick fixes however it takes me a fair while to get right so though i would sign up to this forum and see if i can get swift responses.

My first question to post is what expression would i need to use to give a cell in the report 2 values from the source?

for instance i want both this value:

= Fields.Specification

and this value

= Fields.Type_in_the_Standard

to to appear in the same cell

any help is much appreciated.

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?