RPC - Report Concept

Report Concept

HTML Reports can offer you huge flexibility when creating automatic documentation for the Knowledge Base:

• the possibility of reporting information directly from the Knowledge Base
• the possibility of personalizing reports by using a Cascading Style Sheet
• the possibility of navigating through the report by using a navigation frame
• the possibility of creating a report using other reports
• the possibility of sharing a report with another user
• the possibility of saving a personal report
• the possibility of creating a report in HTML compatible format which can be used on an intranet or the internet without modification

An HTML Report that is generated by the application is based on the cascading level concept, in other words each level is equivalent to the chapters in a book. To build your report, therefore, you must describe your data by levels.

Take for example an HTML Report for a list of all table definitions. To find a table definition, you must:

• Find Table Identifiers

• For each Table Identifier, then find the Table Information

You can describe this report in two stages:

• List of all tables in the Knowledge Base
• For each table in the list, retrieve information

This method described above can be carried out with the following code:

/*....;Lev:=0;Title:=Table ,1;....*/      Select      TabNam,TabId,...... <--- this select statement retrieves the table list      with its name in the first column and identifier in the second column.      /*....;Lev:=1;Title:=Information;%%IdtCol:=2;....*/ <-- Use the      identifier found in column 2 in the previous level.      Select TableInformation....  Where TabId =      %%IdtCol         <-- %%IdtCol is used to specify the identifier.

The result of this query could be:

Table BONUS

Table name BONUS TabId 1035
Schema name SCOTT

Table Column information