After finish creating report, what you need to do is adjust the necessary properties and field included. We will use the table tblMainAccount as an example. Just point your mouse to the table tblMainAccount and click Report button. The report will look like this (displayed in Layout View):
Now, do the following steps:
- Switch the report to Design View
- You may change the Logo with yours, or you can delete that (Properties
Name: Auto_Logo0) - Go to Form properties and change Caption to "Chart of Account -Main
Account". - Go to Auto_Title0 properties and change Name to "Chart of Account -Main
Account". Adjust the width as necessary. - Reorder the detail lay out:
- before: AccountCode - AccountName - GroupName
- after: GroupName - AccountName - AccountCode
- Go to GroupName properties and change the following properties:
- Hide Duplicates = Yes
- Can Grow = No
- Can Shrink = No
- Adjust the border on the Page Header and Detail as follow:
- Border Style = Solid
- Border Width = Hairline
- Save the report to rptMainAccount. When open in Print Preview, the
report will look like this:
very nice posts i found here. hey I am also a freelance Vb net programmer i like to visit my blog www.ram-a-singh.blogspot.com
ReplyDeletewow great post guys
ReplyDeleteWebsite Design Company in Bangalore