Crystal Report

To Levis.

Sorry, I am not Babu, but will try to help you. In Cr8 you were able to correct this in such way: go to Database menu, Set Location; in Location section in Table text box delete database name and other stuff, leave only table name. It worked in CR8.

Victor

Hi,

Thx for ur help. I used to delete the database name in cr8 or 8.5.
But this is no longer working in cr9 as the set location become a one to one mapping between reporting tables and current connection tables. And the user cant directly touch the generated sql anymore...

:(

hi babu,
i created a crystal report based on Access Database through ADO connection. Can i use the same report for other backend databases like SQL server/Oracle without changing the report ?

Or is there anyway to change the connecting string property through VB code?


please help me

thanks

Hi,
I want to know how I can creat a Cystal Report with vb code ,
not using Cystal Reprot designer. would you like to help me?

Use RDC for develop crystal report from vb, available in cr 8.5

Quote:

---

Originally posted by nwy
Hi,
I want to know how I can creat a Cystal Report with vb code ,
not using Cystal Reprot designer. would you like to help me?

---

Hi Babu,
I have a report that displays a set of data. Here, one requirement is, when one field is say 'High', I have to display one red image. If it is 'Medium' I have to display 'Green' and so on. I am using Crystal reports 9.
Thanks in advance
Pooran

1.
I am trying to export to .pdf format from exe file.
it fails without error message.
got few solution from crystaldecisions.net but no help
but it runs well with vb

how to solve?.
thanks in advance.

2. i am printing a report in line printer (very old).

but when i print string field, if the value is empty "" the alignment all goes out, how to solve.

same applies to the fields whose rows missing for the child table.
for ex, if master table contains 100, child 25 only. the alignment for 25 & 75 is different like

emp name emp no dept name dept no

john 1101 IT 10
Ken 1201

Iam using below code

rpttoview="E:\Manju\ERP\Reports\DCReport.Rpt"


' Only create the Crystal Application Object on first time through
If Not IsObject ( session ("oApp")) Then
Set session ("oApp") = Server.CreateObject("Crystal.CRPE.Application")
End If
Set oApp = Server.CreateObject("Crystal.CRPE.Application")
' Turn off all Error Message dialogs
Set oGlobalOptions = oApp.Options
oGlobalOptions.MorePrintEngineErrorMessages = 0

' Open the report
If IsObject(session("oRpt")) then
Set session("oRpt") = nothing
End if

Set session("oRpt") = session("oApp").OpenReport(rpttoview,1)
Set oRpt = oApp.OpenReport(rpttoview,1)
' Turn off sepecific report error messages
Set oRptOptions = oRpt.Options
oRptOptions.MorePrintEngineErrorMessages = 0

Iam getting the following error.

CPEAUT Error Ocured on Server.
20614: Starting background processing failed.

Hi Babu,

I need your help on my web application that using crystal report as reporting system module.

The problem is the report gradualy stuck when generating report. Then we restart the system again, but the performance wont budge. I check the system performance (we use win2k as the server) on SQLServer.GeneralStatistic.User Connection and it count more then 500.000 connection.

TIA.

hi Babu,

Iam using below code get my report in browser but Iam getting the error.

Error No is :20614
Starting background processing failed.

one more method Iam using that is directly giving the link the report <a href=report1.rpt?user0=sa&password>Show Report</a>
If I give this user can view database server Used Id & Password,
how to avoid this.

Please help me,

Thanks in Advance

-------Code-------
Set oConn = Server.CreateObject("ADODB.Connection")
sconnection="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;pwd=test;Initial Catalog=TestDB;Data Source=MYSERVER"

oConn.Open(sconnection)

set session("oRs") = Server.CreateObject("ADODB.Recordset")
session("oRs").ActiveConnection = oConn

session("oRs").Open "SELECT [Comp_Name], [Address], [City] FROM Company"
reportname = "TestReport5.rpt"
' CREATE THE APPLICATION OBJECT

If Not IsObject (session("oApp")) Then
Set session("oApp") = Server.CreateObject("Crystal.CRPE.Application")
End If





Path = Request.ServerVariables("PATH_TRANSLATED")
While (Right(Path, 1) <> "\" And Len(Path) <> 0)
iLen = Len(Path) - 1
Path = Left(Path, iLen)
Wend


If IsObject(session("oRpt")) then
Set session("oRpt") = nothing
End if

Set session("oRpt") = session("oApp").OpenReport(path & reportname, 1)


set session("oRptOptions") = Session("oRpt").Options
session("oRptOptions").MorePrintEngineErrorMessages = 0

session("oRpt").DiscardSavedData
set Database = session("oRpt").Database


set Tables = Database.Tables


set Table1 = Tables.Item(1)

Table1.SetPrivateData 3, session("oRs")

On Error Resume Next
session("oRpt").ReadRecords
If Err.Number <> 0 Then
Response.Write err.Description & "<br>"
' Response.Write "An Error has occured on the server in attempting to access the data source"
Else

If IsObject(session("oPageEngine")) Then
set session("oPageEngine") = nothing
End If
set session("oPageEngine") = session("oRpt").PageEngine
End If

%>
<!-- #include file="SmartViewerActiveX.asp" -->

Hi

I am using crystal reports 9 in a program. The following line of code genates the error " Creation feature not enabled".
Set m_Report = m_Proj.NewReport

How can I workout this problem.

Thanks

hello, i hope you can help me with this one.

how can i display the name of the report in the title bar?

thanks...

Hi Babu

I'm using VB 6 & Crystal Report 4.6. In my VB form (frmMain) I have Text and DBGrids that has all the information from MS Access. I would like a report that have the information in frmMain. Can this be done and what books do you recommed?
Thanks

I am having difficulty in viewing reports using the OCX in my application. The user can choose to view/print 1 of 4 different reports. The problem is after viewing one, then choosing another, the window does not refresh with the new report.

Here is code to view a report:

Code:

---

void PrintThisReport()
{
                ....................................
                ................................
              ..............................

        CWnd* pWnd = FromHandle(GetReportsWindowHandle());
        CRect rect;
        pWnd->GetWindowRect(&rect);
        ScreenToClient(&rect);

        m_cReport.SetReportFileName(csPath);
        m_cReport.SetSelectionFormula(csSelection);

        m_cReport.SetWindowLeft(0);
        m_cReport.SetWindowTop(0);
        m_cReport.SetWindowWidth(rect.Width());
        m_cReport.SetWindowHeight(rect.Height());
        m_cReport.SetWindowParentHandle((long)pWnd->GetSafeHwnd());
               
        if(m_cPreview.GetCheck())
                m_cReport.SetDestination(0); // To window
        else
                m_cReport.SetDestination(1); // To printer
        m_cReport.PrintReport();
        m_cReport.Reset();
}

---

If I called this function twice via Button Click, change the selection formula, the report doesn't change!

Mike B

I'm using the VB code below to generate a report but the crystal report keep on complaining
"ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]An ORDER BY clause is invalid in views, derivied tables, and subqueries unless TOP is also specified"

Dim sSQL As String

sSQL = "Select SalesForceDetail.SFID,SalesForceDetail.SFName,SalesForceDetail.CustID,customer.Name
From SalesForceDetail, customer Where SalesForceDetail.CustID = customer.CustID
And SalesForceDetail.CustId In (select CustID from SalesForceDetail
Group by CustID having count(CustID) > 1 ) Order by SalesForceDetail.CustID"

With CrystalReport1
.Connect = gblDSN
.SQLQuery = sSQL
.ReportFileName = App.Path & "\Report\SalesForceCustomerDetail.rpt"
.Action = 1
End With

Please help