Search results for query: *

Hi there, Need more information...? Is this a new installation, has the error just occuring..? etc etc... GreatPains

1 other thing to check in crystal is that you uncheck "Save Data With Report" on the file menu. If this is Checked then the report will not ask for parameters, and will always return the same data. As far as Stored Procs go, it's probabily not worth it, Views are quite good if you don't want...

I'm not sure what you are trying to do.. but I use this to check if PO's are received or outstanding.... select CASE WHEN R.POPRCTNM IS NULL THEN 'NOT RECEIVED' ELSE 'RECEIVED' END as RECEIVED, PO.POLNESTA, PO.PONUMBER, H.USER2ENT, H.DOCDATE, H.VENDORID, H.VENDNAME, R.Status, R.ITEMNMBR...

Have you enclosed the batch in single quotes... Query.AdditionalCriteria = "Batch='" & dBatch & "' " An expert is one who knows more and more about less and less until eventually he knows absolutely everything about nothing.

Have you made a DexSQL.Log to see what SQL is being executed. It seems to be a simple update statement... An expert is one who knows more and more about less and less until eventually he knows absolutely everything about nothing.

You can kinda fudge the tables together... SQL Server version... Create the report in GP and make a DEXSQL.LOG of the transactions. You can the edit the DEXSQL.LOG and turn the temp tables into real tables ( by removing the ## in front of the table name ). Then remove the 'DROP TABLE ##xxxxx'...

RM20101 is the Receivables Open File RM00101 is the Customer Master File They link on Customer Number Goto Tools / Resource Descriptions / Tables This will the list all the table groups in each of the series within the application.

OK, I've written a similar report for us, the SQL Being.. SELECT RM20101.CUSTNMBR, RM20101.DOCNUMBR, RM20101.RMDTYPAL, RM20101.DOCDATE, RM20101.ORTRXAMT, RM20101.CURTRXAM, RM00101.CUSTNAME, RM00101.SALSTERR, RM00101.SLPRSNID FROM ANA.dbo.RM20101 RM20101 INNER JOIN ANA.dbo.RM00101 RM00101 ON...

Hi all, A User was doing a PA Purch Inv Entry, and was Matching an Equipment and freight line when their Machine crashed. Now, although the transaction was not posted, when they go in to re-enter the transaction the Equipment Item is no longer available for selection from the PO. Does anybody...