Visual Basic :: Access Reports In Visual Basic

Access Reports Vs Visual Basic Data Reports?
I need some help.

For the longest time - I've been using Access Reports that are printed on carbon copy bill of ladings and the like, etc. These reports print only the data that is based on one query. That one query is based on three text boxes on a form. The query searches whatever the user typed in those 3 text boxes and pulls all the records that match. If the user does not type anything in those 3 text boxes they automatically default to '*' in each of the text.

I want to do the same thing in Visual Basic. But I have a better idea for a search. I am using a DataGrid to list everything in a query and basically the user just highlights the row that he wants to choose. Then up top on the menu he clicks on whatever report he wants to print based on the record he/or she highlights. I know I've got to use DataGrid.Columns(0) as a criteria for a search and so I've finish what kind of SQL statement I'm going to use. As regards output, I'm unsure of what to use. I did try to pull up the actual Access Report I used before but that did not work because it would not recognize the DataGrid.Columns(0) command in the query.

I'm new to the Visual Basic Data Report - I don't see any tutorials anywhere.
I understand Crystal Reports are the old way of doing this but don't have a means to try that out.
At this point - in my development - I'm thinking I'd probably make a form that would have the same output with the text boxes tied to the datasource (recordsource would be the query) and then i'd print the form data only. But not sure how to do this either? Please help.

Thanks,

Stephen

Opening MS Access Reports From Visual Basic
I am using following code to view preview of a report built in MS Access, but it just displays an hourglass pointer and nothing happens. What's the problem?

Code:
Dim appAccess As Access.Application

Set appAccess = New Access.Application

appAccess.OpenCurrentDatabase App.Path & "dataeticketxp.mdb", True, "Devel0peR"

'appAccess.DoCmd.OpenReport "TestReport", acPreview, , "myOptionalCondition"
appAccess.DoCmd.OpenReport "TestReport", acPreview, , "myOptionalCondition"
'appAccess.DoCmd.OpenForm "Addresses", acPreview

appAccess.Quit

Set appAccess = Nothing

Importing MS Access Reports In Visual Basic
Can I access MS Access reports through VB code? Or, is it possible to call MS Access report with data passed from VB code at run-time?

Using MS Access Reports Within Visual Basic Securely.
I am working on a project in VB which has several reports that have subreports. Because of the complexity of the reports, I am unable to use the DataEnvironment in VB6. (but if someone can demonstrate subreports with it, I may reconsider).

I have decided to use MS Access 2000 and call the reports from within Visual Basic. My problem is that different users have access to certain reports, while other users can only view different reports. I am hoping to use an Access Project (adp) to connect to SQL Server 2000 with the SQL Server username and password I pass into MS Access (The credentials will change per user).

It appears to me that both Access and Crystal Reports prefer to save the connection string information in the file, and I'd like the ability to change this information from VB and open the report with the new string.

1) How would I go about securing this?
2) Does this sound reasonable, or am I going about this the wrong way?
3) I can also use Crystal reports, but I'm unsure how to do this in CR as well, also, because I'm using Office VBA extensively anyway, I was hoping to keep my licencing costs down.

thanks in advance for any help the community can provide.

Update: I just recently found out how I can modify the connection string in MS Access by using the CurrentProject.OpenConnection command. I still don't know how I would go about preventing the user from accessing the remainder of the database. I want them to SOLELY have access to the report I've opened through Visual Basic.

Edited by - hadmacker on 8/15/2002 1:32:22 PM

Access Reports In Visual Basic - Can't Find Component?
I've got all the code I need to make a report show in Visual Basic but I can't find the actual component or object to let me do this? Where should it be? If it isn't there for some reason - where can I get a long list of components to add to what I currently have!

Thanks,

Stephen

Problem Generating Reports Of MS Access From Visual Basic
Hi,

I am writing a code to generate reports of MS Access from VB. I have written the following code

<b>
Dim appAccess As Access.Application

Set appAccess = New Access.Application

appAccess.OpenCurrentDatabase ("test.mdb")

appAccess.DoCmd.OpenReport "tblNames", acViewPreview

