Field Formats 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 !

[jeniheaton]

Question 1: in Crystal in the Field Explorer there is a place called "Parameter Fields" right click say "New.." declare the parameter there.
then under the Report Menu -> Selection Formulas -> Record...

do something like this:

{tblName.fieldName}<={?param1} and
{tblName.fieldName}>={?param2}

Or you know what ever you need to set. Then when you preview the report it prompts you for the parameters.

Question 2: right click on your time field in the report, select format field, date and time tab. all kinds of formats there..

Hope this helps!