Solved

Invoking Reports under Reports Services 10g (again)

Posted on 2004-10-14
5
975 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 500 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 Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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.

726 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