likely you can do this.
The other thing you are going to run into here is that you will likely be writing a select statement in crystal based on date parameters. This can re-exclude the items you just added back in via excel source.
Just a warning.
You also may consider using subreports.
Not sure how you have your report designed but perhaps you can use the main report as a grouping on the room where you have no select statement to limit the rooms from appearing so all will appear in the group 1 regardless of scheduling data or not.
In group footer add your sub report that would show the schedule. You would link on the room name and if nothing was scheduled you would have a blank sub report but your main report header would still be there.
Just another thought for an approach.
Edited by DBlank - 21 Sep 2009 at 1:41pm
IP Logged
