ReportMax is a free reporting tool for .NET Framework developers on Visual Studio.NET 2010 and 2012. It is easy to use and rich in features. In this tip, I would like to step through a basic tutorial to get you started in this tool. More tutorials to come.
As a main developer for this tool, I would like to provide help on how to use this tool. It is free and great to use. The current version is 2.2 and we have fixed many bugs and issues. Feel free to use the tool. You can view your reports in PDF format.
Using the Code
In this tutorial, I will show how we can use
ReportMax without a single line of code. You can instantly preview your report from the designer by right clicking on a blank area and select Preview Report. Here are the steps to use the tool. You need to install
ReportMax 2.2 from here.
Designing the Report
- Run Visual Studio.NET
- Goto File -> New Project
- Select Visual C# - Windows. Then Select Windows Forms Application. Enter
TestReportMaxWinForms for the Project Name. Click OK.
- From the Project menu, Select Add New Item. Select
ReportMax files from the left. Select Blank Report (Inch) from the right. Name the File to
MainReport. Click Ok.
- Add a Label (
lblHeader) in the middle of the Page Header section. Enter Arial Font Bold 24. Enter Alignment Property as Centered. Enter the text of the label to "Cities of the World".
- Right click on a blank area in the report and select Add Section - Group Header/Footer
- Click on a blank area in the report to view the Page properties. Or right click on a blank area and select Properties.
- Click on the ... button in the
ConnectionString property. Select Microsoft Jet 4.0 OLE DB Provider. Click Next. Browse to Cities.mdb Access database sample file. Hit Test Connection to make sure. Click OK to close the dialog. Please note that in order to run the sample report file, you need to do this step to select the sample database, or otherwise the database path will be invalid.
- In the SQL Property. Click the ... button. Enter the following SQL Statement and hit OK.
SELECT Country.Code, Country.CountryName, City.CityName, City.Population
FROM Country INNER JOIN City ON Country.Code = City.Country
ORDER BY Country.CountryName;
- Click on the Group Header blue bar to view its properties. Enter "
Code" in the
DataField Property (without the quotes)
- Add a
Textbox in the Group Header area (between the Group Header and the Detail section). Blank that
textbox. Name it:
txtCountryName. Set the
DataField property to "
- Select the
Detail section bar. Select
AutoShrink property to
- Add two
textboxes in the
Detail section. Name the first
txtCityName and the section
txtPopulation. In the
DataField property of
txtCityName, enter "
CityName". In the
DataField property of
txtPopulation, enter "
- In the Group Footer section. Add a
txtPopulationTotal. Set the
DataField property to "
Population". Set the
FunctionType property to
Sum. Set the
1-Number and the
3 - 123,356,789.
- Add a label near
txtPopulationTotal with text "Population Total"
- In the Page Footer Section. Add a Field control named "
txtPageNo". Set the
FunctionType property to Page Number. You can add another Field control and set the
FunctionType to Page Total. This way, you will have Page n of m at the bottom of every page.
- Make sure to save your work.
Viewing the Report
- Goto to
Form1 Design window. View the
Toolbox. Right click the General category and Select Choose Items... The Choose Items dialog will appear. In the .NET Framework Components tab, click on the Namespace column. Go to the top and locate
ReportMaxViewer component and add it to the dialog.
- You will find the
ReportMaxViewer component in the
Toolbox. Click and drag over the form and place it stretched on the form.
- Click on the control placed on the form and locate the
OutputType property. You have three choices. You can view it on the control window, to the Printer or to a PDF File. Make sure it is
- In the
ReportFile property, browse to the location of MainReport.rpm you created.
- Run the project. You should be able to see your report.
Points of Interest
The source code for
ReportMax is not available yet, but I have provided the sample project. Make sure you point the
ConnectionString property of the
Page to the correct location of the database provided Cities.mdb. I would like to mention that you can use images and charts, and you can customize your output by code. You can also connect to virtually any database type.
Also, please refer to:
- Added VB.NET sample. Follow the same steps in the tip.
This member doesn't quite have enough reputation to be able to display their biography and homepage.