Data Display in Crystal Report ???

[mahesh_575]

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 !

[VB IT]

You can customize your crystal report by passing ADO RecordSet. All your problem will solve!

[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.

[mahesh_575]

Hey Yahoo Thank you very much !

I had forgotten this idea !!! But now will try !!!

[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 !

[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.

[NewbieVB2003]

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

[mahesh_575]

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

Thanks and Regards
Mahesh

[VB IT]

You always welcome.