[rm-users] Drilldown Reports

[Tony Griffin]

We're building web-enabled SQR reports that include drilldown links to
more details.  These detail reports are also written in SQR and all are
stored in Brio.Portal.  The SQR reports are published to the portal with
the datasource pre-defined, but not the database username/schema.  In
our environment, the application that Brio is integrated with determines
the database schema/user to connect to dynamically, based on their
application login.

I have found a "dbuser" parameter that can be used on the URL inside of
the HTML form, but this is not a secure solution to the problem of
passing along database connectivity information down to one or more
drilldown reports.

Is there a way of passing this sensitive information more securely?  Is
there a way to link reports together in the portal at publishing time so
that database connectivity is transparent?

-- 
Tony Griffin
Performaworks, Inc.