Search results for query: *

Qty needs to be accumulated, once the Accumulated Qty hits a minus number, thats what I need to know. The records are ordered by reqdate, when the accumulated qty goes negative I need the reqdate of the item that goes negative, this tells me the date the item is shceduled to go negative. I...

I have data from a manufacturing system and each row represents a transaction. I need to know when an item is scheduled to go negative and the next scheduled replenishment date and amount after that. Sample data. Data is not stored in order, will need top be sorted by itemid,reqdate...

I have various sales and orders queries that I must now link to a currency table to convert to USD. The currency table looks like this: currency fromdate rate USD 1900-01-01 78.44 USD 2006-08-31 77.839 USD 2006-09-30 79.001 USD 2006-10-30...

Couldn't figure out how to edit the original post, but the last column of the subreport should read 3 not 2 for the qtyonhand. Thanks ...

I need to modify my inventory valuation report to show the newest and oldest date an item has been in inventory. I've added a subreport that selects all receipts for each item. I've passed the qtyonhand to the subreport for comparison. I've ordered the subreport by transaction date descending...

This seems to have taken care of it: EXEC sp_addlinkedsrvlogin 'pcisv002', 'false', @rmtuser = 'report', @rmtpassword ='report'

I figured out to do this for one user. If I run this command I can get it to work for jsmith: EXEC sp_addlinkedsrvlogin 'pcisv002', 'false', 'domain\jsmith, 'report', 'report' What would be the same command but that would work for all users? I don't want to have to run this for every current...

Thanks for the response Frederico. I'm not sure that's the issue though. If I remove the part of the query that accesses the linked server (it is a union query with the second part hitting the linked server) the users can run the report successfully. They just don't get any data from the...

I created a query that links 2 servers (used sp_addlinkedserver). I used this query for a Crystal report. Works fine if I run the report. I assume because I have admin rights. My users get a 4064 (failed to retrieve data) error code when running the report however. Any ideas on how to get...

We have a 2008 ru2 Terminal server that serves two user bases, one in China and the other in India. The Chinese have a application for reporting taxes that needs to have the system locale (control panel/region and language/administrative/language for non unicode programs) set to Chinese...

We are increasing our prices by 4% (price*1.04) and I need to write a query to show the sales dept. what the new prices would look like and I need a little help with the syntax to calculate the new rounded prices. We would like to round these new prices based on the table below: Price...

Thanks Gruuuu, your formula worked perfectly. Skip, thanks for the info on the TGML tags, I'll check them out for the next time.

I need help creating a formula that will add column B to the sum of D where column A = column C. Column C can have multiple entries for column A so a sum is needed in the vlookup. There might not be anything in C for every A. C and D would be used as the table array A B C...

Thanks Markros and GM, all are good suggestions. I used Markros statement since it worked perfectly for me. Thanks ....

I have a field whose data looks like this: 003391 003391-01 003391-01-01 002498-02-01 004895-02 004895-02-01 005523-01 I would like to have a query that returns "Warranty" for lines 3,4 and 6 and nothing for the others. Warranty items end in "-01" but only after the second dash. So lines 2...

Thanks lbass, that worked for me.

I have created a crosstab report that shows each item and the quantity of that item in each warehouse along with the total of all warehouses. whse1 whse2 whse3 total item1 1 2 6 9 item2 0 3 2 5 I would like to add the item's description as a...

Thanks crystalreporting, that worked perfectly.

MS SQL

I need to update the data.