Just recently we upgraded our crystal reports from XI to CR 2008. One of the reports that has dynamic prompts always ask for user-id and password when it is about to show the page two of the dynamic prompt parameter. We had issues with limiting data (some data values were missing on the on the drop down of dynamic prompts); This we settled by adding MaxRowsetRecords to 400000.
Can anyone please help us to see how we can avoid the user-id and password prompt?