DataPA Administration Course

Data PA Administration

DataPAFileConcepts

DataPA Query (customers.qpa)

Database Application

DataPA Report (customers.rpa)

© Data PA

DataPAQueries Inorder todefine thedata extracts wewill use froma given system,DataPAuses theconceptof a query. Thequerydefines the following:

Thesystemwewish toextractdata from The typeof datawewant toextract

 

 Any conditions or parameters used to limit thedatawe receive  Which fields from thedata setwewish to receive  Thesortorder thedatawill be received in

Queries arestoredondisk in the formof qpa files, for examplewemight savea fileas C:\MyQueries\customer.qpa. This means wecansharequeries between applications such as MicrosoftExcel andDataPAReports.

DataPAReports For DataPAReports themodel is slightlydifferent. For a reportweneed to store thedata formatting and layout information inaddition to thedata extractdefinition. As such,DataPA reports arestored in a different file format, rpa files. For examplewemight saveour customer reportas C:\MyReports\customers.rpa. This report filecontains both thequery, and formattingand layout information for the report. Wewill see later on in thecoursehowwecanbuild a new reportusinganexistingquery. The existing querywill havebeen saved todisk as a qpa filewhich couldhavebeen generated inExcel. Wewill alsoseehowwecan sharea query thatwas created inDataPAReports, so it canbeused inExcel.

5

Made with