Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to dynamically choose database in the parameter field?

Status
Not open for further replies.

hex6007

MIS
Joined
Sep 2, 2008
Messages
53
Location
PH
Hello everybody,

How can i add in the parameters field to choose the database i want to work with? pls help?

thanks in advance.
 
You could have a main report that does nothing except hold a pair of subreports, each for a different database. Use a parameter choice to suppress one or the other.

When coding, you can switch between similar records in different databases using Database > Set Datasource. But not when you run stuff, as far as I know.

This is based on Crystal 10. It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
You could also potentially set this up in a command, where you create a parameter that is used to identify the database, and then use the parameter in place of the references to the database in the command. The command would then become the datasource for your entire report.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top