Recent content by leftfldr5

Bump....anyone please?

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

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.

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

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

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

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

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

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

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

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

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.

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

Awesome! I appreciate the help - it works great.

Does not happen if you enter 12 and 2005.