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

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more