VB and Crystal Report

[hafizfarooq]

Hello,
I have developed a samll application about Student Information. The database i have used is SQL Server.
On the form i have 2 textboxes and 1 image box
when i write student id in Text1 is shows student name in text2 and picture in image1
How to print that Id, Name and Picture using Crystal Report.

Please help me

Thanks
Farooq

[RobDog888]

Did you already create your report in CR? What version of CR are you using? Your only wanting to print the one record as entered by the user?

[hafizfarooq]

i have not created the report yet bcoz my concepts was not clear about transfering the data form VB to Cr. I m using Cr 8.5. I want to print the report of the selected record.

Thanks

[RobDog888]

After you create your report you can use the example code I have in my signature. It works with ADO, VB6, and CR 8.5

[hafizfarooq]

Thanks

[Hack]

Is this question resolved?

[hafizfarooq]

No, this question is not resolved HACK. Do u have any advise to solve the above mention problem

[sorporchuchu]

Try the following website,

http://support.businessobjects.com/l...s/c2010371.asp

[GeoCrystal]

Hi RobDog888,
Thanks for the sample code you have given under your signature.
I tried the code. I am using VB6.0 ,CR8.0 and ADO. Things are working well till the code reaches oReport.Database.selectDatabase oRs,3,1.
It is giving an error message "Subscript beyond range". I suspect this is because oRs is defined as Ado.Recordset and value required in place of oRs in the oReport.Database.SelectDatabase line is data.
Can you please help me?

Can you also tell me how do I define the values for Datatag and Table No that come up after the Data in the same line while writing the code?

Thanks
GeoCrystal

[RobDog888]

It should be .SetDataSource and not .SetDatabase.

[GeoCrystal]

I am used .setDatasource. Getting the same error. Any other way?
Thanks
GeoCrystal

[RobDog888]

Step through your code and verify that the error is on that line.
The only other thing I can think of is that your using 8.0 which may have different arguments.