passing logon info from report to UFL

[JasonLord]

I have an application that logs me into a report automatically when the report is run. I also have a UFL that will allow me to run other reports from then main report to export or email (Thanks Ido!)...

Here's what I need to be able to do...I need to grab the logon criteria from the main report (which my app has populated and run) and pass each component of the logon (username/passwprd, db etc) to the UFL function...Is the information available to the report itself? Or Can the connection pointer itself be grabbed? I saw it was possible to (within an app) to latch a report onto an existing ODBC connection with the ODBC connection Handle...is it possible to get the ODBC handle of the current report?

Any other ideas out there?

 

[AndrewBaines]

You can get the username and database name from a SQL formula -
{fn DATABASE()}
{fn USER()}
The rest of your stuff would need an application to reuse the ODBC connection. You can only set a password in a report, not read it. Andrew Baines
Chase International