Introduction
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.
Background
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 "CountryName
".
- Select the
Detail
section bar. Select AutoExpand
to True
and AutoShrink
property to True
.
- Add two
textbox
es 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 "Population
".
- In the Group Footer section. Add a
textbox
(Field
) named txtPopulationTotal
. Set the DataField
property to "Population
". Set the FunctionType
property to Sum
. Set the FormatType
to 1-Number
and the Format
to 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 rmOutputTypeWindow
.
- 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:
History
- Added VB.NET sample. Follow the same steps in the tip.