Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Command Parameter Prompting Twice Post Reply Post New Topic
Author Message
GFICHTNER
Newbie
Newbie
Avatar

Joined: 05 Dec 2011
Online Status: Offline
Posts: 1
Quote GFICHTNER Replybullet Topic: Command Parameter Prompting Twice
     Posted: 29 Nov 2012 at 7:33am
I have a command "table" that I added a parameter too. Lets call it parameter "city". This is in Crystal XI.   After adding the parameter to the command - the same parameter appears in the field explorere - under parameter fields. Somehow these must be related but different (there are more options in field explorer, the parameter options under command are very limited). In any case- after working with the report - at some point - start getting prompted for both (first the command one - then the field explorer one along with another parameter in field explorer).   I tested and used different values. The value of the 2nd one is actually whats used. But if I go into the command and delete the parameter from there - it also deletes the one in field explorer. Seems like a bug in Crystal - but wondering if there are any known work arounds. I tried starting a fresh new report - and I think it worked for a while - but eventually the double prompting started in there too (not sure what step caused it though).   Thanks in advance for your help. This one has no subreports.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 29 Nov 2012 at 12:19pm
this seems to be an issue when command objects are used and tables, and the parameter is used to filter the data...both in the command and the report.
 
at least that is the usual description of things.
 
what comes to mind is to use the parameter only in the command or only to filter the data, but not both.
 
this seems to be one of the few drawbacks to using the command object.
 
The question that arises is are there real tables in the report or just the command table?
 
 
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum