Last post Nov 10, 2010 01:03 AM by You-Hu Fu
Nov 05, 2010 03:01 AM|zahidzia|LINK
I am working on a appliaction in which I have a following schema
Task_Count (can be any number like 2 or 3 or 4 or 40)
the Input Form is like that which the staff will fill at the end of the day.
24/01/2010 | How many cheque books issued today | 12
24/01/2010 | How many ATM Issued today | 7
Now I want a matrix report showing all tasks suppose 28 tasks in vertical row and on given month it should show all the dates of the particular month horizontal direction like from 1 to 31 days or 30 or 28 as per month days with the task_count using PIVOT
in query. i am failed to produce the result as i dont know to make it work. please help.
SQL Server 2008
Nov 10, 2010 01:03 AM|You-Hu Fu|LINK
Now you have below data:
You want to display below :
Date | Task Name | Task_Count
I think you could join two data block together utilizing external key Tast_ID, then add a table control to your report to display the top report layout.