Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Query in SSRS Expand / Collapse
Author
Message
Posted Thursday, February 28, 2013 3:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 21, 2013 5:56 AM
Points: 18, Visits: 99

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
Post #1424977
Posted Sunday, March 3, 2013 5:40 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:03 AM
Points: 450, Visits: 842
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?

Post #1426052
Posted Sunday, March 10, 2013 12:49 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, June 30, 2014 8:31 AM
Points: 647, Visits: 760
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
Post #1429005
Posted Monday, March 11, 2013 2:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, May 31, 2014 9:19 PM
Points: 1,128, Visits: 1,162
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
Post #1429107
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse