Subreports problem

[Crowley16]

I've got a strange problem with on of my test servers.

On my development server, a report which contains 7 subreports works fine, however when I deploy it onto my test server the sub reports doesn't appear on the main report.

If I open the sub reports individually, then they all work fine. Also, when I open up the report in Visual Studio on the test server, it works fine.

This seems to point to a reporting services problem, but I'm all patched up and the other reports all work, so am at a loss to say what the problem is.

Anyone got any ideas?

Thanks

--------------------
Procrastinate Now!

 

[xlbo]

Are all sub repor6ts also deployed to test server?

are credentials the same on the test server?

are data sources the same with same access rights on test server?

Are any errors generated when running on the test server?

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

 

[Crowley16]

all subreports are deployed, and in the same directory, and all run fine on thier own.

I have modified the datasources to use admin accounts, with the same results.

the report behaves very strangely.

When it is first opened (default parameters), it will just show the title text box on the main report and no subreports, however when view report is clicked on (without changing parameters) then the server comes up with an "internal server error, check logs".

If the parameters are changed, it goes back to just showing the text box.

I've looked at the logs as well, and don't really get anything useful. I can post the logs if you think it'll help...

--------------------
Procrastinate Now!

 

[xlbo]

very odd - not seen anything like that before. It's normally a duff data source log on or something for stuff like that

Feel free to post the logs (as long as they aren't too long) - will have a look but can't promise anything

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

 

[Crowley16]

For the time being, have been assigned to do something else...

will get back to this issue later...

--------------------
Procrastinate Now!