Pre Sales Question: OData support for ComplexType

Stimulsoft BI Server discussion
Post Reply
Holger
Posts: 6
Joined: Mon Feb 13, 2017 11:14 am

Pre Sales Question: OData support for ComplexType

Post by Holger »

Hello,

we are interested in your Reports/Reports.Server products for usage in our software product which publishes an OData service as an interface for reporting solutions.

I have tried out the Stimulsoft end user designer which basically supports OData, but seems to be lacking support for ComplexTypes (embedded types) and collections in EntityTypes.

This can be reproduced by using the OData "TripIn" sample service: http://services.odata.org/V4/TripPinServiceRW/People
The "Person" EntityType for example contains a collection of "Emails" and a collection of ComplexTypes "AddressInfo".

Am I missing something? Will you support this in the future?

Kindest regards,
Holger
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Pre Sales Question: OData support for ComplexType

Post by Alex K. »

Hello,

At the current moment, we are working on the V4 version of OData service.
We will let you know about the result.

Thank you.
Holger
Posts: 6
Joined: Mon Feb 13, 2017 11:14 am

Re: Pre Sales Question: OData support for ComplexType

Post by Holger »

Thank you for your answer.
Aleksey wrote:At the current moment, we are working on the V4 version of OData service.
We will let you know about the result.
That sounds promising.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Pre Sales Question: OData support for ComplexType

Post by Alex K. »

Hello,

We will try to add it in one or two builds. We will let you know about the result.

Thank you.
Holger
Posts: 6
Joined: Mon Feb 13, 2017 11:14 am

Re: Pre Sales Question: OData support for ComplexType

Post by Holger »

Hello,

I'm still in the evaluation process.

By now I'm creating a sample Report to verify whether your reporting engine will fulfill our requirements. So far it looks great and I'm really impressed with your product.

But there is a small problem that I could not resolve until now. I have created a Report containing a GroupHeaderBand and inside of a Text field in this GroupHeaderBand I want to calculate some percentage.

This is the expression of the Text field:

Code: Select all

{Convert.ToDouble(CountIf(DataBand1, /*some condition*/)) * 100D / Convert.ToDouble(Count())}
Checking the expression returns the following error: "There is no matching overloaded method for 'op_Mult(Object, Double)'

Thanks in advance
Holger
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Pre Sales Question: OData support for ComplexType

Post by Alex K. »

Hello,

Please send us a simple report with test data which reproduces the issue for analysis.

Thank you.
Holger
Posts: 6
Joined: Mon Feb 13, 2017 11:14 am

Re: Pre Sales Question: OData support for ComplexType

Post by Holger »

Hello,

Please find the sample files attached to this post.

Thanks in advance
Holger
Attachments
sample-data.xml
(755 Bytes) Downloaded 326 times
sample.mrt
(8.56 KiB) Downloaded 486 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Pre Sales Question: OData support for ComplexType

Post by Alex K. »

Hello,

Please try to use the following expression:

Code: Select all

{System.Convert.ToDouble(CountIf(Datarecord, record.status == "Error")) * 100D / System.Convert.ToDouble(Count()) + "%"}
Thank you.
Holger
Posts: 6
Joined: Mon Feb 13, 2017 11:14 am

Re: Pre Sales Question: OData support for ComplexType

Post by Holger »

Hello,

Thank you for your help.

The report is rendered now without errors while the "Check" button still shows the described error message. But this is not a problem at the moment.

For reproduction purposes I've attached the updated report definition file and a screenshot showing the error message.

Regards
Holger
Attachments
Check.png
Check.png (22.23 KiB) Viewed 10244 times
sample.mrt
(8.64 KiB) Downloaded 463 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Pre Sales Question: OData support for ComplexType

Post by Alex K. »

Hello,

We will try to fix it in one of next builds.

Thank you.
Post Reply