473,385 Members | 1,944 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

reg hyperlink in oracle report built by oracle reports builder

Hi,
I am using Oracle Reports builder for reports.
I have one pie graph in my report.
It contains 3 fields like lastmonth, lastweek, today.
what I want to do is, when I click on a field it should go to particular page.
Like putting seperate hyperlinks for fields
Please any one can help me

Thanks
Naresh
Aug 19 '08 #1
4 6550
amitpatel66
2,367 Expert 2GB
Use SRW.SET_HYPERLINK property for creating hyperlinks. Check Report 6i help for detailed information
Aug 21 '08 #2
Hi Amit,

Thanks for your reply.
I used following code
<Graph version="3.2.0.22" pieDepth="60" seriesTooltipLabelType="TLT_MEMBER" groupTooltipLabelType="TLT_MEMBER" markerTooltipType="MTT_PERCENT_VAL_VALUES_TEXT" pieTilt="40" graphType="PIE">
<LegendArea automaticPlacement="AP_NEVER" position="LAP_RIGHT" borderColor="#cc33cc" fillColor="#66ffff" borderTransparent="false" fillTransparent="false"/>
<PieLabel visible="false"/>
<SeriesItems defaultColor="">
<Series id="0" color="#99ff99" SRW.SET_HYPERLINK="www.google.com"/>
<Series id="1" color="#66ffff" SRW.SET_HYPERLINK="www.yahoo.com"/>
<Series id="2" color="#ffff00" SRW.SET_HYPERLINK="www.gmail.com"//>
</SeriesItems>
<Slice labelPosition="LP_OUTSIDE_WITH_FEELER"/>
<SliceLabel textType="LD_TEXT_PERCENT"/>
</Graph>

but it is not working.
I gone throught Oracle 6i but I am unable to find the solution
Can you give me some sample code..

Thanks
Naresh

Use SRW.SET_HYPERLINK property for creating hyperlinks. Check Report 6i help for detailed information
Aug 26 '08 #3
amitpatel66
2,367 Expert 2GB
Check here .
Aug 27 '08 #4
Hi Amit,

Thanks for your reply.

solution for this is: in graphHyperlink we have to give field name in "&< >"


<rw:graph id="graph" src="G_DISPATCHENDDATE" groups="DISPATCHENDDATE" dataValues="DISPATCHCOUNT" graphHyperlink="javascript:check('&<P_DISPATCHENDD ATE>')">
Sep 9 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: FuzzyBear | last post by:
Hi, How do dependencies work with Oracle reports? I have a set of developers creating reports in Report Builder 6 w/ Oracle 8i and every time the stored packages change that the report uses,...
13
by: kristoff plasun | last post by:
I have a problem with a C++ DCOM application that prints Crystal Reports with data from Oracle. The SQL query is relatively complex but when the report is printed from the Crystal Reports...
0
by: Rohit Dhawan | last post by:
I have Oracle 9.2 installed in my computer and want to use Oracle reports builder 6i. Is it possible to use both of them. When I tried to install Oracle report an Forms 6i the Oracel Installer...
4
by: Corrado Valiente | last post by:
Hi all, I am thinking about becoming an Oracle developer. I have experience with Centura Team Developer AKA SQLWindows, this is a front-end developer environment for a variety of of database...
2
by: Rob Dob | last post by:
Hi, I have several reports ( .rdl) that I created using report designer, how can I let the end user make modifications to the text in some of these reports. As I am unable to use Report Builder...
2
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
2
dlite922
by: dlite922 | last post by:
Before i spend hours coding this thing, i want to see if there's already a solution or one of you has built something close to it. Please suggest anything that may relate to any of the following ...
2
by: debashish113 | last post by:
hi all, i have been working on oracle reports using oracle reports builder for few weeks. i am facing a problem to generate a sub report from a main report and the syntax i.e. srw.run_report( ) is...
1
by: tatipellinaresh | last post by:
Hi, I am using reports builder for generating report. In my report iam sending parameters from one jsp to other jsp. In the second jsp parameters are coming good, when iam printing ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.