Changing data source and restoring list values in a crystal report

This is specific to Crystal reports pointing to finance databases because unlike Data warehouse and custom applications, database names for finance prodction and development are different and crystal report data source configuration needs to modify before we move it to production.  Check the database configuration for crystal report on BODEV server.

In below  example the data source name is PSFINPRD however it is pointing to PSFINTST for testing purpose.

To change that and point it PSFINPRD, open the crystal report from server and change data source.

You can create a new data source or use the existing one and update it within the crystal report and hit update.

Once done, make sure your new/updated data source us pointing to correct server and Database catalog.

If you have a crystal report with sub-reports in it, make sure to update the data source in all reports.

Example below: 

During making the changes in crystal reports you may lose the static drop down from various prompts and they needs to be restore before production migration of reports.

Please check with crystal report developer for complete information about dropdown list and number of places it needs to be updated.

Below if the example from Order Intake Summary Report crystal report. For example in this report we need to restore two drop down list

1-      Business unit

2-      Yes and No response.

Open the crystal report and navigate to View -> Field Explorer

 Look for the prompt with drop down list, right click on it and choose edit.

Import the data from text file or data as provided by developer. Also make sure to update the value options as desired.

PeopleSoft Jobs – PeopleSoft Interview Questions Set

http://peoplesofttutorial.com/peoplesoft-jobs-peoplesoft-inteview-questions-set-01/
http://peoplesofttutorial.com/peoplesoft-jobs-peoplesoft-interview-questions-set-02/
http://peoplesofttutorial.com/peoplesoft-dba-interview-questions-part3/

Enjoy!!

Loginless users in SQL Server 2005+

MSDN

When you create a user without a login, there is no path that allows a login to be mapped to that particular user in the database.  The only way to "utilize" this particular user in the database is through impersonation.  Again this is BY DESIGN.  Loginless users were added in SQL Server 2005 as a replacement to application roles.  The main reasons behind this were that you did not need to embed a password into an application and you also did not suddenly have multiple people coming into your SQL Server all with the same "login".  By utilizing loginless users, the user's of an application login to the SQL Server using THEIR login credentials (NOT a generic login), so that you can audit activity to a given login.  Once they change context to the application database, you can issue an EXECUTE AS command to change their user context thereby giving them the authority they need within the application.

Testing execute as ->

create user deep without login;

USE DEEPTEST;

GO

CREATE PROCEDURE dbo.usp_Demo

WITH EXECUTE AS 'deep'

AS

SELECT user_name();

GO

USE DEEPTEST;

exec usp_Demo ->  deep
SELECT user_name(); -> dbo

List of users in Business Objects

Author: Adrián BO_Worker developed from Julien Bras' userlist utility.
Author notes: Excel 97-2003 VBA application. Displays some lists for users, groups, universes, reports... Only reading, not writing back. Please go to configuration sheet and fill Server, Username and Password in order to get it working. After that try the rest of sheets pressing the buttons to field the data below. Whenever you get orange cells that's a place you should fill. If you get Id and Name to fill you can write one or the other. In names you usually can use % character. Some queries can take a long time (10-15 minutes) depending on your server and number of objects involved.

I hope it's useful for someone and want to thank Julien Bras for previous programming. 

---

http://www.forumtopics.com/busobj/viewtopic.php?t=118177

BOXIR3_Lists97.zip
Description:		Download
Filename:	BOXIR3_Lists97.zip
Filesize:	105.64 KB
Downloaded:	6275 Time(s)