Is there a way when you publish a Crystal Report in ERS that runs with data refresh to pass the user id and password of the users logged into ERS so that it does not have to prompt them for it?

Are you referring to Enteprise Reporting or Reporting Services? If it's Reporting Serivces, what version are you on?

Are you just wanting to eliminate the need of the end user to provide a db user/password at runtime, or are you wanting to filter the data based on the end user running the report?

This is Reporting Services. I want the first - to eliminate the runtime prompting of the db user/password - since they have already provided this when they logged into portal...

I'm filtering (on some reports) by way of the security classes - not through the report itself.

What version of Reporting Services? Sounds like your reports are using the Lawson OLE DB connector as the data source - is this correct?

Yes - OLEDB 9 and RS 1.3 with latest patches.

Upgrading to Reporting Services (RS) 9 would give you this with the Bursting functionality.

The one caveat is that in addition to maintaining laua application security, you will also have to maintain report/data level security rules within RS. You can't leverage laua security for this, unless you wanted to do a custom export from laua and import into RS.

OK - 2 questions:

Does RS 9 work with IOS 8.0.3? Or does the environment need to be upgraded to 9 as well?

I would understand about not leveraging laua for access to the reports/etc..but my assumption is that since we would be using OLEDB it would still leverage laua from a data access standpoint,which is how some of the data filtering is done...