21 September 2011

Create a Report Using Report Button



Report button in Create tab - Report groups can be used to create a basic report on the data in the current table or query, to which you can add features such as groups or totals. It is very easy to apply. Point your mouse to the table the report you want to create, and click Report button. Finish.

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:
  1. Switch the report to Design View
  2. You may change the Logo with yours, or you can delete that (Properties
    Name: Auto_Logo0)
  3. Go to Form properties and change Caption to "Chart of Account -Main
    Account".
  4. Go to Auto_Title0 properties and change Name to "Chart of Account -Main
    Account". Adjust the width as necessary.
  5. Reorder the detail lay out:
    • before: AccountCode - AccountName - GroupName
    • after: GroupName - AccountName - AccountCode
  6. Go to GroupName properties and change the following properties:
    • Hide Duplicates = Yes
    • Can Grow = No
    • Can Shrink = No
  7. Adjust the border on the Page Header and Detail as follow:
    • Border Style = Solid
    • Border Width = Hairline
  8. Save the report to rptMainAccount. When open in Print Preview, the
    report will look like this:

18 comments :

  1. 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

    ReplyDelete
  2. Thank you for some other informative website. The place else may just I get that kind of information written in such a perfect method? I have a venture that I am simply now running on, and I’ve been at the glance out for such info. access card system

    ReplyDelete
  3. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! https://michaelguion.wixsite.com/access-control

    ReplyDelete
  4. Technology oriented careers have been making a comeback. Accordingly, talented technology managers are necessary in every area of the field - from Web design and development, to database-driven e-commerce, to software engineering, to technical service and support. access card system

    ReplyDelete
  5. I definitely enjoying every little bit of it. It is a great website and nice share. I want to thank you. Good job! You guys do a great blog, and have some great contents. Keep up the good work. https://accesscontrolsystemsorg.wordpress.com/2021/08/27/access-control-system/

    ReplyDelete
  6. You there, this is really good post here. Thanks for taking the time to post such valuable information. Quality content is what always gets the visitors coming. https://secom15.livejournal.com/460.html

    ReplyDelete
  7. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! access card system to buy

    ReplyDelete
  8. I definitely enjoying every little bit of it. It is a great website and nice share. I want to thank you. Good job! You guys do a great blog, and have some great contents. Keep up the good work. card access system to buy

    ReplyDelete
  9. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. https://accesscontrolsystems38.mystrikingly.com/

    ReplyDelete
  10. Thanks for your post. I’ve been thinking about writing a very comparable post over the last couple of weeks, I’ll probably keep it short and sweet and link to this instead if thats cool. Thanks. buy door access control in singapore

    ReplyDelete
  11. Positive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. access control system singapore

    ReplyDelete
  12. Thanks for a very interesting blog. What else may I get that kind of info written in such a perfect approach? I’ve a undertaking that I am simply now operating on, and I have been at the look out for such info. biometric access control system order online

    ReplyDelete
  13. Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome! best door access system

    ReplyDelete
  14. Wow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also https://biometric-access-control-system.my-free.website/

    ReplyDelete
  15. Thanks for the blog loaded with so many information. Stopping by your blog helped me to get what I was looking for. biometric access control system

    ReplyDelete
  16. This particular papers fabulous, and My spouse and i enjoy each of the perform that you have placed into this. I’m sure that you will be making a really useful place. I has been additionally pleased. Good perform! door access control system

    ReplyDelete