Data #ERROR in Report Manager but not Designer

Hi,

I'm running a report using MDX. In preview, the report displays correctly, but after deploying to Report Manager, where there were once numbers there is now '#Error'. The string fields display correctly, its just the numeric ones that are not working.

Any help is much appreciated.

Cheers,

Ali

Is anything coming back from the cube? Are dimension values being retrieved correctly?

It sounds as if the connectivity may not be working between the server and the cube.

|||Yes, a list of zones are coming back from the cube. It's their associated measures that are displaying the error.|||

Is there any security on the cube?

Also, is it a matrix or tabular layout?

|||

There's not really too much security. There is one user who has access to everything and this is the credentials used in the data source.

The report uses a table and it has previously worked on a 2000 server but has recently migrated to 2005 (referencing a 2000 cube with a 2005 dll). Other similar reports using the same dll have migrated fine, except for one which keeps asking for a user name and password.

I've copied the code from the dll and added into the dataset and am still getting the same errors.. so the problem isn't with the dlls..|||

Well, that exhausted my short list of possibilities.

Are numeric cells using any type of formula? Aggregate can be a bit flaky.

|||

I know.. its confusing ey!!

and get this.. when i try it on our production 2005 server .. it works! Something funky is going on.