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'
[Solved] Document could not be opened, user lacks privilege or object not found
[Solved] Document could not be opened, user lacks privilege or object not found
Last edited by Hagar Delest on Tue Jun 06, 2023 9:47 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
Apache OpenOffice 4.1.6 Windows 10
Re: Document could not be opened - user lacks privilege or object not found
Hello,
just tried that with one of my sample-.odb files, found no problems, see attached file, see Report R_DOB.
R
just tried that with one of my sample-.odb files, found no problems, see attached file, see Report R_DOB.
R
- Attachments
-
- DOB.odb
- (56.31 KiB) Downloaded 196 times
- MMove 1.0.6
- Extension for easy, exact positioning of shapes, pictures, controls, frames ...
- my current system
- Windows 10 AOO, LOLinux Mint AOO, LO
Re: Document could not be opened - user lacks privilege or object not found
Thank you, I examined your example and I have deduced the error comes with trying to group the report by Year Month or Day.
Apache OpenOffice 4.1.6 Windows 10