Visual Basic :: Crystal Report Viewer(Urgent)

Passing Crystal Report Or Viewer A Value Used For Filtering The Report
I having a problem trying to filter out my crystal report based on a case number which is a primary key in my access table tblCaseInfo. I am trying to do this through vb.net so when the user is viewing a particular case they can click the print button and print only that particular case being viewed. The case number will be coming from a textbox (txtCaseNumber.text) on the form in vb.net.

As of right now when the print button is clicked every case in the database is displyed in the crystal report viewer to be printed.

I have three tables involved:
tblCaseInfo - VictimID, AssailantID are foreign keys for the table listed below
tblVictimInfo - VictimID Primary Key
tblAssailantInfo-AssailantID Primary Key

Only code I have so far:

Private Sub btnPrintSurveyReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrintSaveSurveyReport.Click

frmSurveySummaryReportInstance.ShowDialog()

End Sub

How To Have Multiple Report On The Same Crystal Viewer Report Control Vb.net CR9
Hi !
I try to set more than one report to the crystal viewer control where the user
can use the top TAB to naviguate between report.

I search for it since a long time but nothing found.
Anyone know how to do this ?

Thanks a lot !
Joe

Where Is Crystal Report Viewer?
Hi folks, i'm looking foward to print a crystal report but i'm having trouble finding the correct procedure. after looking at a few samples i noticed that every one is talking about crviewer but i can't find it anywhere, can someone help out on this? maybe i don't have the correct version of VB?

maybe someone can also give me a code sample on how to simply print the reports without having to view it.

Thanks again for the help!

Crystal Report Viewer From VB
I am about to write a program which will use Crystal Report viewer to grab reports and display them so that the users on site don't have to have crystal installed.
I would like to do this dynamically when they click on a *.rpt file.

I have worked out how to get my program to run when this happens but am not sure how to grab the 'filename' parameter which is generated (%1).

It' s probably really simple stuff but have not done this before - can anyone help?

Crystal Report Viewer
Hi friends,
How to use CRViewer to show report which is created using automation server. Please help with some sample code.

thanks in advance.

Thomas George

Crystal Report Viewer, Where Is It
I have crystal reports version 10. I install it and it adds alot of references and components, none of which I am sure does what. I have added the crystalactivexreport viewer since I cannot find any other viewer. I have then added this code

VB Code:
Dim Report As New CrystalReport1 Private Sub Form_Load()Screen.MousePointer = vbHourglassCRViewer1.ReportSource = "C: estCR 8.5
eport.rpt"CRViewer1.ViewReportScreen.MousePointer = vbDefault End Sub Private Sub Form_Resize()CRViewer1.Top = 0CRViewer1.Left = 0CRViewer1.Height = ScaleHeightCRViewer1.Width = ScaleWidth End Sub Private Sub Form_Unload(Cancel As Integer)Unload MeForm1.ShowEnd Sub

Apparently that is not anyway to do it cause no matter what I try it will not display the report. Any help would be appreciated.

Crystal Report Viewer
Hi all
I'm doing a project in VB6. I wanted tomake reports in Crystal Reprts 9. I have used prior versions of crystal reports before.
But using this version, I don't get any crystal report control in VB control component list. Ther I get only Crystal Report Viewer.
I created reports using crystal reports. but how can I display it thro' VB using Crystal Report Viewer?

Please help

Crystal Report Viewer
Hi

I have created one report (Invoice.rpt), now i want to display it in the Crystal Report Viewer Control. I am using Crystal Report 8.0. I am new to Crystal Report.

Please Help

Crystal Report Viewer
How to display Export button on Crystal Report Viewer

Crystal Report Viewer And VB.NET
Could anyone tell me how to pass parameters in VB.NET 2003 to Crystal Report Viewer Control. Some lines of coding would be very much appreciated.

Crystal Report Viewer
crystal report viewer ...?

Crystal Report Viewer
i designed my report in crytal report, and i used a crytal report viewer on the form in VB6. i need the code to link the crystal report to the viewer and the code to view it

Using Crystal Report Viewer
how do you display a report using the report viewer?

Crystal Report Viewer
Can any one point me to an example on how to use crystal reports in VB.I want to use CRViewer to display the report.

thanks

Crystal Report Viewer With VBA
Hello,

I'm starting to use the Crystal Report now and I'd like some tips to do a print report from data that already is available in a recordset.