appAccess.Quit
Set appAccess = Nothing
</b>

The problem is the report prints perfectly on the printer, but it does not show a preview of the report even if I have used the acViewPreview. Is there a way I can do a preview before I print the report?

Access Reports In Visual Basic With Like [FORMS]![NEW DISP]!ID
In Access I have a form named NEW DISP where the user searches for a particular record. Once the user finds that particular record, he/she has 12 different reports to print. All 12 reports are based on one query - the ID that the form displays.
Thus the following: (qryrptsearch) located in Access:

Code:
SELECT [DISP].[ID], [DISP].[DECI], [DISP].[ORDER], [DISP].[DATE], [DISP].[TYPE], [DISP].[JOB], [DISP].[CUSTOMER], [DISP].[FIRSTNAME], [DISP].[PHONE], [DISP].[PHONE1], [DISP].[CONTACTO], [DISP].[ORIGADDRESS], [DISP].[ORIGCITY], [DISP].[ORIGST], [DISP].[ZIP], [DISP].[CONTACTD], [DISP].[DESTADDRESS], [DISP].[DESTCITY], [DISP].[DESTST], [DISP].[ZIPDEST], [DISP].[WT], [DISP].[UNIT], [DISP].[CONTRACTOR], [DISP].[DRIVER], [DISP].[MOVERS], [DISP].[REMARKS], [DISP].[STOP], [DISP].[SPVR], [DISP].[GBL], [DISP].[SCAC], [DISP].[RANK], [DISP].[SOCIALSEC], [DISP].[code], [DISP].[ACCOUNT], [DISP].[KEYMAP], [DISP].[MAPREF], [DISP].[ETA], [DISP].[TIMEIN], [DISP].[PATRA], [DISP].[COMMREV], [DISP].[PAID], [DISP].[ACTWT], [DISP].[LH], [DISP].[PKG], [DISP].[CURRENTDATE], [DISP].[BKBY], [DISP].[SALESPERSON]
FROM DISP
WHERE ((([DISP].[ID]) Like [Forms]![NEW DISP]!ID));

Now I'm at a dilema.
I have tried to make the same thing with Visual Basic. It is a better form that connects to the data with an ADO control named datPrimaryRS. The 46th field in the Recordsource contains the ID of each record. I know that I want to change the above query (qryrptSearch) to something like this:

Code:
SELECT [DISP].[ID], [DISP].[DECI], [DISP].[ORDER], [DISP].[DATE], [DISP].[TYPE], [DISP].[JOB], [DISP].[CUSTOMER], [DISP].[FIRSTNAME], [DISP].[PHONE], [DISP].[PHONE1], [DISP].[CONTACTO], [DISP].[ORIGADDRESS], [DISP].[ORIGCITY], [DISP].[ORIGST], [DISP].[ZIP], [DISP].[CONTACTD], [DISP].[DESTADDRESS], [DISP].[DESTCITY], [DISP].[DESTST], [DISP].[ZIPDEST], [DISP].[WT], [DISP].[UNIT], [DISP].[CONTRACTOR], [DISP].[DRIVER], [DISP].[MOVERS], [DISP].[REMARKS], [DISP].[STOP], [DISP].[SPVR], [DISP].[GBL], [DISP].[SCAC], [DISP].[RANK], [DISP].[SOCIALSEC], [DISP].[code], [DISP].[ACCOUNT], [DISP].[KEYMAP], [DISP].[MAPREF], [DISP].[ETA], [DISP].[TIMEIN], [DISP].[PATRA], [DISP].[COMMREV], [DISP].[PAID], [DISP].[ACTWT], [DISP].[LH], [DISP].[PKG], [DISP].[CURRENTDATE], [DISP].[BKBY], [DISP].[SALESPERSON]
FROM DISP
WHERE ([DISP].[ID] Like datPrimaryRS.Recordset.Fields(46));

This is so when I click on the Command1 button to view "rpttime" (one of my 16 reports)...

