I need to group by column ? As example - Month/day/year by given date range in the parameter. RRS feed

  • Question

  • I have parameter "start date" and "end date" - I need to count the no of records for each month. 

    • Edited by SSRSQ Friday, August 7, 2020 2:15 PM
    Friday, August 7, 2020 1:32 PM

All replies

  • It is easy to achieve in direct T-SQL query using PIVOT operator. I'm not exactly sure how to apply this in SSRS.

    Looking for new opportunities

    For every expert, there is an equal and opposite expert. - Becker's Law

    My blog

    My TechNet articles

    Friday, August 7, 2020 3:09 PM
  • Hi

    Could you please share the  dataset sample with me?

    For I could not quiet get your meaning.

    You want to count the number like (4+5+6+4+2……+6+1+2){row sum} or

    (4+40) (5+46)……(4+44)(1+35)(2+38){column sum}



    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Monday, August 10, 2020 6:24 AM