sql server - Allow user to skip a multi-value and use non-query list parameter in SSRS 2008 -

-

i want able use or not use "allow multiple values" parameter. far, i've found how add "blank" or "null" parameter default, pulls values blank or null result set, doesn't allow me skip parameter.

also, use shared dataset, not stored procedure, , can not use specified query list (there on 2.8m records), need allow users type list manually in text box or skip entirely.

i try anything, long data values manually entered or can skipped.

thanks can offer.

i hope more detail generate idea. working in medical environment, developing series of reports users choose requesting provider information, or physician information, never both @ same time.

i tried suggestion, setting providernpi parameter properties default specified to: ="noentry" , edit query add: (fieldprovidernpi in (@providernpi) or @providernpi = 'noentry').

to run report, entered 1 week in date range parameters, entered valid physiciannpi number in @physiciannpi, , left default noentry in @providernpi text box.

the results pulled 1.8m records, providernpi numbers in providernpi column, , various or blank numbers in physiciannpi column, none of number entered @physician.

i expected 34 records physician, various providernpis.

does have way allow skipping multi-valued parameter in environment of shared or embedded datasets only, no stored procedures?


Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more