Solved

Invoking Reports under Reports Services 10g (again)

Posted on 2004-10-14
5
968 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now