forum.venkateswarlu.net
      Register      Login
Matrix Report

1 replies to this topic

Duncan Rhoden #1
Member
14 Points
Posted on 11 Dec 2011 06:47 AM IST What are the steps in creating a matrix report? 
SSRS     849 views     Reply to this topic
Aditya Janardhana #2
Member
12 Points
Replied on 13 Dec 2011 09:22 AM IST In the Report Wizard, select Matrix Report as the report type, and select the Opportunities module.
Select ” Sales Stage is Closed Won” as the filter, and click Next.
Select “User Name” and “Month: Expected Close Date” as the group-by columns, and click Next.
Add SUM:Amount as a Display Summary column, and click Next. “User Name” and “Month:Expected Close Date” are automatically selected for Display Summaries.
Optionally, select a chart type, and click Next.
On the Report Details page, select Opportunities>Assigned to User as the optional related module.
Run the report. 
Reply to this topic