Skip to Content
author's profile photo Former Member
Former Member

reference range

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2009 at 03:14 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2009 at 04:52 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 02, 2009 at 06:09 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.