SSRS Table data displays in VS 2005 but not report manager

[Shiloy]

I created a report which has 3 tables in it. Each table has 1 group. The first column of the table has client demographic data and the second and third columns contain a sub report of all the services that client received. Second table is by vendor and what services they provided us. Third is just totals. There is also on textbox on the report which uses a data source that is coded in the report. The others use stored procedures.

The report and sub reports work fine in Visual Studio but when I deploy the tables that use stored procedures do not work. I get nothing. The textbox that has the data source with the code in it works. I had this working and then the user wanted me to separate the reports by social worker. I created three linked reports. I noticed a total was not right so I went in to correct and then redeployed and now it does not work. It has to something easy but I cannot find it. I have been working on this for about 10 hours. I do not get any error message either.

It is like it is ignoring my parameters and why does in work in Visual Studio?

Can anyone point me in the right direction?
thanks

 

[xlbo]

potentially it is security on your stored procedures (although I would expect an error message) - your data source in report manager may be set up differently to the one in VS so the credentials being passed to the database may not have exec permission on the stored procs

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question