insert_recordset using the Query class (query::insert_recordset) work with aggregation for SSRS reports?

(1) Share

Report

Posted on by Stephen King

Hi all

I'm hoping to get confirmation on this subject please. Using the bulk record set operation, "query::insert_recordset" in the report data provider class I was wanting to aggregate a few fields but can't get it right. I get the error: "There is mismatch between source and target fields for insert_Recordset."

One user suggested using this mapping:

fieldsMapping.insert(

<Target Table fieldStr>,

[ds.uniqueId(), strFmt("SUM(%1)", <Source table fieldStr>)])

e.g.

strFmt("SUM(%1)", fieldStr(InventTrans, CostAmountPhysical))

but, unfortunately this doesn't work either.

I've seen many examples where the aggregations are performed after the initial 'query::insert_recordset' using set based operators: 'insert_recordset' and 'update_recordset' but I was hoping to include the aggregations in the initial query. Has anybody managed to do this or have confirmation on whether it is supported or not?

Thanks in advance

Stephen

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

udaY-ch 5,180 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Similar thread with same question.

community.dynamics.com/.../209243

Even in standard i couldnt find any aggregation used is Query::insert_recordset.

/Uday.

Was this reply helpful? Yes No
Stephen King 86 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply Udhaya. I did come across that thread also initially. I think I will need to accept that aggregation is not supported for now. Kind regards

Was this reply helpful? Yes No