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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter is cleared when command is edited

Status
Not open for further replies.

unknownly

Programmer
Jul 7, 2003
181
US
Using Crystal reports version 10.


When a user edits a command object in the report and the command has a parameter "date" set to a default value. When edit command it done and click ok. The parameter values gets reset. We have dowlanded the hotfix for CR 10 and I have read in the "READ me" file that this was resolved (Patchid: 37826544)

This what I am having trouble with

Step:
Command:

select * from table1 where table1.date = {?date}

{?date} parameter was created in the command object box.

Step2:

Edit Command:

select * from table1 where table1.date = {?date}
and table1.column1 = 'Some Value"

click OK

the ?date parameter does not show me the box where I can either enter a date or the default date give at the time of creation id all cleared out.

to make this work.

Step 3:

Edit command again and highlight the paratmeter and click modify and click ok. This makes it work again

but I have to do this everytime I edit the command

Can someone advice Please!

TIA,
Sweetie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top