APPX is the Premier Development and Runtime Environment for Business Application Software
(Category) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment :
Output Processes
FAQ's relating to the design of APPX Output Processes.
Subcategories:

Answers in this category:
(Answer) How do I keep an Output from automatically printing Grand Totals?
(Answer) Can I print a date in Julian format?
(Answer) When I add rows at the frame level the rows on the image do not change.
(Answer) Does APPX support printing a bar code on an output form?
(Answer) How to get a setup grid on a PDF report?
(Answer) How to format a date to automatically display day of week or month of year!
(Answer) Can I format the date on automatic OUTPUT header(s)?
(Answer) Why are my labels in an output PDF report being truncated?
(Answer) How do I pass 'ESCape' sequences to my printer?
(Answer) How to print duplex, print on front and back of each page
(Answer) How to program an exception report, example of ALTERNATE IMAGE NUMBER
(Answer) Can GRAND TOTAL be controlled via ILF
(Answer) Additional help on PDF layout options
(Answer) Now that I can generate PDF files from APPX, how can I get the PDF to display as such in a browser?
(Answer) What is the best format to print a logo, images?
(Answer) We need to be able to use a specific font to support an OCR scan line
(Answer) HTML tags that can be used within a text field that is to be displayed with an HTML Viewer widget type via the APPX client.
(Answer) Can I print an OCR font in a PDF document?
(Answer) How to embed an image on an output?
(Answer) I have upgraded to 4.2.6 recently and now my PDF output text is shifted
(Answer) Is there a limit to the number of lines PAGE-END can have?
(Answer) HTML in PDF Documents
(Answer) How to create a PDF Form Overlay.

[New Answer in "Output Processes"]
2007-Jan-24 3:40pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
How do I keep an Output from automatically printing Grand Totals?
There is a flag in each query process called “Grand Total”. Set it to “None”.
[Append to This Answer]
2003-Nov-17 4:41pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
Can I print a date in Julian format?
A display mask of 555 will display the Julian day number. A mask like "8807 - 555" would display a date as 2004-247.
[Append to This Answer]
2003-Nov-26 3:07pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
When I add rows at the frame level the rows on the image do not change.
The number of rows are set in additional attributes at the IMAGE LEVEL. The number of rows (and columns) in an image by default are the same as the number of rows and columns of the frame. You can set the number of rows and columns for each image in the additional attributes for the image. If the numbers of rows are set to 2 at the image level (in additional attributes) and you change the number of rows at the frame level from 2 to 5, the image size will not change. The image size cannot exceed the frame size.
[Append to This Answer]
2004-Jan-07 2:43pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
Does APPX support printing a bar code on an output form?
No. As of release 4.2, there isn’t a bar code font supported within APPX..
[Append to This Answer]
2003-Dec-26 1:38pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
How to get a setup grid on a PDF report?
There's a field in the PDF form definition process labeled "Print Grid?". Set that to "Y" if you want a grid to be overlaid on your report during design.
[Append to This Answer]
2003-Dec-26 1:40pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
How to format a date to automatically display day of week or month of year!
If in painting a date field onto an OUTPUT image, you edit the display masks with the Day-of-the-Week or the Month-of-the-Year, you will get appropriate substitutions. For example:

A display mask of "Monday January 05, 04:03 am" will (on 9/16/96) yield a displayed Date of "Monday September 16, 11:48 am".

A display mask of "05 January 0807" will (on 9/16/96) yield a displayed Date of "16 September 1996".

Also, the 'SET DATE' ilf command can extract the Day-of-the-Week or the Month-of-the-Year, as documented in ...

            http://www.appx.com/manuals/appl-dsgn/drm282.html

[Append to This Answer]
2003-Dec-31 8:53am
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
Can I format the date on automatic OUTPUT header(s)?
Date masks on OUTPUT Report Page Headings can be controlled by means of a
System-Parameter, or Application-override Date masks, and an environment
variable 'APPX STD PGH MASK'.

For Example:

If I have no System or Application date mask override set, and I run an
OUTPUT with a standard page heading, I get a page heading date (for example)
of "03/25/1999 00:16 23.83"

