How to report on test case categories
I have 4 test case categories that I would like to include in a list report. I want the category name or TERM to be the columns and the values to appear in the row. I have been trying to use expressions to limit what is displayed in each column. For example, I have a category called function that I have created a column for. I then use the expression editor to do the following (pseudo code below):
IF ( = 'function') THEN (category value) ELSE (' ')
I get 4 rows with one having the function value (because I have 4 categories). I want only 1 row. I believe it is the ELSE that is causing the problem but I can not make an IF work without an ELSE.
Anyone have an idea how to do this - I have tried a lot of different things with no success.
Thanks in advance
IF ( = 'function') THEN (category value) ELSE (' ')
I get 4 rows with one having the function value (because I have 4 categories). I want only 1 row. I believe it is the ELSE that is causing the problem but I can not make an IF work without an ELSE.
Anyone have an idea how to do this - I have tried a lot of different things with no success.
Thanks in advance
4 answers
I have 4 test case categories that I would like to include in a list report. I want the category name or TERM to be the columns and the values to appear in the row. I have been trying to use expressions to limit what is displayed in each column. For example, I have a category called function that I have created a column for. I then use the expression editor to do the following (pseudo code below):
IF ( = 'function') THEN (category value) ELSE (' ')
I get 4 rows with one having the function value (because I have 4 categories). I want only 1 row. I believe it is the ELSE that is causing the problem but I can not make an IF work without an ELSE.
Anyone have an idea how to do this - I have tried a lot of different things with no success.
Thanks in advance
Use a query filter to filter out all rows except for the one who has a value of 'function'. Do you know how to create a query filter?
That doesn't work either - I think a picture will explain better what I
want. In the atttachment you will see a portion of the data I am trying
to build a report around - notice that each TER id is repeated 4 times
because of the blanks in Complexity, TestType, Category and Function.
What I want to achieve is a single row with the values of Complexity,
TestType, Category and Function in that row with no additional blank rows.
On 7/19/11 7:38 AM, petroula wrote:
want. In the atttachment you will see a portion of the data I am trying
to build a report around - notice that each TER id is repeated 4 times
because of the blanks in Complexity, TestType, Category and Function.
What I want to achieve is a single row with the values of Complexity,
TestType, Category and Function in that row with no additional blank rows.
On 7/19/11 7:38 AM, petroula wrote:
dmehaffywrote:
I have 4 test case categories that I would like to include in a list
report. I want the category name or TERM to be the columns and the
values to appear in the row. I have been trying to use expressions
to limit what is displayed in each column. For example, I have a
category called function that I have created a column for. I then
use the expression editor to do the following (pseudo code below):
IF ( = 'function') THEN (category value) ELSE (' ')
I get 4 rows with one having the function value (because I have 4
categories). I want only 1 row. I believe it is the ELSE that is
causing the problem but I can not make an IF work without an ELSE.
Anyone have an idea how to do this - I have tried a lot of different
things with no success.
Thanks in advance
Use a query filter to filter out all rows except for the one who has a
value of 'function'. Do you know how to create a query filter?
try to use case statement
case()
when ('AE') then ('TestType, Category,')
when ('BG') then ('Category')
when ...
end
and fill out the duplicate record
case()
when ('AE') then ('TestType, Category,')
when ('BG') then ('Category')
when ...
end
and fill out the duplicate record
That doesn't work either - I think a picture will explain better what I
want. In the atttachment you will see a portion of the data I am trying
to build a report around - notice that each TER id is repeated 4 times
because of the blanks in Complexity, TestType, Category and Function.
What I want to achieve is a single row with the values of Complexity,
TestType, Category and Function in that row with no additional blank rows.
On 7/19/11 7:38 AM, petroula wrote:
dmehaffywrote:
I have 4 test case categories that I would like to include in a list
report. I want the category name or TERM to be the columns and the
values to appear in the row. I have been trying to use expressions
to limit what is displayed in each column. For example, I have a
category called function that I have created a column for. I then
use the expression editor to do the following (pseudo code below):
IF ( = 'function') THEN (category value) ELSE (' ')
I get 4 rows with one having the function value (because I have 4
categories). I want only 1 row. I believe it is the ELSE that is
causing the problem but I can not make an IF work without an ELSE.
Anyone have an idea how to do this - I have tried a lot of different
things with no success.
Thanks in advance
Use a query filter to filter out all rows except for the one who has a
value of 'function'. Do you know how to create a query filter?