Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mtrang81
  • Order by date
  1. mtrang81

    Problem with Outer Join

    Hi, I'm having a similar problem and tried to follow the selection formulas outlined but unsuccessfully. My main table is "People Count History" which is FULL-OUTER joined to "People Count Current YTD". I have two parameters, one is based on the field {People_Count_History.Ops Center} and the...
  2. mtrang81

    Graphing a formula field

    Thanks lbass for the info! I followed the instructions and everything works perfectly now. Thanks again! ~Trang
  3. mtrang81

    Graphing a formula field

    Here's the 2004 Projections formula (which references other formulas): 2004 Projections: IF IsNull({Ten_Year_Projections.2004}) THEN {@MR}*{@YE Proj} ELSE {Ten_Year_Projections.2004} @MR: {Ten_Year_Projections.10-Yr Total}/Sum({Ten_Year_Projections.10-Yr Total}...
  4. mtrang81

    Graphing a formula field

    Hello all, I have a production report that requires a line graph to follow to show seasonality. My report has fields such as 2003, 2004, 10-Yr Avg, and 2004 Projection (which is a formula). I need to create a line graph showing 2004, 10-Yr Avg & 2004 Projection. The problem is that the 2004...
  5. mtrang81

    Formula referencing itself

    Hello all, I'm converting an EXCEL projections report into Crystal 9.0. My report has these fields for 12 records (for the 12 months): 2004 Actual, Monthly Relativity (which is 10-yr monthly total/total for previous 10 years), YTD 2004 Actual and 2004 Monthly Projection, etc. Most of these...

Part and Inventory Search

Back
Top