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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.