cancel
Showing results for 
Search instead for 
Did you mean: 

reference range

Former Member
0 Kudos

I am currently designing reports for my lab. I am having trouble trying to get our reference ranges to display grouped together. Of course I can have the fileds display on their own, but then there are spacing issues. I have tried formulas and template fields. However, I keep getting the error message : the result of a formula can not be a range.

//Crystal Report Template Field

WhileReadingRecords;{SPEC_ANALYTES.LOWB} to {SPEC_ANALYTES.HIGHB}

How can I set this up so it will show our reference ranges properly? Any help is greatly appreciated.

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with your directly

Former Member
0 Kudos

Thanks, for responding. Now its gives me the error message " the remaining text does not appear to be part of the formula" and highlightes the second half.

Former Member
0 Kudos

it looks like your fields are text and not number.

Change your formula like this :

tonumber({SPEC_ANALYTES.LOWB}) to tonumber({SPEC_ANALYTES.HIGHB})

I hope this helps,

Regards,

Zack H.