Code:
Private Sub Command1_Click()
Dim appAccess As Access.Application
Set appAccess = New Access.Application
appAccess.OpenCurrentDatabase "c:Documents and SettingsStephen LeCompteMy Documentsdisp-1.mdb"
appAccess.DoCmd.Maximize
appAccess.DoCmd.OpenReport "rpttime", acPreview
appAccess.Visible = True
End Sub

the first thing it will go to is the qryrptsearch!

My problem is that it won't work.
I get a run-time error '3085'.
Undefined function 'datPrimaryRS'.Recordset.Fields' in expression.

How can I define or change qryrptSearch query to where it understands what the datPrimaryRS.Recordset.Fields function is?

Any help is appreciated!

Thanks

Creating Reports In Access 2000 From Visual Basic 6.0 Enterprise
Hi

I am currently developing a dynamic reporting utility which will create a report in access then view it with the snapshow viewer. However, the error: The Save action was cancelled is being produced.

I have spent the last 8 hours viewing everything I could find in MSDN, Net and Access Help, to no avail.

I would appreciate it if someone could assist with a solution. I am referencing the Microsoft Access 9.0 Object Library.

Please email me.

Regards

Ivan Dormain

Reports & Visual Basic
I am working on a project using vb as front end and back end with access database, the database will be resided on the server. I am also thinking to add some reporting capibilities, what do you recommend? Crystal or Data Report? BTW, I am using vb6

Visual Basic Reports
I am doing a form, which calls a report with a parameter and to do so, I write the following programming code:

Private Sub Preview click()
DECActivo.Persona (DPPersonas)
RCActivo.Show
End Sub

DEACtivo: Data Enviromment of RCActivo
Persona: Parameter

When I show the report for the second time, I received the following message:

"The operation requested by the application is not allowed if the object is open"

what do I need to include or do in my coding to avoid/resolve this situation?

Please HELP!!!!!

Visual Basic Reports
Can any one tell me where i can find free components to Handel Reporting Functions in VB im looking for something simillar to Crystal Reports

Thanks

Visual Basic 6.0 And Crystal Reports 7
I need help on how to integrate .exe reports in Visual Basic.

I have found some methods but it's only for the .rpt files.

Visual Basic / Crystal Reports 10
I'm developing a program in Visual Basic and need to make reports in Crystal Reports 10. I have many .dll files and I don't know which to use and how to use it. My list of ActiveX controls is: crviewer.dll, reportparameterdialog.dll, enterprisecontrols.dll and printcontrol.dll.
I don't know how to tell VB the name of the report and how to pass parameters to a report in Crystal Reports 10.

Using Crystal Reports With Visual Basic 6
This is goingn to be something REALLY stupid . . .

I've got visual basic 6, and an installed and registered copy of crytal Reports 10. i'm trying to do something really simple, like launch the application and create a new report by clicking on a button on a VB form.

Here's my code;

Private Sub Command1_Click()

Dim CrReport As CRAXDRT.Report
Dim CrAppl As New CRAXDRT.Application

CrAppl.NewReport

End Sub

Whenn I run, I get this:

You are attempting to use functionality that falls under the crystal Decisions report Creation API license. This system does not have a valid license, or the evaluation copy of the license has expired. Please contact Crystal Decisions to obtain a Report Creation API license.

As I said - I've GOT a registered, installed, and working copy of Crystal Reports 10!

Help1

Visual Basic 6 And Crystal Reports
Im new here so im sorry if this is in the wrong place and thanks in advance for any help.

We have a bespoke order management program built with visual studio 6. The labels are produced using crystal report templates. I need to create a csv or txt file from the label print table (MS SQL Database). All the labels print fine from rpt files but when i save to file the order number field doesn't show. If i use txt file, only the text fields show and none of the database fields. any help greatly appreciated.. The code i have at the mo is:

CrptFLabel.sqlQuery = sql
Screen.MousePointer = vbHourglass

CrptFLabel.ReportFileName = App.path & "Report riangleexport.rpt"

CrptFLabel.Destination = crptToFile
CrptFLabel.PrintFileType = crptCSV

