Report Manager for Dot Net

Basics

The dot net version of Report Manager is a full translation from Delphi to C# of the reporting engine. The port to dot net is near completion but requires still some work. Libraries are provided so you can link easily your reports with your application. The .net por tof the Report Designer is not completed, so, the design and test of ther reports must be done with native Win32 database drivers

How to design reports for .Net

Design the report normally but:

• Set at page setup, options tab the prefered save method to XML or XML compressed. The .net runtime read and save the reports in this new formats.
• There are small diferences, for example when executing in .net, the fortmat property for dates will behave like in .Net framework so the M represents the month and the m the minutes, and the H is the 24 hour format hour.
• For linked querys, the parameters of the child dataset must be defined in Parameters definition and must be assigned to the child dataset.

Missing parts

• Output as csv.
• Report Designer
• Some barcodes still missing, charting not implemented

Different behaviour

• In odbc provider you use ? for placing parameters, the parameters will be assigned by position, not by name, parameters by name are not supported by odbc dot net driver, so make sure to sort the parameters to match query position when you use odbc.

Using the library

To use the libraries provided, you should include a reference to them in your project. It' better if you include the .csproj to your project and then a reference to that project so you can debug any problem deeper.

Documentation is available but still incomplete.

This is sample code to execute a report, a portion of the sample provided testinglib.exe.

using Reportman.Drawing;

using Reportman.Drawing.Forms;

using Reportman.Reporting;

using Reportman.Reporting.Forms;

Report rp=new Reportman.Report();
rp.LoadFromFile(EFile.Text);

// Set the provider factory for each database, user the invariant name of the factory (defined in mahine.config)

rp.DatabaseInfo[0].ProviderFactory = "YourDatabasefactory";

// As an alternative you can provide an already stablished connection and transaction

// rp.DatabaseInfo[0].Connection =YourIDBConnection

// rp.DatabaseInfo[0].Transaction=YourIDBTransacion

if (pdf)
{
rp.AsyncExecution=false;
PrintOutPDF printpdf = new PrintOutPDF();
printpdf.FileName=pdffilename;
printpdf.Compressed=compressedpdf;
printpdf.Print(rp.MetaFile);
}
else
{
rp.AsyncExecution=asyncexecution;
if (ParamsForm.ShowParams(rp)
{
PrintOutWinForms prw = new PrintOutWinForms();
prw.Preview = preview;
prw.SystemPreview=systempreview;
prw.ShowPrintDialog=showprintdialog;
prw.Print(rp.MetaFile);
}
}