Joined: 04 Oct 2013
Location: United States
Online Status: Offline
Posts: 3
Topic: Parameter Problem??? 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.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
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.
Joined: 04 Oct 2013
Location: United States
Online Status: Offline
Posts: 3
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.
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
IP Logged
