How to use one data set output to create another data set dynamically

I have one data set as below

final result should be like below. each deal should get the accumulated Debit and credit based on it's parent deal id.

Answers

  • You can achieve this by doing all your calculations in a stored procedure and access that stored procedure in a Data Set of type "SQl Stored Procedure Query"

Sign In or Register to comment.