September 7, 2006 at 3:53 pm
A developer here created a report for reporting services that uses a matrix to display the result set.
It runs great from visual studio 2005.
But once it is deployed to the reporting server the results are all Zero.
I added a table to the report to be sure that the fields had different values in them. (Which they do.) But it will not populate the matrix.
I have ran the report from visual studio on different boxes (even on the reporting server it self) and the report looks great. But once deployed it again shows all Zeros instead of the correct number.
I would appreciate any help I can get.
September 8, 2006 at 11:11 am
Wyat is your datasource ?
September 8, 2006 at 3:32 pm
I am using a sql shared datasource.
September 10, 2006 at 3:47 pm
just a thought but is the report server SS2005 or SS2000? I seem to recall that VS2005 editted reports don't work properly on SS2000.
htp
Martin
November 3, 2006 at 9:01 am
We found the Reason for the issues.
The preview tab does not use the dot net CAS (Code Access Security).
But if you do the local debug or any other reporting service deployment then the CAS comes into play.
The matrix was not the problem it was the custom code on the code tab that could not access the data set.
Thanks for the suggestions.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply