[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Invoking Reports under Reports Services 10g (again)

Posted on 2004-10-14
5
Medium Priority
?
986 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
  • 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

831 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