Help With Crystal Report - Display Only Needed Data
i'm really new to crystal reports. i have a database which saves payroll information every 15th day, now i want to come up with reports on a specified paydate only... how do i go about it?
say, i have payroll records each employee for the last 5 paydates, so how do i go about having only to print one of these paydates instead of having all existing paydates in my report?
any suggestion, links? tnx.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Data Display In Crystal Report ???
Hey I`m sorry for asking again and again, but I have not worked on Crystal Repots before this.
What is basic concept of showing data in Crystal Report. When I select tables and fields in a report. Then all available data is displayed in that report OR can it be changed as per requirements. If yes then how ?
e.g. I am having data of attendance (date / time) of Employees. And I want to display data only for specific month. In short how can I customize display in Cryst. Repo. ?
One more que. : Format of a field is Date/Time and I stored time in it. (e.g. 14:00:00) but report is showing Date value at random (e.g. 99/12/30)
Please Guide !
Crystal Report Data Display
Hi all
I have made Report by using recordselectionformula but when i am previewing the report that is coming correct and suppose i have closed the preview and without unloading the project i want to see the report for some another record i have to click on the refresh button without this i am not getting data display
and if i stop the execution and execute the s/w then again once it is working o.k. for once and again the same procedure if anybody of u can suggest me sol.
Dinesh
Display Dynamic Data In Crystal Report
hello Sir,
i m using vb6 and access 2000,crystal report 9.
i would like to display changed access table data at run time. my problem is report is not accepting data from database.
actualy i stored data in access table from text file.
but it not reflecting when i create exe of project and run it.it display records from local disk,where project sored.
pls help me. my code is as
Open App.Path & " est.txt" For Input As #1
Line Input #1, cname
Line Input #1, ccity
Line Input #1, sno
Close #1
str1 = "Delete * from Table2"
Set rs = New ADODB.Recordset
cn.Execute str1
rs.Open "Select * from Table2", cn, adOpenDynamic, adLockOptimistic
rs.AddNew
rs.Fields(0) = Trim(cname)
rs.Fields(1) = Trim(ccity)
rs.Fields(2) = Trim(sno)
rs.Update
rs.Requery
cr1.Database.SetDataSource rs
DoEvents
cr1.DiscardSavedData
cr1.ReadRecords
rs.Close
For i = 1 To cr1.Database.Tables.Count
cr1.Database.Tables(i).SetDataSource (App.Path & "sample.mdb")
cr1.Database.Tables(i).Location = App.Path & "sample.mdb"
cr1.Database.Tables(i).SetLogOnInfo "", App.Path & "sample.mdb", "", ""
Next i
cr1.Database.Verify
How To Display Data From Database SQL In Crystal Report?
i'm new in VB.NET and need help in crystal report.
i've tried but i still face problem in binding the crystalreport viewer and crystal report. i get error when i put this source code: "CrystalReportViewer1.DataBind" in method CrystalReportViewer1_load.
i would be grateful if anyone can help me in this... please...
thanks
Error On Selection Formula To Display Data On Crystal Report From SQL Database
I have a problem on selection formula to display data from SQL database on crystal report it produce an error like this:
error A number, currency amount, date, time, date-time or string is expected here
Code:
Dim Ap As New Application
Dim Rep As Report
Private Sub CRV_Click()
End Sub
Private Sub Form_Load()
Dim RepFileName
RepFileName = App.Path & "LeaveForm2.rpt"
Set Rep = Ap.OpenReport(RepFileName)
Rep.RecordSelectionFormula = "{tblLeaveApp.EmpNo}=" & ndEmpNo ->error is here
Rep.DiscardSavedData
CRV.ReportSource = Rep
CRV.ViewReport
CRV.Zoom 100
'frmcrs.Enabled = False
End Sub
Private Sub Form_Unload(Cancel As Integer)
Form6.Show
End Sub
anyone can help me....
Why Cant Display Report That Contain Chart In Crystal Report?
I done my crystal report and everything works fine until i try to call a report that contain chart, nothing come out when i try to call it, anybody knows why?
CR1.ReportSource = crptReport
CR1.ReportFileName = "statistic.rpt"
CR1.ReplaceSelectionFormula (str)
CR1.WindowState = crptMaximized
CR1.PrintReport
CR1.PageZoom (100)
Help Needed For Crystal Report 9.0
Crystal report by default prints out it details like this
00512270
1
00512271
1
however i need to get it like this 00512270 00512271
1 1
Anyone noes how to do that in crystal and also this report takes data from 3 queries, but all these queries have the same input parameter. SO how do i do it so that users would have to key in the parameter once.Thanks in advance.
Vb6 And Crystal Report .(help Needed)
Hi ,
I am developing a project in Vb6 and Access.I have to make some reports too .So i am using Crystal Report 9 for it .I have learned how to make reports using Crystal report.
Actually i am making Account Ledger reporting ,so when i enter date and Party Name as a parameter and then report should generate and also that report can be printed.
please guide me how to do this or suggest me any good tutorial links on net .
need urgent help of u fellows...hope to get satisfactory reply .
thanks in advance
Help Needed Using Crystal Report With Vb6
Hi, everybody,
I need to create a new crystal report by passing variables (whic store the field data) into it using vb6 (the field name and typ need to pre-define. they are fixed). I have not use crysta report much yet. I searched within this website, and tried som codes but do not work for me. Does anyone have any suggestions Sample code definiately help a lot. I really appreciate you help.
Crystal Report Help Needed
Hi Friends
I am using vb6,sql server 7,crystal report 7 for
developing a small application.
I want to design a report for A4 Size .
Report contains mostly of text contents
which i have inserted into text objects.
These text objects are placed in page
header and page footer section of report.
I have datas to be taken from database
at the maximum of 5 datas per report.
i have pasted these fields in the details section
of the report.
My problem is even for the data of one record, details
section takes more than one third of report space.
So report grows to second page.
Will anyone show me how to reduce the number lines in
the details section (default space in details section of
the report) so that my report content is accomadated in one sheet.
cthirus
Crystal Report Help Needed
Hi all
I have a query Abour Crystal report distribution. I want to install cr7 report file at my client machine but not in the form of .exe
but as .rpt , and also the user can not open that file for updation or changes . pls guide me in this.
thanks in advance
regards
tushar
Help Needed To Display Data
G'day,
I have a database of up to 300 records and 20 fields, but I only need to display 8 fields.
The important field is a number between 0 and 13 called 'Zone'.
I want to display all the records on the screen, but sorted into one of 14 display areas (Zones). If there is too much data for one zone, vertical scroll bars must appear.
I need to be able to drag a line from one zone to another zone.
I need to be able to click on a line to bring up another form to display additional data.
The display zones need to refresh themselves each time a new record is added to the database which is kept on a server.
I thought about using 14 Flexgrids (because of the columns), or list boxes, or some other display method. Maybe I could get by with 2 display areas with 0-6 in one and 7-13 in the other and using separator lines.
There maybe too much data for one monitor, in that case, I am prepared to have 2 monitors off the one computer with 7 display zones on each screen.
Hopefully you can give me some ideas and your comments.
Feel free to email me.
Peter
Simple Crystal Report && VB Example Needed!
I'm very new to using crystal reports and have
only just figured out how to create a report
using data from my Access DB.
Does anyone please have a very simple basic example of how
to start using crystal reports in a Visual basic project??
Crystal Report 9 Files Needed For The EXE
I have two questions:
a) What are the files needed to load a vb exe with the CR9, in a computer without CR9? They asked for 'crviewer9.dll' so I put it in the directory of the exe, but it still doesn't work.
b) What should I use - CR9 or Data Report? The answer to this question probably lies on the reason I use them for. Well, all I want to do is merely two recordset in one report, each recordset changing its records through SQL.
Needed Help - Crystal Report / NPViewer
Hi All,
I have an application written using Visual Basic, which uses Crystal Report 8.5 for generating reports and Sql Server at the back end. I have installed the application on client systems. The Client system uses NPViewer for displaying Crystal Report. Applications displays the reports just fine. But the problem is Export option [I can see the Button] on the NPViewer is not working. Nothing will happen if I clicked on the Export Button. The client machine uses Windows XP. Is it because of any missing DLL or what. can some body please help me out???
Thanks in advance..
Sreekanta
Thanks and Regards,
Sreekanta J.
9844367535
Help Needed For Creating Crystal Report From VB
Dim rptDB As CRPEAuto.Database
Dim rptTbls As CRPEAuto.DatabaseTables
Dim rptTbl As CRPEAuto.DatabaseTable
This are needed when a Crystal Report has subreports that may access different tables.
How to go about doing it if i need to access different tables without a sub report and with s subreport???
Thanks!!!
How To Display Crystal Report
Hi to all,
I've just created a report from Crystal Report 8.0 but I'm struggling how
to display the report in VB.
Is the CRViewer the right control to use in displaying the report?
This is the code:
CRViewer1.ReportSource = "report2.rpt"
CRViewer1.ViewReport
But I got an error...
Data Type Mismatch.
Any help will be appreciated..
Display Crystal Report In Vb 6.0
hi, i want to display a crystal report in VB6.
The databasename is: Db1
The report name is: Level1CodeRegister
The form name is: frmReport
The CRViewer name for the form is: CRViewer1
if anyone could post the code for this or give me a sample i can substitute with i would be very appreciative as this is quite urgent for my college project. Thankyou in advance.
Crystal Report Display
I am working on a report, using vb and crystal reports.I have on-demand subreports in my main report.When I click on th link,I want the subreport data displayed just below the mai report data, and not seperately.Preferably I would like th design as, showing a + symbol for subreport.If the + is clicke it should show the subreport, just below the main repor section.If once again, the + is clicked it should hide th subreport.Please help.
Thanks
Display In Crystal Report
Hi
Can you Tell me how to Use Crystal Report 6.0 for displaying an Array of data Genrated by VB at runtime.
Is it possible or not?
Help Needed For Dos Mode Printing Using Vb And Crystal Report
Hai
Iam Ameen,
I have a small problem, I am working on VB 6 and I am using Crystal Reports as Reporting tools. My client want the report should be printed in DOS mode because he want the priting should be fast. Can u help me how i can get the DOS mode printing in VB for crystal report
if possible please send me code
thanQ
Dlls Needed To Print Crystal Report In Vb5 App??
Howdy all,
I'm developing a visual basic 5 program that will print crystal report documents (thru the Crystal Report Control 4.6 that's included with vb). This program will be distributed to machines that do not have vb or crystal reports installed on them. i'm having a difficult time trying to find the list of DLLs needed for the reports to be processed and printed! Every time i try to print a doc on one of these machines, it gives an error stating that that file could not be opened. The program *does* work on machines that have Crystal Reports installed, so i'm assuming that DLLs are to blame. Does anyone have any suggestions on where to find the necessary dll files?!?
thanks in advance,
chris wilker
Display Image On Crystal Report
i need to display an image on a crystal report. the report will print the image without being viewed by the user when a button is clicked. i have tried doing this using a dataset and xml schema, but it is not working. below is some of the code i was using. can someone please help?
Dim ds As New DataSet
Dim dt As New DataTable
Dim values(0) As Object
dt.Columns.Add("ImageColumn", GetType(Image))
If Not ipNotes.Image Is Nothing Then values(0) = Image.FromStream(ipNotes.Image)
dt.Rows.Add(values(0))
ds.Tables.Add(dt)
ds.WriteXmlSchema("c:PSI
eportschema.xsd")
Using One Crystal Viewer To Display Each Report
I have several crystal reports that I've created in VB with the .dsr extension. Do I have to create a separate form with a CrystalViewer control on it for each .dsr report or can I just have each one load up in that one control as each report is called by the user?
Cannot Display Graph Of Crystal Report In VB
I create a graph report in crystal report 6.0 , it's OK .
But the report does not display on VB 6.0. ( I use the same way as tabular report). The report show only tabular data how i can fix it..
Display String In Crystal Report
How can i display a string from other form in the crystal report v7.0?
Eg...i have accept a date (string) in a form then when i display the report, i want to show that date inside there.
What method can i use?
Disorder Display In Crystal Report
Dear all,
Please help me out when I am selecting conditioned record in Form
Flexgrid it is showing selected records correctly but when i am
executing same selecting condition formula in crystal reports
the crystall reports view gets sometimes correctly & sometime it
incorrectly. why?
Thank you & grateful
Santosh
Display More Than 256 Characters In Crystal Report
Hi
I am facing problem in displaying text in Crystal Report. It displayspart of string (256 characters). i have a long text to display can anyone help me.
P.R.Krishnan
Web Traverse India Ltd.
Ph:91-22-8577025
Crystal Report 8.5 Display Problem
hey ppl.
i m using crystal reports 8.5 and VB6 . whenever i pass a value the whole report comes out blank. this is my code
Code:
Dim Report As New CrystalReport1
Public jobno As String
Private Sub Form_Load()
Report.Database.LogOnServer "p2ssql.dll", "T2T2", "JBSurvey1", "sa", ""
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
jobno = frmJobDet.txtJobNo.Text
Report.ParameterFields.Item(1).AddCurrentValue jobno
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
End Sub
Private Sub Form_Resize()
CRViewer1.Top = 0
CRViewer1.Left = 0
CRViewer1.Height = ScaleHeight
CRViewer1.Width = ScaleWidth
End Sub
Quick Display Crystal Report 8
i m new be with crystal report 8.
i have few conf abt crystal report 8 with vb6.
my project have connection object is created dynamic not Data Enviornment.
IN project v generally use Recordset to query db , i want to show such query int o crystal report. I want to use a single report for all Reports like invoice , product master, party master etc.
1) How to create a crystal report on basis of query ? v give dynamically generated query i.e. recordset to crystal report and it display those records.
2) what is fastest way to populate data in crystal report ??
thanx in advance.
It May seem Impossible, But Possibly We don't know the way how to reach there ????
Crystal Report - Bottom To Top Display
I want display the word from Bottom to Top in crystal subreport, is it possible.
i attach my file, it more easy to understand what i mean.
In deposit received: if more than 1 deposit, maybe 1 pay by cash, another pay by cheuqe, then my record "DEPOSIT" will be grow,
normally record was grow from Top to Bottom, but i want it grow from Bottom to Top, is it possible ?
How To Display Crystal Report 8.5 In VB6 Application??
Hi All,
I am newbies in integration of Crystal Report 8.5 with VB6 application.
Code:
Private Sub Command1_Click()
CR.PrintReport
CR.LogOnServer "PDSODBC.DLL", "DNS NAME", "DATABASE NAME", "USERID", "PASSWORD"
End Sub
CR is Crystal Report Control.
When i run it, it will prompt me to set the Parameter for crystal Report as usual. After parameter has been set, the report is gone after few milisecond.
Can anyone help me on that?
Thanks!
Display HTML Tag In Crystal Report
Quote:
Originally Posted by dragon_ballz96
Basically, i allow user to enter some free text (part of the content) which can contain html in a quoutation. It will then be exported to PDF using VS .Net Crystal Report. I understand that crHTMLText is currently not working properly. Is there any other work around?
Rgds
Ryan
hello please i have the same probleme, i have customers that send me a fragment of an HTML code on an XML file, and when i generate the with crystal report, i also do the interpretation with crHTMLText but the result is not formated corretly.
so i want to know if you have resolve your probleme by any way.
thank you (excuse me for my bad en english, i speak french).
thanks a lot
Crystal Report 8- Cannot Display The Chart
Well, things were all going fine, until I upgraded my Crystal repports from version 7.0 to 8.0.
I am able to open a report (that does not have a chart) perfectly alright from VB. But if the report has a chart, it is giving an error 'run time error 20998'.
Why is this happening? Is there a dll I/m missing? Why does it open a report but not a chart? Please let me know. It's kinda urgent here.
thanks
Display Text In The Crystal Report
Hi,
i want to enter a text in the text box on the VB like'Employee Detail" and show this in the crystal report without using table.
how can i do this..
thanx in advance..
subas
Display HTML Tag In Crystal Report
Hi,
I am using VB .Net to export a crystal report to PDF. Seems like one of the fields which contains HTML tags didn't display correctly even i have set the property of the field to crHTMLText. I have applied the latest patch for VS .Net 2003 but it don't seems to work. Anyone has any idea to get this one fixed? Let me know. Thks.
Rgds
Ryan
Display Of Tabular Data--Control Needed.
Hi,
I am trying to display a set of tabular data which sometimes can
run long.At present I use Heirarchial Flex Grid and it does not
provide a gud User Interface and the readability is poor.I am
thinking of displayin them in a HTML page in the VB application
itself with some good GUI(Say like hyperlinks, etc.).So please
suggest a method to acheive the same ASAP.
Thanks in Advance.
Help Needed In Viewing Crystal Report Through CRViewer Control In VB
Please Help.
I am a VB6 Programmer, but Iam new to Crystal Reports. Iam tyring to view a .rpt file using the CRViewer control in VB. The Report is not showing in the CR Viewer control and each time I click the refresh button or print button, it gives a message EServer has not yet been openedE
I am using a password protected MsAccess database. The version of crystal report is 8.5. Could u please tell me how to connect the database to the crviewer.. Iam pasting the source code below..Kindly help.
============================
Dim Appl As New CRAXDRT.Application
Dim cr As New CRAXDRT.Report
Private Sub Form_Load()
If rec1.State = 1 Then rec1.Close
rec1.Open "select * from clientmaster order by clientname", db, adOpenDynamic
Set cr = Appl.OpenReport(App.Path & "ReportsClientlist.rpt")
cr.Database.SetDataSource rec1, 3, 1
CRViewer1.ReportSource = cr
CRViewer1.ViewReport
End sub
==============================
Source Code Needed For VB5 To View Crystal Report
Hi,
I am trying to integrate crystal report version 9 into Visual basic 5 so that another person without Crystal report dll can actually view my report. May I know what are the essential visual basic source codes to be written to so that I can create the setup successfully and to run the setup in another person's pc....
Thanks
Display 20 Rows Per Page In Crystal Report
Hi
1. How can i display 20 records in detail section per page in crystal reports.
2. I have put Urdu data in my access 2003 database. How can i get that data in Crystal Report.
If anybody got clue could please email me.
Thanks
Best Regards
Farooq
Display Variable Value In Crystal Report Text Box
In my application I have certain calculated values stored in variables. I am using Visual Basic 6 and Crystal Reports 8.5 and my Report has certain Text Boxes where I want to display the calculated values. I don't want to use the Data Fields. I want to do like this:
Code:
Dim C as ...CrystalReport1
Dim var1, var2 As String
Set C = New CrystalReport1
C.txtName.Text = var1
C.txtNumber.Text = var2
But the Crystal Report displays an error at lines "C.txtName", saying that it is a Read-Only field.
Crystal Report : Restrict Second Instance From Display
Hi
In one of my project when user clicks 'Print Preview' button it will displays the report, but when user clicks again the 'Print Preview' button it displays the second instance of the same report even though the first one is on the screen
How to avoid displaying the second instance of the same report OR how can i restrict this.
Thanks.
How To Display Selected Records In Crystal Report
hello...
i have a prb ... is regarding to display crystal report....means... how to get the crystal report display the selected records??
ex...
i have these Stocks
A001,A002,A003,A004, A005
i only select the A002, A003 and A004 to be display
and this is my code...
my database name is Inven.mdb
thanks
swiss
********************************************************
Private Sub cmdPrint_Click()
Dim sCondition, sTemp As String
sCondition = ""
sTemp = ""
mOK = True
If optSpecificStockCode.Value = True Then
sTemp = ("{stocktake.StockCode} >= " & cbStockCodeFrom.Text & _
" and {stocktake.StockCode} >= " & cbStockCodeTo.Text & "")
If sCondition = "" Then
sCondition = sTemp
Else
sCondition = sCondition & " and " & sTemp
End If
End If
If optPreview.Value = True Then
mDestination = crptToWindow
Else
mDestination = crptToPrinter
End If
Debug.Print "f=" & sCondition
With rpt
.Reset
.DataFiles(0) = (App.Path & "Inven.mdb")
.ReportFileName = (App.Path & "
ptst.rpt")
.WindowTitle = "Stock Take Report"
.WindowState = crptMaximized
.WindowShowRefreshBtn = True
.SelectionFormula = sCondition
.Destination = ToDestination
If .PrintReport() <> 0 Then
MsgBox "Error #: " & .LastErrorNumber & vbCrLf & .LastErrorString
End If
End With
End Sub
**********************************************
Crystal Report Will Not Display Multiple Values
I am using the code below to display employee payroll information
depending on the value entered for a parameter named department.
In the code below I use the value 1234 for the department number
as an example.
I would like to be able to display information from multiple
departments, departments 1234, 2222 and 9876 for example.
Ideally, the report would be setup to show department 1234's
payroll information, then on a new page department 2222's
information, then on another new page department 9876's
information.
I have tried setting the parameter to accept multiple values, but
when I do that only the information for the lowest value (1234
in this case) is shown. The lowest value problem is probably a
reflection of the department field being a numerical value, but
even if I change it to be a string I think I would probably just
end up getting information for the first entered value.
If anyone knows how to get a crystal report to display
information for multiple discrete values, passed
programmatically, please advise. I'm using Visual Studio 2005
Professional.
Private crReportDocument As New PayrollReport()
Private Sub frmPayroll_Load(ByVal sender As Object, ByVal e
As System.EventArgs) Handles MyBase.Load
crReportDocument.SetDataSource(DsEmployeesPayroll1)
Dim crParameterFieldDefinitions As
ParameterFieldDefinitions
Dim crParameterFieldDefinition As
ParameterFieldDefinition
Dim crParameterValues As ParameterValues
Dim crParameterDiscreteValue1 As ParameterDiscreteValue
Dim crParameterDiscreteValue2 As ParameterDiscreteValue
' Get the current ParameterFields collection from the
ReportDocument.
crParameterFieldDefinitions crReportDocument.DataDefinition.ParameterFields
' Get the "Department" ParameterField from the
collection.
crParameterFieldDefinition crParameterFieldDefinitions.Item("Department")
' Get the current values from the ParameterFields
crParameterValues crParameterFieldDefinition.CurrentValues
crParameterDiscreteValue1 = New ParameterDiscreteValue()
crParameterDiscreteValue1.Value = "1234"
crParameterValues.Add(crParameterDiscreteValue1)
crParameterDiscreteValue2 = New ParameterDiscreteValue()
crParameterDiscreteValue2.Value = "2222"
crParameterValues.Add(crParameterDiscreteValue2)
' Apply the current values.
crParameterFieldDefinition.ApplyCurrentValues(crPar ameterValues)
crvPayroll.ReportSource = crReportDocument
End Sub
Display Image In Crystal Report From Database
hello
sir
i am desperately in need of suggestion or say i want to know how to display image (ie pic of students) in a crystal report to print their admit cards.
Sir i have a databese field name (picture datatype - ole object ) in STUDENT_mas table
and the data stored in the database is Long binary data
sir now i want the report off all students for their admit card with their pic stored in the database on the report . iam able to display the same in vb in image control
but not able to display it in crystal pls
pls
pls
pls
help
thanking u in advance
hussain
|
TRACKER
