i build a project in reframework datatable i need to create summary report how i can achieve it?
Thankyou
You can update the status of each transaction in Process Transaction
state after Set Transaction
Invoke.
Add your Summary preparation/sending etc. do that it in End
State.
Could you please elaborate
Thankyou @ashokkarale
I tried to explain in detail below:
- Init State: You should use build datatable containing the columns you want.
- Then you should pass this variable as an argument(in/out) to the Process.xaml.
- Process State:
a) At the end of the Try block, you should create new row from the datatable and fill the columns’ values there also.(You can add ‘Process Status’ column and assign as ‘Successful’)
b) At the end of the Catch block, you should agaib create new row from the datatable and fill the columns’ values there also.(You can add ‘Process Status’ column and assign as ‘Failed’) - End Process State: Your datatable is ready at this state. You can write the datatable to an excel and send it by mail activites.
Hope this helps,
Regards.
- build a summary table with required columns in init state under first run
- In set transaction status pass the datatable as in/out and in each sequence success, bus exception and system exception use add data row activity and add the required details you need
- in end state use the dtaatable and use write range
cheers
in My use case there are two loops in process transaction state one is getting input from input file and other from that input data many excel file has to download and perform vba code i need to create a summary sheet that each of every excel file vba is created
@Anil_G
@ashokkarale
@tolga.kamci
Thanks in advance
Depending on what data you need in report keep the add data row either in first or second loop
But not sure why you have so many loops again inside ref as wel
Cheers
Second Loop
1st loop is getting one data and typing in website
From that i will get list of Excel file that i will perfom vba for that i need summary report
Then inside peocess xaml…inside first loop use build datatable at start
Inside second loop use add data row
After second loop and inside first loop use append range activity
Cheers
Thankyou
@Anil_G
@ashokkarale
@tolga.kamci
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.