Suppressed sub rpt prompts for db login on 4/1
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21927
Printed Date: 02 May 2024 at 3:30am
Topic: Suppressed sub rpt prompts for db login on 4/1
Posted By: Cervello
Subject: Suppressed sub rpt prompts for db login on 4/1
Date Posted: 05 Apr 2016 at 9:11pm
All of a sudden we have a report with several sub reports that is prompting for a db login to our production db which we do not report from. It happens when we try to export to excel. This just started happening on 4/1. We found it was the YTD version of the sub report was pointing to the wrong connection.
My question is Why is this all of a sudden happening. This report has been running and exporting to excel for well over a year without issue. It has not been modified in several months. The report all of a sudden started this behavior.
Can anyone point me to possible causes?
I'm wondering if the Security team changes the login credentials to the db would this cause this to happen. In other words someone intentionally set that db as the source when creating the report some time ago and provided the correct login creditials, but since then those creditials expired on 4/1???
|
Replies:
Posted By: hilfy
Date Posted: 10 May 2016 at 11:44am
How are you running the report? If it's through Crystal Reports Server or BusinessObjects, then the Security team changing the password would have this effect. However, the credentials for the report would have to have been set in the CMC in order for this to work.
If you're not running through CRS or BO, then something else is happening as Crystal does NOT save the password information internally in a report.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|