Hi,

We have bought an Eventbooking program called Full House. This program is a complete product. So i can't change fields or relations or anything. I have to work with how it is build. This program Full House uses Crystal reports to output reports. I try to design a report which goes reasonably well for being a newbie. Being a newbie i don't know yet all the terms as Xgroup etc.

Now i have a problem which i cannot solve, no matter what i try. I'll try to explain the problem as clear as i can and i hope someone have an answer.

The report looks like this:

Room1
          Starttime     Endtime         Items                   Eventnr. and Clientname
               09.00      15.00       09.00 - 12.00 Yoga       122: Mr. Johnsson
               09.00      15.00       12.00 - 15.00 Tai Chi    122: Mr. Johnsson

Room2
               09.00      17.00        09.00 - 13.00 Meditation  534: Ms. Weiber
               09.00      17.00        13.00 - 17.00 Singing       534: Ms. Weiber

Room3
               09.00      17.00         Room3                           136: Mr. Houston

This report is for our frontdesk. The receptionists have to inform the people at what time, in what room is what event.
Now as we look at Items for a moment. Items is a table in the database in Full House. In table Items all items we have are stored. Items like chairs, tables, whiteboards, sandwiches, beverages, beamers, rooms and also  times.  We can also make categories in table Items, so if we make a new item say sandwiches we categorize that as Food and Beverages. Rooms are all category Location and times are category Various.
Now the problem is in the example above in Rooms3. In the Items you see Room3 (in red). That is not what i want.
So i try to find a way to tell Crystal reports the following: "If you see category Various (times) in field Items > go ahead and generate it, but if you see any other category (for instance Locations (rooms) > do not generate them". Not all events have specified times so a lot of times this field should be blanc. But instead CR puts the rooms in when there are no times.
In the code in CR this the formula looks like this:
(Megaview.Comp_type) in ["VA", "LO"] So, show all items from categories Various (times) and Locations (rooms). We have to put in LO because if we don't CR only shows that events with only category Various and we need to see all events. So LOcations have to be generated but not shown.

How do i tell CR this???

Thanks for any suggestions.

New attempt to make my problem more clear.

This is the code i have now.

{MEGAVIEW.COMP_TYPE}  IN ["VA","LO"]

Both VA and LO should be generated, this code does that, but LO should not be visible, how do i do that?

Thanks for any answers