May 6, 2011 at 2:01 pm
hi, i am new to ssrs and am attempting to create a matrix report, i have a stored procedure which returns a resultset returning
student name - subjects - subject fullname - scores - region - indicator1 - indicator2 - flag1 - flag2
i need the matrix report to display me
student name as rows
subjects as columns
and scores as data
so this would give me output as
english maths science
north
student1 90 89 99
student2 76 67 89
student3 56 67 78
south
student1 90 89 99
student2 76 67 89
student3 56 67 78
east
student1 90 89 99
student2 76 67 89
student3 56 67 78
west
student1 90 89 99
student2 76 67 89
student3 56 67 78
in the stored procedure i am inserting 4 rows in a temp table which returns the resultset
the 4 rows contain north,south,east,west as values in studentname column and 1,2,3,4 as values in rank1 column and 0 as value in rank2
i order by resultset on rank1, rank2, desc, studentname, subjects
problem is when i create a report the only rows i see on it are the ones i inserted with north,south,east,west values.
i do not see and student names and scores being returned, where as when i execute the stored procedure i see the output as i intend to see.
any advice would be great.
thanks.
May 6, 2011 at 2:29 pm
How does your temp table only have 4 rows?
May 6, 2011 at 2:43 pm
no there are around 2000+ table which i get from my tables in database but i get only those 4 back which i had inserted.
May 6, 2011 at 4:20 pm
If you are only getting 4 of 2000 rows back, and you should be getting more, then there is either a problem with your data or your query, you should be looking there.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply