Skip to Content
avatar image
Former Member

Having Issues with Function Output

I need to track and accumulate the costs for different "PROJECTS", and print them out on the report in the detail section.  The "PROJECTS" names are in a string variable delimited by a semi-colon, coming from a database table.  Because of this, I cannot use any of the built-in CRYSTAL grouping or summary functions.

I use a CRYSTAL Forumula "TheProjectsAndCostsAvg" to pass all the cost variables and project-name string variable to a function, where I split out all the data to get the various Project name(s) and cost(s)

I build string variables for each "Project" name and their costs and pass them back to the report to print out in the detail section.

I am having 2 problems.  I print out the string from the function next to the "XXX" in the Detail Section.  If you look at the output file, you will note that there is a "2.00" that prints out at the begining and end of the string.  I cannot for the life of me figure out where this value is coming from.  I tried adding "BeforeReadingRecords;" at the begining of the formula, that did not make a difference.

Also enclosed is a copy of the Formula "TheProjectsAndCostsAvg", and Function "ThePerProjectCost".  What the output looks like, and what the Desgn mode looks like.

I'm pulling my hair out.  Thank you


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 09, 2014 at 07:47 PM

    Hi Vince,

    Get rid of the text 'crDoubleLine' from each of your variables:

    Example: strScopeTitle = crDoubleLine & "THE COST FOR THE SCOPE PROJECT: " & curScopeCost & crDoubleLine

    Should just be:

    strScopeTitle = "THE COST FOR THE SCOPE PROJECT: " & curScopeCost


    Add comment
    10|10000 characters needed characters exceeded