Microsoft Dynamics 365 | Integration, Dataverse...

SSRS - Fetch XML Values are multipled (decimal in the wrong place)

(0) Share

Report

Posted on by unicorn_tech

What should be 29.26, appears as 292.6. So I have to create a caluclated field that takes the value and * .1.

Why would the values come in to the report so incorrectly?

All responses (5)

Answers (0)

unicorn_tech 89 on at

Like (0)

Report

RE: SSRS - Fetch XML Values are multipled (decimal in the wrong place)

There was something wrong with my fetchxml. The aggregation in the article caused an issue, but redoing the fetchxml in a simpler format brought the correct values. Thank you for your time.
unicorn_tech 89 on at

Like (0)

Report
RE: SSRS - Fetch XML Values are multipled (decimal in the wrong place)

Thank you for the suggestion. I modified the fetch to the following:

This resulted in a dependancy calculation error

"Failure (An attribute can not be requested when an aggregate operation has been specified and its neither groupby nor aggregate. "

ErrorDetails-_2800_16_2900_.txt
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: SSRS - Fetch XML Values are multipled (decimal in the wrong place)

Hi unicorn_tech,

Based on your description, you want to group by a field, but the sum result is not correct. Please refer to this document about aggregation in fetch xml, and then change you fetchxml to have a try:

Use FetchXML aggregation (Microsoft Dataverse) - Power Apps | Microsoft Docs
unicorn_tech 89 on at

Like (0)

Report
RE: SSRS - Fetch XML Values are multipled (decimal in the wrong place)

I think my problem is that I'm trying to use get the "area" (value) to subtotal based on Tablix Groupings. Instead, it's just taking the first value. I'd like to attach my fetchxml and my report, so you could see what's going on.

When I use the field: Fields!ab_new_areaValue.Value, it only takes the first value of the grouping (rather than the sum total of the group.) When I do SUM(Fields!ab_new_areaValue.Value), it multiplies the first value by 1,000, but it's still the first value.

If I itemize the tablix, without grouping, I get all the correct entries. The issue is in the grouping, which doesn't subtotal the value, per variety and year.

This is the fetchxml:

100000000 100000003 100000005 100000004 100000002 100000001 100000000 100000001
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report
RE: SSRS - Fetch XML Values are multipled (decimal in the wrong place)

Hi unicorn_tech,

I created a Decimal column to test and it is still 29.26.

Result:

The following is my fetchxml:

Could you share your fetchxml for further research?