February 28, 2013 at 3:51 am
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
March 3, 2013 at 5:40 pm
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?
March 10, 2013 at 12:49 pm
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
March 11, 2013 at 2:13 am
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