Data #ERROR in Report Manager but not Designer RRS feed

  • Question

  • 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.





    Thursday, March 29, 2007 12:38 AM

All replies

  • 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.

    Thursday, March 29, 2007 1:31 AM
  • Yes, a list of zones are coming back from the cube. It's their associated measures that are displaying the error.
    Thursday, March 29, 2007 1:41 AM
  • Is there any security on the cube?


    Also, is it a matrix or tabular layout?

    Thursday, March 29, 2007 2:52 AM
  • 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..
    Thursday, March 29, 2007 3:11 AM
  • Well, that exhausted my short list of possibilities. Smile


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

    Thursday, March 29, 2007 4:11 AM
  • I know.. its confusing ey!!


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

    Thursday, March 29, 2007 4:49 AM