CrptFLabel.WindowState = crptMaximized
CrptFLabel.DiscardSavedData = True

Crystal Reports 10 With Visual Basic 6.0
what r the reference i should use to run this code
and
where i can download Crystal report runtime lib

Crystal Reports XI + Visual Basic 6
Hi

I just downloaded CR XI Dev Ed..

I am trying to use CR XI to do some reports etc..

But when i install it.. it does not show up in VB 6 components..

In some guides it said

Go to the Project Menu, Components, put a check mark next to the “Crystal
Reports Control”.

That control does not show..

Please help.. new to this.. I need to generate reports etc out of an access DB and i m totaly new to it..

Crystal Reports XI With Visual Basic 6.0
Crystal Reports XI With Visual Basic 6.0
' Add Form And rename to FrmRepView
' Add Code to Module

VB Code:
Sub ReporView(SQLsentence As String, ViewName As String, ReportName As String) On Error Resume Next Dim CN As New ADODB.Connection Dim rss As New Recordset Dim appw As New CRAXDDRT.Application Dim rpt As New CRAXDDRT.Report Dim tbl As CRAXDDRT.DatabaseTable Dim db As New ADODB.Connection CN.Execute "Drop View " & ViewName CN.Execute "Create View " & ViewName & " as " & SQLsentence x = App.Path & "" & ReportName & ".rpt" appw.LogOnServer "crdb_odbc.dll", "GRS", "GRS", "sa", "asd123" Set rpt = appw.OpenReport(x) rpt.Database.LogOnServer "crdb_odbc.dll", "GRS", "GRS", "sa", "asd123" FrmRepView.show FrmRepView.CrystalActiveXReportViewer1.Refresh FrmRepView.CrystalActiveXReportViewer1.ReportSource = rpt FrmRepView.CrystalActiveXReportViewer1.ViewReport ' appw.LogOnServer "crdb_odbc.dll", "GRS", "GRS", "sa", "asd123" 'DSN=grs;USER ID=sa;pwd=asdsuez; End Sub

thes Code Work With Me

But
I Use Sql Server 2000
The problem Is When I Change Database Name
And Cang DSN To New Database

The Report Not View result
And Gev Me Error Logon failure

If Eny own Now The problem Help me please !

Visual Basic 6 / Crystal Reports 8.5
In a simple code please,
passing Visual Basic form variables (country) to crystal reports,
{Customers.Country} = {?SelectCountry}

Using VB 6.0, Cyrstal 8.5, Northwind.mdb, Customers Table, Win2000.
Created report with above country parameter.
Thanks,

Visual Basic 6 / Crystal Reports
I am creating a report in visula basic 6 with crystal. I am using menu options,
"Project, Add Crystal Reports 8.5."
I have no problem connecting to tables (Timberline, pervasive odbc),
dragging fields on to the report, but when I run it, I am getting a popup message, "server has not been opened.".
Any help on solving this.
Thanks in advance.

Help: Using A Different Printer In Visual Basic Reports
Hi guys,

I am using Visual Basic 6.0 and the report builder that comes with it. My Operating System is Windows 2000.

I want to print my report on a printer which is NOT the "Default Printer".

I can retrieve the DeviceName and DriverName properties of the second printer from the Printers collection. But I dont know how to switch to that other printer for the report.

This is pretty frustrating for me, and I cant believe that there isn't an easy way to switch to a different printer for reports.

I would really appreciate any help that I can get.

Thanks,

Faraz

Crystal Reports 9.0 With Visual Basic 6.0
I need some help in Crystal reports 9.0 with Visual Basic 6.0

Is there any crystal reports control to call the reports file from vb, like we have it in Crystal Reports 7 and 8.

Else what is the way I can open a Crystal Reports 9.0 file in VB ???

HTML Reports Using Visual Basic
Hi there, i want to develop some reports to be called from a VB form and displayed in Internet Explorer, could this be done through VB? I really appreciate if you could provide some code example. Thanks in advance.

Cheers.

Columns In Visual Basic Reports
I am using the dataenvironment and a data report within VB6, I have a report that uses only about 3 inches of a page.

