ReportID

[travisdh]

I am curious how people handle reporting in their database systems, basically i am trying to work out how i can allow my system to dynamically generate reports but still allow for traceability.

The logic is that i would need to potentially generate a reportID, and other report information in a report table, to record the reportID, when it was generated, and a filename, and then potentially save the report as the filename.

How do people manage to keep traceability when the report is dynamically generated each time? and the results come from different tables and so on?

 

[SpentGeezer]

Greetings,

I have a report history table that is updated with a file name whenever the form is generated/printed. The report is printed to PDF (using Lebans code) and stored in a shared system directory. The table is updated with the file path, date/time and user details. This is essential for our auditing processes. The database is setup so that the user has to use either a print button or email button (email genereates a PDF and emails it using Lotus Notes). If either of these processes are successful then a pdf of the report is created and placed in the folder. After this is successful the table is updated with the details. The PDFs created use the date and time to give them a unique name.

Regards,
Spent