Sage 300 Crystal Report DLL/ODBC

[ravazz]

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.

 

[Jay Converse]

Start with POPOR04, not POPOR01, then comment out the datapipe lines for that report in PORPT.INI.

Sage 300 Whisperer

 

[ravazz]

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

 

[Jay Converse]

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

 

[ravazz]

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"

 

[Jay Converse]

'type=DATAPIPE

Sage 300 Whisperer