SSRS Report Builder Part 11.4 - Multi Value Parameters and Null Values

Поделиться
HTML-код
  • Опубликовано: 11 дек 2024

Комментарии • 17

  • @TheMisiekMisiek
    @TheMisiekMisiek 3 года назад +3

    Very useful, clear and professional. Continue your tutorials, please. You're my basic source of knowledge on ssrs/ssms.

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад

      Thanks! Happy you found it useful and thank you for watching!

  • @nikakalichava8012
    @nikakalichava8012 Год назад

    Hello Mr Owl!
    13:00 how do I handle null dates? I have a date parameter but some values are not filled and are null, If I check the null check-box it just gives me all the data (without nulls), but If i type a specific date then I still cant search for data with null dates.

  • @laionegan
    @laionegan Год назад

    Wonderful videos.the best on ssrs. I am seaeching for a soluzioni where i could create an ssrs query text using the expression.could you post some video on this?i hope to be clear.thx

  • @moyura2
    @moyura2 2 года назад

    Thank for sharing, it's easy to follow and very educational. How would you create a filter with few countries in the list e.g. (Select All), Show All Countries, No Country Assigned, US, UK, China ?

  • @RohithKK-uh7pp
    @RohithKK-uh7pp 3 года назад +1

    Sir super.

  • @ericsos101
    @ericsos101 Год назад

    I have a drop-down list in a parameter and all is one of them so when all is selected no data is displaying.. how can i fix it that issue

    • @WiseOwlTutorials
      @WiseOwlTutorials  Год назад +1

      Hi Eric! I'd check out videos 10.4, 10.4b and 10.5 in this playlist ruclips.net/p/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU
      I hope it helps!

  • @srinivasbestha7293
    @srinivasbestha7293 3 года назад

    Hi ,How can we create an optional multivalue parameter instead of passing all values by default on a report filter ?

  • @sblack1976
    @sblack1976 2 года назад

    This list of available values could be very long, how could we begin typing in the parameter field to filter down the list of available values?

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 года назад

      Hi! Sadly, SSRS parameters don't support this feature. There are several alternatives (none of which are as clean as autocomplete)
      stackoverflow.com/questions/43040817/how-to-type-value-dropdown-list-in-ssrs
      stackoverflow.com/questions/14691616/ssrs-report-parameter-with-500-values
      tpuch.blogspot.com/2011/02/options-for-filtering-parameter-values.html
      I hope it helps!

  • @Wzxxx
    @Wzxxx Год назад

    How to add null to report which uses data from dateveresse data set (DAX query)?

    • @WiseOwlTutorials
      @WiseOwlTutorials  Год назад

      Hi! Take a look at the example DAX queries here community.fabric.microsoft.com/t5/Desktop/How-to-add-a-blank-row-in-a-table/td-p/1368615
      I hope it helps!