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 derfloh 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: *

  1. leftfldr5

    Table join on formula field?

    Bump....anyone please?
  2. leftfldr5

    Table join on formula field?

    Yes SQL Server. The item lengths vary, but is always the last two characters I want to change. EX. XXXX+C to XXXX+O or ZZ+C to ZZ+O
  3. leftfldr5

    Table join on formula field?

    This is the add command I am trying: replace({IV00101.ITEMNMBR}, '+C', '+O') but I receive the error: Failed to open a rowset: Syntax error or access violation. I thought I could then link by this to the IV30101. The IV00101 and IV30101 are two different tables within the same database.
  4. leftfldr5

    Table join on formula field?

    Crystal 10, SQL database. Need to link Item Master(IV00101) to Item Master Summary (IV30101) by a formula. Desired results: Item Number Item Number (summary) QTY Last Year Sales 111+C 111+O 2 0 222+C 222+O 5 2500 I need...
  5. leftfldr5

    Sales Report not showing $0 sales

    I just have the Item Master table (IV00101) as my leftmost table. I then have my sales line table (SOP30300) linked by item number with a left outer join. My sales header table is linked to sales line table. The report is only showing item numbers that exist in both the IV00101 and SOP30300...
  6. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    Problem solved! I moved the formula for group supression: sum({@Difference},{table.custID}) < {?SalesIncr} to the group select expert and changed the logic so now my running totals will work correctly since I am limiting the data upfront instead of suppressing it. Thanks for all the help -...
  7. leftfldr5

    Sales Report not showing $0 sales

    I am having the exact same problem with the exact same scenario. Did you find a solution to your problem?
  8. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    @accum for the GF2 for all these records is 0.00 but the selected year and prev year formulas have a total in the GF1. GH1 END CUSTOMER 0.00 (reset) cust sel yr prev diff GF2 10180 5770 0 5770 12045 6528 735 5794 12559 6204 0 6204...
  9. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    Parameters : Month-2, Year-2006, Increase-5000 Only showing non suppressed records All formulas are using currencyvar and same variable names @accum whileprintingrecords; currencyvar selyr; currencyvar prevyr; if sum({@difference},{RM00101.CUSTNMBR}) >= {?Sales Increase or (Decrease)} then (...
  10. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    No problem. I am still struggling with this and have tried a million combinations. The reset is still working but the @accum does not accumulate right. GH1 - EQUIPMENTDEALER 0.00 (GH reset) @accum cust name sel yr prev yr diff $0.00 10337 AVIA SOURCE IN...
  11. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    Ok the reset seems to be working fine and resetting to 0.00 at change of Class ID. However, I could not get @accum to give me correct numbers either in CustID group header or footer. I get closer if I use: whileprintingrecords; currencyvar selyr := Sum ({@Selected Period/Year}...
  12. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    From your first response you had me do a suppress formula on the group footer that is: sum({@Difference},{table.custID}) < {?SalesIncr} to suppress the records that do not meet the increase parameter. It works perfectly, but I do need group totals for the formula fields.
  13. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    I have this report grouped by Class ID then Customer ID. Is there any way to get group(Class ID) totals for {@Previous Period/Year} and {@Selected Period/Year}formulas since I am suppressing records in the Cust ID group? I have tried a running total, but still get totals including the...
  14. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    Awesome! I appreciate the help - it works great.
  15. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    Does not happen if you enter 12 and 2005.
  16. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    HISTYPE 0 being calendar year (HISTYPE 1 is fiscal year so it would duplicate) {RM00104.HISTTYPE} = 0 and ( {RM00104.PERIODID} <= {?Month} and {RM00104.YEAR1} in {?Year}-1 to {?Year} ) or ( {RM00104.PERIODID} > {?Month} and {RM00104.YEAR1} in {?Year} - 2 to {?Year} - 1 )
  17. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    Thanks for the help - REAL CLOSE! Here is a sample of the months/years I get if the I enter Year = 2005 and Month = 10 **Everything looks good except notice that I get 12 of 2004 twice which doubles the sales for that period/year. 1 2,004 2 2,004 3 2,004 4 2,004 5 2,004 6 2,004 7...
  18. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    Bump.....Anyone??? I could really use some help on this one.
  19. leftfldr5

    Rolling 12 month period sales over previous 12 month period sales

    I need to create a report where customer sales increased x$ for this 12 month period over the last 12 month period. Parameters are period, year, and increase. If the user enters parameters of 12, 2005, and 5000.00 then they can see the customers whose sales for period 1 - 12 of 2005 increased...
  20. leftfldr5

    Group sort on formula field

    I am gathering quantity records in the detail section and then have a summary by item number in the group footer. I then taken that sum quantity and muliple it by a static cost number to get extended cost, which makes extended cost this formula: ( {IV00101.STNDCOST} * Sum ({SVC06101.QTYSOLD}...

Part and Inventory Search

Back
Top