Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SKP
Starting Member
34 Posts |
 Posted - 2008-05-27 : 06:02:49
|
| Hi Guys,I am creating a report in Reporting Services 2000. I have a stored procedure that returns 4 columns with one column having 21 weeks of entries in it. I am using matrix to group these 21 weeks as 21 week columns created dynamically but when I preview the report it is only displaying columns for first 5 weeks. Any idea why Reporting services is not displaying the rest of the columns? Any limitation on maxiumum number of columns that can be generated dynamically in SSRS 2000?Any help will be highly appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-27 : 06:09:27
|
| Do you have data for the rest of weeks? The matrix creates a column based on data and so if there's no data for a week you wont get the column corresponding to week. |
 |
|
|
SKP
Starting Member
34 Posts |
Posted - 2008-05-27 : 06:20:15
|
| Hi Visakh,I have the data for all the weeks.Here is the table for you:Classname Availability Total WeekNoActive Resources Assigned 640 1Active Resources NotAssigned 116 1Active Resources Assigned 780 2Active Resources NotAssigned 155 2Active Resources Assigned 801 3Active Resources NotAssigned 144 3Active Resources Assigned 814 4Active Resources NotAssigned 138 4Active Resources Assigned 791 5Active Resources NotAssigned 149 5Active Resources Assigned 837 6Active Resources NotAssigned 126 6Active Resources Assigned 875 7Active Resources NotAssigned 106 7Active Resources Assigned 850 8Active Resources NotAssigned 119 8Active Resources Assigned 842 9Active Resources NotAssigned 122 9Active Resources Assigned 845 10Active Resources NotAssigned 122 10Active Resources Assigned 877 11Active Resources NotAssigned 106 11Active Resources Assigned 911 12Active Resources NotAssigned 89 12Active Resources Assigned 875 13Active Resources NotAssigned 107 13Active Resources Assigned 857 14Active Resources NotAssigned 114 14Active Resources Assigned 807 15Active Resources NotAssigned 138 15Active Resources Assigned 790 16Active Resources NotAssigned 146 16Active Resources Assigned 774 17Active Resources NotAssigned 154 17Active Resources Assigned 781 18Active Resources NotAssigned 153 18Active Resources Assigned 791 19Active Resources NotAssigned 148 19Active Resources Assigned 850 20Active Resources NotAssigned 119 20Active Resources Assigned 189 21Active Resources NotAssigned 14 21Associate NotAssigned 52 1Associate NotAssigned 65 2Associate NotAssigned 65 3Associate NotAssigned 65 4Associate NotAssigned 65 5Associate NotAssigned 65 6Associate NotAssigned 65 7Associate NotAssigned 65 8Associate NotAssigned 65 9Associate NotAssigned 65 10Associate NotAssigned 65 11Associate NotAssigned 65 12Associate NotAssigned 65 13Associate NotAssigned 65 14Associate NotAssigned 65 15Associate NotAssigned 65 16Associate NotAssigned 65 17Associate NotAssigned 65 18Associate NotAssigned 65 19Associate NotAssigned 65 20Associate NotAssigned 13 21AX Consultants Assigned 16 1AX Consultants Assigned 20 2AX Consultants Assigned 20 3AX Consultants Assigned 20 4AX Consultants Assigned 20 5AX Consultants Assigned 20 6AX Consultants Assigned 20 7AX Consultants Assigned 20 8AX Consultants Assigned 20 9AX Consultants Assigned 20 10AX Consultants Assigned 20 11AX Consultants Assigned 20 12AX Consultants Assigned 20 13AX Consultants Assigned 10 14AX Consultants NotAssigned 5 14AX Consultants Assigned 10 15AX Consultants NotAssigned 5 15AX Consultants Assigned 10 16AX Consultants NotAssigned 5 16AX Consultants Assigned 10 17AX Consultants NotAssigned 5 17AX Consultants Assigned 20 18AX Consultants Assigned 16 19AX Consultants NotAssigned 2 19AX Consultants Assigned 16 20AX Consultants NotAssigned 2 20AX Consultants Assigned 4 21Consultant Assigned 16 1Consultant Assigned 16 2Consultant NotAssigned 2 2Consultant Assigned 20 3Consultant Assigned 20 4Consultant Assigned 18 5Consultant NotAssigned 1 5Consultant Assigned 18 6Consultant NotAssigned 1 6Consultant Assigned 18 7Consultant NotAssigned 1 7Consultant Assigned 18 8Consultant NotAssigned 1 8Consultant Assigned 18 9Consultant NotAssigned 1 9Consultant Assigned 18 10Consultant NotAssigned 1 10Consultant Assigned 20 11Consultant Assigned 20 12Consultant Assigned 20 13Consultant Assigned 20 14Consultant Assigned 10 15Consultant NotAssigned 5 15Consultant Assigned 2 16Consultant NotAssigned 9 16Consultant Assigned 2 17Consultant NotAssigned 9 17Consultant Assigned 8 18Consultant NotAssigned 6 18Consultant Assigned 20 19Consultant Assigned 10 20Consultant NotAssigned 5 20Consultant Assigned 2 21Consultant NotAssigned 1 21 |
|
|
|
SKP
Starting Member
34 Posts |
Posted - 2008-05-27 : 06:36:25
|
| Visakh,I have found the cause of problem.Even if i set the dates for start and end of the period to make 21 weeks, when i click preview report it changes it to 5 weeks only, so I have to reset the end date in the preview report to desired end date and i am getting all the weeks appearing now.Thanks for you time again. |
|
|
|
|
|
|
Only 5 columns being displayed in Matrix