Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
parameter that will read previous quarter

Unanswered parameter that will read previous quarter

  • Wednesday, February 06, 2013 4:56 AM
     
     
    Sign In to Vote
    0

    Good day! i created a report that will show data quarterly. this a running value from 2011 to 2013. now my problem is i need to create a next report that will show the quarter that i click here. for example if i click Q1 from 2013 this will give me a break up of 56,925(red only). i tried to pass a parameter of Q1-2013 but it will not read the previous quarters for 2011 and 2013 and should be running value. any idea how do fix this? TIA

     

All Replies

  • Wednesday, February 06, 2013 3:41 PM
     
     
    Sign In to Vote
    0
    Check if this help you: Enabling Drilldown on (SSRS) Reporting Services 2008 Charts
     
  • Wednesday, February 13, 2013 5:12 AM
     
     
    Sign In to Vote
    0

    thank you for the response irusul but i already know the drilldown here in SSRS.

    as you can see here in the report that i attached. i have Quarters by Years. i want to pass a parameter to the next report that will read the exact Quarter and also bring the previous Quarters which is not happening to me.. when i try to select Quarter 1 in the Year 2013 which value is 56,925 i add in the chart that pass the @Quarter and @Year. but it will only pass the Value of Quarter "1" for 2011, 2012 and 2013..

    the output should be (for the next report as a breakup of 56,925) 

    (1,2,3,4) /(1,2,3,4)/ (1)

    2011/ 2012/ 2013

    i hope its clear. sorry for my english.

    regards,

    Jef


    • Edited by jefnavarro Wednesday, February 13, 2013 5:53 AM
    •  
     
  • Wednesday, February 13, 2013 6:53 AM
     
      Has Code
    Sign In to Vote
    0

    or how about a different scenario..here the same report how can i add a parameter for QTR and YEAR..

    if i input a value for "QTR = 1" and for the "YEAR = 2013"

    it should show me the same graph and it will start to the given Parameter Value but since this report has running value on it this should give us the amount of 56,925.

    in my query i create a subquery to get a runningvalue.

    (SELECT SUM(Col_1)
                FROM  Table_1  b
                WHERE  b.Col_1  >=  a.Col_2)
               	AS  running_total

    this is for the Red Line of the Chart. the problem now is if i enter the value in the given parameter's it will only show the amount of QTR 1 from Year 2013  (10,541) this should read the previous quarter's also. the output should show us 56,925. how can i achieve this?

    thanks!

    regards,

    Jef


    • Edited by jefnavarro Wednesday, February 13, 2013 6:54 AM
    •