The chart is not printed OK

[thebigbadwolf]

I create a report using many Functions and many Running Total Fields. I want to create a Chart using some of this fields but some problems appeared

1. When I select a running total (count) "for each record" I am not taking the last value of the count appeared on report footer, but every counted value. (e.g jan_open, jan_close... etc)

2. I cannot select any functions as values in the chart

Any ideas?

 

[lbass]

Create a formula {@All} like this:

whilereadingrecords;
""

Insert a group (#1) on this formula. Then in the chart, use "on change of" and select {@All} as the field. This will allow the running totals to be added and you will get a chart based on the final running total values.

-LB

 

[thebigbadwolf]

Thank you very much!

Is there a way also to use the percent functions's values in another chart?

 

[lbass]

What is the problem you are facing with the percentages?

-LB

 

[thebigbadwolf]

I cannot select the percentages functions to show them as value in a second chart

 

[lbass]

Are you saying you cannot select the formulas that create the percentages?

Also, in what report section is the chart to be located?

-LB

 

[thebigbadwolf]

Exactly!

I need to have the chart in the last footer section after the second table and use the @.% functions

 

[lbass]

Without looking again at your report, I would say first that if you don't really need running totals, you should replace them with conditional formulas. If you are using counts or distinct counts, you would need to default values that return a null instead of zero (let me know).

If you want to continue with your current method, I think it will be tough, and that you will have to use a method called "Charting on Print-time Formulas":

http://www.sdn.sap.com/irj/boc/go/p...2a54ff4cd?QuickLink=index&overridelayout=true

-LB

 

[thebigbadwolf]

I have changed the running cost #jan_in_open which is doing a count of WO_CODE using to evaluate the following formula:
"isnull({VCR_WORK_ORDER.VWOWO_JOB_REQUEST}) and
month({VCR_WORK_ORDER.VWOWO_REPORT_DATE})=1"

with a formula named @jan_in_open:
"if isnull({VCR_WORK_ORDER.VWOWO_JOB_REQUEST}) and
month({VCR_WORK_ORDER.VWOWO_REPORT_DATE})=1 then count({VCR_WORK_ORDER.VWOWO_CODE})"

but it returns zero as result

What I am doing wrong?

 

[lbass]

No, what you need to do is change the formula to:

if isnull({VCR_WORK_ORDER.VWOWO_JOB_REQUEST}) and
month({VCR_WORK_ORDER.VWOWO_REPORT_DATE})=1 then
{VCR_WORK_ORDER.VWOWO_CODE} else
tonumber({@null})

...where {@null} is a new formula that you open and save without entering anything. You can then right click on this formula and insert a count in the body of the report or you can use it as a summary formula in a chart.

As a test, try adding two or three summaries to your chart using this formula template.

-LB

 

[thebigbadwolf]

Is working fine now, THANK YOU!!!