Manual XTAB formula not working 1

[cjbrown815]

Hello,
I'm creating a manual XTAB report. I have a column for the test name (SAMPLEPARAM.PA_NAME) and need the results to show in the body. So to get there I used this formula. It works some of the time and mostly not at all. Any idea how I can get this to work all the time? thanks, I've messed with the syntax and can't figure it out.

if{SAMPLEPARAM.PA_NAME}in ["Appearance"] then {SAMPLEPARAM.SRESULT}else ""

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

if isnull({SAMPLEPARAM.SRESULT}) or
{SAMPLEPARAM.PA_NAME} <> "Appearance" then
"" else
{SAMPLEPARAM.SRESULT}

-LB

 

[cjbrown815]

Thanks LB,
When I used your formula I didnt get anything, then I put the Appearance in [ ] and it returned a bunch of results but not filtereed to the test name Appearance.

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

How does the field actually display? Please show samples. Does the field contain additional words? Is it in propercase as shown in your example?

This is a formula to place in the detail section and then insert a summary on. The brackets should be irrelevant.

-LB

 

[cjbrown815]

Hey LB, sorry for the slow response.

I put the raw values in the details and then created a formula field in the group footer.

How can I summarize on the formula? With another formula field or with a running totals field? these are alphanumeric results not just numeric.

thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

Please respond to all items in my last post. We need to see samples of the two fields in the formula.

-LB

 

[cjbrown815]

({SAMPLEPARAM.SRESULT}) STRING
PASS
FAIL
.123
TNTC
0
>10
<100
TRADEMARK
NOT TRADEMARK

{SAMPLEPARAM.PA_NAME} STRING
Control
H2o
ASH
SPC-Ct
Appearance
Flavor
Y&M-Ct
Foodscan MFF
Foodscan FDB

Currently I have all results coming in correctly. I'm grouping on SAMPLEPARAM.PA_NAME, @Product Type which is just{SAMPLE.SAMPLE_TYPE} and @Quality Code which is just {SAMPLE.TEXT3}

I've done this because I'm just shooting at the stars trying to get this thing to work.

The report is not showing results in one row as desired. It's returning 10 results for each quality code, then the rest blank. As I scroll through the report I see another 10 results for another test and then the rest blank and so on. I think its a grouping issue, but the only way I can get results to show is by grouping with the SAMPLEPARAM.PA_NAME.

thanks



-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

I think you should formulas like this (assuming that neither field can be null):

if {SAMPLEPARAM.PA_NAME} = "Appearance" then
{SAMPLEPARAM.SRESULT}

This will return a result only for those detail rows that match the criteria. Then you have to insert summaries on the formula at the various group levels and suppress the detail section.

-LB

 

[cjbrown815]

Thank you, its working!!!!!! 6 flags

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931