none
SSRS - Previous row , left side column value in tablix

    Question

  • Hi Guys,

    I am having a tablix in SSRS report:

    Now, I need to have the Row "Completed" which should get the data from previous row (planned) & left side column. Please suggest.
    Below is the design of the report- Column grouping 

    Thanks in advance.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Friday, August 24, 2012 9:07 AM

Answers

  • Thanks for your reply. The functions LevelInScopeAggregate and Previous cannot be used in the expressionparameter. Specifying the recursive parameter for any aggregate function is not supported in SSRS. If you see the report layout, I am using the sum on each cell value. 
    Finally, I had to write the SQL query in such a way to get the previous records in a column using temp table & while loops.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Friday, August 24, 2012 11:50 AM

All replies

  • try your luck with Previous(Fields!Planned.Value)

    Amit
    Please mark as answer if helpful
    http://fascinatingsql.wordpress.com/

    Friday, August 24, 2012 11:21 AM
  • Thanks for your reply. The functions LevelInScopeAggregate and Previous cannot be used in the expressionparameter. Specifying the recursive parameter for any aggregate function is not supported in SSRS. If you see the report layout, I am using the sum on each cell value. 
    Finally, I had to write the SQL query in such a way to get the previous records in a column using temp table & while loops.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Friday, August 24, 2012 11:50 AM