Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ClareR

    Limit of dynamic parameter

    Hi all I am having this issue too when appending database values on creation of a parameter. The link does not seem to be working.... can you repost? pmgatwork - did you find a solution? Many thanks Clare Crystal XI
  2. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    Hi LB I was being a complete and utter noddy! I have worked out what I need to do now and it works perfectly. Thank you so much for your help! Clare
  3. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    Hiya LB Thanks for the above tip about creating a new formula - that has worked to enable me to add the if isnull part. Below is the formula in its entirety (sorry its so long!) It is erroring at the new if isnull part, but there does appear to be a "(" for every ")" whileprintingrecords...
  4. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    Hi LB I'm really struggling with this. I cannot find that the formula for the 'change group name' or 'display string' has any particular name eg {@formulaname} no matter where I look. It doesnt matter what i put in i keep getting 'the ) is missing' error. Do i need to change the drop down at...
  5. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    Hi LB Thanks for this. I have added but its being rejected saying 'the ) is missing'. The original formula is in the change group options 'use a formula as a group name' part of the report. So my formula looks like this (as you suggested) stringvar array x :=...
  6. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    Hi LB Its the code field that is null I think. using the examples from the formula above case '121' : "Construction" case '172' : "Confectionary" 121 is the code/fieldID and "Construction" is the description/translation of the code. However there are some records where there is no entry in...
  7. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    Hi LB Thanks for the above formula, its working brilliantly and I have used it in several areas :) What would I need add this into the formula to display "None" if the field {Company.comp_campaign} isnull? I have tried several things but none seem to work. Many thanks in anticipation for...
  8. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    Hi LB Thanks for this - it worked perfectly!! Further to the above, you mentioned about creating a table or lookup table, is this something straightforward to do in Crystal or do you have to be an expert user? Thanks again Clare
  9. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    The field displays as you have it ,9,172,121, C
  10. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    Hi LB A sample of my codes are (which include the commas): ,7, ,8, ,9, ,172, ,121, ,142, ,17, the corresponding descriptive values are: Coins Collectables Computing Confectionary Construction Consumer Cookware The field may include all, some or none of the codes. I need to display in the...
  11. ClareR

    Converting multiple codes to descriptions (Crystal XI)

    Hi all I need help with a (probably simple) formula that will convert a field code to display a description. The field holds codes like ,1, ; ,2, ; ,3, etc up to ,230, I need to translate the code to show a description, which is easy if the field equals a specific code. The problem I am...

Part and Inventory Search

Back
Top