Solved

Invoking Reports under Reports Services 10g (again)

Posted on 2004-10-14
5
964 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
Comment Utility
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
Comment Utility
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á
Comment Utility
Are parameters type right ?
0
 
LVL 22

Expert Comment

by:Helena Marková
Comment Utility
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
Comment Utility
Hello,

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

grant create session priviledge to alcie;

PT
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
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.

771 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

11 Experts available now in Live!

Get 1:1 Help Now