Complex Examples

Grid examples
Purpose	Source	Result (PDF)
Simple list (1. version)	test_c_1_v1.prc	test_c_1_v1.pdf
Simple list (2. version)	test_c_1_v2.prc	test_c_1_v2.pdf
Master-detail report	test_c_2.prc	test_c_2.pdf
Report with summaries (1. version)	test_c_3_v1.prc	test_c_3_v1.pdf
Report with summaries (2. version)	test_c_3_v2.prc	test_c_3_v2.pdf
Graphical examples
Grid 10mmX10mm	Grid_A4_10x10mm.prc	Grid_A4_10x10mm.pdf
Grid 1mmX1mm	Grid_A4_1x1mm.prc	Grid_A4_1x1mm.pdf
Colors	test_color.prc	test_color.pdf
Patterns	test_pattern.prc	test_pattern.pdf

Query Print

The query_print package is designed to enable users to create PDF documents based on simple SQL
statements with basic formatting options. The package is designed to give quick results with minimal
design and development commitment from the user.

Source: query_print.sql

Examples
Purpose	Source	Result (PDF)
Fills the available width according to the ratio of the width of the fields in the query.	test_query_01.prc	test_query_01.pdf
Width of the columns/fields for the query is specified in a parameter.	test_query_02.prc	test_query_02.pdf
Width of the columns/fields is calculated according to the length of the data type of the cellwidth parameter.	test_query_03.prc	test_query_03.pdf
Pivots the fields in the query so that the column become rows.	test_query_04.prc	test_query_04.pdf
Pivots the fields in the query so that the column become rows with multiple columns.	test_query_05.prc	test_query_05.pdf
Width of the columns/fields for the query is specified in a parameter as a percentage.	test_query_06.prc	test_query_06.pdf
Width of the columns/fields is calculated according to the length of the data type of the cellwidth parameter. A parameter specifies how many cells should NUMBER and DATE data type fields be written into. For text data type fields the length of the text specifies the number of cells. Maximizes the width of cells.	test_query_07.prc	test_query_07.pdf
Same as query_print_07, except if the columns do not fit on the page then each column width is reduced according to its ratio to the whole width.	test_query_08.prc	test_query_08.pdf
Same as query_print_07, except if the columns do not fit on the page then the column width of columns that are not NUMBER or DATE is reduced according to its ratio to the whole width.	test_query_09.prc	test_query_09.pdf