Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdedmunds
Starting Member
1 Post |
 Posted - 2007-07-03 : 13:53:35
|
| I am trying to filter data on a report by using drop downs. I have been able to create the drop downs, however I can only get one to actually filter content. I need to allow users to select the group from drop down one, and then a different group from drop down 2 so the end result will only display informaiton that matches both drop downs.Any suggestions will be appreciated. Below is the code if needed <SqlVariable name="V_Queue" display="Queue :" type="dbselect" displaycolumn="display" datacolumn="group_name" default="%"> <SelectQuery mssql="true" oracle="false" db2="false"> <![CDATA[ SELECT group_name, group_name AS display FROM table_1 WHERE group_name like '%cat1%' UNION SELECT '%' AS group_name, 'All' AS display ]]> </SelectQuery> </SqlVariable> <SqlVariable name="Group" display="Group :" type="dbselect" displaycolumn="display" datacolumn="group_name" default="%"> <SelectQuery mssql="true" oracle="false" db2="false"> <![CDATA[ SELECT group_name, group_name AS display FROM table_1 WHERE group_name like '%group%' UNION SELECT '%' AS group_name, 'All' AS display ]]> </SelectQuery> </SqlVariable> |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
dropdowns