I am composing a report in Crystal Reports 9 in which I need to access and display data (due dates for multiple projects) that may be in one of two tables, depending on the type of project. I am picking a calendar date range via Crystal, then attempting to get all the due dates for a series of project within that date range. In order to make this work I need to tell Crystal to check the media code for the project, and depending on the type of media, go to the correct table to find the corresponding due dates for that project.

Most of my reports are simple ones, and I have no problem if I run separate due date reports for each of the two project types. However, I would like to include the due dates for both types of projects in a single report, and this is the first time I've tried to  incorporate an if then statement in a report. Is the formula I wrote below on the right track to get me a functioning report?


If {ad_info.media_cd} = "ROP" Then
   {vrsn.prdctn_schdl.job_step_due_dt}
Else
If {ad_info.media_cd} <> "ROP" Then
{ad_prdctn_schdl.job_step_due_dt}

Thanks. I am not familiar with union queries, but  I will investigate your suggestion to see if this is something that is available to me.