Hi,

I am fairly new to Crystal, and am using CR 2008 version. I have a report which needs to be modified. My report is designed in following way:
1. Report details - fetches & displays data from db (say x) based on dates from db (say y)
2. Report header - fetches & displays header which includes dates from db y

My problem is: for a query which returns no data from db x (based on the dates from db y), my header report gets suppressed automatically. I have valid dates from db y, however the header do not display them since the detail section is blank. (maybe this is because of the inner-join on db x & y).

My header say "Report for the range: (from) & (to)". So even when there is no data to be displayed, I still want the header to show the date range. Any suggestions on how I can handle this situation?

Thanks and cheers!

Technically I do not have a direct join. Both my tables are not linked with each other. I have added table y, without any links.

So I retrieve dates from table y and use them to fetch data from table x.