Hello all,

How can I take the username of the logged in user, and pass this value to an SQL statement?  I'd like to get customer-specific information selected from the SQL server.

Please let me know how I can do this?

Thanks

Mark

You can do it like this

SELECT * FROM {oQ}Users WHERE UserID = @UserID

In the current version of the Reports Module, the following parameters are supported by default:

• @UserID: Replaced with the ID of the User who is currently viewing the report.
• @TabID: Replaced with the ID of the Tab (Page) on which this module is situated. Note: If the same module is copied to a different page, the @ModuleID parameter will be the same but the @TabID parameter will be different.
• @ModuleID: Replaced with the ID of the Reports Module on which the report is defined.
• @PortalID: Replaced with the ID of the Portal on which the report is running.

---

Philip Beadle - Employee