Table of Contents

KB Item 343

Product

VERSAGO

Product Version (if applicable)

All

Issue

A Crystal Report being called from a Versago report action link always requests DB login information.<br />

Symptom

A Crystal Report that is called from a Versago report action link does not automatically execute the Crystal Report.&nbsp; Instead the user is prompted for database login credentials.<br />

Cause

<p>1)&nbsp; The database connection type may be incorrect.</p><p>2)&nbsp; A Crystal Report “command” may be in use.</p><p>3)&nbsp; Sub-reports may be in use.<br /></p>

Resolution Notes

<p>1)&nbsp; The database connection type for the Crystal Report should always be OLE DB (ADO).&nbsp; Other connection types will not work across different databases.</p><p>2)&nbsp; In general, “commands” should not be used in Crystal Reports being used with Versago.&nbsp; If the report data absolutely cannot be obtained using the standard Crystal Reports data source selection process, a SQL View should be used as the data source.</p><p>3)&nbsp; Check the linking from the main report to the sub-reports.&nbsp; If the linking is incorrect it can cause the report to prompt for database credentials each time the sub-report is called.</p>

KB Type

Solution

Item Date

08 Aug 2018