HOW to Create Summary report using reframework datatable

i build a project in reframework datatable i need to create summary report how i can achieve it?
Thankyou

@Vijayan_Sathyagiri_EXTERN,

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

Hi @Vijayan_Sathyagiri_EXTERN

I tried to explain in detail below:

  1. Init State: You should use build datatable containing the columns you want.
  2. Then you should pass this variable as an argument(in/out) to the Process.xaml.
  3. 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’)
  4. 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.

@Vijayan_Sathyagiri_EXTERN

  1. build a summary table with required columns in init state under first run
  2. 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
  3. 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

@Vijayan_Sathyagiri_EXTERN

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

@Vijayan_Sathyagiri_EXTERN

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.