Hi, I designed a report using crystal report XI, I use a store procedure from database in SQL 2005.
My connection data is:
Database type: OLEDB (ADO)
Provider: SQLOLEDB
DataSource: MAR1ACCT01
Initial Catalog: Request
User Id: sa
Integrated Security: false
Use DSN default properties: False
This report work fine from Crystal XI but when I copied this report in Report Application Server of Crystal Enterprise 9 the report prompt for the DB logon credentials, I dont want to enter logon credentials this must be automatically.
How do I do it?