Create Excel Summary report

Help
1

Hello All,

I want to create summary report for my process. Where I am using 5 different applications to process each transaction. I am using Re Framework and queues too… I need to create an excel summary report at the end of the run which will have first column for transaction numbers and other 5 columns with 5 different applications. This columns will have “Successful” and “Failed” status for each transaction and each applications. Please let me know how can I achieve this???

Thanks for help…

2 Likes
2

Hello,

You have 5 processings (workflows) for different applications per each transaction?
If workflow fails with one application,
do you catch error and continue the process with the next application?
or you don’t catch an error → then entire transaction fails?

2 Likes
3

Hello Vadim Thanks for reply. Yes I catch the error for each transaction I catch business and system exceptions both…

1 Like
4

For every loop, you want to write the status right @RPA2?

Its a simple thing like

  1. declare a variable globally in the main workflow as count which is of type integer
  2. after the process completes, just use excel application scope and write cell activity to write the status of the transaction, you can even write the transaction number or the item you are passing to your application as the reference to the status
  3. The range should be dynamic as “A” + count.tostring
  4. After writing the status of that transaction, increment the values of the count using assign as

count = count + 1

Just out of curiousity, I’m asking, how you are letting the process know the transaction needs to run in which application?

2 Likes
5

Hm, also you didn’t answer for the first question. It’s important.
If you can’t provide conditions and requirements nobody can design a project for you.

2 Likes
6

Is there an example of this?

1 Like
7

Just in the REFramework, declare a variable in Main workflow and then pass it as arguments to the required workflows @happygal321

1 Like
8

Excel Summary Report to make easy by using ZetExcel. It’s easy to use. just try it. Thanks

1 Like