|
-
February 20th, 2020, 12:49 PM
#2
Re: Using one parameter to select multiple values
Crystal Reports must first connect to the database before it can process any data. Therefore, you cannot use a parameter to control which database CR uses. However, you could create a view, or multiple views in one database which, using linked servers or db links, return data from other databases. Then, by using a command object (database->database expert ->connection->add command) you could have a parameter to control how you select from the view, or even which view is used. If you can have a column in the view to indicate where the data originated, then the parameter can control the result set.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|