DBExpress for reporting by Web
Good afternoon
We are using the Fast Report Server for reporting by Web.
Our reports are independent developed of Delphi, we use 2 connections to the database of the component DBExpress in each report, we only success generate the reports by Web with the connection already open, didn't find a way to pass the connection by parameters. We researching a way to pass these parameters by the component TfrxReportServer, i try to use your event OnGetReport and using the parameter Report as the example below, like we used in the application Delphi:
TfrxDBXDatabase(Report.FindObject('DataBaseSat')).ConnectionName := DatabaseSAT.ConnectionName;
TfrxDBXDatabase(Report.FindObject('DataBaseSat')).DriverName := DatabaseSAT.DriverName;
TfrxDBXDatabase(Report.FindObject('DataBaseSat')).Params := DatabaseSAT.Params;
Any code entered in that event, write off the performance of the report server.
See that the DatabaseSat is a SQLConnection(DBExpress), a connection that we put on the source code of server reports and want to pass this paremeter to the reports, at the moment of the execution by Web.
I saw that there are some components like frxServerConnection and frxReportClient.
Perhaps there is the answer to our problem, if they have the best way to do please repassing to us, with some example if you can.
Grateful.
We are using the Fast Report Server for reporting by Web.
Our reports are independent developed of Delphi, we use 2 connections to the database of the component DBExpress in each report, we only success generate the reports by Web with the connection already open, didn't find a way to pass the connection by parameters. We researching a way to pass these parameters by the component TfrxReportServer, i try to use your event OnGetReport and using the parameter Report as the example below, like we used in the application Delphi:
TfrxDBXDatabase(Report.FindObject('DataBaseSat')).ConnectionName := DatabaseSAT.ConnectionName;
TfrxDBXDatabase(Report.FindObject('DataBaseSat')).DriverName := DatabaseSAT.DriverName;
TfrxDBXDatabase(Report.FindObject('DataBaseSat')).Params := DatabaseSAT.Params;
Any code entered in that event, write off the performance of the report server.
See that the DatabaseSat is a SQLConnection(DBExpress), a connection that we put on the source code of server reports and want to pass this paremeter to the reports, at the moment of the execution by Web.
I saw that there are some components like frxServerConnection and frxReportClient.
Perhaps there is the answer to our problem, if they have the best way to do please repassing to us, with some example if you can.
Grateful.