Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Two columns into one

Status
Not open for further replies.

christimess

Programmer
May 26, 2004
33
US
Hi,

I'm using oracle (hosted) and need to turn Date_C and Date_D from the EMPLOYMENT_TBL into one column. It is possible that an employee has a date in each field, which I would then need that employee to have two lines. I also need to be able to have a field that can then tell me if that date came from DATE_C or DATE_D.

Thanks!
 
Not possible with in a Columnar report. It has to be two field or you can jion the side by side with a space inbetween, but RS will not make it one with 2 rows. It would have to be a master detail report to get two with the 1st report returning the 1st Date and the 2nd report returning the 2nd date and the alin the two columns to look like one.

Artie Dunnings
ADTECH Consulting Inc
HRIS Functional & Technical Trainer
Alpharetta, GA
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top