I would like to have 2 columns on a page, is this possible?

Also, I have not been able to find any good documentation about the VB6 report capabilities. does anyone have a link to something that will help me out?

Visual Basic With Crystal Reports
how to use coding for crystal reports for generation of report using a temporary variable used in VB at run time.

Visual Basic - Crystal Reports 9 0
Hi All,

I have a Peculiar problem when displaying crystal reports in a crystal viewer in visual basic. This was happening to me recently. When I made a change to the existing report in the crystal designer and run the report, the report is displaying as a grey box and when I tried to click the next button it is showing the last page, but I could not able to see the first page, but when I tried to open the report without making any changes, then the report is displaying properly (here the change I try to make is a minor one, like reducing the size of a text box).

Solutions / Suggestions from any of you will be appericiated and will be very very helpful for me.

Thanks in advance

Visual Basic Crystal Reports
I am opening a crystal report in Visual basic and I want to reference a formula in the crystal report from the visual basic. I also want to be able to reference a field in the crystal report, from the visual basic project.
Pls advise if anyone can help or if this is better off in the Crystal Reports forum

Visual Basic Data Reports
Question: How do I do basic formating of rptTextboxes?
there does not seem to be any easy way of making alignment adjustments etc.
For exmaple I have fields with dollar amounts so they should be right justified but I cannot get that to happen.
Any help would be much appreciated
thanks in advance

Crystal Reports In Visual Basic 6?
Hi,

I am using VB6 in Visual Studio 6 Enterprise Edition. Does it bundle with Crystal Reports? I cannot find anywhere to install Crystal Reports. If it is not bundled, where can I download it like an add-in?

Jeff

Visual Basic, Queries And Reports
Hey this is my first post, just want to say i would appreciate it greately if anyone could help. Ive self taught myself all my programming knowledge, so chances are this is a simple solution, im just tired of beating my head against the wall.

Simply, I have a visual basic application that is communicating with an access 97 (ugh, i know) database via DAO. I have a query and a report based off of that query that i need to call in my application. The query and the report basically tally up the records in the table (being queried).

so in short....i need to know how to:
A. input information into the "criteria" blocks of the fields in the query (such as date, etc)
B. run the report and print it out
C. hopefully accomplish this without running an instance of access.

Please PLEASE email me at mszewczyk@mortgagerefi.com or post back. i dont think my head can take any more bumps. Thanks in advanced.

Data Reports In Visual Basic
i would like to desing the data reports at run time,
i would like to changing all the fields and report name, section name at runtime
how to do , pls suggest me

Crystal Reports 10 And Visual Basic 6
Hello all experts,
Before I have Crystal Reports 8.5 and visual basic 6 in the system.
In vb ide, there is a "Add Crystal Report 8.5" menu command under the Project menu.
Crystal report file then embeded in vb project with extention (.Dsr) same as vb data report.
And it works ok.

Now I've upgrade Crystal report to version 10.

Does CR 10 still supports vb6?
Why can't I do the same thing with CR 10? (There is no sub menu that can be added CR 10 to vb project)
How can I view the crystal report 10 in visual basic 6? (Pls give me the codes)

Thanks a lot,
visal.

Edited by - visal on 6/29/2004 6:32:27 PM

Crystal Reports And Visual Basic 6
Hi, I have had a long losing battle with data reports. I have now finished my crystal report 7 and would like to use it with my vb6 application. I looked in components for "crystal report control" but it is not there. There are other things like crystal report viewer etc.

How do I go about getting this control and where do I go from there? Thanks

thanks
leadfinger
http://www3.nbnet.nb.ca/gspil

Visual Basic Data Reports
Hi all ,

I am using Visual Basic Data reports in my application and i dont know why after a few or several runs of the application i see in addition to the "filename.dsr" file , corresponding file "filename.tmp" for some or all the .dsr files ???

how do i get rid of this problem ??/

Thanks
matu

Visual Basic With Crytsal Reports
hello

i have made a application in VB6 . i need some very long reports in this in landscape style ..

