I have a problem with a report I'm creating in CR11. I am using two SQL commands to pull data from two different DBs. I have it working, but I have to use separate parameters for each command. Is there a way to pass the same parameter to two different created SQL commands in CR11? I can create parameters for each one separately in the 'parameter list' box in the database expert, but I can't find a way to use an existing parameter in a command.

haha. Yes, I'm stumped! (sorry, no prize though)

I don't think it can be done. One option would be to put the report into a blank main report and this blank main report has a single parameter that gets passed to the subreport (your original report with two command objects). But I still don't think that will work b/c the parameter on the main report can only be linked to a single parameter in the subreport.

What I think I would do is create a single command object with both SQL queries in it and do the join in the command object (rather than having CR do the join on the client side). Then you can use that one parameter within the command object and pass it to both SQL queries.

Combining both commands into one didn't work. I imagine it would have worked fine if both commands were pulling data from the same database. But each command is pulling data from a different DB and Crystal 11 associates a command with a particular DB. So it errors when one command is trying to pull from two different DBs.

Thanks for the help. I guess they'll just have to settle for six parameters instead of three.

Since some people here are Crystal consultants, please suggest that parameters SHOULD be able to be passed anywhere. Even to two sql commands. It seems that forcing each command to have it's own custom parameters is a glitch that handicaps the full functionallity of Crystal.