Visual Catpro
  

Doc Report Forms

Doc Report forms is to design forms. That designed forms may be attach with documents like invoice, challan etc.  That may also be use for design forwarding letters. Open Doc.Rep.Forms then following windows appears:

graphic

Now click on 'Page Setup' button to set the size, margins for this report form. Click on Add button a pop-up menu appears as shown below:

graphic

Select Text/Field to add a text or database field or select Box to create a box/line on report form.  You may also select Picture option for inserting a picture. After clicking on Text/Field it creates a new field on the report form as shown below:
graphic



A field/Object has various properties to change it's position, appearance etc. Select the object and change its properties from the property windows displayed right side on the 1st screen. Here are the list of properties available and their description.
  
Property
Description
Align
Specify 'L' for left, 'R' for Right and 'C' for Center. If blank is specified then default alignment is left.
graphicAnchorPos
 
graphicBackColor
 
Caption
This property is useful, when we are required to print any text or an expression like:- "Doc No." & r1("DocNumber")
In above example "Doc No." is a normal text & is an operator to join to strings and r1("DocNumber") means print the value of DocNumber DB field. r1 is a recordset. Every DB field can be access by a recordset number like r1,r2 etc. To study which recordset number attach with which table. See help topic Recodsets Numbers
 
graphicDonAdjust
 
FontBold
Mark True, if you want to apply bold style.
FontItalic
Mark True, if you want to apply italic style.
FontName
Specify the font name to apply in windows based printing
FontNameDos
Specify the font name to apply in dos based printing
FontSize
Specify the font size.
graphicFontSizeMin
 
ForeColor
Specify the fore color of the text.
Format
You may apply various format as per requirement. Here are list of formats:
Example Value :  9922525.123
n2 : 9922525.12
n3 : 9922525.123
c2 : 99,22,525.12
if you want to print zero also : use N2, C2 ( Capital Letters)
Height
Specify the Height of the object in twips.
IfPrint
If you want to print the object on certain condition. For example I want to print the object only if DocVatBill is true. Then specify r8("DocVATBill") in this property. Now it prints object only if DocVATBill is true.
graphicMaxWidth
 
PosX
Specify the X position (Horizontal Position) of the object.
PosY
Specify the Y position (Vertical Position) of the object.
PrintOrder
Specify the Order of the object. You may also set the order of the object by choosing the appropriate option after clicking on 'Order' button.
graphicRemoveIfBlank
 
graphicReplicateBox
 
RsField
Specify the DB Field name here and also specify its relevant recordset number in RsNo field. For Example to Print  GrNo specify GrNo in this field and 1 in RsNo field. Click Here to see which recordset number assigned to which table.
RsNo
Specify the recordset number in this field.
Type
There are two types are exists 'T' and  'C'. 'T' used for printing field name. The 'C' is used for printing text mention in caption property and the variable name mention in VarName property.
VarName
Specify the variable name to print like Agent, Transport etc. You must mark 'C' against Type property to print variable.
graphicVisible
---------Not Working---------------
graphicWarning
 
Width
Specify the Width of the object in Twips.
graphicWrap
---------Not Working---------------

You may also select the database field to print by clicking on 'RS Field' button. After clicking on RS Field button following screen appears:

graphic

Select the appropriate table from Table list and then select the desired field from the list.