so i use crytsal reports .. but at the time of making it Setup, crytal is not working fine...
how can i embedd crytsall in my setup.exe....???
i use setup factory + package & depolyment wizard & install shield...

but when i make setup from setup fatory it not working on other pc which doesn't have crytal report installed on it ,...

please tell me how can i use crystalll report at the time of making setup & for that condition if someone doesn't have crystal report installled ..
please help me ....

ankur bhatnagar

thanks

Visual Basic Data Reports
Hi All,

I've been doing some work with these datareports but have become stuck, I have put an Imagebox in the Details section one of the fields in my recordset is a path to an Image. What I want to do is display the image for each record. The Image control itself has no Datasource property or anything so in the Declarations on the Data report I have put the below ;

Code:

Private WithEvents rsPKoiMain As ADODB.Recordset

Private Sub DataReport_Initialize()
Set rsPKoiMain = Koi.rsPrintKoiMain
End Sub

Private Sub rsPKoiMain_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)

If rsPKoiMain .EOF = False Then
Set DataReportKoiMain.Sections("Section1").Controls("ImageKoi").Picture = LoadPicture(App.Path & "Images" & rsPKoiMain!PicturePath)
DataReportKoiMain.Sections("Section1").Controls("label13").Caption = rsPKoiMain!PicturePath
End If

End Sub

If I add a msgbox to display rsPKoiMain!PicturePath it does cycle through all the images, but the Label Caption and Image only display the last Image in the recordset for each record on the report.

Anybody any idea how I can achieve this ?

Would be very much appreciated

Calling Reports In Visual Basic
I dont know how to call a report in vb... with some specific query...plz do the need ful (anybody)

Data Reports In Visual Basic
Hi,
When i try to add a rpttextbox in a Data Report, it does not allow me to type any data into that textbox. It has "Unbound" written in the textbox. Can anyone out there show me how to add a textbox and how to write data in that textbox.
For Eg: In my Header i want to write my name ie: "Derek" with the help of a textbox.

Also how do i show the maximum records that are going to be displayed in a data report just like we do in Crystal Reports?
For Eg: If i have 5 records displayed in my Report i want to show the total ie: "Total Records = 5" in this case at the bottom of the 5th record.
How do i make any Field names that i want to display bold or add any font style to it.
For eg: I have my name ie: "Derek" , I want to make it Bold , color=red and Font face should be verdana?
Thanks in advance for any help,
Derek

Visual Basic - 6.0, Data Reports
In Visual Basic - 6.0 , Data Report Designer - how will I include a label control that generates a serial number corresponding to each record shown in the report.

Working With Crystal Reports Within Visual Basic
I am currently developing a Visual Basic Program that will use Crystal Reports as a reporting tool. I have installed Crystal Reports Developer 8.5 in order to get the Crystal Reports Tools.

The program that I am writing had been developed with an ADO connection to a MS SQL Server.

I am unsure how to make a connection for the Crystal Report viewer in ADO, and how to pass records from a SQL statement to the report. Can anybody help me.

DataBase, Crystal Reports And Visual Basic
Hi! I work at a Software Publisher and we currently have an application developped in FileMaker. In my own, FileMaker ************************, so do the bosses think the same, since they annonced me this morning that they're looking for a new language. I first thought about VB, that's why I'm here. The application we develop is a Printing Software intended for nurseries. It consists of a Plant database with all the information about plant (including a picture file). It's pretty simple, the user browse trough the plant database, he selects the plant he want to print, select the style of signage he wants and then prints. I wanted to know, what db would be the best for text and picture file? I though of access, would there be anything better? And I thought of using crystal reports to print. Would that be a good idea? ok well, I hope I made myself clear and that you will get the point of the thread. Thank you!

PS.: Since its been a couple of years I havent been Visual Basic'ing.. should I go with Visual Basic of Visual Basic .NET !??? Thank you

Edit by reboot: Would you talk to a customer like that? Please show us the same respect.

How Do I Speed Up The Printing Reports In Visual Basic?
Everytime I print my reports in my printer, it takes 20 seconds to start up to print. Is this a problem in the code, if that so, what is your advise? Thanks again.

