unable to preview the report in SSRS 2008

Question

Post reply

unable to preview the report in SSRS 2008

sandy1234

Say Hey Kid

Points: 673
More actions
December 9, 2010 at 4:40 pm

#232007

Hi every one,
here is my issue:
i set up a report services project in my local machine.
when i am trying to preview the report in my local machine it was showing the following error message.
An error occurred during local report processing
Failed to load expression host assembly. Details: Could not load file or assembly 'Microsoft.ReportingServices.ProcessingCore, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies.
The parameter is incorrect (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
The report is working fine in previewing the data in another machine.
But when i am set up the report project in my local machine by copying all dll files in the local report server and properly including all the References in the Report Properties Tab.
Please help me,
Thank you

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 1

Copying .dlls may not be sufficient. Some of them need to be registered.

EDIT: Did you just copy stuff from the other machine or do you actually have SSRS installed on your local box?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

sandy1234 Say Hey Kid Points: 673 More actions · Answer 2

Thanks for the reply Brandie,

In my local computer SSRS 2008 is installed properly.

I copied the references properly and added the references to the report layout.

in the RSPreviewPolicy.dll file code i included AAC.CustAssembly2007.dll,

AAC.RSLocalize2007.dll files location which are necessary to set up in local machine.

but still getting the same error in the preview mode of the report.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 3

Do you know what parameter the error message is referring to?

EDIT: This is an old thread, but it might be able to help you. http://www.bigresource.com/Tracker/Track-ms_sql-0kT9qz2f/[/url]

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

sandy1234 Say Hey Kid Points: 673 More actions · Answer 4

The same report solution is able to give proper preview in another system in which my colleague can able to preview the report.

When i access the same solution through Team foundation server in my local machine, First i am unable to build the report becasue of improper references in the local machine then i overcome that issue through by properly matching the references in the local report server.

Now here is main culprit RSPreviewPolicy.dll file, I believe this is giving me this trouble.

is this information help full to get some conclusion

thank you

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 5

Have you registered the .dll as I first suggested?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.