Search results for query: *

Thank you Ken, Tried it but it did not work. I cannot setup a Running total on a Running total. This is the error -You cannot select this field as the field to summarize/reset/evaluate- Here is suppressing formula: if {@A-T-P}<=0 then true else false Thank you -M

I have a report where a group is suppressed bases on the running total. This works fine. What I am having a problem with is that I also need an additional running Total Field at the end of the report where it will total all running totals from the unsuppressed groups. group not displayed pn...

Thank you for you help MeanGreen. I just realized that when something is wrong it always means that you overlooked something. In my case I realized after countless hours trying to find the problem, the problem was with the OEH table, it had two records with the same information. Oh well, next...

When I remove the DISTINCT clause from the statement the output is as follow. -----OUTPUT 07 200.0000 476.26 I believe that it should read 07 100.0000 238.13 Thank you, Mauro

When I execute the following statement SELECT DISTINCT OEL.item_no, OEL.qty_to_ship AS 'Total quantity Sold', OEL.sls_amt FROM OEL INNER JOIN OEH ON OEL.ord_no = OEH.ord_no AND OEL.ord_type = OEH.ord_type WHERE OEH.cus_no = '000000000027' AND OEL.loc = 'SALES' ORDER BY OEL.item_no...

I would like to know how I could write the following stored procedure step 1 read the data from database1 step 2 add the results from step 1 to database2. Note that fields in database1 are not necessary the same name as the fields in database2. step 3 write into a field from step 1 results...