Hey guys, the next bit they want me to work on is a report that will show the total number of times a Test Case was during and Event and the number of types the RunAssessment was Green.
I've built the forum TC Summary to allow the use to select the Event they want to view.
I've also built the report TCSummary_rpt, but it is not functioning like I want it to. The txtEvent (just under the title) is not being updated to reflect the event the user selected in the form. The Total Runs textbox (Text18) is showing the total amount of runs from all events and not filtered by the Event selected in the form. Finally, the Green Runs textbox (Text20) is returning an error instead of the number of Green runs from that event.
Text18 Control Source code
Code:
=DCount("TestCase","RunResultData")
Text20 Control Source code
Code:
=DCount("RunNumber","RunResultData","RunAssessment = Green")
I've also attached the db if that helps.