473,385 Members | 2,014 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Crystal Report XI Business Object error

Hello All i am using Bisness object Crystal Report XI version and installed it on my server.
I have checked to installed as server. I am using the following code to connect and display the Report file i have created with store procedure in Sql Server 2005.
The code is as below::::



__________________________________________________ _____
1. SimplePreviewReport.asp
Expand|Select|Wrap|Line Numbers
  1. <%@ LANGUAGE="VBSCRIPT" %>
  2.  
  3. <%
  4. reportname = "SimplePreviewReport.rpt"
  5. %>
  6.  
  7. <!-- #include file="AlwaysRequiredSteps.asp" -->                       
  8. <!-- #include file="MoreRequiredSteps.asp" -->
  9. <!-- #include file="SmartViewerActiveX.asp" -->    
  10.  
2. AlwaysRequiredSteps.asp
Expand|Select|Wrap|Line Numbers
  1. <%                                                                    
  2. If Not IsObject (session("oApp")) Then                              
  3.   Set session("oApp") = Server.CreateObject("CrystalRuntime.Application.11")
  4. End If                                                               
  5.  
  6. Path = Request.ServerVariables("PATH_TRANSLATED")                     
  7. While (Right(Path, 1) <> "\" And Len(Path) <> 0)                      
  8. iLen = Len(Path) - 1                                                  
  9. Path = Left(Path, iLen)                                               
  10. Wend                                                                  
  11.  
  12. If IsObject(session("oRpt")) then
  13.     Set session("oRpt") = nothing
  14. End if
  15.  
  16. On error resume next
  17.  
  18. Set session("oRpt") = session("oApp").OpenReport(path & reportname, 1)
  19.  
  20. If Err.Number <> 0 Then
  21.   Response.Write "Error Occurred creating Report Object: " & Err.Description
  22.   Set Session("oRpt") = nothing
  23.   Set Session("oApp") = nothing
  24.   Session.Abandon
  25.   Response.End
  26. End If
  27.  
  28. session("oRpt").MorePrintEngineErrorMessages = False
  29. session("oRpt").EnableParameterPrompting = False
  30. 'session("oRpt").DiscardSavedData
  31. %>
  32.  
3. MoreRequiredSteps.asp
Expand|Select|Wrap|Line Numbers
  1. <%
  2. session("oRpt").ReadRecords
  3.  
  4. If Err.Number <> 0 Then                                               
  5.   Response.Write "Error Occurred Reading Records: " & Err.Description
  6.   Set Session("oRpt") = nothing
  7.   Set Session("oApp") = nothing
  8.   Session.Abandon
  9.   Response.End
  10. Else
  11.   If IsObject(session("oPageEngine")) Then                              
  12.       set session("oPageEngine") = nothing
  13.   End If
  14.   set session("oPageEngine") = session("oRpt").PageEngine
  15. End If
  16. %>
4. SmartViewerActiveX.asp
Expand|Select|Wrap|Line Numbers
  1. <HTML>
  2. <HEAD>
  3. <TITLE>Crystal Reports ActiveX Viewer</TITLE>
  4. </HEAD>
  5. <BODY BGCOLOR=C6C6C6 ONUNLOAD="CallDestroy();" leftmargin=0 topmargin=0 rightmargin=0 bottommargin=0>
  6. <OBJECT ID="CRViewer"
  7.     CLASSID="CLSID:6F0892F7-0D44-41C3-BF07-7599873FAA04"
  8.     WIDTH=50% HEIGHT=50%
  9.     CODEBASE="../viewer/ActiveXViewer.cab#Version=11,5,0,261" VIEWASTEXT>
  10. <PARAM NAME="EnableRefreshButton" VALUE=1>
  11. <PARAM NAME="EnableGroupTree" VALUE=1>
  12. <PARAM NAME="DisplayGroupTree" VALUE=1>
  13. <PARAM NAME="EnablePrintButton" VALUE=1>
  14. <PARAM NAME="EnableExportButton" VALUE=1>
  15. <PARAM NAME="EnableDrillDown" VALUE=1>
  16. <PARAM NAME="EnableSearchControl" VALUE=1>
  17. <PARAM NAME="EnableAnimationControl" VALUE=1>
  18. <PARAM NAME="EnableZoomControl" VALUE=1>
  19. </OBJECT>
  20.  
  21. <SCRIPT LANGUAGE="VBScript">
  22. <!--
  23. Sub Window_Onload
  24.     On Error Resume Next
  25.     Dim webBroker
  26.     Set webBroker = CreateObject("CrystalReports115.WebReportBroker.1")
  27.     if ScriptEngineMajorVersion < 2 then
  28.         window.alert "IE 3.02 users on NT4 need to get the latest version of VBScript or install IE 4.01 SP1. IE 3.02 users on Win95 need DCOM95 and latest version of VBScript, or install IE 4.01 SP1. These files are available at Microsoft's web site."
  29.     else
  30.         Dim webSource
  31.         Set webSource = CreateObject("CrystalReports115.WebReportSource.1")
  32.         webSource.ReportSource = webBroker
  33.         webSource.URL = "RDCrptserver115.asp"
  34.         webSource.PromptOnRefresh = True
  35.         CRViewer.ReportSource = webSource
  36.     end if
  37.     CRViewer.ViewReport
  38. End Sub
  39. -->
  40. </SCRIPT>
  41.  
  42. <script language="javascript">
  43. function CallDestroy()
  44. {
  45.     window.open("Cleanup.asp");
  46. }
  47. </script>
  48.  
  49. </BODY>
  50. </HTML>
  51.  
__________________________________________________ ______
This code throws the following error:
Server object error 'ASP 0177 : 8007007e'

Server.CreateObject Failed

/Reports/AlwaysRequiredSteps.asp, line 3

8007007e
........................
actually i have download this code from some where in the net to display the report file via custom ASP 3. but i have tried of my best for last 2 months and i am failed to display the report in my asp page.
So, if some one please help me in this regards I will be always remember him in my prayers.
thanks in advance.
Sep 29 '08 #1
2 9151
jhardman
3,406 Expert 2GB
check the documentation from where you downloaded this code - there should be something steering you toward something you need to install or register.

Jared
Oct 2 '08 #2
where did u get the software crystal report business object, i want to buy,borrow or steell..can u tel me ..
Oct 5 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Bob Skutnick | last post by:
Help.... I've created an ADO.NET dataset in Visual Studio (a web project). I build the project and then try to create a Crystal Report using the dataset. When I try to use the ADO.NET dataset...
1
by: Ron Holmes | last post by:
I posted this question on the Crystal Reports Support site and I am still waiting for an answer. Using Crystal Reports 9.0 Developer Full edition: My Crystal report .RPT file has a Picture box...
1
by: Karthic | last post by:
When i right click on the .rpt file in the VS 2003, i see a property printer setting. It says "No printer" on the top and there is option to select printer and paper settings etc.. I want to...
17
by: Peter Proost | last post by:
Hi Group, I've got an interesting problem, I don't know if this is the right group but I think so because everything I've read about it so far says it's a .net problem. Here's the problem, we're...
0
by: Chris | last post by:
I have the following situation in a VB.Net App I am working on: 1.)A report created in VS.Net 2003 using the CR.Net component of VS 2003. 2.)The datasource for the report is a Stored Proc in a...
3
by: lodatokab | last post by:
I'm have problem to run crystal report (VS 2005) on my computer with Windows 2000 Server. I run the solution in my dev envroiment (Windows XP) and no problems. When I try to run in on IIS 5.0 on...
1
by: Kbalz | last post by:
Having a really hard time finding solid examples on deploying a CR .NET applcation on my intranet. I'll explain what I've done so far, and toward the bottom is where I can't print using the report...
1
by: =?Utf-8?B?VGVycnk=?= | last post by:
I am brand new to using Crystal Reports and am trying to generate a report based on a custom object - in another project. I have a layered design, with all my business objects in a seperate...
3
by: Miro | last post by:
Hi, Just wondering what a good book is on visual studios 2008 ( or 2005 if no 2008 ) that teaches you how to properly use crystal reports with it. Or im assuming that as long as I can create a...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.