Share
Report
1,158Creating SSRS report to show Open Vendor Invoices as of a specific retrospective date. I also have query that is mandatory in report parameter.
CustVendTransDetails
Above class will help me to calculate the correct open balance and settlement status for each transaction as of that specific date.
Above class will help me to calculate the correct open balance and settlement status for each transaction as of that specific date.
The Challenge:
I am struggling to implement Set-Based Operations (like insert_recordset) because the logic for calculating the balance resides within the class method, which requires a record buffer.
I am struggling to implement Set-Based Operations (like insert_recordset) because the logic for calculating the balance resides within the class method, which requires a record buffer.
Current Evaluation:
insert_recordset: Not feasible because I cannot call the CustVendTransDetails class using insert_recordset.
Query::insert_recordset: I can use this to bulk-insert the initial VendTrans records into a temporary table. However, I would still need to loop through the temp table afterward to update the "Settled Amount" for a particular date also to check whether the transactions is settled or not.
RecordInsertList:- Currently, this is the only way to get the data, but it will cause performance issue as I have huge data set.
Question:
Is there a better, more efficient approach to handle this? Specifically, I am looking for a Set Based suggestion that would allow me to calculate retrospective balances for a give date.
Is there a better, more efficient approach to handle this? Specifically, I am looking for a Set Based suggestion that would allow me to calculate retrospective balances for a give date.
Categories:
I have the same question (0)
All responses (
Answers (
