Printable View
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:
If I called this function twice via Button Click, change the selection formula, the report doesn't change!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();
}
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
Hello everybody
I am trying to pass a recordset to Crystal report using a TTX file. The recordset is created by executing Stored procedure. I created the TTX file from the recordset, using the Active Driver Function CreateFieldDefFile(). but when i run the code the report does not get populated with the records. I am SQL Server2000 as the database. What am I doing wrong here? Please advise.
Thanks in advance
Dim CrAppl As New CRPEAuto.Application
Dim CrRep As CRPEAuto.Report
Dim CrDB As CRPEAuto.Database
Dim CrTables As CRPEAuto.DatabaseTables
Dim CrTable As CRPEAuto.DatabaseTable
Private Sub UserForm_Activate()
Dim oRSRate As New ADODB.Recordset
Dim oCmd As New ADODB.Command
Dim oParam As New ADODB.Parameter
Dim oConn As New ADODB.Connection
Dim sStr As String
oConn.Open sConn
Set oCmd.ActiveConnection = oConn
oCmd.CommandText = "sp_get_total_qty_rate"
oCmd.CommandType = adCmdStoredProc
Set oParam = oCmd.CreateParameter("customerid", adChar, adParamInput, 15, "AI")
oCmd.Parameters.Append oParam
Set oParam = oCmd.CreateParameter("datefrom", adDate, adParamInput, , "2003/01/01")
oCmd.Parameters.Append oParam
Set oParam = oCmd.CreateParameter("dateto", adDate, adParamInput, , "2003/01/20")
oCmd.Parameters.Append oParam
'open the ADO recordset
oRSRate.Open oCmd, , adOpenDynamic, adLockBatchOptimistic
'open the report
Set CrRep = CrAppl.OpenReport("D:\Report1.rpt")
'set the database object to the reports database
Set CrDB = CrRep.Database
'set the databaseTables object
Set CrTables = CrDB.Tables
'set the databaseTable object to the first table in the report
Set CrTable = CrTables.Item(1)
'sets our ADO recordset as the data for the first table
CrTable.SetPrivateData 3, oRSRate
'Preview the report with the ADO recordset as the data
CrRep.Preview
oRSRate.Close
End Sub
Using CR 7.0.0.0, CRW32 7.0.1.192.
Trying to run a report that is based on ADO (driver pdsmon.dll).
If there are no records in the query set that is used by the report, I receive the error 'Unable to access first record!' followed by 'SQL Server error'. I searched and saw that some others had received this error, but I think their situations were different.
Anyway, this report is based on a query, not a stored proc. It is run against either SQL Server or MSAccess. Any ideas on how to get around this error; i.e. just display the report with no records.
Hi Babu,
Thanks in advance,
I am a new comer for CRYSTAL REPORTS.
I want to create a report that doesn't contain any recordset object during design time. But During Runtime it should generate
columns according to Fields in different Tables.
Also i want to know, how can I size report designer i.e. Landscapre mode during desing time.
Thanks once again
Dharmesh
Hello,
I am using Crystal reports 8/8.5. I would like to distribute my reports to users who don't have CR on their PC. I have been able to do this to the internal users, by placing them in the web folder, and with the page server running as a service. I am not sure how i can distribute to users outside our company! I would appreciate if you could provide me some insight on the same.
Thanks.
Raj
Hi all,
Im having trouble printing from my VB app using crystal reports.
The app runs on systems having 2000,NT and 98.....I have used the generic printer driver in Crystal Reports.
The problem is the formatting is fine on prints from 2000 systems,but the same report gets screwed up if a print is fired from NT or 98 clients....
Jacob
Hello !
I know just a little bit about Crystal Report. I am a VB developper and I am lokking for a report engine. I know that Crystal Report is a good one but I have certain specification I want from a report engine.
I want a report engine having a lot of kind of pagination. For example, 2 pages by sheet... I will explain me...
If you want to print a book with 2 pages by sheet and recto-back, so on one sheet, I will have 4 pages (2 on recto, 2 on back). The problem is if I have document of 8 pages, I will need 2 sheet. I will show you with a picture (see below).
So, my question is: Do you know if Crystal Report can build that kind of report (with this pagination). If no, do you know another report engine that can do this.
Thank you very much ! :)
Patrick.
Hi all,
Does anyone know how to enable the CE8.0 to sent out email notification on the success or failure of a particular report that has been scheduled?
Our aim is to write a CSP that pass the parameters to the CE8.0 to enable this.
We hope to do this without having to upgrade to CE8.5. Has anybody done this? Please share with us. Many thanks.
best regards
Tony
Hi everybody,
Another question on CE8.0.... Is there a place where sample code can be found for writing a CSP to export scheduled rpts to diff file formats??
Can I assume that the following is relevant...
cr.Destination
cr.PrintFileName
cr.PrintFileType
If so where can I find the syntax for using them? Many thanks.
best regards
Tony
Hi,
Does anyone know how to trigger the CE8.0 to ran repeatably for a particular weekday? e.g. rpt to be generated on every monday...
we interested to know the methods avaiable to a CSP for the above...
Thanks in advance.
regards
Tony.
Hi!,
I´m trying to insert a Graph (vertical bars) on my report without success. There are three AccessDB fields that need to be shown in the graph (as a bar each).
I created a summary for these fields but apparently I can only display one bar (field) per graph.
If someone knows if it´s possible to include more than one field in a graph please let me know.
Thanks in advance.
:confused:
This is not a reply but a new thread directly to Shri K Babu.
Hi,
I am using VB6 and Crystal report for my application. While designing the report using report expert, I have used ADO with Jet 3.51 and for data I have an sql statement linking three tables from my Access database.
After designing the report, I am not able to modify the sql statement, if i want to add any more fields from the tables. When i try to modify the sql statement using verify command, i get an error message. As a result, if I want to modify my report adding some additional fields, I have to redo the entire design.
I am using CR8.
Can you help me where I am going wrong ???
thanx
Does anyone known if it support wince?
Andytim
--------------------------------------------------------
http://www.********.net
XD++ MFC Library provides Microsoft Foundation Class (MFC)/Visual C++ developers with a complete library of MFC extension classes which implement a drag and drop (e.g. VC,VB Form Editor) graphical interface.
Hi,
encountered a big problem here.
I have create a rpt with a crystalreportviewer on a aspx page. It runs well on my local machine. But when pushing it to my live server, (my database is on another machine), the following error occurred
CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
Can enlighten??
this is my codes
crpt = New CrystalReport4()
For Each myTable In crpt.Database.Tables
myLogin = myTable.LogOnInfo
myLogin.ConnectionInfo.ServerName = "server1"
myLogin.ConnectionInfo.DatabaseName = "abc"
myLogin.ConnectionInfo.UserID = "sa"
myLogin.ConnectionInfo.Password = "sa"
myTable.ApplyLogOnInfo(myLogin)
Next
CrystalReportViewer5.ReportSource = crpt
THANKS FOR ANY HELP RENDERED
Make sure your DSN are correctly refered,
and your server permission are correct.
Quote:
Originally posted by francis3
Hi,
encountered a big problem here.
I have create a rpt with a crystalreportviewer on a aspx page. It runs well on my local machine. But when pushing it to my live server, (my database is on another machine), the following error occurred
CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
Can enlighten??
this is my codes
crpt = New CrystalReport4()
For Each myTable In crpt.Database.Tables
myLogin = myTable.LogOnInfo
myLogin.ConnectionInfo.ServerName = "server1"
myLogin.ConnectionInfo.DatabaseName = "abc"
myLogin.ConnectionInfo.UserID = "sa"
myLogin.ConnectionInfo.Password = "sa"
myTable.ApplyLogOnInfo(myLogin)
Next
CrystalReportViewer5.ReportSource = crpt
THANKS FOR ANY HELP RENDERED
Don't change the sql select fields in cr, instead of this you can create query at access database whatever you need select fields names.
Then use the query from your access database to cr as a table.
Quote:
Originally posted by jojys
This is not a reply but a new thread directly to Shri K Babu.
Hi,
I am using VB6 and Crystal report for my application. While designing the report using report expert, I have used ADO with Jet 3.51 and for data I have an sql statement linking three tables from my Access database.
After designing the report, I am not able to modify the sql statement, if i want to add any more fields from the tables. When i try to modify the sql statement using verify command, i get an error message. As a result, if I want to modify my report adding some additional fields, I have to redo the entire design.
I am using CR8.
Can you help me where I am going wrong ???
thanx
Hi Babu,
I was wondering if you could advice how one would go about implementing a recursive scheduling of report on CE8.0 using CSP?
Basically our recursive report uses the same parameter and every time it runs recursively. We want the parameter to be relevant to the time run.
For example, report is scheduled to run on 29 apr 03 (Tue), and then again everyweek on the same day, granted it does run every tuesday, but the date of data to print is stuck at 29 apr 03.
How do we tell CE8.0 that when it runs a recusive report, it should get current date, week month or even year's data, so that every time it runs, relevant data is secured?
Thanks & best regards
Tony
Refer the Graph Wizard at Graph Type Report, this will help you to follow the steps easly.
Quote:
Originally posted by RIC_V
Hi!,
I´m trying to insert a Graph (vertical bars) on my report without success. There are three AccessDB fields that need to be shown in the graph (as a bar each).
I created a summary for these fields but apparently I can only display one bar (field) per graph.
If someone knows if it´s possible to include more than one field in a graph please let me know.
Thanks in advance.
:confused:
I have been trying to use crystal reports from a MFC dialog box. But I donot find any documentation on how to do it.(in Visual C++ .NET).
Any help would be appreciated,
thanks,
CA_IB_MR
Hi K. Babu
I am using VB6 and CR9. Not that Familiar with CR9.
I have a frmMain with DBGrid and text etc. that the user has entered, with that I would like to transfer the info to CR9 and was wandering how I can do this
Thanks
:)
Hi,
I 've a problem in printing report (file.rpt) from Crystal report 9 environment. I have Microsoft Windows 2000 installed in Italian Language, and Crystal report 9 installed in English Language.
When I print a report, the result is that numbers are correctly printed but characters are non correctly printed (strange combinations of symbols are printed).
If I use both Windows 2000 and Crystal Report 9 in English version, the printing works fine.
---------------------------------------------------------------------------
Another question.
What is the run time (dll) that have to be used with Crystal Report 9??
The applicatione that have to use the run time is a C++ application.
Thanks in Advance
Hi there, in my program you r supposed to be able to print a bunch of reports in one time.. All the report displays well but it will only print the last one even if it gives printer dialog after first one..
So i guess i need to wait a event saying that the display - Printing is done.. b4 trying to do the next..
My report are done in Crystal Report exported in PDF..
Any idea?
Thanks
Dear Babu,
Can you please answer my post in http://www.codeguru.com/forum/showth...hreadid=243434
I don't post it again here because it may be considered as spam.
Thanks in advance
Kishore
hi mr.Babu,
I just came to know about the forum on crystal report.
I have a problem with crystal report which I have posted a thread just now on the following link.
www.codeguru.com/forum/showthread.php?s=&threadid=243456
Can u answer me on this immediately. I am stuck on that and i need solution immediately.
my email id is
[email protected]
thanks in advance.
Ashish
Hi all,
In my previous thread i have mentioned that I tried to connect to oracle database through crystal report wizard but it is not working. Now i have tried through code and still it is not working.
here is the code that i have written in crystal report's initialize event
Please help me immediately. it is urgent. I am stuck on that.Quote:
Const ConString = "Provider=MSDAORA.1;User ID=gtsc;password=gtsc;Data Source=portal1;Persist Security Info=False"
Private Sub Report_Initialize()
Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.ConnectionString = ConString
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
con.Open
rs.Open "Select * from emp", con, 3, 2, 1
Database.SetDataSource rs
End Sub
thanks,
ashish
Hi Babu,
I've created a report with a line chart. When I call the report from vb6 on a windows XP, it's running fine; but when the same report is called on Windows 98, the chart just dissapeared. Is there anything to do with any missing file? However, I didn't get any error message. The other info in the report was displayed properly. I'm using CR8.5.
Thanks
yeosc
Hi People,
How can I set the database location at runtime from my vb app? When i was using an old version of Crystal report i was allowed to set "same as report".
Thanks in advance.
Ricardo
OK..the problem is like that.I connect the crystal report to MYSQL using ODBC.
Everything work perfect when i am just using 1 or 2 tables in a report. I use left outer join to connect each table.
But the problem occur when i am using the data from 3 or more tables in a report.It always appear a message " Fail to open a row set" What wrong actually?
Thanks for help.
I am using ODBC to connect crystal report to MYSQL database. I am wondering why i cant select a data from a tables where a field in a table is equal to "" (That mean it was nothing in the field,but not null,just nothing).
I right click on 1 field at the table..then click select expert
-> click equal to "" , but when run the crystal report,nothing select? how can i fix this problem?
thanks for help.
Hi,
I'm having real problems trying to do something that ought to be very straightforward. I have a stored procedure that returns a recordset. This displays a nice tabulated report without problems. This stored procedure takes 3 parameters, 2 dates and an ID to identify a survey I'm reporting on. Also there is a sub report which is related to the main report but is designed to sumarise some columns with a view to creating a graph.
The sub report is a stored procedure which takes the same parameters but also another parameter which is the question number of a particular question in the given survey. This produces a small recordset with which I want to produce a pie chart from.
I can do all this seperately and I have also figured out how to link the parameters so that the subreport takes the parameters from the main report. However, for the sub report, I do not want the question ID parameter to be entered by the user, I want to hard code it (for reasons I won't go into right now). I have to run this sub report for 24 different questions so I need to be able to have a subreport generated from single stored procedure.
To summarise, if I were to run this in query analyser I would run:
exec MainReport @Date1, @Date2, @Survey
and then for the sub reports:
exec SubReport @Date1, @Date2, @Survey, 100
exec SubReport @Date1, @Date2, @Survey, 101
exec SubReport @Date1, @Date2, @Survey, 102
exec SubReport @Date1, @Date2, @Survey, 103
exec SubReport @Date1, @Date2, @Survey, 104
where the first 3 params in each case are the same.
This will then give crystal the recordsets with which it can create the charts from. I don't want to prompt the user to enter in the question numbers in the subreport, I just want to hardcode them into crystal.
Any help is most welcome.... I'm running Crystal 9 and Report Application Server. All I require is the end user to choose a report in the browser, type in the dates and state which survey to run and for crystal to show the report and the graphs. I have the SQL in the form I need, but not the knowledge of crystal to pull it off.
Cheers,
Lee
helo ,
nice to hear that's a crystal report specialist would resolve my question .
ok , i'm facing a problem of displaying my daily sales value into graph, my clients which running his operation hours from afternoon 3 pm to morning 3 am .... so ... it's raise a serious problem to me of displaying the sales value , you know .. by default crystal report uses default time as daily (00:00:00 to 00:00:00) ... so all my value getting wrong !! ... it should be 03:00:00 to 03:00:00 correct ? so i had been mad about this .. hope you can give me a hand .. i'm grade of hearing reply from you . thanks you!
Dear K. Babu.. how r u...
I face a problem in projects of VB when calling Reports through Crystal Report ActiveX Control that is the report some times does not show i mean if application is run and some reports are frequently used all of a sudden they fails to show and again to show i have to close the application and then run it again.. pls help me...
Dear NasirAbbas,
I was facing the same problem with my VB6 and CR9 app.
LogoffServer worked fine for me. Everytime I close my viewer window I Logoffserver.
cReport.Database.LogOffServer "crdb_dao.dll", gsDatabase, gsDatabase, "", ""
Maybe it helps...
Ricardo
Hi ,
I am using CR7.0 version and i want to place a jpeg picture as background image in detail section when all records are displayed simultaneuosly (one by one just like in Grid).When i am printing a single record it is coming correct what i need,but when i want to print all(nearly 10 ) records it is not getting what i need......
My printer is colour printer and it is HP Deskjet color printer and all my Cry Reps are printing in Black and White and when i am printing the same reports in Data Report it is printing Colour.....
I have a created database in MS Access XP and having some tables in that database.From CR7.0 i can't able to open the database and it is giving error like unrecongnised database..
Please help me because i need this Urgent !!!!!
Thanks !!!!!!
I want to create a report that's based on a user's selection, basically a form with checkboxes and comboboxes. The end user will not have to write an sql statement.
to start with, I have a form with check boxes and comboboxes and based on those that are selected i want to be able to grab that record or count the number of records. That's the easy part. I'm stuck on how i go about displaying that information on to the report. How do i go about putting that into a field? Is the field unbound??? I'd do an Add Command but it's not known until runtime what will be selected or what will be needed until runtime.
Also I want to be able to edit a text object without having to actually going to the report design, specifically in the page header. I want to be able to have some code that will do that for me but i'm at a loss here too.
for e.g., suppose the end user wanted to know the total number of orders sold rather than the total number of employees. how would that be displayed? (From access northwind.mdb)
Hi,
I have one crystal report that I can not add or move fields on the preview mode. Why?
Pleae help
Thanks