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.


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


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






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


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


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








English versionEnglish  italian versionItaliano

AL-TEK 2020 twin site Development and consulting