Search results for query: *

How to you incorporate and 'isnumeric' check into the formula? Or is this a separate formula? If it's not numeric I want to apply a number value to it for reporting/selection purposes. --- Made some progress using the formula below. IF {itmldg.ilgdno}= "PI3030" THEN 0 ELSE IF {@ISNUMERIC} =...

Trying to resolve a formula error with a field that include both Alpha and Numeric data. There are some system generated text that I can account for but there's also user entered text that can be just about anything. I need to convert the field to a number field using the tonumber command which...

Good point. I'll try that. Thanks again for your assistance.

I'll see if I can get the expression right. Tried using the example above but got a -201 error (syntax error). Below is what I used based on your sample. CASE WHEN itmldg . ilgdtyp = 'S' THEN (SELECT COUNT( itmldg . ilgiid ) FROM itmldg (**this is the table name and may be the cause of the...

The items will show once in each or once in one and not in another. Received error "An array's dimension must be an integer between 1 and 1000" when attempting to run the formula. I'll reduce the range the report is searching for testing purposes. Had a feeling that creating an array was...

Wow... Quite the detailed response. Thank you so much for taking the time to offer a solution. Question though, if the details are hidden how will the formulas affect the group results? I don't want to suppress any records I just want to highlight the records that are duplicates. The itm.typ...

Need to find a way to highlight the items in a report that are duplicates. It's OK that they are duplicates, because they fall into separate groups based on an item type. Database records for an item are assigned a P or S depending on the datatype (Purchases / Sales). See example below of...

Have a field in a group that I would like to sort descending. The field includes formulas (see below). Basically the field is looking for the gross profit per lb for the group #2. The report is grouped by salesman then by customer. It would be great to then have the values sorted descending so...

Well... since I'm evaluating the sales and costs for different time periods without using a sub-report I need to use a running total. The report layout is as follows. The values for each group are next to each other on the report. GF3 - RT (sum of sales current month) By Customer GF3 - RT (sum...

If I try to use the parameter as the formula in the running total I get an error: "the result of a formula cannot be an array" Perhaps the syntax is wrong, or it just can't be done? BV

Looking for a better way to handle updating my report. My report has 16 running totals. 4 in each, GF1, 2, 3, and report footer for current month and prior year month. I need to enter the same date in 8 of the RT's for the current month date and the same month date for the prior year in the...

LB, Thanks for the response. I'll give that a try. If I get repeating values that's often fixed by changing to a left or right outer join. Either way, it's the joins. Thanks, BV

Thanks LB. This looks like another solution you helped me with last year. I'm using this logic on a monthly report. It works although I'm still a little fuzzy on the logic. Not sure how to answer 'repeating values'. Each line on a report will be specific to an item, customer, class, etc...

I was just reading this post (http://www.tek-tips.com/faqs.cfm?fid=6524). Noticed that the author says to use Running Totals only if necessary. I use running totals in several of my reports because I need to see the sales for a current month/year vs a prior month/year. Is there another way I...

Appreciate the insight. Thanks! BV

Perfect... Thank You!

Hello... Have a weight field where the output is (example: 204.34) Want the output to be 20434. How do I remove the decimal? Would it be a formula in the format field>customize>decimal separator? Thanks, BV

LB, Worked like a charm! Your help is invaluable. Best, BV

LB, Correct, I'm using CR 2008. Forgot to include this in the first post. I'll give that a shot and let you know the results. Thanks again for your support. Best, BV

LB, No, not based on parameters. Record selection: {itmldg.ilgwid} = "10" and {itmldg.ilgdno} = "MF3050" and {itmldg.ilgdat} in Date (2007, 10, 01) to Date (2008, 09, 30) and {itmldg.ilgnam} startswith "REC" Thanks again for the help! BV