Search results for query: *

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...

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;]...

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...

If i have 2 formula fields where both show calculated date result. Then i need to show month differences between them what can i use to accomplish this. Per say formula 1 results in date 12/01/02 formula 2 results in date 12/01/03 then we have 12 months betwween these 2. I like to know how i...

When Windows 98 or Windows ME computers try to connect using the microsoft VPN that we built, they get the following error. We have clients also download the dial-up networking v1.4. This connection requires security features that are not available on this platform. For information, contact...

Worked great, thanks...

Using CR 8.5 With a help from this forum using below code has helped me to be able to add a starting date to a duration of time such as 1 year, 3 year or 5 year periods at a time to show a monthly value in cells that shows each month of the year. dateAdd(&quot;yyyy&quot...

Thank you...

Well I was way off on my thinking, now i see clearly what you mean. I was making it alot harder then it was. Thnak you so very much...

END IF; IF type_set = 0 THEN IF this_proj.l2_proj_seg_id LIKE '95%%%' THEN this_proj_type := 'B' || '&' || 'P'; type_set := 1; END IF; END IF; IF type_set = 0...

Hi everyone, I am a junior oracle dba and we are bring in our remote site Colorado into our environment in VA. They no longer have their own databases, they remotely connect to us. But also they are using another program for timesheets that is called unanet and this program has its own oracle db...

Thnaks but i can not hard code award dates, i wish i could. There is a different date for each project, so it changes... else if {@Marchmonth} <-- i need to be able to set this formula to point out the correct date of say the cell that points to month march of 2003 in [...

Seems like @dur = dateAdd(&quot;yyyy&quot;, ({BID_SUBJ.DURATION}), ({BID_SUBJ.AWARD_EXP_DATE} )) is doing the trick BUT say i used this in conjunction with my formula Local NumberVar x; if {BID_SUBJ.AWARD_EXP_DATE} in [Date (2003, 02, 01) to Date (2003, 02, 28)] then x :=...

It is version 8.5. on the report i do not show exp date but yes i do store it on a suppressed report footer duration is there as well. How can i set up a formula with start and end dates based on duration when duration depends on *12 to count the months and award date changes for each project?

I am trying to enter a monthly amonth in each month up to 60 months (5years) depending on award dates which also depends on duration (1, 2, 3, 4, 5 years) Local NumberVar x; if {BID_SUBJ.AWARD_EXP_DATE} in [Date (2003, 02, 01) to Date (2003, 02, 28)] then x := {@MonthlyRev}...

Here is the formula i created for each cell up to number 61. This formula also shows in the first table as the monthly amounths. Local NumberVar x; if {BID_SUBJ.AWARD_EXP_DATE} in [Date (2002, 07, 01) to Date (2002, 07, 31)] then x := {@MonthlyRev} This as you know only lists...

Here is what i am trying to accomplish Marketing and Sales Revenue Forecast Pipeline Date Report SBU J2 F2 M2 A2 M2 J2 J2 A2 S2 O2 N2 D2 02T 02Q1 02Q2 02Q3 1 2 3 4 5 6 7 8 9 10 11 12 Sum(1-12) Sum(1-3)...

I am having trouble getting the stacked bar chart to lay data in correct order. When i run this report with last years date it works perfectly and I have Won and Lost projects lined up on a stacked chart by color (Won-Green, Lost-Red).With last years dates, Won was in the bottom of the stack...

I am using 8.5, The percent field on a pie chart comes from devision of 2 fields. I have no problems getting the percent. Now i need to do the same thing on a pie chart but this time the formula counts the projects. I can get chart to show the oppurtunities as a count and i can show the total...

I am running 8.0 version and i have a histagram and a pie chart. I set the values as $1 and on the chart i can see the data as $ amonths. Then i save the report and reopen it, the report sets it self to 1M for the values. I open the chart expert and see i amset for the $1 and i close the chart...