Data Display in Crystal Report ???

Printable View

Apr 28th, 2003, 04:53 AM
mahesh_575

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 !
Apr 28th, 2003, 05:04 AM
VB IT

Pass ADO RecordSet

You can customize your crystal report by passing ADO RecordSet. All your problem will solve!
Apr 28th, 2003, 05:11 AM
manu487

On the right button click u can easily format the date problems. Do right click the date field and select 'Format Field'. I think u r all problems solve by this.
Apr 28th, 2003, 05:14 AM
mahesh_575

Hey Yahoo Thank you very much !

I had forgotten this idea !!! But now will try !!!
Apr 28th, 2003, 05:29 AM
mahesh_575

VB IT !

Please tell me how to pass ADO recordset to Crystal Report.

e.g. I am having CrystalReport1 and testRecSet now by which property I can assign this recordset to Cryst. Repo. ? and how can I assign values in that recordset to various fields in Cryst. Repo. ???

Please Help !
Apr 28th, 2003, 06:56 AM
VB IT

1 Attachment(s)

I you want to customize your report

Firs Make Custom recordset and then make TTX file. After TTX file make report by using TTX file and pass your ADO Recordset to your report at run time. I attacked a fine in which you can find the way , how make TTX and Pass RecordSet.
Jun 4th, 2003, 04:00 PM
NewbieVB2003

Re: I you want to customize your report

Quote:

Originally posted by VB IT
Firs Make Custom recordset and then make TTX file. After TTX file make report by using TTX file and pass your ADO Recordset to your report at run time. I attacked a fine in which you can find the way , how make TTX and Pass RecordSet.

If the same task has to be implemented with executing a Stored Procedure,how would the code look like.
Thanks
Jun 4th, 2003, 08:32 PM
mahesh_575

Thanks VB IT

Hey VB IT, Thank you very much for sending Cry. Repo. Documentation. I was badly searching for it.

Thanks and Regards
Mahesh
Jun 4th, 2003, 09:44 PM
VB IT

Welcome

You always welcome.