Report Class

Data report handling and document handling

Inheritance Hierarchy

SystemObject
Velo.DataReport

Namespace: Velo.Data
Assembly: Velo.Data (in Velo.Data.dll) Version: 22.2.10.1 (22.2.10.450)

Syntax

public static class Report

<ExtensionAttribute>
Public NotInheritable Class Report

The Report type exposes the following members.

Properties

	Name	Description
	GetSQLSelect	Report SQL SELECT statement (include date format dmy)
	GetSQLSelectJoinAddress	Report SQL SELECT statement with relationship to table Address (include date format dmy)
	GetSQLSelectJoinBike	Report SQL SELECT statement with relationship to table Bike (include date format dmy)

Methods

	Name	Description
	Add	Add a report data record to database
	Delete	Delete a report data item by ID and his positions
	DeleteByAddress	Delete all reports data item by address ID and his positions
	DeleteByBike	Delete all reports data item by bike ID and his positions
	GetAll	Gives a list of report
	GetByAddressFirstName	Gives a list of report data by address first name (search wild card)
	GetByAddressID	Gives a list of report data by address ID
	GetByAddressName	Gives a list of report data by address name (search wild card)
	GetByBikeBrand	Gives a list of report data by bike brand (search wild card)
	GetByBikeID	Gives a list of report data by bike ID
	GetByBikeNumber	Gives a list of report data by bike number (search wild card)
	GetByBikeType	Gives a list of report data by bike type (search wild card)
	GetByDateReceipt	Gives a list of report by receipt date (date range 30 days)
	GetByID	Gives a report data item by ID
	GetByWithoutAddress	Gives a list of report data by without address
	ToDocument	Create a report document from template
	ToDocumentCheckTemplate	Check template to create report document
	ToFill	Report document fill with data
	Update	Update report data