Showing posts with label adventure. Show all posts
Showing posts with label adventure. Show all posts

Sunday, March 11, 2012

Can't run reports in Report Builder

I've followed the Adventure Works tutorial for Report Builder, but when I click Run Report I get this error message:

Report execution error
The report might not be valid or the server could not process the data.

Input string was not in a correct format.
-
Remote GDI stream version: 10.0.1. Expected version: 10.0.1.

Any ideas?

Most likely this is happening because you're running with regional settings on the client not equal to US English.

I'm always getting this error after a new installation, but when I switch from Norwegian to US English Regional Settings, the error disappears.

Trond

|||

Yes, switching the regional settings to US English should work for CTP builds.
Note: the underlying issue is fixed for the final SQL Server 2005 RTM release.

-- Robert

|||Thanks guys, that worked.

/Jonas|||Hello

I have a similar problem, but when I create a pivot table connecting to an OLAP cube in SQL2005. This does not work and I get an error message saying: XML for analysis parser: The lovalidentifier property is not overwriteable .....

If I change my settings from swedish to American English it works.
Can I say to my customer that Ii also will be fixed in the final release?

Thanks
/Martin

Saturday, February 25, 2012

can't open adventure works example

after running msi, can't open this solution

C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Standard, select the file Adventure Works DW.sln

error msg
Microsoft Visual Studio

The application for project 'C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\standard\Adventure Works DW Standard Edition.dwproj' is not installed.

Make sure the application for the project type (.dwproj) is installed.

error msg

Did you install it some other folder than the one stated below ? Or did you not install the samples libarary ? Then you won′t find the information in this folder. You can install the samples from disks afterwards, juzst launch the explorer and use the custom installation type.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||It's installed exactly where shown, but there are no instructions on how to install .dwproj|||ARe you installing SQL Server Express ? SQL Server Analysis Services isn′t shipped with Express so you should get the project files from another edition than express.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||yes I'm using sql express the advanced edition which is supposed to support the adventureworks sample|||Express does not support Analysis Services, you are trying to open the analysis services sample for adventure works, try one of the others.