Printable View
Hello !
i want to ask a question.
can i use crystal reports instead of a listview control in order to
display results in the same manner like the listview?
moreover i want that when i click on a columnheader that the
records are ordered according to this column.
so i want a columnheader_click event or something like that.
is there a tutorial for doing all this stuff ?
thanks !
I use CR with Visual C++ 6.0 and I don't use CR Active X viewer because it does not export correct the reports.
Instead, I access the reports preview using "cpeaut32.h" (ICRApplication, ICRReport, ICRView etc.).
I need to pass some parameters at runtime to the report, but I couldn't find a way. There is a an interface ICRParameterFieldDefinition but i couldn't figure how to use it.
It would be very helpful an advice or example about how can I can do this.
Hello Dear Babu,
Nice to meet you through this forum. I am developing some Crystal Reports in Version 8.
These are not ordinary reports where we can connect to one database from report and so on...
My problem is i have many databases, in them more than one table in each database.
R:\\2000\WM5.mdb
R:\\2001\WM5.mdb
R:\\2002\WM5.mdb and so on for each year.
I have one database of each type for every year in R drive. and i designed my reports accordiing to Client.
Now from VB 6.0 front end interface i have to select Year(2002,2003 etc) , DatabaseName and product number etc. When i click display report it has to search in the particular MDB i selected and should display corresponding data of the record(given product number).
Simply this is a Dynamic report generation.
PLease help me in doing this.
I have designed reports and GUI also.
Now i need code from which i can generate reports according to the user selection of Year, database, table name and product number.
NOTE: the database has same structure for all years.
The tables has same no.of fields and names of the fields are also same...
Thanks in advance.
Preetham
Hi, I Really need help with this unsolved problem, the problem is actually come when i try to send parameter value from ASP page to crystal report with stored procedure parameter...
In this link i have the unsolved problem for passing parameter with uniqueidentifier value .....
http://www.codeguru.com/forum/showth...hreadid=274834
I hope u will be patient with my problem to read a while on the link above,thx a lot
hi,
i keep getting an unknown query engine error each time add a java bean as a data source, i looked it up on the crystal decisions forum and followed their tips to resolve the issue , i am still unable to do it.
Any help would be useful.
I also have another question, if i have a report generating a chart from an oracle table. I have displayed it using a jsp, but i need it to be refreshed each time the data in the tables changes. which i am unable to do.
thanks and regards,
Rajbir
I want to insert pictures into my report, this pictures are stored a sqlserver 2000 database in an image type field and i am working in Cristal Reports for Visual Studio .Net. I need a report with a table, where in each row i must insert the picture of each employee of my company.
How can i do that???
Please help me and thank you very much.
Hi!
I have some problems with a crystal report that has two subreports.
Problem is that for some reason I do not get anything on the subreports. It would be ok if there is not information matching with the parent, but there really is information that matches with the parent detail.
If I remove the link between the parent and the subreport, I get the whole list. So, for some reason filtering is not working properly. Main report and 2 subreports are based on ttx files. The field I am using to link subreports with the parent is a uniqueidentifier type. Does anybody has a clue about this?
I made a test creating new reports but instead of using ttx files I am using the stored procedures directly and they are working fine. The problem here is the architecture of the app was designed to use ttx files and they are fed at run time with the recordsets coming from the sp's I am using on the test.
I will really appreciate your help because I have spent too much time on this. Thanks.
Manuel
hi,
Can any one help me in getting the euro symbol in crystal report which can be exported into MS Excel while scheduling the report.
I can see the symbol in crystal output, but not in excel file.
Please help!!
Thanks
Anand
Hi shaikh_intekhab
I got something regarding your questions. Attached one zip file. This will be help ful to you.
I've read about that sample that you gave to me, about SAmple to make report over the web, but the problem is i can't pass the parameter value.....not how to preview it....maybe u can't read the problem carefully...cause i feel my problem is weird.....and i get mad of this problem,coz ake me stuck on this too long for my project...thx anyway
Hi,
Find out the ASP Sample Code attachment, I hope this sample will solve your problem.
yours friendly,
K.Babu
Quote:
Originally posted by endrue
I've read about that sample that you gave to me, about SAmple to make report over the web, but the problem is i can't pass the parameter value.....not how to preview it....maybe u can't read the problem carefully...cause i feel my problem is weird.....and i get mad of this problem,coz ake me stuck on this too long for my project...thx anyway
Hi
I am preparing a sales report grouped by month and year
The data is something like this
Name1 MonthYear Year Date Sales
X1 200203 2002 date1 200
X1 200203 2002 date2 300
X1 200204 2002 date 400
I have grouped by MonthYear and then Month
The report format should be like this
Name Date Sales
x1 date1 200
date2 300
200203 500
date 400
200204 400
2002 900
I have done supress column if duplicated for name1.
The problem is that the name is not supressed for outer group.
The report that I have now is something like this
Name1 Date Sales
X1 date1 200
date2 300
200203 500
x1 date 400
My issue is that I dont want X1 to be repeated for the next month year group.
Please help...
Thanx for reading through...
I am using crystal reports 9.
Rgds
Kudla guy
hi
i am preparing a report which contains values -1 and 0
if value is -1 it is to be replaced by string pp
else it should be blank. the field name is papercode. how can i do this?
thanks
Hi,
Insert Formula field in the Crystal Report,
inside that formula validate the papercode
eg. if papercode = -1 then "pp" else ""
Yours Friendly,
K.Babu
Quote:
Originally posted by snehal G
hi
i am preparing a report which contains values -1 and 0
if value is -1 it is to be replaced by string pp
else it should be blank. the field name is papercode. how can i do this?
thanks
Hi,
Group by name1, Year, Month.
So that it will come once in the name1 group.
Yours Friendly,
K.Babu
Quote:
Originally posted by Kudlaguy
Hi
I am preparing a sales report grouped by month and year
The data is something like this
Name1 MonthYear Year Date Sales
X1 200203 2002 date1 200
X1 200203 2002 date2 300
X1 200204 2002 date 400
I have grouped by MonthYear and then Month
The report format should be like this
Name Date Sales
x1 date1 200
date2 300
200203 500
date 400
200204 400
2002 900
I have done supress column if duplicated for name1.
The problem is that the name is not supressed for outer group.
The report that I have now is something like this
Name1 Date Sales
X1 date1 200
date2 300
200203 500
x1 date 400
My issue is that I dont want X1 to be repeated for the next month year group.
Please help...
Thanx for reading through...
I am using crystal reports 9.
Rgds
Kudla guy
hi,
How can I create a crystal report of a rtf file.
Any ideas or suggestions is appriciated
thanks,
bye,
//
Hi,
Group by name1, Year, Month.
So that it will come once in the name1 group.
Yours Friendly,
K.Babu
quote:
--------------------------------------------------------------------------------
Originally posted by Kudlaguy
Hi
I am preparing a sales report grouped by month and year
The data is something like this
Name1 MonthYear Year Date Sales
X1 200203 2002 date1 200
X1 200203 2002 date2 300
X1 200204 2002 date 400
I have grouped by MonthYear and then Month
The report format should be like this
Name Date Sales
x1 date1 200
date2 300
200203 500
date 400
200204 400
2002 900
I have done supress column if duplicated for name1.
The problem is that the name is not supressed for outer group.
The report that I have now is something like this
Name1 Date Sales
X1 date1 200
date2 300
200203 500
x1 date 400
My issue is that I dont want X1 to be repeated for the next month year group.
Please help...
Thanx for reading through...
I am using crystal reports 9.
Rgds
Kudla guy
--------------------------------------------------------------------------------
But the problem is that if I do so, the Name comes in a different section something like this
Name Date Sales
X1
Date1 100
Date2 200
I want X1 to be on the same line as Date1 and 100..
Please help
Rgds
Kudlaguy
I am using crystal 8.5 with VB front end.
i am using VB GUI for devlopment not
crystal. ADO recordsets are retriving data
for the reports. then retrived data is added
to report using following syntax
Set fld = m_Report.Section3.AddFieldObject
("{ado." & valarr(0) & "}", 400, 0)
i am using Crystal Report Viewer to
view/execute report
Now Problem is,
when report is run for first time it
produces expected results but if its re-
runned/re-executed new data overlaps older
data.
in short, i want report to refresh and
delete old data when new execution takes
place.
Any input will be deeply appreciated
-Rohan :)
Hi,
I have written a series of crystal reports, connecting via a UDL file pointing at an OLEDB provider. Now the reports have passed testing, I have changed the UDL, but the reports don't seem to care... they still reference the original Data Source and Catalogue (it’s as if crystal hard codes the connection parameters into the report rather than referencing the UDL each time:rolleyes: )
I have tried to change the data source location within crystal, but when I point the report at the new connection I get the error message "Some tables could not be replaced, as no match was found in the data source. Please specify the table required for any unmodified tables"
The reason that the report can’t find tables is that the connections are added as commands within the Add Command function.(example below)
PEARL Custom Reports.subPEARLSR19_1 "Legal Entity={?Legal Entity}" "Vehicle={?Vehicle}" "GLDate={?GLDate}"
This allows us to reference the OLEDB provider and pass parameters back from crystal to the OLEDB provider.
Has anyone come across this problem and/or know of how to resolve this issue.
Thanks
GavD:confused:
Hello,
I have a report in CR8.5 and a subreport that goes into the first report. Is there a way that I can access the subreport fields from within the main report to be used in calculations, using either Formula editor or directly from within VB6.
Regards,
Samehme
Dear Mr. Babu / friends
i want to take my reports (from crystal report with vb, Access) very speedly like Foxprow reports (Dos version). what are the precautions i have to take while designing in crystal report. i am using dot matrix printer also. what about font, size that help fast printing.
thks
bobby
Dear Mr.babu/friends
my crystal report is working 100% perfectly. But if i alter my underlying table (change the datatype or width) , the report is not working properly. so what setting i have to make while designing the report.
Bobby
Hi Mr Babu or other Crystal developers,
I am prompting for a parameter from a pick list on an ASP page using Crystal 9. I create the parameter pick list in Crystal via the "Set default values" > "Import pick list" tool. In the Crystal development environment itself, my pick list contains 300+ items. In my ASP page, on the report viewer parameter entry page, the pick list only contains about 38 of the items. Any ideas??
Thanks very much. Greatly appreciated!
:)
Hi Mr. K Babu
1. I'm building the reports using crystal report included in MS VS .Net (ASP.net).
2. On runtime, to display report, I am using CrystalReportViewer by passing selection formula.
4. This works fine, It can only navigate to page 2, after that, clicking on the next button return the same page (page 2) over and over again.
5. Clicking the 'last page' button will bring you to the last page of the reports.
6. In short, the report can only be viewed on page 1,2, and the last page
Please help me...
Thanks in advance.
Hello everyone,
I'm using a blob field in a crystal report (v 8.5) to display an image stored in an access 2000 database (embedded bitmap in an ole field). This image was created by visual basic via picture box. Access shows this data as "binary-long data".
Crystal reports 8.5 shows this data correctly as an image.
But recently I had to update to crystal report 9 and now the image is blank!!
Does anybody know what the problem is?
(when I store an bitmap file via copy&paste in the access field, cr9 shows the image correct)
How can I store the bitmap via vb in the access database in a way that access shows it as "bitmap" data?
Hi , I have a problem with crystal report. This time i have a problem when i pass a parameter with uniqueidentifier value into report with stored procedure, so if I don't use "Execute" command in my stored procedure to run my sql query it runs correctly, and i have trace the problem that if i use a variable into my exec command with uniqueidentifier value, but if i just put the uniqueidentifier with hard coded...it works.....and if try it on sql query analyser it works fine too
I really confused of this.....so everytime i preview the report always show error message"Error query engine on server : cannot converting char to uniqeidentifier
I hope someone can Help me.....thx....
Crystal Reports
Hi everybody,
I'd developed an application using VB6 and Crystal Reports 9 in Windows XP Pro. Everything works fine.
The problem is I need to make it as EXE and to run the program in Windows 2000 which is not havin VB or Crystal Reports. I manually copied all the exe, dll, ocx files including
craxdrt.dll
crystalviewer9.dll
But while trying to open the report it raises "Active X can't create object"
The code is
Set Report = Appl.OpenReport("path")
Report is craxdrt.Report
Appl is craxdrt.Application
Have any idea regarding this? please help me. I struck up with this. Can't move
To run this, Do I need to install the Crystal Reports 9 in Destination machine. Is it necessary?
Thanks in advance
Using:
VB 6
Crystal Reports 8.5 Developer Edition
Installshield 7.0
Windows 2000 Professional for both the Developer computer and the client computer
My program consists of a ServerAPI and a Client. The user chooses the type of report and sets the necessary criteria. The client passes the info to the server, who does a query against the database and passes the requested info back to the client in the form of a string. The client parses the strings and loads the data into an array. The array is then passed to the report via CDO.
This process works beutifully on my own computer (which has VB6 and CR 8.5 installed). When I run the Installshield setup on the client machine, everything installs fine. But when I run the program and try to bring up a report, I get "Error: -2147024770 - Automation Error, The specified module could not be found."
In my setup, I included:
Crystal_Database_Access2003.msm (which includes cdo32.dll and crpe32.dll)
cpeaut32.dll
p2smon.dll
Here's the code I use in my program:
Code:
Private m_crApplication As CRPEAuto.Application
Private m_crDatabase As CRPEAuto.Database
Private m_crTables As CRPEAuto.DatabaseTables
Private m_crTable As CRPEAuto.DatabaseTable
Private m_crView As CRPEAuto.View
Private WithEvents m_crReport As CRPEAuto.Report
If FindReport = True Then
Screen.MousePointer = vbHourglass
UpdateStatus "Generating Report, Please Wait..."
Dim clsPrtSel As New CSelectPrinter
m_cdoRowset.AddRows m_varRowsArray
'According to my debug info, it breaks on this line
Set m_crApplication = New CRPEAuto.Application
Set m_crReport = m_crApplication.OpenReport(m_strCRReportPath & "\" & m_strReportName)
Set m_crDatabase = m_crReport.Database
Set m_crTables = m_crDatabase.Tables
Set m_crTable = m_crTables.Item(1)
Call m_crTable.SetPrivateData(3, m_cdoRowset)
If blnPreview = True Then
Debug.Print "PreviewData"
Set m_crView = m_crReport.Preview
m_crView.ZoomPreviewWindow 100
Else
Debug.Print "PrintData"
m_crReport.SelectPrinter clsPrtSel.SelectedPrinter.DriverName, _
clsPrtSel.SelectedPrinter.DeviceName, _
clsPrtSel.SelectedPrinter.Port
m_crReport.PrintOut False, clsPrtSel.SelectedPrinter.Copies
End If
End If
Am I missing a dll, or a dependency for one of the dll's? In my research, it seems that that the only dll's I needed were Cdo32.dll, crpe32.dll, cpeaut32.dll, and p2smon.dll (along with all their dependencies).
Any information you have that might help me, or any website you could point me to, would be greatly appreciated. I've been working on this almost nonstop for the past 2 days and have come up empty handed. I've done online searches on every keyword that I can think of.
Thanks in advance!
Fiona
Hi,
I want to refer a sub report field in my main report. Is there any way to do this. Using CR9
Hello,
I'm working with Crystal Reports 8.5 and we're using a webbrowser to view the reports. Each report is scheduled to run once every day (using a recurrence), That works fine. However, the users also have to option [Run Now], to generate a new instance of the report. That works fine as well, however it also generates a recurrence. This means that if you click [Run Now] 5 times, it generates not only 5 instances, but also 5 recurrences. We don't want that. Is there a solution to that problem?
Thanks.
Mr. Guru,
I created a CR report , and I tried to open it with ASP, code is like
following:
---------------------------------------------------
<%
Dim objReportApp
Dim objReport
set objReportApp = Server.CreateObject("crystalruntime.Application")
set objReport = objReportApp.OpenReport("c:/reports/ClientInformation.rpt")
%>
---------------------------------------------------------
and I got these error:
--------------------------------
Seagate Crystal Reports ActiveX Designer error '80043ac6'
Access denied.
/reporttest/test1.asp, line 8
How to slove it?
Thanks.
Hi,
Make sure you have Read/Write access for your logon user in server machine.
Quote:
Originally posted by asp_worker
Mr. Guru,
I created a CR report , and I tried to open it with ASP, code is like
following:
---------------------------------------------------
<%
Dim objReportApp
Dim objReport
set objReportApp = Server.CreateObject("crystalruntime.Application")
set objReport = objReportApp.OpenReport("c:/reports/ClientInformation.rpt")
%>
---------------------------------------------------------
and I got these error:
--------------------------------
Seagate Crystal Reports ActiveX Designer error '80043ac6'
Access denied.
/reporttest/test1.asp, line 8
How to slove it?
Thanks.
Hi,
Try this, store the date to logfile in client machine, validate the logfile before starting the recurrence instance.
Quote:
Originally posted by cterburg
Hello,
I'm working with Crystal Reports 8.5 and we're using a webbrowser to view the reports. Each report is scheduled to run once every day (using a recurrence), That works fine. However, the users also have to option [Run Now], to generate a new instance of the report. That works fine as well, however it also generates a recurrence. This means that if you click [Run Now] 5 times, it generates not only 5 instances, but also 5 recurrences. We don't want that. Is there a solution to that problem?
Thanks.
Hi,
This code works through the RDC object model to identify a subreport object in the main report
Code:Dim crSecs As CRAXDRT.Sections
Dim crSec As CRAXDRT.Section
Dim crRepObjs As CRAXDRT.ReportObjects
Dim crSubRepObj As CRAXDRT.SubreportObject
Dim crSubReport As CRAXDRT.Report
Dim i As Integer
Set crSecs = CRReport.Sections
For i = 1 To crSecs.Count
Set crSec = crSecs.Item(i)
Set crRepObjs = crSec.ReportObjects
For X = 1 To crRepObjs.Count
If crRepObjs.Item(X).Kind = crSubreportObject Then
Set crSubReport = CRReport.OpenSubreport(crRepObjs.Item(X).SubreportName)
'the following code sets the subreport table to a different database
crSubReport.Database.Tables(1).Location = CommonDialog1.FileName
'set the value for a text object in the header of the subreport
CRReport.Subreport1_Text2.SetText "This is the subreport"
'within this loop you can set other properties of the subreport and
'the field objects and sections in it.
End If
Next
Next
Quote:
Originally posted by harmonycitra
Hi,
I want to refer a sub report field in my main report. Is there any way to do this. Using CR9
Dear Babu,
I am new at using Crystal Reports and I'm hoping you can help me with a problem. I'm using Crystal Reports 9 and I'm trying to create a cross-tab.
On the left hand side of my cross-tab (columns) I have duration in seconds. I have to break the duration down into sections like 1 - 30 seconds, 31 - 60 seconds, etc.
Everything works fine unless there is no data for a particular column, like 1 - 30 seconds. If there is no data for that duration I would like my report to still show that column with '0' in the summarized fields section. Instead, it does not even display the 1 - 30 seconds column.
What are my options for correcting this?
Thanks so much,
Stephanie
K.Babu have given a deploy file list,that's for crystal report 8,not 9,i accord it and success .but cr9 is terrible,
i copy craxdrt9.dll to other machine,then want to register it using regsvr32 craxdrt9.dll(i put it under winnt\system32),no echo,i can not see the registration successful dialog,i think it must need some others files.Do you know HOW TO REGISTER CRAXDRT9.DLL?
when using cr8 ,i can register it successful.
no error message ,when register like this:regsvr32 craxdrt9.dll,only cursor become cup icon,several seconds,then finished the registration .it is very weird.
Dear K.Babu,can you give me the file list of cr9 for deploment?(if it can let cr9 run ,that's ok),thanks a lot to K.Babu.
i have got the anwser:
register follow dll file first :
keycode.dll
ExportModeller.dll
crtslv.dll
crqe.dll
then register craxdrt9.dll
Have you got any error message while registering CRAXDRT9.DLL with regsvr32.
Quote:
Originally posted by xqyz8888
K.Babu have given a deploy file list,that's for crystal report 8,not 9,i accord it and success .but cr9 is terrible,
i copy craxdrt9.dll to other machine,then want to register it using regsvr32 craxdrt9.dll(i put it under winnt\system32),no echo,i can not see the registration successful dialog,i think it must need some others files.Do you know HOW TO REGISTER CRAXDRT9.DLL?
when using cr8 ,i can register it successful.
Hi,
I have a table full of <Nulls> and at first my application loads correctly after I log into SQL Server via ODBC. However, when I close the CrystalReportViewer, the login window for SQL Server comes up again.
I tried closing and closing, but I still get the same window. Any solutions? It only does it to this table, all my other reports work fine w/ different tables. Any solutions?
I am using Crystal Reports with VB.NET
Chris
Hi Babu and everybody,
I have got these problem which I am trying to breadk from past 2 days. I have explaine the problem below :
I have report called main.rpt. I am displaying the details from the
database like total number of persons who have given their response as 'Yes', 'No' and 'No Response'. These is display for all the categorys. Totally I have 6 categorys.
So I will be displayed 6 sections (Categories like Stratagies, Communications,Personnel, Plans, Maintainence, Awareness) with total number of persons who have given their response as 'Yes', 'No' and 'No Response'. Now the link is provided for all these 'yes', 'No' and 'No Response'. I can provide the hyper link at the design time only for one in the details section. But how to achive at the run time for all the categories. So depending on the categories the sub report has to be opened.
Please help me out.
Regards,
Deepak.
Now your post is added as a "reply" to Crystal Report Thread.
To add questions to an already existing thread, you have to hit
the "post reply" button you can find at bottom right of the page.
Hi,
How to view the reply for my question posted. I got a mail that Cimperiali has replied for my question. I want to see the contents.
Regards,
Deepak.
Hi Mr. Babu & everyone
Please guide me proper that I want to generate a report with multi_tables.
Suppose I have 3 tables like tables whose names are Men, Women,Childs. There three tables data should be listed in a report. When 1st table data is completed a parameter passed from Vb should be printed and so on.
Attachment file is here for more clear.
How can I do at runtime from VB
Thanx in Advance
Sir Babu,
Im just new in using Crystal Reports.... would u give me a snippet of code in accessing the Report Designer Component (RDC). My main platform is VC but i understand VB... my real problem is the query attach to the report (that can be seen in Show SQL).
sample:
select own_ln, own_fn
from
db2inst1.own_names own_names
<db2inst1 is the owner of the table and also owner of the database, we were just given a schema access to use the database and tables as well>
when i run the program <my UserID is ProgI>, a message box saying "ProgI.own_names" is undefined name.... what seems to be the problem? hope u can give me samples that may modify the setting of the report file at runtime or dynamically.
By the way, im using DB2 as backend
thanks....
I post the error codes first.
Imports CrystalDecisions.CrystalReports.Engine
'Namespace or type 'Engine' for the Imports 'CrystalDecisions.CrystalReports.Engine' cannot be found.
Imports CrystalDecisions.Shared
'Namespace or type 'Shared' for the Imports 'Imports CrystalDecisions.Shared' cannot be found.
Imports CrystalDecisions.Web.Design
'Namespace or type 'Design' for the Imports 'CrystalDecisions.Web.Design' cannot be found.
Dim rpt As CrystalReport_item
'Type 'CrystalReport_item' is not defined.
rpt = New CrystalReport_item()
'Type 'CrystalReport_item' is not defined.
I have VB.NET Standard Version 2002. Then I bought Crystal Reports Version 9 in order to print reports. (Note that I don't have Visual Studio.NET, so this is not the embeded Crystal Reports in Visual Studio.NET)
First, I install the VB.NET. Second, I install the Crystal Reports. (I just select normal installation, not customize intallation)
After installation, I create and save a Crystal Reports called "CrystalReport_item" using the Crystal Reports software.
I move the "CrystalReport_item.rpt" to the folder of my solution.
Then at the VB.NET software, I click "Project->Add Existing Item...". Then I click the "CrystalReport_item.rpt" and click "Open" in order to add it to the solution.
Then I type the code
"Dim rpt As CrystalReport_item"
in a new form's button1.click.
However, there is a line under the "CrystalReport_item" and there is a yellow box telling that "Type 'CrystalReport_item' is not defined.".
Firstly, I think that I forget to import libraries, then I type the code
"Imports CrystalDecisions.CrystalReports.Engine".
However, there is a line under the "CrystalDecisions.CrystalReports.Engine" and there is a yellow box telling that "Namespace or type 'Engine' for the Imports 'CrystalDecisions.CrystalReports.Engine' cannot be found.".
Can you please tell me what I need to do in order to add the report to my solution and let it print the report?
Please tell me more detailly as I am just a beginner of VB.NET and Crystal Reports 9. Thanks a lot.
Sorry, forget to say hi first.
Hi, everybody.
Hope that Mr. K.Babu and other people can help me.
Thanks again.
^^
I have a strange problem with a report in Crystal 8.0.
This report is used from a MFC application wich creates a temp table with a customized name to allow multiple user access.
So the reports works wonderfully on every kind of PC and every kind of printer settings. And also i have many applications reporting on temporary tables both in VB and VC++, and all these work perfectly.
But I have a single application doing a strange joke on a single PC and a single Printer.
When the user prints on the Epson4000 the printer defaults loading paper from the mail envelopes dish instead of the "A4" paper dish.
But this problem doesn't occour if the report is another one.
Note: all the rpt files I use got the same printer and page settings.
The code I use is:
Code:m_Crystal1.Reset();
m_Crystal1.SetReportFileName(path);
m_Crystal1.SetSelectionFormula(Sel);
m_Crystal1.SetWindowTitle("Print");
m_Crystal1.SetFormulas(1, (LPCTSTR)("Title = " + Title));
m_Crystal1.SetWindowAllowDrillDown(TRUE);
m_Crystal1.SetWindowShowNavigationCtls(TRUE);
m_Crystal1.SetWindowShowCancelBtn(TRUE);
m_Crystal1.SetWindowShowPrintBtn(TRUE);
m_Crystal1.SetWindowShowExportBtn(TRUE);
m_Crystal1.SetWindowShowZoomCtl(TRUE);
m_Crystal1.SetWindowShowCloseBtn(TRUE);
m_Crystal1.SetWindowShowProgressCtls(TRUE);
m_Crystal1.SetWindowShowSearchBtn(TRUE);
m_Crystal1.SetWindowShowPrintSetupBtn(TRUE);
m_Crystal1.SetWindowShowRefreshBtn(TRUE);
m_Crystal1.SetWindowState(2);
m_Crystal1.SetConnect(pApp->m_StrConCrw);
// load up a ##temp table
m_Crystal1.SetSQLQuery(Temp);
m_Crystal1.SetDestination(0);
BeginWaitCursor();
m_Crystal1.PrintReport();
EndWaitCursor();
Hi,
I am trying to create a radar chart. Now the radar chart I can draw lines on the sum of a column values. But my requirement is draw the lines depending on another column value. This should translate into multiple lines.
Any suggetions?
I'm trying to change the currency format of a report at runtime, here is some of the code...
However, I get a 'Feature Not Enabled' error on the following line...Code:Private Sub SetReportFormat(crReport As CRPEAuto.Report)
Dim objSections As CRPEAuto.Sections
Dim objSection As CRPEAuto.Section
Dim objReportObjects As CRPEAuto.ReportObjects
Dim objTextBox As CRPEAuto.TextObject
Dim X As Integer
'// Get an object to represent each of the report sections
Set objSections = crReport.Sections
'// Begin loop for each section in the report
For Each objSection In objSections
'// Get an object to represent each of the objects in the report section
Set objReportObjects = objSection.ReportObjects
'// For each individual object in the report objects collection...
For X = 1 To objReportObjects.Count
'// If the object is a text box...
If objReportObjects.Item(X).Kind = crTextObject Then
'// Get an object-reference to the text box...
Set objTextBox = objReportObjects.Item(X)
'// If the text box is a currency field, then change the currency to
'// the new format
If objTextBox.Format = "Currency" Then
objTextBox.Format = GetCurrencyFormat
End If
'// Destroy this within loop...
Set objTextBox = Nothing
End If
Next
Next
'// Clean up
Set objTextBox = Nothing
Set objReportObjects = Nothing
Set objSections = Nothing
End Sub
objTextBox.Format = GetCurrencyFormat
{GetCurrencyFormat is just a function that returns a string - e.g; £#,##0.00;(£#,##0.00)}
Any ideas? I tried to manipulate other propeties of the object but they all generate the same error??
Thanks
Hi,
I hope someone can help me with the following problem.
have a SQL-Server table which contains eight string fields with links to pictures which need to be shown on the report. These str255 fields can sound like "//blabla/pic/test1.jpg" and I really need to get them into the report without storing the pic in the database (we talk about 100 of Gigabytes of pictures).
Thx in advance,
Simon :)
Hi K. Babu and Evryone,I have a problem to pass value to Stored Procedure parameter with crystal report RAS,this case happen when I use "Execute" command on my stored procedure that to control some parameter based on user input, but it shows an error when i Put the parameter in "Order By" clause....
The value for the parameter seems to be empty. this is my code :
Create Procedure RPT_PRint
@OrderBy varchar(50),
@SortOrder varchar(50)
as
exec(' Select
AbsenceCode,
AbsenceName
from Absence_T
order by '+@OrderBy+' '+@SortOrder)
Go
It comes weird, cause when i try to input the value on the crystal report designer it works fine, but when i pass the value from ASP page it won't show the report.....show error message " Syntax error near By"