×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sage 300 Crystal Report DLL/ODBC

Sage 300 Crystal Report DLL/ODBC

Sage 300 Crystal Report DLL/ODBC

(OP)
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.

RE: Sage 300 Crystal Report DLL/ODBC

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

Sage 300 Whisperer

RE: Sage 300 Crystal Report DLL/ODBC

(OP)
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

RE: Sage 300 Crystal Report DLL/ODBC

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

RE: Sage 300 Crystal Report DLL/ODBC

(OP)
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"

RE: Sage 300 Crystal Report DLL/ODBC

'type=DATAPIPE

Sage 300 Whisperer

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close