To
display crystal report (with ASP.NET 4.0) from the IIS7 production server, following steps are requried... (it worked for me and hopefully will work for you too...)
Step 1:
Installing Microsoft Data Access Components (MDAC) 2.8 Software Development
Kit.
2. Service
Pack 1 of MDAC from the link: http://www.microsoft.com/en-us/download/details.aspx?id=5793
Step 2:
Adding ASP.NET 4.0 as Application Pool on IIS 7
1. Open your command prompt (Windows + R) and type
You may need to start this as an administrator if you have UAC enabled.1. Open your command prompt (Windows + R) and type
cmd
and press ENTERTo do so, locate the exe (usually you can start typing with Start Menu open), right click and select "Run as Administrator"
2. Type cd C:\Windows\Microsoft.NET\Framework\v4.0.30319\ and press ENTER
3. Type
aspnet_regiis.exe -ir
and press ENTER again.
·
If this is a fresh version of IIS (no other sites running on it)
or you're not worried about the hosted sites breaking with a framework change
you can use -i instead of -ir. This
will change their AppPools for you and steps 5-on shouldn't be necessary.
·
at this point you will see it begin working on installing .NET's
framework in to IIS for you
4. Close the
DOS prompt, re-open your start menu and right click Computer and
select Manage
5. Expand
the left-hand side (Services and Applications) and select Internet
Information Services
·
You'll now have a new applet within the content window exclusively
for IIS.
6. Expand
out your computer and locate the Application Pools node, and
select it. (You should now see ASP.NET v4.0 listed)
7. Expand
out your Sites node and locate the site you want to modify
(select it)
8. To the
right you'll notice Basic Settings... just below the Edit
Site text. Click this, and a new window should appear
9. Select
the .NET 4 AppPool using the Select... button
and click ok.
10. Restart
the site, and you should be good-to-go.
(You can repeat steps 7-on for every site you want to apply .NET 4
on as well).
Step 3:
Copying "aspnet_client" folder into your web
application directory
Take this content:
C:\inetpub\wwwroot\aspnet_client
And copy to here:
C:\inetpub\wwwroot\WebAppFolderName\aspnet_client
(I installed IIS root directory in C: drive)
Step 4:
Modify web.config file
Add following section into web.config file...
<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime
version="v4.0"/>
<requiredRuntime
version="v4.0.20506"/>
</startup>
Now, you are done setup Crystal Report withASP.NET 4.0 into the production Server...
Enjoy!!!
Hi, I have a project, in my developer's machine works good, but when i publish into server IIS 7, the CR's XI report don´t show or export. My report have a ODBC link with a database in SQL, the error thats exactly the connection with de database, I follow you tuto, and i don´t have results. any idea?
ReplyDeleteI believe you used .net 4.0
ReplyDeleteI embedded CR withing the source code (did not use ODBC)... I have to go through with ODBC too...
please check whether CR runtime is installed in the server pc...
ReplyDeletelink: http://www.businessobjects.com/jump/xi/crvs2010/us2_default.asp