Print Only the select record

[Baixinha]

I created a report and I need this report print only the record selected (only one).

How can I do this?

 

[emcevoy]

Hi

Could you give more details on exactly what you are wanting to do and how you have your report set up now? Also, what version of crystal reports are you using?

When you refresh your report, do you only see one record? or more? If you have more records in the report, what do you mean by "Selected"?

I look forward to your response. E. McEvoy
Crystal Reports Consultant

http://www.pacificridgesolutions.com

 

[Baixinha]

Hi

I'm using Crystal Reports 8 and VB5.
I have a database where I can consult a record by the title and the record is showed in the form and I wanna print this consult by a report created CR8 (only one record). I only developed the report. Now, I need to program the report to work this way.

 

[Baixinha]

.

 

[kenhamady]

Do you want Crystal to retrieve this 1 record from the database or do you want to pass the record from the form to the report?

You can store the record in a recordset and pass it to the report, or you can pass the criteria of the record to the report and have it retrieve the same record. The second option is simpler but will require a second query of the database. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Baixinha]

I wanna print only the record consulted.

 

[kenhamady]

You didn't really answer the first question, so I will assume that you want to have CR retrieve the record.

Now, can you write a SQL statement that would return only the record you are looking for from the database? If so, post the statement here, and I will explain how to get CR to return just that record. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Baixinha]

I wanna pass the record from the form to the report.

 

[kenhamady]

Is this record in memory as a recordset of one record in the application? How many fields in the recordset. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Baixinha]

Yes.
There are only three fields in the recordset.

 

[kenhamady]

You have to convert the report to use the active data driver, and to use only these three fields. If the report was designed using more than on table you have to recreate it.

If you converting the report use "Database - Convert Driver" and switch it to PDSMON.dll and then select the appropriate connection.

In the application you will need to use the converted report and then use the "SetPrivateData" method to pass the data to the report. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Baixinha]

Ok, I'll try it!

Thanks