Print Page | Close Window

Select DB Source Based on Report Parameter?

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
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=6999
Printed Date: 05 Apr 2025 at 9:05pm


Topic: Select DB Source Based on Report Parameter?
Posted By: johnwsun
Subject: Select DB Source Based on Report Parameter?
Date Posted: 08 Jul 2009 at 6:05pm
Hi All,
 
is it possible for CR XI to select a database source based on a report parameter?  I have one report that serves two different libraries, both on a same server.  I have two parameters: lib1, lib2. So when user select lib1, I wish the report will point to DB sourceX; if user select lib2, the report will point to DB sourceY.  could anyone please advise if this is  achievable?
Thanks in advance.
 
John


Replies:
Posted By: hilfy
Date Posted: 20 Jul 2009 at 1:24pm
Unfortunately, no.  You can't change the datasource internally in the report.  However, you can change it through the SDK by writing an interface that runs the report and sets the database appropriately.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window