Adding fields from DOLINE in SOP backorder Report

I have a requirement to add the doline.reqdat field to the SOP backorder Report. I know the syntax for the seek command to pull the field from another table but Pegasus are not opening the table I need when running the report. Does anybody know how I can open a table from with-in the report?

Find more posts tagged with

Pegasus - Partner General Discussions

Comments

alan-bourke

In general sqopen() can be used. For example:

iif(sqopen("S", "operatable"), iif(seek(yourvalue, "operatable", "indextagtouse"),operatable.returnfield,""),"")

alan-bourke

I might also add a report summary band and one expression :

iif(sqclose("operatable"), "","")

Just to be tidy.

richardd

Thanks Alan, I was just missing the sqopen command.

0712131256598360.doc

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help

Copyright © 2025 Infor. All rights reserved.