Sales Report InfoPath 2010 template

Watch a demonstration of codeless InfoPath techniques that are contained in an InfoPath 2010 form that can serve as a sales report.

This InfoPath video is a demonstration of a Sales Report InfoPath form template, which I'm making available free of charge to all customers who bought InfoPath 2010 Cookbook or InfoPath 2010 Cookbook 2.

InfoPath 2010 video transcript:

Here I've got an InfoPath form that is completely based on codeless techniques. The first thing that the InfoPath form does when you open it is that it displays the current date in this date picker. Then it displays the month based on the current date. And it displays the year based on the current date.

This year drop-down list box also gets dynamically populated with a certain amount of years. So if you have the current year, it will take 7 years in the past and 7 years in the future. For example, if the current year is 2013, the years would run from 2006 to 2020.

Another thing is that I can enter a category here, and I can specify products. I'll say this is Product 11 and I'll say it costs $10 and I've sold 2 units. And then you can see the totals being calculated here.

I can add a second product. I'll say this is Product 12. It costs $20. And again you'll see the totals being calculated here.

I can also add a second category. Once I've added the second category, you'll see that a summary section will appear here at the bottom of the form. And when I give this category a name, you'll see that same name appear here in the summary section.

I'll say Product 21 belongs to Category 2, and it costs $100. And again, you'll see the totals being calculated here, and the grand total of the categories displayed here in the summary section.

So that is how this InfoPath form works.

See more InfoPath 2010 tutorial videos »

 
 Subscribe for updates via RSS or Email

Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related InfoPath Articles:

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services