Skip to Content
0
Former Member
Jul 16, 2008 at 05:04 PM

SQL Parameter Prompts Twice

410 Views

I've a few reports that utilizes the SQL Parameter feature in CRXI. I mostly use this if the Command SQL query is hitting large tables and it's unnecessary to pull a large amount of records defined in the SQL and then have it filtered in Crystal. Instead, I take care of that all at once by having the user input the criteria they want by using the SQL Parameter prompt.

One thing I can't figure out is why in the world the SQL Parameter prompts the user twice. This holds true on both Crystal Reports and Business Objects.

I've noticed that when you create a SQL Parameter, it also creates a parameter on the report itself. Maybe whatever the user value input is on the SQL Parameter, it does not get passed on to the same parameter on Crystal Report level. It still does not make sense to me as that parameter is not defined anywhere in Select Expert.

One clue I got that it's asking me for two different things is that the first time I'm prompted to input a value, the parameter order is set the way it is ordered on Command. (ie, on Command, FiscalEnd starts first then FiscalStart). Once I enter those prompt values, it asks me the same thing again, this time in the order it's defined in Crystal (ie. FiscalStart is first, then FiscalEnd)

I've tried various things. Checked off both versions of "Verify First..." options, etc etc.

Any help would be appreciated.