Search results for query: *

Thanks again for getting back to me. :) after looking on all the tool bars i finally found it in report/change group export. I looked at all the toolbars, and it was no where to be found in Crystal Reports 8.5 :)

Thank you for responding, i do have a question: Where would I find Group Expert in CR 8.5 I have looked all over and can not seem to find it. If Group Expert is not in CR 8.5 how else would I be able to do this. I see Insert Group but no Group Expert.

Crystal Report 8.5.0.217 Is it possible to have 2 different groups for the detail line: I need to have a report with Top 10 Dollar amount for the customers we ship to (which I already have the Top 10 in place). Each customer has more than one part number shipped to them so I need to group the...

Thank You LB! :)

CR 8.5.0217 Report: Shipped Items Sorted by dollar amount highest to lowest(top N/sort) there is a Report Header, Page Header, Group Header/footer, detail line. The detail line is surpress, user does not need the details, what the user wants is company name and total dollar amount for...

The user wants the Order Number, Vendor ID and Original Quantity in the report for a matrix using the T (TO) transaction code. He is going to go another route to get that information. Thank you very much for your assistance in this issue, it is/was appreciated. Robin

When a part comes in, Receiving goes into the Transaction section of the application, Enters the order number and receives the part. After that, that part is not associated with the order number. When a user moves a part from one stock location to another, issue out a part, ship the part,do a...

the records for transfer are NOT related to the order numbers even though both Transfer codes and Order numbers are in the same db. No they are not paired with records that have an R code. and no there is not a field that links the original order to the transfer record. :) this does not look...

LB, Below is a link to a file where I copied and paste print screens and gave a description of what happened when I did the select statements and what is needed. The Transaction History DB allows the users to move parts from one Stock ID to another and assigns the transaction a code. The...

LB, sorry i did not get back to you sooner. other issues came up to put this on the back burner. I hope to get back to this by mid week. I will do as you suggested and look at the data in the detail level etc and will see what happens. thanks again

LB, I decided to start the report from scratch. I started with the Transaction History DB only, which had the most in the Detail line, added Date and Stock ID parameters and the Select Statements for the Date, Stock ID and Transaction Code. Everything worked fine so I added the Part Master...

Ok I removed the space and MS works, however I do not get any results when I have the NCMR as one of the selected. I went into Pervasive SQL and did a query like i did for MS and used NCMR and there were results. I checked and doubled checked to see if there was a space or anything what...

I was given the wrong information about what the Transaction Code was. T means To and is used in conjuntion with F which means From. So I won't be using the Transaction Code in my report in a select or parameter statements. With that information I am still having an issue with getting the...

Thank You. I am working on it right now. :) I will post back with my results. Robin

sorry i did not get back sooner. no rush on getting back to me today. I will be leaving soon and will return on Monday. This is what is in the Select Expert for the three select statements: {Transaction_History.TNXDTE_15} = {?Transaction Date} and {Transaction_History.TNXCDE_15} =...

DB's 3 - Order Master, Part Master, Transaction History Order Master\PRTNUM equal join to Part Master\PRTNUM Order Master\ORDNUM equal join to Transactin History\ORDNUM Select Expert: {Transaction_History.TNXCDE} = {?TRANACTIONCODE} Parameter field -- Tranactioncode Option: Discrete value...

Correction: ****To correct this problem (or try to correct this problem) I created a Parameter and set the Default Value to T (supposed to be TRANSFER not Transaction), ******

Crystal Reports 8.5 I created a report that pulls the following information using 3 DBs. Part Number, Description, order number, vendor ID, Transaction date, Original quantity, Transaction quantity, Unit of Measure, Stock ID, Transaction Code, Reference and User Define Reference. There is only...

Thank You LB. That solved the issue! I really appreciate your help. :) Robin

Thank you for your response LB. If I understand your question: The description formula is the description of the product that was purchase. @Description: stringVar XODE:= {Purchase_Order_Code.XODE_16}[1 to 2]; if XODE = "NI" then {MAX_Notes.NOTES_60}[1 to 50] else...