Search results for query: *

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

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

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...

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...

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 :=...

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...

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...

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

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

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...

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...