Skip to Content
0
Former Member
Aug 31, 2007 at 07:21 PM

Pass Multiple Parameters to SQL query in Drop down or Select Boxes

152 Views

Post Author: JasonW

CA Forum: Data Connectivity and SQL

Hello all- I am using CR XI and SQL server 2000.I have written a SQL statement and used that statement as a 'command' in the Database Expert, to pull data into a report. There are two issues I have that I need some help/advice on.-. The report needs 4 parameters. A, B, C, D.-. I can create Parameters in the Database Expert that will prompt me for the data when I refresh the report. However,-. I need to be able to select those parameters in drop down boxes based on data in the SQL database. The problem is that the parameter cannot pull the data without the criteria - so a drop down box seems impossible. OR is it? That is part of my question. The other part is - Even if it is possible, can Crystal do this somehow? NOTE: The query is selecting the data rather than Crystal - so Creating a Parameter field IN the report is futile. -. The other half of this problem is that users would like the ability to select multiple values from Field A and from Field B.