If I had set my System or Application date mask to 

"06/05/07 - 04:03:02.01"

I get a page heading date of

"03/25/99 - 00:16 23.83"
[Append to This Answer]
2003-Dec-31 8:52am
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
Why are my labels in an output PDF report being truncated?
Several things might be causing this problem. First check to see if the report will print on another printer. It’s been reported that this problem occurs on a Xerox Docucenter 440ST. If it does, there may be a problem with the print driver.

If you are trying to print using Adobe Acrobat, make sure that the image is not being modified by the viewer when it prints. In Acrobat 6.x, on the File/Print screen set Page Scaling to none, Auto Rotate to no, and Choose Paper Source to yes. Set the "Bitmap" ("Image" in English?) option under the Advanced button on the bottom-right of the Adobe print screen.

Also ensure that the form definition is defined and allows enough ‘grid’ space for the elements on the output page.

                        

Bruce Johnston Jan 12, '04:
wrt the Xerox driver, the problem was only appearing for right-justified label widgets but was there regardless of whether a PCL or PS driver was used.
Have a care when changing the drivers for experimentation. I tried the latest and greatest and it reverted to a previous bug in which white space in fixed-space fonts was being calculated as zero which really messed thigns up.
Note that printing as Image or Bitmap will be slower but only really noticable in slower LAN/WAN connections to the printer since each page can be a couple of Mb vs. the KB range for native .pdf requests.
[Append to This Answer]
2004-Jan-16 2:40pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
How do I pass 'ESCape' sequences to my printer?
The ILF code ...

         CNV BIN  --- TEMP 1           = 27

 ... puts an "ESC" Escape character (hex(1b)) into TEMP 1.  You can then SET
this into an Alpha field, append other control codes as necessary, then embed
Alpha fields constructed in this manner in our OUTPUT report.

 ('ESCape' = Hex(1b) = 16 + 11 = decimal(27).)

See the ILF manual on the CNV BIN verb, for more detail on how it works.  

 www.appx.com > Support > Manuals > Application Design > Search > CNV BIN

On APPX/Windows platforms, you'll need to send a 'Form Control' of "-raw", in
order to tell the Windows Print Spooler not to filter out your escape codes.

WARNING:  Winprint interfaces to the printer's printer driver.  Some printer
drivers don't honor '-raw' pass through of hex codes.  The only way to find 
out is to try it.
[Append to This Answer]
2004-Jan-02 10:48am
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
How to print duplex, print on front and back of each page
For occasionally printing in duplex mode, you can put -interactive into the Form or Printer Control string. This calls up the printer driver's interactive setup screen (just like Word's File; Print; Properties screen). You should be able to set front/back printing there.

If you need to hard code it in the body of your output file with escape/hex codes, you must turn on the -raw flag in the Form or Printer Control string.

WARNING: Winprint interfaces to the printer's printer driver. Some printer drivers don't honor '-raw' pass through of hex codes. The only way to find out is to try it.

Bruce Johnston Jan 14, '04: Under Unique things are easier to manage, Go down to the formfont directory and look for files named "formname.printermake" as in "136.HP" and inside you should see something like Duplex=1 or Duplex=2 The first results in long-edge binding the second in short-edge binding.
Always back things up first.
[Append to This Answer]
2004-Jan-15 8:54am
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
How to program an exception report, example of ALTERNATE IMAGE NUMBER
On an exceptions report, I only want to print records with problems. How do I tell it to skip (not print) the good ones? Do I do this in Pre-Display?
Start your OUTPUT Frame's "Select Image" ILF series with:

           SET --- ALTERNATE IMAGE NUMBER = 0

Put the ILF that tests for exceptions below that. If a Record (or set of conditions in a Range-End frame) qualifies as an exception:

           SET --- ALTERNATE IMAGE NUMBER = 1

You can also issue MESSAGE, WARNING, ERROR, or CANCEL ILF commands at this point. Paint whatever fields and text you'd like on the OUTPUT Frame's Image, and you have a customized exception report!

