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://ift.tt/19nLNVq http://ift.tt/1iEAj0c
No comments:
Post a Comment