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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter Double Prompting

Status
Not open for further replies.
kjaz11

kjaz11

Programmer
Sep 24, 2002
5
US
I have a crystal report which links to a stored procedure. The stored procedure accepts 1 parameter (siteid). The report works great, except that the siteid parameter is always blank with no choices.

I've added both a table and command prompt, so I can dynamically choose the SiteID (not at the same time). I linked the dynamic parameter to the stored procedure parameter.

The report now prompts for the siteid twice. 1st with no choices, then 2nd with the SiteID choices from the database. It doesn't matter what value I put in the 1st parameter screen as the 2nd prompt is used by the report.

How can I skip/hide the 1st parameter box for siteid? I am using Crystal IX.

Thanks,
 
Status
Not open for further replies.

Similar threads

allyne
  • Locked
  • Question
RE: Sub Reports with parameters 1
Replies
3
Views
132
allyne
allyne
Statey603
  • Locked
  • Question
Input Parameters screen issues: multi-line and width
Replies
0
Views
122
Statey603
Statey603
telex2
  • Locked
  • Question
Ignoring Characters when entered by user in Parameter Field 1
Replies
2
Views
97
telex2
telex2
meljunk
  • Locked
  • Question
Form front to pass parameters to a crystal report
Replies
3
Views
112
hilfy
hilfy
lilolee
  • Locked
  • Question
Error Failed to open connection crweb00000119 when running a report with a Parameter
Replies
4
Views
167
lilolee
lilolee

Part and Inventory Search

Sponsor

Back
Top