Query in SSRS

  • hi All ,i have one requirement where the SSRS report is displaying only certain data of a column based on a filter on a date range ,

    whereas i should get all the data even though the date range is selected or not for that particular column ,how can we achieve this is SSRS report

  • You want to get all data even though you have filtered the data? That doesn't really make sense. If you want all the data, don't filter it.

    Can you explain a bit more?

  • Hi Old hand,

    i think the OP means he need some average data for 1 particular column even while only a subset is returned in the actual report

    If this is the case then i would look into Creating a SP (not needed but easy to maintain)

    and some code like the one below (just example, not working code)

    ;with cteData as (

    select col1,col2, datecol1, sum(numcol) as totalFordataset from table x

    )

    select * from cteData where datecol1 between @DateFrom and @DateTill

    You cab easily put this into SSRS Querywindow, it should work without a stored procedure to.

    Hope this helps you on your way

    Wkr,

    Van Heghe Eddy

  • davoscollective (3/3/2013)


    You want to get all data even though you have filtered the data? That doesn't really make sense. If you want all the data, don't filter it.

    Can you explain a bit more?

    exactly , could you explain it a little more ..

    why do you need the whole data ???

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

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

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