on 11-01-2015 8:27 PM
We're migrating a .NET app from a Server 2008 environment to Server 2012. Installed the latest SP15 SAP for VS on the Dev server which runs VS 2013, and the installed the accompanying SP15 runtime MSI on the web server. Authentication to the SQL server is working fine, but when I click the link to open the report it's just blank (picture attached)...I don't even get the expected parameter screen. Any ideas?
Notes:
Any ideas on how to fix this or things to try?
I've got some Process Monitor output I'll add to this post soon.
Thanks!
Process Monitor entries created when trying to open a report via my .NET app that aren't marked as SUCCESS:
NO MORE ENTRIES:
RegEnumValue - HKLM\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Report Application Server\InprocServer
NAME NOT FOUND:
RegOpenKey - HKCU\Software\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\Locale
RegOpenKey - HKCU\Software\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\Database
RegOpenKey - HKCU\Software\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV
BUEFFER OVERFLOW:
RegQueryValue - HKLM\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Enterprise\InstallRoot\Path
QueryAllInformationFile - E:\MySite\aspnet_client\system_web\4_0_30319\crystalreportviewers13\promptengine-compressed.js
FILE LOCKED WITH ONLY READERS:
CreateFileMapping - C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64\smagentapi.dll
There were more entries, but most were duplicates or similar to the ones above.
Edit: I added those missing keys above and after trying it again I got many more NAME NOT FOUNDS for keys that are supposed to be under the ones I added. Maybe the application didn't install correctly. I'll try a reinstall but that's already been done a few times. This is the MSI package I'm using - http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_64bit_13_0_15.zip
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for the reply Don!
I tried changing my Page_Load section to the Page_Init section and that didn't do it.
Those registry keys listed under "NAME NOT FOUND" group (and many others that are supposed to be under that the listed keys) do not exist.
I neglected to mention that I'm currently running the IIS App Pool as my user account, which has admin permissions on the web server.
Any other ideas?
Hi Albert,
Those missing reg keys are a little misleading actually. Most have default values set in our dll's, they look to see if the default behavior has been changed through a reg key.
Most are access denied errors that you need to look for.
Try creating a new report, no database and just drop a text object with "Hello World" in it and see if that works. Try starting from the basics...
Don
Hi Don,
I created a blank report with with text objects and it displayed correctly in my ReportViewer control. I also added a selection criteria and data field to that blank report and that field displayed on the report correctly too.
Good news: I added a parameter field to this basic report and while working just fine in preview mode, when the report is deployed to the server in question, the parameter window does not appear like all the other more complicated reports.
Any ideas on a fix?
When I hit F12 and attempt to load a report I get a 'bobj' is undefined error. Attached to this post is the code directly above that error.
Reading through the code I discovered I was missing the aspnet_client folder (copied from the inetpub/wwwroot directory) at the root of my website, and after placing the folder there my reports work!
Thanks so much for your help Don!
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.