Search results for query: *

I have a report that gives me Customer Number, Name, Credit Limit, Sales Rep, Current Year Sales, Current Year High Balance, and then sales and high balance for last year. The problem is, my high balance that I currently have is the largest invoice amount. I need to work this query --- start...

Thanks! Jason

Yes, running total. The first part works great, thanks a ton. Jason

something along the lines of Trx Date Trx Amt Current Balance Highest Balance 8/24/2008 10000 10000 10000 8/26/2008 -10000 0 10000 2/1/2009 4000 4000 4000 3/1/2009 100 4100 4100 3/24/2009 -1000 3100 4100 4/2/2009 200 3300 4100 5/3/2009 300 3600...

I have a query that pulls transaction date and amount per customer. I would like to add to my select statement a method to calculate Current Balance owed by the customer and the Highest Balance Owed over his history with us. Thanks in advance! Jason select transdate,amountmst from custtrans...

Thanks for the sanity check. Jason

I have a portion of a select formula {AAcsbycpi.glpostdt} >= Date(Year(Maximum({?Date Range}))-1,1,1) that gives me everything from the current and previous year in my report. I received word that February data for this year and last are off. I presume this is a leap year issue? Thanks Jason

Ah, I think this is it. Thanks guys! Jason

select itemnmbr,locncode from mail..iv00102 t1 where exists( select itemnmbr from mail..iv00102 t2 where locncode <> 'M' and locncode <> '' and t1.itemnmbr = t2.itemnmbr group by itemnmbr having count(*) > 1 ) order by t1.itemnmbr returns 248 rows, below is a sample: CFFPLN32...

starting with 26,000+ records, your query brings me down to 62. How can I also display the locncode field? BTW, thanks for the code. Jason

I have a database with products and location codes. fields: itemnmbr,locncode Every item should have a locncode M. We want to find out which items do not have M but have any other locncode. We also need to ignore items that have a blank locncode field. The database has a record for each...

nevermind, I figured out how to rename the share/target in the migration tool. I did have a problem with renaming nested shares though. JS

I am using the Fileserver Migration Toolkit to move shared directories from one fileserver to the next. I elected not to use DFS as I prefer my new file server to be simple (sans extra services). The toolkit copies the shares and permissions with ease, but appends the old fileserver name to...

in version 8.x, I have a report that pulls data from two date ranges (this year and last). The problem is, there is no data in my database for days where there is no data entered by a user. How do I display in my report a date from the range that does not have data with a Zero in place of the...

I have a report that pulls data from both a date period in the current year and the same period last year. I would like the report to display by day with the current date range ascending on the left with last year's data on the right. Currently, my report is What programming magic do I have...

I changed the -365 to -366 and the date yield is correct. Thanks for the push. JS

I have a date range formula IF {V_Sales_History_w_Ecomm_Attributes.glpostdt} = {?Date Range} THEN {@Shortened GL Date} And I would like to create a second formula that leverages a condition of {?Date Range} minus one year. My report pulls two sets of dates; a date range from this year and a...

Thanks LB, that did the trick! JS

Ian - yours is the approach I took. I have a feeling that my goal of only bringing in data from the two date ranges (start to end this year & start to end last year) is not going to become a reality. JS

no joy. When I remove the group selection formula I still only get one day.