[Append to This Answer]
2004-Jan-06 4:15pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
Can GRAND TOTAL be controlled via ILF
The "Grand Total?" design spec is editable in the QUERY editor, and displayed at run-time on the QUERY sort order screen. Manipulating the "Grand Total?" spec would get into editing the run time Q files.

The design spec, "Grand Totals", is used to set the following QSORT fields:

     QSORT SUBT
     QSORT SUBT NEW PG

They are set respectively as follows:

     NO       N,N
     STANDARD Y,N
     NEW PAGE Y,Y

Note that there are multiple QSORT records. This one is the one with QSORT SNO=0. The other QSORT records would be for the other "Sort Order" records. The field QSORT ACTV probably also needs set to 'Y'.

You're dealing with APPX internals here, so ASI does not provide support for the viewing and manipulation of these files. You're on your own.

[Append to This Answer]
2004-Jan-06 4:30pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
Additional help on PDF layout options
If you haven't already tried it, create a new PDF form and set Print Grid? to Y (and then print your reports with the new form). You should get an extra page at the end of each report that explains how to use the APPX_GRID_STYLE environment variable to control a few useful layout options.
[Append to This Answer]
2004-Jan-09 9:56am
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
Now that I can generate PDF files from APPX, how can I get the PDF to display as such in a browser?
Normally I use a CGI script that designates the content type as "text/html". I can create a link on the website that runs a subroutine that creates a PDF report, but in sending it back to the browser, it's treating it as text, so all of the PDF codes you would see if you looked at it in Notepad are displayed instead of launching Acrobat. How can I send the PDF file as a *.pdf back to the browser so it knows to open Acrobat?

Changing the content type tag in the CGI script to "application/pdf", which is the content type for *.pdf documents, will do the trick.

[Append to This Answer]
2004-Apr-07 3:39pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
What is the best format to print a logo, images?
In general to get the best scaled images, you want as much resolution as you can get in pixels (within reason) and also a high number of colors in the image bit depth.

The high resolution means the image will be scaled down for the pdf form instead of up. Scaling formulas do a lot better job throwing away extra detail than they do creating detail where it doesn't exist.

The large color depth gives the formula a much better ability to anti- alias. If you are using a black and white (1 bit) color depth, it can't anti-alias at all and will always create a jagged border. If you are using straight black and white, just converting the image to a gray scale image will make a big difference in the result of scaling.

As for image processing software, you can use Adobe Photoshop. But almost any tool will allow you to alter the image color depth and save under a number of formats. If you have linux, it comes with a tool called "gimp" that is an open source knockoff of photoshop without the fancy user interface.

Is .JPG the 'best' file type? Or is there a better one? And for that matter, what other formats are acceptable (if any)?

For screens, you can use JPG, GIF, and PNG files. JPG's aren't good for line drawing (because the images are compressed with a lossy algorithm - sharp lines disappear).

GIF's are patent-encumbered.

If you want to include a resource image that has fine, crisp, details, you don't want to use JPG to store the image. JPG uses pixel averaging which distorts and drops out fine detail. Like very thin lines and such. JPG was create to store high color, low detail images like photographs.

PNG is the best bet. It's the newest if the three and does a fine job.


[Append to This Answer]
2004-Apr-28 4:32pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
We need to be able to use a specific font to support an OCR scan line
We need to be able to use a specific font to support an OCR scan line in an output process with APPX 4.2.4. How would we go about using the following font: OCR A Extended

Go the the output editor and bring up your output image. In the Object Properties > GUI Attributes of the field there is a selection for Font (in Font Options box). This is a drop down list showing the fonts that are available to you. Select the font you want. Of course this has to be a PDF document for printing this report. If the font is not listed in the drop down, then the font will have to be installed on your machine.

[Append to This Answer]
2004-Jun-16 9:15am
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
HTML tags that can be used within a text field that is to be displayed with an HTML Viewer widget type via the APPX client.
For a new line, use CTL RETURN.

