Apache OpenOffice Community Forum

Thank you in advance for any assistance
Using Repots Wizard with Oracle Report Builder 1.2.1 to create a report from a query. The query runs with out error. There are four field from one table and three fields that are extract of YEAR, Month, Day from Date-Time field in the query. If i create a Report with the four fields from the table, the report will run. How ever when I attempt to add any of the extracted fields year, month or day into the report I receive the following error:
The document "TBL-ENTRY-Date sort" could not be opened.
user lacks privilege or object not found: TBL-ENTRY,YEAR in statement
SELECT "ENTRYID"
, "CUR-PAIR"
, "TRD-PLN"
, "ENTRY-DT:TM"
, YEAR( "ENTRY-DT:TM" ) AS "YEAR"
, MONTH( "ENTRY-DT:TM" ) AS "MONTH"
, DAY( "ENTRY-DT:TM" ) AS "DAY"
FROM "TBL-ENTRY" AS "TBL-ENTRY"
WHERE "CUR-PAIR" = 'EURUSD' AND "TRD-PLN" = 'Thin Orange 3 PT'

Hello,
just tried that with one of my sample-.odb files, found no problems, see attached file, see Report R_DOB.
R

Thank you, I examined your example and I have deduced the error comes with trying to group the report by Year Month or Day.