We frequently modify the base sales order and PO reports but the comments stopped printing out on some of the modified reports (not all). Never made a change to the comments area and can't figure out what is going on. This happened in 3.71 and continues in 4.05. Any help appreciated.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Comments don't print on Sales Order and PO 1
- Thread starter elopian
- Start date
Is this a crystal report? If so try verifying the database and let me know what happens.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
- Thread starter
- #3
Hi. Are the comments on Sales Order or PO lines? Or are they header comments?
I had a situation where after adding UDF's, the UDF's didn't exist for certain records and this caused my problem. I changed to a left join and it solved it.
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
I had a situation where after adding UDF's, the UDF's didn't exist for certain records and this caused my problem. I changed to a left join and it solved it.
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
-
1
- #5
horsehasmail
Technical User
You can only have one left outer join, if you do it can cause the problems that you describe.
Typically, one will lose comments (and other non-inventory types of lines) because they have linked an inventory related table to the report. Thus precluding all non-inventory type lines. The proper way to handle this situation would be to use a sub report and not a outer join.
- Status
Similar threads
- Locked
- Question