Basic Report 1

[saran26]

Hi All,

I have the following requirement.

I have a table called TestPlan

with n number of testcases, each plan has a execution time and a over headtime.

I have to display as below in a cross tab

totaltests plantime overheadtime
Plan name 10 10.15 23

Note there are many tests per plan , so I have to find out the count of tests per plan, but plantime and overheadtime are unique per plan.

Please let me know how to achieve that.

Thanks
Saran

 

[IanWaterman]

In the summary type of Tests use a distinct count, and sum or the others.

Ian

 

[saran26]

Thanks

 

[lbass]

What have you tried so far? What problems did you run into?

-LB

 

[saran26]

Hi LB,

Thanks , as per Ian's advice I am able to get the desired results.

Thanks again
Saran