Sunday 15 January 2012

crystal reports : substring error -


I have developed a workaround because crystal reports do not have a substring function with the following formula:

P> What am I trying to do , Searches for the duration (".") In a string, and changes it with a comma. Then get the status of the comma in the Stram and print all the letters after the comma. Only 1 period in the string will be in the entire string.

Now when I try to do this, I get some weird letters that look like wings. any idea?

Thanks in advance

I do not know the whole issue that you have to complete Trying, but only for this question, the steps to replace the period with a comma seem unnecessary. If you know that there is only one string in it and you only want the characters of that period, then you should be able to do something (this is @first_formula):

  right ({_ V_hardware.groupname}, len ({_v_hardware.groupname}) - instr ({_ v_hardware.groupname}, "."))  

If for some reason you show comma So if I want to separate the formula. If you need a full screen coma space then just do this:

Change
  ({_ v_hardware.groupname}, ".", ",")  

And if you need a comma then it may be easy to do something like this:

  "," + {@first_formula} " > 

Hope it helps.


No comments:

Post a Comment