Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

passing total to subreport

Ok. I keep running into road blocks THANKS FOR THIS FORUM!!!

here is the latest.

I am trying to pass this total to a subreport for evaluation in a chart.

have this formula in the year grouping on the main report.

whileprintingrecords;

numbervar escalation;

//2007 Deescalation

if {TPHASE.DF_DATE}= #1/31/2006 12:00AM# or

{TPHASE.DF_DATE}= #2/28/2007 12:00AM# or

{TPHASE.DF_DATE}= #3/31/2007 12:00AM# or

{TPHASE.DF_DATE}= #4/30/2007 12:00AM# or

{TPHASE.DF_DATE}= #5/31/2007 12:00AM# or

{TPHASE.DF_DATE}= #6/30/2007 12:00AM# or

{TPHASE.DF_DATE}= #7/31/2007 12:00AM# or

{TPHASE.DF_DATE}= #8/31/2007 12:00AM# or

{TPHASE.DF_DATE}= #9/30/2007 12:00AM# or

{TPHASE.DF_DATE}= #10/31/2007 12:00AM# or

{TPHASE.DF_DATE}= #11/30/2007 12:00AM# or

{TPHASE.DF_DATE}= #12/31/2007 12:00AM# then

escalation:=({#Active Projects}/1.035)

//2008 Deescalation

Else

If {TPHASE.DF_DATE}= #1/31/2008 12:00AM# or

{TPHASE.DF_DATE}= #2/28/2008 12:00AM# or

{TPHASE.DF_DATE}= #3/31/2008 12:00AM# or

{TPHASE.DF_DATE}= #4/30/2008 12:00AM# or

{TPHASE.DF_DATE}= #5/31/2008 12:00AM# or

{TPHASE.DF_DATE}= #6/30/2008 12:00AM# or

{TPHASE.DF_DATE}= #7/31/2008 12:00AM# or

{TPHASE.DF_DATE}= #8/31/2008 12:00AM# or

{TPHASE.DF_DATE}= #9/30/2008 12:00AM# or

{TPHASE.DF_DATE}= #10/31/2008 12:00AM# or

{TPHASE.DF_DATE}= #11/30/2008 12:00AM# or

{TPHASE.DF_DATE}= #12/31/2008 12:00AM# then

escalation:=({#Active Projects}/1.071)

//2009 Deescalation

else

If {TPHASE.DF_DATE}>= #1/31/2009 12:00AM# or

{TPHASE.DF_DATE}>= #2/28/2009 12:00AM# or

{TPHASE.DF_DATE}>= #3/31/2009 12:00AM# or

{TPHASE.DF_DATE}>= #4/30/2009 12:00AM# or

{TPHASE.DF_DATE}>= #5/31/2009 12:00AM# or

{TPHASE.DF_DATE}>= #6/30/2009 12:00AM# or

{TPHASE.DF_DATE}>= #7/31/2009 12:00AM# or

{TPHASE.DF_DATE}>= #8/31/2009 12:00AM# or

{TPHASE.DF_DATE}>= #9/30/2009 12:00AM# or

{TPHASE.DF_DATE}>= #10/31/2009 12:00AM# or

{TPHASE.DF_DATE}>= #11/30/2009 12:00AM# or

{TPHASE.DF_DATE}>= #12/31/2009 12:00AM# then

escalation:=({#Active Projects}/1.108)

else {#Active Projects};

In the subreport I have this in the formula to chart

whileprintingrecords;

tonumber ({?Pm-@ActProj})

I am not getting any totals in the sub report

does any one have any I deas to accomplish this?

Former Member
Former Member replied

Hi John,

I am assuming you would like to gather the values on the main report and then chart on all those values in the subreport.

If it's the case, I will suggest to read the following document:

[Charting on WhilePrintingRecords formula|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40e7130d-aa1e-2b10-ce9f-eee2a54ff4cd]

It contains a step by step instructions on how to chart whileprintingrecords formula.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question