Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sage 300 Crystal Report DLL/ODBC

Status
Not open for further replies.

ravazz

MIS
Dec 8, 2009
112
JM
We are trying to modify the PO Form by adding Terms Desc (Table:APRTA).

However whenever we add a table to the existing report(DLL) we encounter a user login prompt before being able to preview report from within Sage.

How can we get the report to print directly after adding Table to report.
 
Start with POPOR04, not POPOR01, then comment out the datapipe lines for that report in PORPT.INI.

Sage 300 Whisperer
 
Not sure i am going at this right

So first we started with POPOR01, this is where we have done all modifications.

Now when i comment out the datapipe line from for POPOR01 none of the reports work.

I even used POPOR04 and we get a user login prompt before being able to see report.

Any other suggestion

 
You need to start over with POPOR04. And your database connection has to be ODBC(RDO) using a SQL login, not Windows login.

Sage 300 Whisperer
 
Okay no problem

I modified POPOR04 and encountered fail to retrived data from table error.


This is what i did in the PORPT.ini file


'************** Object id = PO3020 ******************
' ----- Print Purchase Order Form
[POPOR04]
type=DATAPIPE
heading=50550
crystal=MEL-POPOR04
orientation=portrait
paper size=1
optparams=13
2=PORFROM STRING 50554
3=PORTO STRING 50555
4=PRINTED STRING 50556
5=QTYDEC STRING 50557
6=ACTIVE STRING 50558
7=STANDING STRING 50559
8=FUTURE STRING 50560
9=BLANKET STRING 50561
10=DPRINTED STRING 50562
11=DELMETHOD STRING 50563
12=ECENABLED STRING 50564
13=DIRECTEC STRING 50565
14=SWDELMETHOD STRING 50566
'datapipe path=..'datapipe query="popoprn.dll=POPOR01\n%PORFROM%\n%PORTO%\n%PRINTED%\n%ACTIVE%\n%STANDING%\n%FUTURE%\n%BLANKET%\n%DPRINTED%\n%DELMETHOD%\n%ECENABLED%\n%DIRECTEC%\n1\n0\n0\n0\n0\n0\n0\n%SWDELMETHOD%\n"

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top