Visual Basic :: Crystal Report 8- Cannot Display The Chart

Crystal Report Chart And VB6 Help??
Hello!....I m using crystal report with visual basic 6.......i develop a report in crystal report in which i add a chart control......when i see preview in crystal report and move mouse over chart then on Tool tip i get each data point shown on mouse movement......
but when i open this report in VB...and run project and move mouse over it then i only get "CHART"...for whole movement.....how i can get data values for mouse movement in VB6??.....thanks in advance........

Crystal Report And Chart
I have developed code using Crystal report.
I am using the Chart of the crystal report.
Can any onr tell me what are the files that I should distribute with this application

Thanks in advance.

Crystal Report Chart
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

In Crystal Report, Report Is Viewed But Doesnot View Next Page Or Not Any Message Display!
in crystal report, report is viewed but doesn't view next page or not any message display! and surprisingly page no is increased infinitely (up to no limit!, I have checked up to 400+) but next page was not displayed! if I print report , only 1st page is print!

In this report , I have attached 6 subreports!

I hope anybody reply about my problem

Crystal Report Chart Problem
Hi all, I'm using CR8.5 & VB6.0 SP5
and I have this problem:

The report is designed with two graphs (one overlaying the another). The top one is set to have a transparent background so that the bottom chart can be seen beneath it.
The graphing combination previews correctly in the Report Designer, however, once the report is viewed through the viewer the transparent background of the first chart becomes opaque and the bottom chart is no longer visible.

Why is the top graph no longer transparent when viewed through the viewer?

Please help, thanks in advance

Marcotta

Crystal Report, Bar Chart Question.
I currently chart dated records from an access db such that there is a count of how many records where generated per Day. There may be times when no records will be generated for a certain Day, resulting in a graph of only the dates which had records generated. I would like to graph this data from my database, but I want all days of a month show up on the graph even if no records where generated for certain dates.

I suspect this could be done by a formula but I can't figure out how to get the forumula to graph the required data.

THANKS!

Crystal Report, Bar Chart Formatting
So I have this bar chart that graphs out some dates. They are currently displayed in MM/DD/YYYY format. I would like to just display the day (DD) on the Group Axis but I don't see any options to do this. I suspect it can be done via a formula but I am not sure how to do that.

Refreshing Crystal Report's Chart
I've made a chart which linked to MsAccess DB file.

Whenever I do a call from VB,

Code:
CrystalReport1.Destination = crptToWindow
CrystalReport1.Action = 1

The chart is not updated with the latest content from the DB file.

Can anyone help me with the command to refresh the chart?

Thanks

Harddisk

Crystal Report With Line Chart
Hi,

I need to do a line chart report, which accept input like
1. Start date
2. Number of Months
3. Minimun length (of the 3 types pressure)
4. Maximum length (of the 3 types pressure)
5. 3 types of pressures

where the X-axis is the month(of Start date), Y-axis is the pressure(with the minimum and maximum pressure)

How could I set the variables in the chart ?

Thank you...

rerds,
Yen

Crystal Report Chart - Logarithm
Hi people!

I included a chart (bar type) in a report where the data fields are in completely different rage, for example;

field 1 = 0,820
filed 2 = 53.000,000

I´m trying to use the logarithm scale but I can´t show numbers smaller than 1. My intention is to have the logarithm data scale varying from 0,100 to 100.000 for instance.

Any help will very appreciated.

Ricardo

P.S. Please forgive for this is not VB programming!

Chart Invisible In Client Side (Crystal Report 8.5)
My program is delevoped using VB6.0, MKSQL 2K and Crystal Report 8.5.

I want to create a report with a line chart on it. Its normal when using in my PC (bcoz i've installed Crystal report 8.5). However, I try to install it to my client PC and run the program. The report pop-up, but the chart invisible.

I cannot install Crystal report to the client PC. What can I do???
I've tried to copy some dll to the client PC, but still not work!

Can anyone help me??

Stephanie

Changing Line Color Of Crystal Report Chart Object
Hi,
The following problems encountered while plotting the line graph in crystal report.

Dev Environment: Visual Basic .NET 2003
Graph object used: Crystal report chart

Pb1) I want to change the line colors in plots. There are five to six variables in my graph. The object assigns random colors to the line. Many times two lines are drawn by same color. How do I change the line color in chart object?

Pb2) In the same chart I want to change the legend names. As per "ReleaseNotes.Doc" document this problem is fixed in crystal report Ver 9.0("ReleaseNotes.DocADAPT 13986"). I am using the "9.1.5000.0" version. (This is what it shows on all crystal report dlls). How do I change the legend names?

Thanks in advance for the information you will provide.

Regards,
Ani

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?

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?

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 !

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 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

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

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 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

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.

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.

Display Crystal Report VIA Visual Basic
How do I display a Crystal Report through Visual Basic code? What is the syntax to display the report ?

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 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

Help! Display Bit Value On Crystal Report As A Group Header In VB.net
Hi! I have some problems trying to display a column with bit data 1,0, Null values to a readable text description like 1 = True, 0 = False, Null value = 'Others' in the crystal report group header. Anyone can help?

Edited by - spritescream on 9/4/2004 12:14:43 AM

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