Recording Report Name in Master Table of Report
Firedac, XE7, RB16.0, Firebird
I have an End User Module based on the Firedac Demo
I have a Stored Procedure which is intended to update the Master Table
used by the Report called by the Report Explorer.
Stored Procedure Input Parameters are :
Reg_No ( An Integer Unique )
Rep_Temp_Used ( V24) ... for the Report Name
Last_Printed (Date)
The intention is to record the the Report Name selected by the end user
and the date last used.
Can you recommend both the recommended object and event to call the
Stored Procedure and the values to pass in the format
Parambyname('Reg_No').asinteger
:=Mastertable.Fieldbyname('Reg_No').asinteger;
Got me stumped.
Regards
Mike
I have an End User Module based on the Firedac Demo
I have a Stored Procedure which is intended to update the Master Table
used by the Report called by the Report Explorer.
Stored Procedure Input Parameters are :
Reg_No ( An Integer Unique )
Rep_Temp_Used ( V24) ... for the Report Name
Last_Printed (Date)
The intention is to record the the Report Name selected by the end user
and the date last used.
Can you recommend both the recommended object and event to call the
Stored Procedure and the values to pass in the format
Parambyname('Reg_No').asinteger
:=Mastertable.Fieldbyname('Reg_No').asinteger;
Got me stumped.
Regards
Mike
This discussion has been closed.
Comments
Here's an rbWiki article that shows how to detect when the report is printed
http://www.digital-metaphors.com/rbWiki/Output/Printer/Detecting_Whether_Report_Printed_to_Printer
You can use TppReportExplorer.CurrentItemName and CurrentFolderId to
identify the report. Use the Delphi Now function to return the current
datetime.
Best regards,
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Thanks