Formula and select criteria

[afelya]

I have a report that i need to add certain totals if certain needs met. Such as while all SBU's are selected in the main report i need to display a total for one SBU like SBU to be in Eng-SED but here is my problem (for this special total there are other criteria as well not just the SBU).

This formula works great if i put it in a sub report or i can get the sub report to work without the formula by just using select criteria. However once i enter this in the actual report then the sub report shows the total under each SBU (report is grouped by SBU)such as for Eng-SED total 4.000.000 will also show 4.000.000 under another SBU. I need this total to show 0 under another SBU

Then i tryed to create a formula for each different total. The formula is correct but when i enter it in the report results come out wrong. I am thinking because the report is set on selection ceriteria not same as the formula and picks all SBU's and other criterias. The formula displays correct result if i enter it in a subreport which dont work for me and displays wrong results in the main report. I am assuming since the seelect criteria from the report is effecting the formula.

Is there a way to overcome this issue?

 

[Ngolem]

you are going to have to give a lot more information in detail about your database and selection criteria. I have no idea what a "SBU" is. Show us the tables with sample data and what you wish as an output from that data. You mention several other selction criteria...show us what they are...your post is too vague to comment on as it is. Jim Broadbent

 

[afelya]

Ok...

The SBU is strategic bussiness unit.
On the report the criteria is set to

(
IsNull({BID_SUBJ.RFP_EXP_DATE} ) OR
{BID_SUBJ.RFP_EXP_DATE} <= currentdate + 450
) and
{STATUS.DESCRIPTION} in [&quot;Phase1 -Qualified&quot;, &quot;Phase2 -TechClose&quot;, &quot;Phase3 -Positioning&quot;] and
not ({BID_SUBJ.LEAD_TYPE} in [&quot;AccountPlan&quot;, &quot;FundingExstngContrct&quot;])

on the formula i am trying to accomplish this:
IF
(({BID_SUBJ.LEAD_TYPE} <>[&quot;AccountPlan&quot;, &quot;FundingExstngContrct&quot;]) and
(
IsNull({BID_SUBJ.RFP_EXP_DATE} ) OR
{BID_SUBJ.RFP_EXP_DATE} in [Date (2002, 01, 01) to Date (2002, 12, 31)]
) and
{STATUS.DESCRIPTION} in [&quot;Phase1 -Qualified&quot;, &quot;Phase2 -TechClose&quot;, &quot;Phase3 -Positioning&quot;] and
{BID_SUBJ.STRATEGIC_TARGET} = &quot;SBUApvd&quot; and
{BID_SUBJ.SBU} = &quot;Eng-SED&quot
THEN
SUM ({BID_SUBJ.EST_NET_REVENUE_AMT})

There are currently 9 different SBU(bussiness units)
and i need to be able to have a est net rev totals. One of them I pasted above the second set of code.

So my formula should be able to pick only 2002 dates not like the actual report which picks dates up to 15 months ahead. Then i should be able to set the SBU to be a specific one, which is Eng-SED in this case, where the report selects all the SBU's. The strategic target is same so no problems there. With what i have the formula does not give the correct totals. Unless i put the formula in a sub report. I hope i am clearer now. How can i set this formula in the actgual report and get results where the formula can ignore the reports select criteria?

 

[dgillz]

So you need subtotals by SBU? Without posting more code is that the issue? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[turkiye]

I need the subtotals per SBU in the manner which the formula has stated.

 

[dgillz]

Silly question, but have you tried to simply insert a summary by SBU? If so why does that not work? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[turkiye]

There are 20 different totals with different criterias i need to add under each group which is sectioned by SBU's.

If i do this and add the summary fields to a subreport then dandy. But then i see the results from each totals under each sbu group since i insert the subreport in the group footer. Where other totals would have to show 0 value while only one total would have the value since the criteria picks different sbu's for different totals. It is just not easy to explain. I will gladly send out the report if anyone want to look at it.

 

[afelya]

No one mentioned about linking. I was able to link the sub report by SBU and it made the sub report to work correctly.

I am still new to most of crystals functuality and am learning as i go. Thnaks for all the help...