Better way to filter data

  • cmw 66135

    Ten Centuries

    Points: 1265

    Hi

    I am currently filtering data on a report using wildcards which is the only way I know how to filter. The problem I am having is that when selecting period 1 the report is also pulling in data for periods 10,11 & 12. If I make this report filter to exact then I get no return on my report. Is there a better way to do this filter so when the parameter is put in it only returns the data for that period?

    Thanks
    Chris

    P.s apologies for asking so many questions at the moment, but I am self taught on SSRS using what I can from my excel knowledge which doesn't always work on SSRS

  • Luis Cazares

    SSC Guru

    Points: 183532

    cmw 66135 - Tuesday, April 17, 2018 5:03 AM

    Hi

    I am currently filtering data on a report using wildcards which is the only way I know how to filter. The problem I am having is that when selecting period 1 the report is also pulling in data for periods 10,11 & 12. If I make this report filter to exact then I get no return on my report. Is there a better way to do this filter so when the parameter is put in it only returns the data for that period?

    Thanks
    Chris

    P.s apologies for asking so many questions at the moment, but I am self taught on SSRS using what I can from my excel knowledge which doesn't always work on SSRS

    Are you connecting to a SQL database? How do you build your data set?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • cmw 66135

    Ten Centuries

    Points: 1265

    Hi Luis

    Yes I am connecting to a SQL database. The report is built using the report builder connected to our finance program (SSRS 2014) but I assume the data sourse is a diritive of the sql tables as it references to report manager not the actual sql database

    Thanks
    Chris

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply