How can i generate test execution report in SOAPUI free version?

Hi,

For the Excel part - possibly you have seen this nice looking answer that came in around the same time as this post:

http://community.smartbear.com/t5/SoapUI-Open-Source/How-to-save-response-data-in-Excel-CSV-format-in-SOAP-UI-5-2-1/m-p/115816#U115816 

To work out the statistics you need, a good place to start is tip 8.2 in https://www.soapui.org/scripting-properties/tips-tricks.html

Which shows an example of a (TestSuite) Tear Down Groovy script that iterates over the runner.results collection and for each TestCase that failed, the iterates over the TestSteps and logs each failure message. This script should be adaptable to give you all but the Test Suite count. To get the Test Suite count maybe it would easier to just add together the separate TestSuite reports?

Hope this helps you get started or at least prompts further discussion,

Rupert