SQL Server SSRS Reporting -

SQL Server SSRS Reporting -

i have create study in bids using sql sever 2008. below mock-up of study have develop, working on lastly 2 days. can't figure out, how build query or stored procedure it.

i need guys suggestion how possible accomplish kind of report:should utilize queries/subqueries or stored procedures ??

i have tried subquery, , struggling stored procedure stuck. cant figure out.

details:

total leads = 12, out of 12, 8 open , 4 closed

create stored procedure homecoming info in given format. may need input parameters homecoming above columns (without pretty column heading merging).

create ssrs study , point @ stored procedure source. can alter formatted results of query in study designer.

see post illustration how select stored procedure datasource

sql sql-server sql-server-2008