ATReport : interacrive tables and charts from database - Files config

In this session you can find a small sample of a file .rep that you can modify with a simple text editor, (for more detailed instructions see ATRep help).

Simple Access database connection.

[SOURCE]

Provider=Microsoft.Jet.OLEDB.4.0; Password=""; User ID=Admin; Data Source=E:\C2003\NCell23\nw.mdb; Mode=Share Deny None; Extended Properties=""; Jet OLEDB:System database=""; Jet OLEDB:Registry Path=""; Jet OLEDB:Database Password=""; Jet OLEDB:Engine Type=5; Jet OLEDB:Database Locking Mode=1; Jet OLEDB:Global Partial Bulk Ops=2; Jet OLEDB:Global Bulk Transactions=1; Jet OLEDB:New Database Password=""; Jet OLEDB:Create System Database=False; Jet OLEDB:Encrypt Database=False; Jet OLEDB:Don't Copy Locale on Compact=False; Jet OLEDB:Compact Without Replica Repair=False; Jet OLEDB:SFP=False

[SQL]

FROM Customers INNER JOIN ((Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID) INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID) ON Customers.CustomerID = Orders.CustomerID

[FIELD]

Year,STR(YEAR(Orders.OrderDate))

Category,Categories.CategoryName

Product,Products.ProductName

Customer,Customers.CompanyName

Order Date,STR(MONTH(Orders.OrderDate))+"-"+STR(DAY(Orders.OrderDate))

[OUT]

Amount,[Order Details].Quantity * [Order Details].UnitPrice

[END]

To quikly test the program download the database and rep files here below:

 

 

 

 

 

 

 

 
Footer1
Footer2
English versionEnglish  italian versionItaliano

AL-TEK 2016 twin site Development and consulting