TONUMBER SPLIT STRING

[JasonDecHer]

I am trying to create a graph on whileprinting records formula. I have a string called DayYieldStrngVal which puts a shared whileprintingrecord calculation into a string and the string looks like: ^.89^.90^.83^.92^ I am trying to use a split statement to seperated this string in a sub report. The sub report is linked to the main report with this formula. I am placing the split statement in the detailed section of the sub report.
can someone help me with the syntax?
This isnt working.

tonumber(split({?Pm-@DayYieldStrngVal}, "^")(recordnumber+1))

Does anyone has any sample reports of how to create a graph on whileprintingrecords formulas?

thank you very much,
jason

 

[synapsevampire]

I think that you'll have to make formulas.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

Sorry, hadn't finished.

I think that you'll need to make formulas out of EACH array element.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

You can't graph on a WhilePrintingRecords formula, unless you can pass the values to a subrpeort via links (not variables) and graph in the subreport. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[JasonDecHer]

Ken
Can you provide an example? When I tried that It only displayed the last value that formula calculated in the subreport graph. I need the graph to display the each value(yield) for each group(date).

K
I am trying to make a line graph, when I did this i got each element on its own line. Can you tell me how to get the different elements to display on one line? It is not finding a corispondence between the date and value.
Thanks guys

 

[kenhamady]

I have never tried this, so I don't have an example. I can't even guarantee that it will work. But, that is the only way I can think of to get a 'whileprinting' value to a place where it is available before the point in the report where charts are created.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[JasonDecHer]

ok thanks Ken