I don't need to show the report I just need to print this with a predefined format.

Somebody could help me sending an example or where can I find some documentation about it?

Thanks a lot in advance.

Cleber Polli

Crystal Report Viewer Refresh
I know this has been answered many times on this form, but I can't seem to find an example like mine...and maybe that's because I'm going about it all wrong...you guys tell me.

The crystal report that I'm displaying is a stand alone crystal report based on one summary table (hitting oracle through odbc dsn). I want to replace the table that the report is based on with a sql statement (onclick of my report button) and then have the report viewer refresh the report link so that the most current version of the data is displayed in the viewer.

I can get the report to refresh at run time when clicking on the little yellow lightning bolt on the viewer...however, I would like for the viewer to refresh the report on the initial load of the report.

I've tried crviewer1.refresh and I get an error message that says "method'refresh' of object 'Icrystalreportviewer3' failed? However when I hit debug and then just hit run again from design mode, it does refresh the report.

thanks here's my code

Dim NETADCREATEQRY As String
Dim NETADDROPQRY As String
Dim crysApp As New CRAXDRT.Application
Dim selectedreport As String
Dim myRpt As CRAXDRT.Report

NETADDROPQRY = "DROP TABLE NETWORK_ADEQUACY_RPT;"
NETADCREATEQRY = "CREATE TABLE NETWORK_ADEQUACY_RPT AS SELECT DESCRIPTION, SUM((CASE SUBSTR(C.CCHP_RESTRICTIONS,1,1) WHEN '1' THEN 1 ELSE 0 END)) OPEN_PCPS, SUM((CASE SUBSTR(C.CCHP_RESTRICTIONS,1,1) WHEN '2' THEN 1 WHEN '3' THEN 1 ELSE 0 END)) CLOSED_PCPS, (CASE C.IPA_GROUP_NAME WHEN 'CCPN' THEN 'YES' Else 'NO' END) CCPN, COUNT(D.PROV_NO) TOTAL, SUM((CASE SUBSTR(C.CCHP_RESTRICTIONS,1,1) WHEN '1' THEN 1 ELSE 0 END))/COUNT(D.PROV_NO) PERCENT_OPEN FROM PHYDEMOGRAPHIC D, PHYSPECIALTY A, PHYADDRESS B, PHYLOB C, COUNTIES E WHERE D.PROV_NO = A.PROVNO (+) AND D.PROV_NO = B.PROVNO (+) AND D.PROV_NO = C.PROVNO (+) AND B.CTY_CODE = E.CODE (+) AND A.PRVTYP = 'PCP' GROUP BY (CASE C.IPA_GROUP_NAME WHEN 'CCPN' THEN 'YES' Else 'NO' END), E.Description ORDER BY (CASE C.IPA_GROUP_NAME WHEN 'CCPN' THEN 'YES' Else 'NO' END) DESC;"

' DROP AND RECREATE THE NETWORK ADEQUACY REPORT TABLE
With cmd
Set .ActiveConnection = con
.CommandType = adCmdText
.CommandText = NETADDROPQRY
End With

With rs
.LockType = adLockOptimistic
.CursorType = adOpenDynamic
.CursorLocation = adUseClient
.Open cmd
End With
With cmd
Set .ActiveConnection = con
.CommandType = adCmdText
.CommandText = NETADCREATEQRY
End With

With rs
.LockType = adLockOptimistic
.CursorType = adOpenDynamic
.CursorLocation = adUseClient
.Open cmd
End With

selectedreport = "J:ReportsGen30Completed_ReportsREPORTING DIRECTORYNETADEQ.rpt"
Set myRpt = crysApp.OpenReport(selectedreport)
Call myRpt.Database.Tables(1).SetLogOnInfo (mngp, , "mylogon", "mypwd")

With RPTS
.Show
Screen.MousePointer = vbHourglass
.CRViewer1.ReportSource = myRpt
.CRViewer1.ViewReport
.CRViewer1.Zoom 100
.CRViewer1.Refresh
Screen.MousePointer = vbDefault
End With

Closing Crystal Report Viewer
My crviewer is on a form I want to close the view but not the form.

I craeted a button to close the viewer with the code crviewer.closeview,

but I get an error message "Argument not optional" what am I doing wrong.

Crystal Report Viewer Beginner
I am a beginner in the field of Crystal Report Viewer and desprately need help.

I just want to load a report, insert the parameters and view the report, however it is playing silly beggers with me!

