Multiple Dropdown in Visual Studio 2008 not filtering correctly -

-

i using visual basic 2008 ssrs , backend sql server 2008 create reports. trying create 2 parameterized dropdowns user can select in order filter data in reports. reason can't seem both parameters filter 1 filters correctly. when run report in visual studio 2008 choose dropdown1 equal 2 , dropdown2 equal 4. should show 1 row, reason second filter seems work. need modify sql maybe?? appreciated, thank you.

**table 1**      **table 2**                **table 3**  key1        key2    data1       key3    data2   data3 1           1       hi          2       green   white 4           1               2       green   white             2       hey         3       red     black             3       hi          1       orange  purple             1       hey         4       blue    black             4       hey         4       blue    purple    **current result**              **desired**      data1   data2   data3       data1   data2   data3 hi      orange  purple      hi      orange  purple hey     blue    purple                **parameters-** @dropdown1- available values label value hihey   1 hi      2  **@dropdown2- avilable values** label     value greenblue   3 purple      4  query designer- select l.key1,  c.data, aa.data2, aa.data3   table1 l inner join table2 c on l.key1 = c.key2  inner join table3 aa on l.key1 = aa.key3    ((@dropdown1= 1 , c.data1 ='hi' or c.data1 ='hey' ) or (@dropdown1= 2 , c.data1 ='hi'))   ,   ((   (@dropdown2= 3 , aa.data2 in ('green', 'blue'))    or  (@dropdown2= 4 , aa.data3 ='purple')    ))

not quite sure logic, desired result, or clause in condition needs bracketed.

((@dropdown1= 1 , (c.data1 ='hi' or c.data1 ='hey') )

a demonstration of full codes:

declare @table1 table (key1 int) declare @table2 table (key2 int, data1 varchar(10)) declare @table3 table (key3 int, data2 varchar(10), data3 varchar(10))  insert @table1 select 1 union select 4  insert @table2  values (1, 'hi'),  (1, 'you'),  (2, 'hey'),  (3, 'hi'),  (1, 'hey'),  (4, 'hey')  insert @table3 values (2, 'green', 'white'), (2, 'green', 'white'), (3, 'red', 'black'), (1, 'orange', 'purple'), (4, 'blue', 'black'), (4, 'blue', 'purple')  select * @table1 select * @table2 select * @table3  declare @dropdown1 int = 2, @dropdown2 int = 4  select l.key1, c.data1,aa.data2,aa.data3  @table1 l  join @table2 c on l.key1 = c.key2     inner join @table3 aa on l.key1 = aa.key3   (  (@dropdown1= 1 , (c.data1 ='hi' or c.data1 ='hey') ) or (@dropdown1= 2 , c.data1 ='hi'))   ,  ((  (@dropdown2= 3 , aa.data2 in ('green', 'blue'))    or  (@dropdown2= 4 , aa.data3 ='purple')   ))

Comments

Post a Comment

Popular posts from this blog

c# - Better 64-bit byte array hash -

-
i need hash algorithm produces 64-bit hash code ( long ) fewer collisions string.gethashcode() , fast (no expensive calls cryptographic functions). here's implementation of fnv still shows 3% of collisions after testing 2 million random strings. need number way lower. void main() { const string chars = "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz!#@$%^&*()_+}{\":?><,./;'[]0123456789\\"; const int n = 2000000; var random = new random(); var hashes = new hashset<long>(); int collisions = 0; for(int = 0; < n; i++) { var len = random.next(chars.length); var str = new char[len]; (int j = 0; j < len; j++) { str[j] = chars[random.next(chars.length)]; } var s = new string(str); if(!hashes.add(get64bithash( s ))) collisions++; } console.writeline("collision percentage after " + n + " random strings: " + ((doubl
Read more

webrtc - Which ICE candidate am I using and why? -

-
[questions in bold below] i have setup kurento media server 5.1.3 in datacenter behind firewall running os ubuntu 14.04. has 2 network cards: 222.222.222.222 (eth0 - private ip) 111.111.111.111 (eth1 - public ip) attached below sdp (setremotedescription) when browser connected kurento media server type: answer, sdp: v=0 o=- 5487318114793304426 0 in ip4 0.0.0.0 s=kurento media server c=in ip4 0.0.0.0 t=0 0 a=group:bundle audio video m=audio 59068 rtp/savpf 111 0 c=in ip4 111.111.111.111 a=rtpmap:111 opus/48000/2 a=rtpmap:0 pcmu/8000 a=sendrecv a=rtcp:59068 in ip4 111.111.111.111 a=rtcp-mux a=ssrc:669011897 cname:user39019747@host-6e83e4c2 a=extmap:3 http://www.webrtc.org/experiments/rtp-hdrext/abs-send-time a=mid:audio b=as:20 a=ice-ufrag:ymdk a=ice-pwd:lylifk5ueqzpwm91ddj37e a=fingerprint:sha-256 ff:0f:81:8c:41:4e:b4:b6:c6:d8:36:f3:d6:5f:09:fd:5f:af:13:b3:9d:fc:12:66:ac:f3:56:d6:5b:0a:73:5d a=candidate:1 1 udp 2013266431 111.111.111.111 55239 typ host a=candidate:2 1 udp
Read more

php - Zend Framework / Skeleton-Application / Composer install issue -

-
i trying create zend framework application using skeleton in netbeans. when run composer install, following error message: "c:\php\php.exe" "c:\composer\composer.phar" "--ansi" "--no-interaction" "update" "--dev" using deprecated option "dev". dev packages installed default now. loading composer repositories package information updating dependencies (including require-dev) requirements not resolved installable set of packages. problem 1 - package requires php >=5.5 php version (5.4.42) not satisfy requirement. problem 2 - installation request zendframework/zendframework 2.5.1 -> satisfiable zendframework/zendframework[2.5.1]. - zendframework/zendframework 2.5.1 requires php >=5.5 -> php version (5.4.42) not satisfy requirement. done. apparently, zend framework only needs php 5.3+ contradicts above. need use php 5.4. my composer.json following: { "name": "
Read more