How to create Summary Sheet to add Exceptions and Successful transactions detail in one sheet using REframwework

Hi @loginerror

In my project using RE framework template
in Set Transaction status i am generating three different sheets Summary (From Success sequence), BE (from Business exception) and SE ( from system exception sequence)

problem here is i need to add Business exception and System exception in Summary sheet but still i am not able to figure out how

Can any one assist ?

Hi @Vikram212

How about saving the exception information upon exception instead of at the later step? You could also try passing your exception information in a data table variable all the way to the Set Transaction status routine and save it there.

1 Like

Currently this are my steps in set transaction

Success Sequence

Read Range (dt_Success)
Add data row (Success details)
Write Range (Summary sheet & data table is dt_Success)

Business Exception Sequence

Read Range (dt_BusineException)
Add data row (Business Exception details)
Write Range (Business Exception sheet & dt_BusineException)

System Exception Sequence

Read Range (dt_SystemException)
Add data row (System Exception)
Write Range (System Exception sheet & dt_SystemException)

(Here i need to add Business exception and system exception details in Summary sheet)
is it possible or should i make any changes