<p>               - new paragraph (does not require an ending </p>)
<pre> ... </pre>  - new paragraph with Courier font and fixed spacing
&nbsp             - fixed space (needed when not using <pre>)
<b> ... </b>      - bold
<i> ... </i>      - italic
<li> ... </li>    - each bullet
<ul> ... </ul>    - to indent bullets
<font size="n"> ... </font> where n=1-9 (1=8,2=10,3=12,4=14,5=18,6=24,7=36pt)

A good example of usage to look at is the new IF DIFF statement under 
System APPLICATION DESIGN, Subsystem ILF STATEMENTS.  
Remember, in INQ mode, you see the HTML tags applied; 
in CHG mode, you see the actual HTML tags coded.
[Append to This Answer]
2004-Jun-24 8:30am
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
Can I print an OCR font in a PDF document?
No, currently (rel 4.2.4) the only fonts supported for PDF output are the ones listed on the pulldown list. Unfortunately, it is not possible with APPX release 4.2 to use an OCR font for PDF output.
[Append to This Answer]
2004-Jul-09 5:39pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
How to embed an image on an output?
If you'd like to embed an image (i.e. company logo) at the PAGE-START of the output, you need to do following:
1. Design transfer STANDARD PAGE HEADING output from 0LC to your application.
2. Modify STANDARD PAGE HEADING to include following code:
   RESTORE  --- WIDGET                     DEFAULT RECORD
      SET      --- WIDGET PARENT TYPE         =      WIDGET
      SET      --- WIDGET WIDGET TYPE         =      PICTURE
      SET      --- WIDGET POSITION ROW        =      1
      SET      --- WIDGET POSITION COLUMN     =      2
      SET      --- WIDGET LOC OFFSET COL      =      -100
      SET      --- WIDGET SIZE ROWS           =      3
      SET      --- WIDGET SIZE COLUMNS        =      15
      SET      --- WIDGET RESOURCE TYPE       =      RESOURCE
      SET      --- WIDGET RESOURCE NAME       =      <your resource name>
      SET      --- WIDGET RESOURCE AP         =      <your app>
      SET      --- WIDGET TEXT POS HORIZ      =
      SET      --- WIDGET TEXT POS VERT       =
      SET      --- WIDGET TILING MODE         =      TILE
      WRITE    --- WIDGET                 FAIL 0
This code needs to go right before the very last statement of the STANDARD PAGE HEADING, which is
COPY --- STANDARD COLUMN HEADING (GUI)
3. You need to go to the System Administration Menu --> System Setup --> Hook records and hook your process.
4. You have to have resource defined. We recommend to have your mage on the server. Your image can be .png, .gif or .jpeg. Some image types can be more restrictive than the other's, so try it with different types and see which one works the best (.jpeg should almost always work).
Remember, that this will work with PDF outputs only and you have to run Java client.
If you want picture displayed anywhere on your image, you need to have a WIDGET defined as PICTURE, give it location type and Resource Name. Make sure you have Resource defined.
[Append to This Answer]
2005-Mar-08 2:33pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
I have upgraded to 4.2.6 recently and now my PDF output text is shifted
You need to make sure that in your Form Definition, the default Font is left blank. The default font for PDF documents is Courier. If you define a font in the Form definition, Appx will use it instead of the default and it may cause your PDf document not to look right. This field was ignored prior to version 4.2.6.
[Append to This Answer]
2005-Apr-01 3:45pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
Is there a limit to the number of lines PAGE-END can have?
There's a 255-line limit on any frame class.
[Append to This Answer]
2005-Jul-25 1:52pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
HTML in PDF Documents
I thought we could use HTML in PDF outputs? I have a TEXT type field that I have filled with some simple HTML:
<html>
Address 1<br>
Address 2<br>
Phone<br>
</hmtl>

The <br> is ignored, and the text prints w/o a break.

I used a LABEL control type. This works fine in an input process.

What I am doing wrong?


 <br> is ignored...  
You can change fonts and colors inside of a PDF field (using HTML tags), but not layout (at least not yet). You should be able to use:
<font size=10 color=#00FF00> set size and color at once, you can also do stuff like:
size=+2 or size=-3 </font> <big> next larger font </big> <strong> bold </strong>
 <i> italics </i> <em> italics </em> <tt> tele-type font (courier) </tt> <small>
 next smaller font </small>
