Simple report - filtering by comparing two fields

[Hellak]

I am an end user of Opera and quite new to report-building.

I am trying to create a simple report that shows reservations on a given day, where RTC (Room Type to Charge) <> RT (Room Type). In other words any and all reservations where the assigned room type is different from the originally booked room type.

RTC and RT is called respectively BOOKED_ROOM_CATEGORY_LABEL and ROOM_CATEGORY_LABEL. See attached screenshot for the parameters of the report.

I am guessing that I need to add a filter and modify the expression directly. Probably along the lines of
SELECT *
FROM ?
WHERE RTC <> RT

My problem is that I have no idea where to find any help on the exact syntax. As a consequence I have now signed up here and am hoping for help

 

[pmax9999]

This is a forum for building reports using an SAP product called Crystal Reports.

There looks to be some documentation on using OSR on Oracle's web sites.

Good luck.