none
How to create a table?

    Question

  • Hi,

    Could someone help me figure out how to create this sort of table? I tried using Matrix and Table option but can't find a way to do it.

    So for specific account, I want to have my Year under Columns, so 2008, 2009, etc

    and I want my Revenue, Expenses, Marketing under rows.

    Something like:

      2008 2009 2010 2011 2012
    Revenue          
    Expenses          
    Marketing          

    Wednesday, April 02, 2014 4:41 AM

Answers

  • As i see from your requirement what you need is a matrix container inside SSRS. You need to add three rows inside matrix for and add year to column grouping to get years onto different columns. I assume when you say you need for a specific account you would need a parameter for that through which user will input required account value. So just create a parameter to pass account and use it to filter report data. You may chose to prefill it with value by attaching dataset to it in parameter properties however if number of accounts are large i would recommend keeping it as a textbox for user to type in values rather than make it a combobox with available values.

    So the container would look like below

    And you can add the required fields in data portions


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, April 02, 2014 5:59 AM

All replies

  • Without knowing the structure of your base tables, I'd say you might want to have a look on pivotizing your data:

    http://technet.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx

    If you want a more detailed help, you will have to give us the structure and some example content of the table you want to query.



    • Edited by C0mmander Wednesday, April 02, 2014 4:50 AM
    Wednesday, April 02, 2014 4:49 AM
  • Hello,

    That's a Pivot table and yes you can create such a table in SSRS 2008 and higher Version. See MSDN Matrices (Report Builder and SSRS) => First example with the countries, or http://www.youtube.com/watch?v=vgtVJf21EXU


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, April 02, 2014 4:53 AM
  • As i see from your requirement what you need is a matrix container inside SSRS. You need to add three rows inside matrix for and add year to column grouping to get years onto different columns. I assume when you say you need for a specific account you would need a parameter for that through which user will input required account value. So just create a parameter to pass account and use it to filter report data. You may chose to prefill it with value by attaching dataset to it in parameter properties however if number of accounts are large i would recommend keeping it as a textbox for user to type in values rather than make it a combobox with available values.

    So the container would look like below

    And you can add the required fields in data portions


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, April 02, 2014 5:59 AM