Problem With Visual Basic Crystal Reports
Hi i want help please. I have a problema with Visual Basic when i'm compiling show an error "don't find the data member" in this line "report1.WindowShowPrintSetupBtn = True" i add the control for Crystal Reports within project and i have this problem.

Crystal Reports Included With Visual Basic?
Hi Everyone,

I read on this website that Crystal Reports is included on the VB installation CD-Rom and free to use as long as you have the Professional or Enterprise Editions of VB. Well.....I have the professional edition and it is nowhere to be found. Is this even true?

Thanx in advance,

Clint

Setting Parameters In Visual Basic Reports
I have set up a vb program. This program must show reports. I want the user to enter in parameter values before they can view a report. To do this I went to the properties of the command object and then I went into the paramters tab. I set a default value. When I run the report, the report for that default value is dispalyed. It does not ask the user for any input parameters. CoulD anyone help me to solve this problem. All answers will be apprecitated.

Thanks

Opening Crystal Reports From Visual Basic
I need some assistance on how to open a crystal report from vb.
Thanks

How To Create Data Reports In Visual Basic??? = )
ei guys please help me how to this.. this is my problem.. i am making my system in as a requirement for our school.. i am somewhat using vb in this case.. so im needing a guide on how to use data reports that is using a Sql client database.. please help me!! please.. i want to finish this requirement!! thnx for the attention....= )

Crystal Reports & Visual Basic Question
I am trying to generate a report in visual basic that will print data between two date ranges. How do I send these two dates from a visual basic front end application to a crystal report file that I have already created, so that it will print data between the two date ranges.
Please help me.

Calling Crystal Reports From Visual Basic
Hi there,
Can anyone help me out!!

I am using crystal reports 8.5
and i createda a report called testreport1.rpt

and i am calling the report into my vb program
(i used homebunny's code call the report)
but when i run the program, a box is displayed for mapping the fields
and when i click ok, then
the formloads but nothing is seen
(ofcourse, i want to see my report)
the report is placed in d: estreport1.rpt

I am pastng my code, could you pls help me out!!
i am a newbie to cr 8.5 and vb 6.0
--------------------------------------------------------------------------------------------------------------------------------------------
The code is as follows:

Dim CRXApplication As CRAXDDRT20.Application ' CRAXDDRT.Application
Dim CRXReport As CRAXDDRT20.report
Dim CRXDatabase As CRAXDDRT20.Database
Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset

Private Sub Form_Load()
    Me.WindowState = 2 'Maximized

Set db = New ADODB.Connection
     cnn = "driver=sql server;server=bappdb02;database=hra;uid=scims;pwd=scims"
db.Open cnn
    Set rs = New ADODB.Recordset

     rs.Open "select distinct deptic,name,attdic from view_icnotequal where year(attd_date)='2005' and month(attd_date)='09' and dept_id=13", db, adOpenStatic, adLockReadOnly

    Set CRXApplication = New CRAXDDRT20.Application
    Set CRXReport = New CRAXDDRT20.report
    Set CRXDatabase = CRXReport.Database
      Set CRXReport = CRXApplication.OpenReport("d: estreport1.rpt", 1)
    CRXReport.DiscardSavedData
    CRXReport.Database.Tables(1).SetDataSource rs, 3

    CRViewer1.ReportSource = CRXReport
    CRViewer1.ViewReport
    '*// Clean up
    Set CRXDatabase = Nothing
    Set CRXReport = Nothing
    Set CRXApplication = Nothing

End Sub

Private Sub Form_Resize()
    CRViewer1.Top = 0
    CRViewer1.Left = 0
    CRViewer1.Height = ScaleHeight
    CRViewer1.Width = ScaleWidth
End Sub

Private Sub Form_Terminate()

    '*// Clean up
    Set CRXDatabase = Nothing
    Set CRXReport = Nothing
    Set CRXApplication = Nothing
    'Set CRViewer1 = Nothing
End Sub

Your help is very much appreciated
Thanks in advance
Regards