Using insert_recordset

(0) Share

Report

Posted on by Community Member

Hi all

i built my SSRS Report RDP based , then when i run my report it took too much time to retrieve data from from Tmp table to Visual Studio

someone advised me to use key word insert_recordset in process report method to improve my performance

i already did that but there is some limitation i need to ask

1- if i need to group by my record with itemId field as Child Group , and making group by SalesBuyerGroup as Parent Group .. how can i do that using insert_recordset ?

2- does it allow to inset display methods using insert_recordset ?

thank you

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

When you say display method, probably you might be referring to display methods on table. You can make use of recordInsertList instead of insertRecordSet and also you can perform required groupings & insert the data.

Refer following links to check the implementation:

(Insert records in a table using RecordInsertList)
msdax.wordpress.com/.../recordinsertlist

(Ax 2012 – RecordInsertList – Performance series (Part 1))
blogs.msdn.microsoft.com/.../ax-2012-recordinsertlist-performance-series-part-1

(RecordInsertList Class [AX 2012])
msdn.microsoft.com/.../recordinsertlist.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Chaitanya

could you skip my second Question .. and let me know how to use insert_recordset and how to apply grouping (parent group, child group) : )

Was this reply helpful? Yes No
Suggested answer

Ali Zaidi 4,657 on at

Like (0)

Report

Hi, m.wafa, I shared the code snippet for insert_recordset with group. I think you miss the forceplaceholders keyword before

insert_recordset _OpeningBalance (ItemId, InventDimId,BeginDate, EndDate,OpeningQty)

select forceplaceholders ItemId,InventDimId , _FromDate , _ToDate from _OrignBalance

// group by ItemId,InventDimId

where

_OrignBalance.BeginDate ==_FromDate

&& _OrignBalance.EndDate ==_ToDate

join sum(Qty)from inventTrans

group by ItemId,InventDimId

where _OrignBalance.InventDimId == inventTrans.inventDimId && _OrignBalance.ItemId == inventTrans.ItemId

&& inventTrans.DatePhysical <= _FromDate - 1

// && inventTrans.DatePhysical >= _NullDate

&& ((inventTrans.StatusReceipt == StatusReceipt::Received || inventTrans.StatusReceipt == StatusReceipt::Purchased)||( inventTrans.StatusIssue == StatusIssue::Deducted || inventTrans.StatusIssue == StatusIssue::Sold ));

Was this reply helpful? Yes No