Can anyone tell my what i am doing wrong?

BELOW IS MY CODE:

Code:
If Not Session("InputParms") Is Nothing Then

Dim Parms() As String = CType(Session("InputParms"), String())
Dim strParmNames() As String = CType(Session("ParmNames"), String())
Dim i As Integer

Report.Load("C:Test EnvironmentsDGS Reports" & ddlDepartment.SelectedValue & "" & ddlReport.SelectedValue, OpenReportMethod.OpenReportByTempCopy)

For i = 0 To UBound(Parms) Step 1

Report.SetParameterValue(strParmNames(i).ToString, CObj(Parms(i).ToString))

Next

End If

Dim logoninfo As New TableLogOnInfo

Dim table As CrystalDecisions.CrystalReports.Engine.Table

For Each table In Report.Database.Tables

logoninfo = table.LogOnInfo

With logoninfo.ConnectionInfo
.ServerName = "DEV-ERPDBS"
.DatabaseName = "Test"
.UserID = "test"
.Password = "test"
End With

table.ApplyLogOnInfo(logoninfo)

Next

With crv
.ReportSource = Report
.Visible = True
End With
Thanks

Crystal ActiveX Report Viewer
VB 6 Enterprise; Crystal Reports XI Developer Edition

Is there any way to get rid of (not display) that hideous "Business Objects" icon in the upper right hand corner of the Viewer?

Thanks, Sam

Crystal 9 Report Viewer Progress Bar
Hi

I am confused about the crystal reports veiwer. When it is loading, which can take some time, I would like the user to be informed of the progress but this does not seme to happen. I have set the CRV.EnableProgressControl = True and it shows a progress bar at the top of the viewer but it sits there motionless.

I have had a search on the forum for any information on this but all I could find was something saying it was not possible to show a progress bar. Could this realy be the case?

If you can't show a progress bar is it possible to show something moving to keap the user entertained like:

Code:
CRV.ViewReport
CRV.EnableProgressControl = True
CRV.ReportSource = crxReport
CRV.ViewReport
CRV.Refresh
CRV.Visible = True
fraProgress.Visible = True
Me.Show , frmParent
frmParent.SetFocus
Incrament = 1&
Do While .CRV.IsBusy = True
DoEvents
Debug.Print "Loading "
PB.Value = PB.Value + Incrament
If PB.Value = PB.Max or PB.Value = PB.Min Then
'Show a Kit effect
Incrament = Incrament * -1&
End IF
PB.Refresh
Loop
fraProgress.Visible = False

But when I try this I get one debug print despite the load taking up to a minute!

Any help would be appeciated.

Crystal Report Viewer - Not Supported
I had create crystal report and run in application vb6. But one of the report pop-up crystal report viewer "Not Supported" message, so the blank report is return. I try it in crystal report is no problem, but dont know how the problem come out. I hope you all can help me to find the solution.
Thanks you

Vb Crash When Using Crystal Report Viewer
hi, i'm using crystal report 9 professional version. i can compile my code. but when i click a command button in my form to generate the report. it will crash the vb. what is the meaning of this? i'm 100% confirm that the vb and crystal report were installed properly. i think the problem is caused by the connection property settings. if i don't use it, it work. but if i set the connection property, it will crash. could it because of i'm using professional version? because it don't allow me to use certain function of developer version IMO. please help!!! here's my code

Code:
Private Sub showreport(rpt As String)

Dim crxApp As CRAXDRT.Application
Dim crxReport As CRAXDRT.Report
Dim crxTable As CRAXDRT.DatabaseTable
Dim CPProperty As CRAXDRT.ConnectionProperty
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sSelect As String
Dim sRep As String

Set crxApp = New CRAXDRT.Application
Set crxReport = crxApp.OpenReport(App.Path & "/" & rpt & ".rpt", 1)
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset

sSelect = "SELECT * FROM tbitem where categoryid = 5 "

sRep = App.Path & "/dbar.mdb"
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & sRep & ";Persist Security Info =False"

cn.Open
rs.Open sSelect, cn, adOpenKeyset, adLockOptimistic, adCmdText

For Each crxTable In crxReport.Database.Tables
Set CPProperty = crxTable.ConnectionProperties("Provider")
CPProperty.Value = "Microsoft.Jet.4.0"
Set CPProperty = crxTable.ConnectionProperties("Data Source")
CPProperty.Value = App.Path & "/dbar.mdb"
Set CPProperty = crxTable.ConnectionProperties("User ID")
CPProperty.Value = ""
Set CPProperty = crxTable.ConnectionProperties("Password")
CPProperty.Value = ""

