Problem with Parameters for SQL command 2

[mgakhar]

I have a report with the SQL being a command where I've simply pasted my query. I have some input parameters for the query as well which I've created via Database Expert --> Edit Command --> Create.

The problem that Im having is that now I want to create another parameter for the query. If I simply edit the command and add a new where clause with the parameter, it works fine. However, if I create a new parameter using the Create button it errors out.

Im using CR 10 and OLE DB.

Thanks,
Manish.

 

[lbass]

I believe I've read that that is a bug. Try creating a new report using "Add Command" where you create all parameters at once.

-LB

 

[Madawc]

You're using an SQL Query and including parameters in it? I've had just that bug. One option - not neat, but workable - is to apply a Crystal selection to the SQL Query input.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[mgakhar]

When I create a new report using Add Command and if I create all the parameters at once, it works fine. Just a big pain coz I have to redo almost all my reports now. Wish there was a simpler fix.

MG.

 

[lbass]

A hotfix might help. Please see:

http://support.businessobjects.com/library/kbase/articles/c2017022.asp

-LB

 

[mgakhar]

lbass - the hotfix did it. Problem now seems to be solved.

thanks a lot for your help !!

MG.