How to Use Single column of Database for Two Field in the Report

[pamulapatis]

Hi all,
This is bav, i m new to this forum. i am working on crystal 8 reports,

My question is, data base has a Event time in single column... i need to put the start time and end time in the report from the event time column,based on event status(new / closed). so i wrote a if condition for both start time and end time fileds (data coming from a single column of a database). when i run the report it is giving a value but not in a single row, two rows one with start time, other with end time, and duplicating some of the fields in two rows. how can i fix this.
Thanks,
koti.

[Madhi]

Use two formulae fields

@starttime

having the code

If {Status}="new"
{eventtime)

@Endtime

having the code

If {Status}="closed"
{eventtime)


Use these two formulae fields in the report