Print Page | Close Window

Parameter Problem???

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20091
Printed Date: 05 May 2024 at 4:02am


Topic: Parameter Problem???
Posted By: veecastillo
Subject: Parameter Problem???
Date Posted: 07 Oct 2013 at 10:19am

I have a report that returns an accurate record when a select statement is used.  Once a parameter is created and placed in the report, the prompt comes up and when a specific record is entered, the results are returning every record in the database. 

 
Has anyone else come across this?   


-------------
Vee


Replies:
Posted By: kevlray
Date Posted: 07 Oct 2013 at 10:22am
Did you use the prompt in the select expert or in a command (SQL statement)?

Posted By: veecastillo
Date Posted: 07 Oct 2013 at 12:27pm
I would like to use a parameter so that a user can enter the info to get a record instead of all of them.
 
I am creating the parameter in Crystal Reports 2011


-------------
Vee

Posted By: kevlray
Date Posted: 08 Oct 2013 at 4:38am
You did not answer the question:  Did you use the parameter in the select expert or in a command (SQL statement)?  If you did not, then the results will not be filtered.

Posted By: veecastillo
Date Posted: 08 Oct 2013 at 12:12pm

Yup, you are right about not answering the question.  That is because I had not used the parameter in the select expert.  Once I did, the report and parameter worked and returned the one record.

 
I'm very new to CR, so thanks for asking the question.  It helped me figure out that I had missed a step.


-------------
Vee


Print Page | Close Window