?
Solved

Invoking Reports under Reports Services 10g (again)

Posted on 2004-10-14
5
Medium Priority
?
984 Views
Last Modified: 2008-01-09
Hello,

I have an Oracle 9i Database that contains a LOT table with the following fields:
1) PROJECT
2) CTRLNUM
3) FIELDNUM
4) SURVEYOR
5) MINUTENUM

A typical entry for these values is something like the following:
project=19690, ctrlnum=713, seqnum=44, surveyor=215, minutenum=19690

I have an Oracle Report called Tbminbok.rdf that generates a report based on these parameters. Using the Reports Services 10g report test, I type the following parameters under other:

userid=system/manager1@oracleln&paramform=yes&param=19690&param=713&param=44&param=215&param=19690

When trying to run the report, I get the following error:

REP-300: 'FIND': invalid identifier
             ==> FIND('TTK', l.project, l.ctrlnum, l.seqnum, l.surveyor, l.minutenum)

1) Why do I get this kind of error ?
2) How can I specify my custom paramters and generate my reports under the Oracle 9i iAS Application Server Control ?

PT
0
Comment
Question by:ptreves
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 2000 total points
ID: 12316372
You can try this:
userid=system/manager1@oracleln+paramform=yes+param=19690&param=713&param=44&param=215&param=19690
0
 

Author Comment

by:ptreves
ID: 12333506
Hello,

My forms contains 4 user parameters as follows:
P_ENDMINUTE
P_ENDSURVEYOR
P_STARTMINUTE
P_STARTSURVEYOR

When I specify the user parameter with corresponding values, I get the following error message:

REP-300: "FIND": invalid identifier
  , ==> find('TTK',l.project, l.ctrlnum, l.seqnum, l.surveyor, l.minutenum) lot_des

I then tried to enter the following:  param=19690&param=713&param=44&param=215&param=19690
I also get the same error message.

1) How can I invoke my reports stand alone using the Reports Services, Gettings Started with ORacle Reports ?

PT


0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 12336593
Are parameters type right ?
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 12336897
Now I see that in the error message there are 5 parameters there:

REP-300: "FIND": invalid identifier
  , ==> find('TTK',l.project, l.ctrlnum, l.SEQNUM, l.surveyor, l.minutenum) lot_des

Where does it come from ? It seems like it would be another report TTK and not Tbminbok ...
0
 

Author Comment

by:ptreves
ID: 12338840
Hello,

Actually, I resolved the issue, by issueing the following database command:

grant create session priviledge to alcie;

PT
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question