Hi ,

I have two dimensional tables 

1. product - primary key for table is  product_id ( value name: product_name)

2. Calendar  -primary key is calendar_date 

And I have a  sales table which is a measure having:

product_id, summary_date,quantity,amount

 so I want to generate a report using SSRS in the following format

Please help me in getting the report following format . I am new to ssrs, I tried using matrix format but i am not able to generate mentioned report

• Edited by ganesh_439 2 hours 25 minutes ago

So you always want report to show data for current year in above format? or does it have to be user interactive and run for the year chosen?

I want it to be user interactive based on the filter selected on 'Date'.