crxTable.Location = App.Path & "/dbar.mdb"
Next

' For Each crxTable In crxReport.Database.Tables
' 'for OLE DB the properties would like this.....
' With crxTable.ConnectionProperties
' .item("Provider") = "Microsoft.Jet.4.0"
' .item("Data source") = App.Path & "/dbar.mdb"
' '.item("Initial Catalog") = "Catalog"
' .item("User ID") = ""
' .item("Password") = ""
' End With

' crxTable.Location = App.Path & "/dbar.mdb"
'Next

crxReport.DiscardSavedData

crxReport.Database.SetDataSource rs

CRViewer91.ReportSource = crxReport
CRViewer91.ViewReport
Screen.MousePointer = vbDefault
End Sub

Crystal Report Viewer Control 9
Hi to all,
I'm newbie in crystal report 9 link with vb6. Now, I m facing big problem in Crystal Report 9. I don't know how to use Crystal Report 9 viewer control to view my report n print it out. Can somebody help me?

Will someone give me a solution and sample? Thanks.

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?

Clearing Crystal Report Viewer
Hi folks,

I have looked over the forum and found various items to do with the crystal report viewer but none that give me a solution to th problem i'm having.

I have an application which consists of a form with a report viewer and several buttons showing popup menus for various reprots that the user can select.

When the form loads the report viewer is a completely blank white control until a report is selected, then it comes to life and the report is loaded. This works fine.
What i'd like is to set up a button that can be clicked so's to clear the report viewer control and show it like it is when the form is first loaded. Does anyone know of any way to do this?

Many thanks in advance.

Need Help In Using Crystal Report Viewer Control 9 With VB6
Hello all
I need help in Using Crystal Report Viewer Control 9 with VB6
Please help me
Thanks in advance
Farooq

Crystal Reports 10 And Report Viewer
Looking for anybody who has used Crystal Reports 10 to design reports and then use the control "Crystal Report Viewer Control" in order to actually present the reports to the user?? Or .. is there an easier way???

thanks ... gollnick

Crystal Report Viewer Full
I have a crystal report viewer on teh main form. As they compute different data, the data is saved to a tmp table and the crystal report is supposed to show the new data.

Example.

They choose the horse, for a report. The report data is figured, and inserted into a table. Then it opens the crystal report viewre, linked to a premade Crystal report. This crystal report does not save data when it is saved, it is linked to the tmp table that the data is inserted into.
The first time the program is run, everything works fine.

But after that, every time i try to open up the crystal report viewer, it gives me

Crystal Report Viewer Full. no error, just that, with an Ok button.
Once i push Ok, and click the refresh button on the crystal report viewer, I see the new report.

So how do I close the crystal report viewer, or the report itself to clear the viewer for any new report?

This is the code I am using to open the viewer.

VB Code:
frmMain.crvEnroll.Visible = TruestrPath = App.Path & "fileshorsestatsum.rpt" frmMain.crvEnroll.Top = 60frmMain.crvEnroll.Left = 4Set objCrystalApp = New CRAXDRT.ApplicationDim objReport As CRAXDRT.Report Set objReport = objCrystalApp.OpenReport(strPath) frmMain.crvEnroll.ReportSource = objReportfrmMain.crvEnroll.ViewReportSet objReport = Nothing

