Telerik Forums
Reporting Forum
3 answers
1.0K+ views

Hi,

Today it is not possible to display/consume object fields from a nested array (as far as I can see).

MyDataSet
- field1 (int)
- field2 (string)
- field3 (int)
- field4 (object)
-- field4_array (object)
---- field4_1 (int) (not visible/accessible)
---- field4_2 (int) (not visible/accessible)
---- field4_3 (string) (not visible/accessible)

This means the fields of field4 (array) are not visible or accessible in the report designer.
The only way to access this data, is to make a new dataset, with (field4_array) as root,
but that is not preferable.

 

Could this potentially be implemented in upcoming versions?

 

Cheers,
Casper

Silviya
Telerik team
 answered on 20 Aug 2019
3 answers
419 views

Hi,

I'm experiencing that simple aggregation functions doesn't work properly on fields 
that includes null values (even though the documentation says that it excludes null values).

I'm doing the aggregations in list rows (outside group) and using the inline json data sources.

I see the following errors:

- Avg: [= Avg(Fields.collectionIncludingNull)]
Error: Type mismatch in expression 'Add'.

- Max: [= Max(Fields.collectionIncludingNull)]
Error: Cannot perform '<=' opreration on System.Decimal and Newtonsoft.Json.Linq.JValue

- Min: [= Min(Fields.collectionIncludingNull)]
Error: Cannot perform '<=' opreration on System.Decimal and Newtonsoft.Json.Linq.JValue

Can you investigate this for me, and see if you spot the error in your end?

Thanks!

Cheers,
Casper

Casper
Top achievements
Rank 1
 answered on 20 Aug 2019
3 answers
529 views
I have a field from the database that is an integer which is basically number of seconds.
but i want to display it as HH:MM:SS, Is there a way to do that using expression in the reports or it has to be done in code behind.

Silviya
Telerik team
 answered on 19 Aug 2019
0 answers
181 views

Dear 

How can i change date filtering parameter to Persian calendar or disable popup calendar ?

tnx

mojtaba
Top achievements
Rank 1
 asked on 19 Aug 2019
3 answers
817 views
Hi,

If I want to use the Exec function in a table- or list row (outside group) to access data in context of a different scope (Report2, which is the name of the report item),
i get an error that the scope does not exist (see attachment).

My expression is in this format: [= Exec("Report2", Sum(Fields.theFieldName))]

Shouldn't this be possible, or am I wrong?

Thanks,

Casper
Casper
Top achievements
Rank 1
 answered on 19 Aug 2019
0 answers
126 views

Dear Mr/Mrs

Hello, I trying to set parameters to my app and does not working...

What is my problem ?

 

mojtaba
Top achievements
Rank 1
 asked on 18 Aug 2019
6 answers
721 views

I am using Table Wizard to display data. I am getting out the way I want but on every page break Table wizard draw an vertical line if it has more data in same table. Attached Image show my Problem (ProblemScreenshot). 

Can anyone help?

Thank You

Todor
Telerik team
 answered on 16 Aug 2019
2 answers
715 views

Hello,

I have a report that needs to dynamically change its currency symbol based on the customer.

Localization is set to true, and I have tried setting the data binding both on the entire report and specific text boxes that are formatted with {0:C2}.

When changing the culture manually to both the report and text box it works but applies those cultures to ALL reports.

The query field that shows the currency type returns as one of the following:

USD , EUR, GBP, CAD, CNY

This is the expression I am trying to use to dynamically change the culture of the text box based on the currency type returned.

IIF(Fields.InvoiceCurrencyCode IS NULL, (Default), IIF(Fields.InvoiceCurrencyCode = USD, (Default),IIF(Fields.InvoiceCurrencyCode = CAD,(Default),IIF(Fields.InvoiceCurrencyCode = GBP, en-GB,IIF(Fields.InvoiceCurrencyCode = EUR, nl-NL,IIF(Fields.InvoiceCurrencyCode = CNY,zh-CN,(Default)))))))

I have tried adding double quotations surrounding comparer and true values and it does not change anything.

In the Binding the property is set to Culture.

What am I missing to make this work?

Please and thank you.

Silviya
Telerik team
 answered on 16 Aug 2019
1 answer
306 views

I'm having issues with trying to add column that will perform arithmetic using info from 2 different tables with different datasources...

And because I need to expand upon info in the field.  I don't think I can put in simple arithmetic using the textboxes.. but I can't select the field from the other table... so how can I do this?  I attached a pic explaining it...

 

Please help?

Lily
Top achievements
Rank 1
Veteran
 answered on 15 Aug 2019
6 answers
1.9K+ views

Hello,

I have a report to show vehicle datas.

For each group here the vehicle, e.g. PCH W 100,  I calculate the difference with the formula

= (MAX(Fields.Mileage) - MIN(Fields.Mileage)) + " km"

(See black arrows in the attached screenshot!)

The result should be summed up and displayed in the bottom line.

But I have no idea how to make it.

This throw an exeption:

= Sum((MAX(Fields.Mileage) - MIN(Fields.Mileage)))

 

Best Regards.

 

 

 

 

Simon
Top achievements
Rank 1
 answered on 14 Aug 2019
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?