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

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

Dear
How can i change date filtering parameter to Persian calendar or disable popup calendar ?
tnx
Dear Mr/Mrs
Hello, I trying to set parameters to my app and does not working...
What is my problem ?
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

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.

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?
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.