Any ideas?
(i know i'm missing something, probably fairly elementary too.)

Close A Crystal REport In Viewer
HI i have a CRViewer controol on a form and when i click a commandbutton it loads a report but what i also want is to unload the report , make it leave the CRView can this be done??? Thanks

Crystal Report Viewer Control
I can't believe the low quality of the Crystal Report Viewer Control that comes with CR 8.5 Developer.

1. It flickers whenever it is resized; not just the area where the actual preview of the report is shown, but the entire control including the toolbar buttons.

2. crviewer1.Refresh causes the following error...
"Method 'Refresh' of object 'ICrystalReportViewer4' failed"

3. If you set the controls visible property to false in either design or run time, it still shows it.

Does everyone else get the same behavior? Do I have a bad copy? Are there any solutions to the flicker?

Need To Make A Crystal Report Viewer
I need to make a Viewer for Crystal Reports 8. SeaGate Analysis doesn't work well. Anyone have any luck with such an endeavor???

Thanks,

Dan

Closing Crystal Report Viewer...
I am using crystal reports 8, and visual basic 6

I have a crystal report viewer, with its commands set up as a function. This way the different aspects of the program use the same viewer, so no two reports are viewed at the same time.

But after i open the first report, every report opened after that gives me a Memory Full error. It doenst close the program or anything, but will not show anythin in the area. I have to click one of the arrows to have the new report shown. I have tried refresh & a number of other things, nothing will close down the previous crystal report or viewer....

Any suggestions?

Crystal Report Viewer Problem With VB6
Hello, Help!!!

I'm using VB6 with ctystal reports, my installion ik ok but when trying to run the program, I'm getting the following error message:

Class not registered

Loooking for object with CLSID:{0000010-0000-0010-8000-00AA006D2E4}

How can I find out which object the message refers to?

When I try to run the program in some other PC which had a previous version of the program installed, the program works but the crystal report viewer doesn't. The screen dissapears instead of viewing the report.

Victor

Crystal Report Viewer Problem
Hi ! I am creating package for my vb project I have used designer in my project of crystal report 7.0. Setup is created and installed successfully but when i run the application it gives an error "application or object problem". I think not all the files for crystal report have been included. Please let me know the files required for to distribute crystal report 7.0

Flexgird, Crystal Report Viewer, Deploying
I have several questions?

Q:1

I am using vb.net 2003. I have imported the Flexgrid control from vb.
I want to use it in vb.net 2003. I wanna insert data from flexgrid to
database table when the save button is clicked.
Let us say i have 5 cols n 10 rows n all of them r filled. so when i
click the save button how the rows values are going to be saved in
the database table?We normally insert the data from a textbox using
rs.fields("...").value=.....text so how can we write this thing for
all the rows? n in the database we have only 5 fields?
I have searched a lot of examples on flexgrid control but all of them
r working only in vb. If anybody know any helpful url about flexgrid
that works in vb.net specifically in case of insertion of records from
the flexgrid to database i would be very thankful to him/her.

Q:2
How to use crystal report viewer in vb.net?

Q:3
what's the proper method of developing a setup for your application?

Close Button In Crystal Report Viewer
hi,
i'm using crystal report 8.0 . I'm displayig reports in VB using the Crystal Report Viewer. The "Close" button in the crystal report viewer is disabled even though I have set the "EnableCloseButton" property to true.

How can I enable the "Close" button??

Thanks

Crystal Report Viewer Err - Server Has Not Yet Opened
Hi all.
I'm using the Crystal Reports Viewer in VB 6 with CR 8.5.0.216. I've got the object installed and opening a report but I am having difficulty refreshing the report. When I attempt a refresh, I need to log on to the server to get the data out but do not understand the arguments for the
LogOnServer method (if this is even what I'm supposed to use). Particularly the pDllName but the rest are kind of vague as well.
If there is a better method, feel free to debunk my current effort since I am not certain of the servername and such.

here is my code.

Public Appn As CRAXDRT.Application
Public cReport As CRAXDRT.Report

Private Sub Form_Load()

Set Appn = CreateObject("CrystalRunTime.Application")
Set cReport = Appn.OpenReport("C:Program FilesDisplay BoardPmWorkOrder.rpt")

Appn.LogOnServer "p2ssql.dll", "T01App02", "Maximo", "myID", "myPass"

cReport.DiscardSavedData

cReport.RecordSelectionFormula = "{WORKORDER.WOEQ9} like 'T181' and {WORKORDER.SUPERVISOR} = 'PCC' and not ({WORKORDER.STATUS} in ['COMP', 'CLOSE', 'CAN'])"

CRViewer1.ReportSource = cReport
CRViewer1.ViewReport

end sub

Also, I've started getting an error telling me that pdssql.dll can't be found. I'm looking straight at the code and it says p2ssql.dll. Why is it fudging the name when it looks for it?
Thanks all
PB

Visual Basic With Crystal Report Viewer
I have had a number of problems using Crystal Reports in a Visual Basic application, but finally, finally have the problems resolved - except for one. This is a new one, something that has popped up just recently, and I am hoping there is a simple explanation.

I am loading the Crystal Report into the Visual Basic Crystal Report Viewer - which works fine. I press the Print icon on the CR Viewer, and nothing prints. No error, nothing. I go to Settings, Printer, and test the printer, and it prints a test page fine. I signed off as my client ( I was testing under his login), log-in as myself (I have higher machine permissions) but have the same problem. I go back to my own cubicle, with my own machine, and run the executable, which points to a different printer. When I click the printer icon in the CR viewer, nothing happens. But the printer prints anything from any other application. I even tried the program directly from the Visual Basic Development Environment, the same problem.

Anyone had this before? I hope so, so that you can tell me how to fix it. Bringing this application up has been a long battle, and this appears to be the last item that is 'stuck'

thank you, laurie

Crystal Report Viewer Not Showing All Records
I am using following code to display records in CRViewer. But how to add more pages to the CRViewer as the record pointer moves to the next record.

Code:
Private Sub Form_Load()
Dim tot, i, t

Screen.MousePointer = vbHourglass
'Set Report = CApp.OpenReport(App.Path & "
eportsCryspermit_Recordset.rpt")
Set rsReport = New ADODB.Recordset
Set Report = New CrystalReport1_Recordset2

If rsReport.State = adStateClosed Then
rsReport.Open "Select * from PermitReport", CN, adOpenKeyset, adLockReadOnly
End If

Report.Database.AddADOCommand rsReport.ActiveConnection, rsReport.ActiveCommand
tot = rsReport.RecordCount
CRViewer1.ReportSource = Report

For i = 1 To tot
With Report
.txtPermitNo.SetText rsReport!permitno
.txtPermitHolder.SetText rsReport!PermitHolder
If i <> tot Then
rsReport.MoveNext
End If
End With
Next i

CRViewer1.ViewReport
Screen.MousePointer = vbDefault

End Sub

Crystal Report Viewer And Date Problem
hi!
I am using vb6 and crystal report viewer and sql server as backend
Now my problem is
I am taking 2 inputs from vb6 and passing them to crystal report so that it can show me the sales between those 2 date

In crystal report i am using the datevalue function in the formula:

DateValue({Sales.dos}) in DateValue({?start}) to DateValue({?end})

Now when i started using crystal report viewer and pass the parameter value it says 'bad date format string'.

The date values which are being passed as parameter can not be wrong as i am taking the dates from dtpicker control and storing them in two variables
The same thing when i use without crystal viewer and call it explicitly with parameters it works
here is the code

Dim app1 As CRAXDRT.Application
Dim rep As CRAXDRT.report
Dim paras As CRAXDRT.ParameterFieldDefinitions
Dim para As CRAXDRT.ParameterFieldDefinition

Private Sub Form_Load()

Set app1 = New CRAXDRT.Application

Set rep = app1.OpenReport(App.Path & "
eportscostbenefit1.rpt", 1)

app1.LogOnServer "p2ssql.dll", Module1.server, "compseller", Module1.username, Module1.pass

Set paras = rep.ParameterFields
rep.EnableParameterPrompting = False
rep.DiscardSavedData

For Each para In paras
With para
Select Case .ParameterFieldName
Case "start"
.SetCurrentValue "'" & Module1.strt & "'"
Case "end"
.SetCurrentValue "'" & Module1.ed & "'"
End Select
End With
Next

With CostBftrpt
.Show
.CRViewer1.ReportSource = rep
.CRViewer1.ViewReport
End With
End Sub

thanks for help
Mukul

How To Pass Parameter Using Crystal Report Viewer
hi!
I have a report to which i am passing a parameter value custid
i was earlier using just the rdc control and showing the report and passing the parameter by

CrystalReport1.ParameterFields(0) = "custid;" & Combo2.Text & ";true"

now when i use crystal viewer using the foll. code

Dim app1 As CRAXDRT.Application
Dim rep As CRAXDRT.Report

Private Sub Form_Load()

Set app1 = New CRAXDRT.Application
Set rep = app1.OpenReport("c:sales1.rpt", 1)

With Form1
.Show
.CRViewer1.ReportSource = rep
.CRViewer1.ViewReport
End With
End Sub

the report prompts for a parameter

How can i pass the parameter to the report within this code so that the viewer does not prompt for any input
thanks in advance
Mukul

Viewing Reports In Crystal Report Viewer XI
Hello,

I have a program that I can run reports with and view them with Crystal. I have Crystal Reports XI installed on my PC and can view the reports fine. However, I have other users that do not have Crystal Reports installed on their PCs that would like to view the reports as well.

I have downloaded the Crystal Report Viewer XI application from BusinessObject's website and installed it on the PCs, but the reports are still not able to be viewed. VB comes back with some sort of a Crystal Report 9 dll file error. Even though my program has the Crystal Reports 9 library added to it, I'm still able to view the reports on my PC with CR XI.

Does anybody have experience with having PCs being able to view reports that does not have a full version of Crystal Reports installed on it, or by just having the Crystal Report Viewer software installed?

Any help that is provided is greatly appreciated! Thanks in advance!

Crystal Report Viewer: Logon Failed (VB 6.0)
Dear all,

There is an error message "Logon Failed" on one of the user's pc while he was trying to preview for certain reports, he could view the rest of the reports without any error message prompted. Besides, there is no problem for developer's pc and other users pc to view the reports. The system is written by using VB 6.0 and intergrated with CR IX. Does anyone could help?? Thanks.

Crystal Report Viewer Throwing Error 429
I am using a Crystal Report Viewer (version 10) in my VB6 application to display a report based on an Access DB stored on a network drive. Everything works fine on my development machine but when I open the vbform that contains the report viewer control on a user machine that does not have VB or crystal installed I get

Runtime error: 429 Activex component can't create object.

I have registered the crviewer.dll file like so:

VB Code:
Shell "regsvr32 /s \irpserver1StrategicPlannercrviewer.dll", vbHide

Runtime 429 still occurs on user machines. Am I forgetting to register something necessary for the user to utilize a crystal report viewer inside my vb app?

*Resolved* How Can I Close Crystal Report Viewer?
I have asked this before, but am asking again. Its the only thing not working correctly onmy program.

I have a crystal report viewer, with its commands set up as a function. This way the different aspects of the program use the same viewer, so no two reports are viewed at the same time.

But after i open the first report, every report opened after that gives me a Memory Full error. It doenst close the program or anything, but will not show anythin in the area. I have to click one of the arrows to have the new report shown. I have tried refresh & a number of other things, nothing will close down the previous crystal report or viewer....

Any suggestions?

Crystal Report Viewer Not Showing All Data
Hi,
I'm using Crystal Report viewer to show mailing labels. I'll pulling an ado recordset from an Access database. About 90% of the time when I pull up the report I am missing a record. It's always the same record, it's always in the same position. When I do a recordcount on the ado recordset the count is correct. There is nothing different about the record that I'm missing, it looks the same as all of the others. Here is my code:

strConnect = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=MAILINGLIST.MDB;" & "DefaultDir=" & App.Path & ";" & "UID=admin;PWD=;"
AdoCon.Open strConnect

AdoRs.Open "SELECT ExportFinal.Line1, ExportFinal.Line2, ExportFinal.Line3, ExportFinal.Line4, ExportFinal.Line5 FROM ExportFinal;", AdoCon, adOpenKeyset, adLockOptimistic

If Len(Dir("\comet
ootMailingListAdoRs.ttx")) > 0 Then Kill "\comet
ootMailingListAdoRs.ttx"
HRESULT = CreateFieldDefFile(AdoRs, "\comet
ootMailingListAdoRs.ttx", 1)

If optAvery5160 = True Then
Set CReport = CApp.OpenReport(App.Path & "avery5160.rpt")
End If
If optAvery5161 = True Then
Set CReport = CApp.OpenReport(App.Path & "avery5161.rpt")
End If
If optMARC = True Then
Set CReport = CApp.OpenReport(App.Path & "MARC2x2.rpt")
End If

CReport.DiscardSavedData
AdoRs.Requery

CReport.Database.Tables(1).SetDataSource AdoRs, 3
frmLabels.CRLabel.ReportSource = CReport
frmLabels.CRLabel.ViewReport
frmLabels.Top = 0
frmLabels.Left = 0
frmLabels.CRLabel.Height = ScaleHeight
frmLabels.CRLabel.Width = ScaleWidth
frmLabels.CRLabel.Zoom 75

frmLabels.Show

Has anyone had a similar issue. Any ideas would be heplful. thanks a lot

Crystal Report Viewer(Urgent)

How do i add crystal report viewer in vb 6?I add crystal report 8 activeX designer run time library from "references"and crystal report viewer control from "components"but the crystal report designer in the project explorer does not add.It's urgentEdited by - jiqlsh on 6/22/2004 10:25:14 PM