<u> underline </u>
More tags likely in future releases
[Append to This Answer]
2006-Jan-10 10:51am
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Output Processes :
How to create a PDF Form Overlay.
A PDF form overlay is a predefined image, or electronic form, that is printed along with data fields in an output process. The use of form overlays can help eliminate the need for preprinted forms. These instructions explain the basic steps for creating an output process with a form overlay.

You will have to determine the scale of your image in relation to the form size that will be used for the output. It may be necessary to create a form in System Administration that is adequate for the overlay you are using. For this example, I have a form named PDF-6P10 that is a type PDF with form length of 60 and width of 80. The overlay image is a .png file named POForm.png.

Although Appx accepts jpg, gif and png images, the png format is the recommended image type to use.

1. The first step is to obtain or develop the electronic form you wish to use in your output process and create the Appx form definition as described above.

2. Copy the overlay file (POForm.png in this example) to the AppxPath/vv/aaa/Resource directory where vv is the application version and aaa is the application.

3. In Application Design add a Named Resource (PO FORM in this example). Make the State ENABLED and set the Type to Design File. The Location is the name of the overlay file, POForm.png. Note; match the case in the Location to that of the actual file name in the Resource directory. The image will not display if the name and case is not exactly the same.

4. Now create an output process. In my example I add a new output process called PRINT PO, Columns set to 80, Standard Page heading set to No, Column headings set to No, and remove the default Separator character (=).

5. Set the Preferred Form in Additional Attributes with the predefined form for this output process, PDF-6P10 in my example. If the default form is not set to the form name you have defined the printed result may not match your design.

6. Select PAGE-START for the first output image.

7. Set the length and width to match the form you will be using. In this example the form is length 60 and width of 80.

8. Navigate to the image editor.

9. Select the Picture icon from the toolbar and drag out a box the size of the display area.

10. Enter the Resource name you added above, PO FORM in this example (don’t forget to include the Application Id). Save these settings.

11. Page the image down (Cntl-down arrow) and drag the bottom of the Picture widget to the bottom of the display area. Repeat this step until you are at the bottom of the display area, line 60.

12. Go back to the top of the display area (Cntl-up arrow).

13. Edit the Picture properties and set the scale to a number that fits your liking. This might be a trail and error process until the overlay is exactly the way you want it. If necessary the overlay image may have to be adjusted using an editing tool such as MS Paint or PhotoShop.

14. Save the output image.

15. Return to the Frame level and set the length to 1, explanation below.

16. Add other frames as needed to complete the output process. On my PO FORM there is a place for repeating and non-repeating data. For the non-repeating fields, the top of the PO FORM, I set the Size of this frame to 21 by 80. There are 21 rows on the form before the repeating line items begin.

17. In the image area for ach frame add the fields, placing them at the approximate location to match your form. You can fine tune their locations while testing the process.

18. Create a Job process to include a Disposition. The Disposition Form Id must be the form you added for this output (PDF-6P10) and the Format must be PDF. You can set these parameters in Pre-Invocation of the Disposition job step for testing.

19. Run the job to test the output process and make adjustments as necessary.

The PAGE-START frame was changed back to 1 line after dragging the picture widget out so that the output would be a single page. PDF output cannot distinguish blank areas within a widget. If the length was left at 60 lines, the output would have printed the form as a page followed by the text on the second page based on my form and image sizes. By changing the length to 1 the output prints only one line, although the actual image extends beyond that. The text image then starts on line 2 of the output for the length indicated. The result is that your data is printed on top the overlay image on a single page.

The fit of the fields into the boxes of the form can be further refined by creating the text or fields as widgets and using micro adjustments to move the widgets into the exact location. Don’t forget you can also adjust the font type, size and color for each widget.

    

[Append to This Answer]
2007-Feb-08 5:15pm
Previous: (Category) Input Processes
Next: (Category) Query Processes
This document is: http://board.appx.com/cgi-bin/fom.cgi?file=27
[Search] [Appearance] [Show Top Category Only]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.