Sitemap

Amicuk Programming Answers

Setting up "in-document" hyperlinks based on database fields, not URLs

-0001-11-30   Views:0

Advertisement

Hi there, Does anyone know whether or not it is possible to set up a Crystal report so that certain fields are presented as hyperlinks to nominated fields? This is what I want to do: In an index-style document, I have a top level value that is accomp

Hi there,
Does anyone know whether or not it is possible to set up a Crystal report so that certain fields are presented as hyperlinks to nominated fields?
This is what I want to do:
In an index-style document, I have a top level value that is accompanied by several related values. For the related values, I want hyperlinks to be displayed so that the person browsing the report can jump to the top level value entry for the related value.... like this...
Top level value: DOGS
Related values...
Broader Value: Mammals (hyperlinked to jump to entry for "MAMMALS")
Narrower value: Poodles (hyperlinked to jump to entry for "POODLES")
So, where the above entry for "DOGS" appears, I want Crystal to put in a hyperlink on Mammals and Poodles so that the reader can go straight to the entries for these related terms, for example, if someone clicks on the hyperlink for Poodles.... they will be taken to the top level entry for Poodles... etc. etc.
Top level value: POODLES
Related values...
Broader value: Dogs (hyperlinked to jump to entry for "DOGS")
Narrower value: Miniature Poodles (hyperlinked to jump to entry for "MINIATURE POODLES")
etc. etc. and so on...
Basically I am hoping and imagining there is a way to do this without sitting down and manually bookmarking these entries. This is something that I could do reasonably easily in Word using Styles, however that would require first exporting the data... and I really want to be able to do it straight out of the database, in Crystal.
Anyone know the answer to this?
cheers
-karenb

The replay answer
Advertisement
I think you can try two ways
1) create a group on the field DOGS and place the related values in the details section.
Now right click on the detail section and go to section expert and write the suppress condition like this
DrillDownGroupLevel=0
Now when you refresh the report it will show the data like this
DOGS
MAMMALS
POODLES
When you double click on Dogs it shows the related details of DOGS in a seperate tab.
2) Try to create a subreport that shows the related details and insert this subreport as an on-demand subreport in the main report.This subreport should be placed in the group headers of DOGS field and change the caption of the subreport by right clicking the subreport and go to format subreport and in subreport tab add the field (DOGS) corresponds to caption by clicking X+2. Now link the subreport and main report with the grouped field in the main report using chnage subreport links option
Hope this helps!
Raghavendra

Go to See the other 4 answers

Setting up "in-document" hyperlinks based on database fields, not URLs

Category:DefaultRelease time:-0001-11-30Views:130

Hi there, Does anyone know whether or not it is possible to set up a Crystal report so that certain fields are presented as hyperlinks to nominated fields? This is what I want to do: In an index-style document, I have a top level value that is accomp[More]

Number of Copies to Print Based on Database Field

Category:DefaultRelease time:-0001-11-30Views:130

Post Author: Ltreat CA Forum: Formula I am a newbie with Crystal Reports XI.  I am new to this forum.  I have a report that I am printing from Crystal Reports XI.  My database has a field called {database.drop-loc}.  If the field has a value of 50, I[More]

Finding t-codes based on database field

Category:DefaultRelease time:-0001-11-30Views:130

Dear All, I have a field AUFK-KOSTL, I want to find in which transactions or transaction codes, this field is being used. Please let me know on which transactions the field AUFK-KOSTL is being used. Thanks in Advance, Ramanahi,   Try the transaction[More]

Can I store/retrieve a Word Document in a Database field?

Category:DefaultRelease time:-0001-11-30Views:130

What conditions should me met to store/retrieve a Word Document in an Oracle database field? May be many things will be necessary to consider but, could you give me some guides? Do yo know about some web site place that talks about it? Thank you in a[More]

Creating an open document/hyperlink

Category:DefaultRelease time:-0001-11-30Views:130

Hello...I am trying to create an Open Document hyperlink on my report.  I am currently using Crystal Reports XI.  My main report is getting sent out in PDF and is a summary version of our inventory items.  I want the user to be able to click on the I[More]

How to findout the clearning document number based on the reference

Category:DefaultRelease time:2015-10-11Views:130

Hi all we  need to findout the clearning document number based on the reference number in financial transaction code. basically we know how to retrieve the data from table level using BKPF without non primary key as XBLNR but we  want to know is this[More]

How to retrieve material document no. based on production confirmation no.

Category:DefaultRelease time:2015-10-11Views:130

Hi Friends, I am retreiving the production confirmation number(PRTNR) thru bapi BAPI_REPMANCONF_CREATE_MTS. Based on that confirmation number I need to retrieve material document number (MBLNR) Because multiple users can post finished goods from diff[More]

HOW TO FIND LAST DOCUMENT DATE BASED ON MATERIAL NUMBER

Category:DefaultRelease time:2015-10-11Views:130

Hi,        I want to know how to find the last document details based on material number. Is there any Functional modulle or BAPI programe? i,e, I want know last goods receipt details (MIGO)  based on material number. Can u please anybody tell me. Th[More]

Document is not in database. when displaying document.

Category:DefaultRelease time:2015-10-11Views:130

Hi All, in mr03, when trying to display liv document, i am getting message "Document is not in database. Search document archive?" I am able to display using MIR4 and through purchase order on the liv document and drill down till accounting docu[More]

Appending to a word document hyperlink text

Category:DefaultRelease time:2015-10-11Views:130

Hey, Is it possible to change the hyperlink text not the address? I would like to append to it not completely replace it. This is my example. I would like the hyperlink to display "Fig 1" instead of just the number "1". Is this possibl[More]

Automatically populate fields in jsp documents based on other fields

Category:DefaultRelease time:2015-10-11Views:130

hello guys. I have a jsp document that has the following <af:inputText value="#{bindings.SourceDocumentId.inputValue}" label="#{bindings.SourceDocumentId.label}" required="#{bindings.SourceDocumentId.mandatory}" columns=&q[More]

Hot
I have my itunes library on an external hard disk and it is working fine but I am about to get a new computer. What is the easiset way to get my new installation of itunes to view the library on the external hard disk. If anybody knows the answer can [More]
Hello, We are implementing EP 7.0 SP11 along with ESS and MSS business package implementation. Version :     SAP_MSS  600 SP6      BP_ERP5MSS  1.0 SP9       ADSSAP  7.00 SP9 We have configured Adobe document services according to configuration docume [More]
I am very upset, I ran my verify disk permissions, everything fine, repair disk permissions, everything fine, do t periodically just to mae sure all my stuff is in order,,,, then I decided to run te VERIFY DISK, because do not do it as much and want [More]
So like me, many verizon users in the US are excited to get their hands on a new iphone, i purchased a black and pink defender case from otterbox so ill have it when i get my iphone...well i started to do some research and found out that APPLE wanted [More]
I purchased several songs from itunes and they are missing from the itunes.  They are listed in my library, but the song says it cant find the file?  how can I get it back?  Some of my songs are compledtely missing???  Please help!!!It does not magic [More]
With Louis Watta Welcome to the Cisco Support Community Ask the Expert conversation. This is an opportunity to learn and ask questions about design, configuration, and troubleshooting of Cisco Nexus 1000V Series Switches operating inside VMware ESXi [More]
Hi, We are in the process of setting up our new BO4 environments and we will be integrating BO with the SAP Netweaver Portal, so our users will log on to the Portal and then open up a tab that will display the BI Launch Pad logging on to BO with SAP [More]
Hi guru, We have 100 employees who must receive BI Report result by email via Bex broadcasting . We don't want to fill in the broadcast setting manually but via an abap program that will execute the boradcasting. Can you help me finding a program tha [More]
hello was wondering if anyone could look at this code and tell me why i cant get it to print the whole string, at the moment it only prints the first 4 letters over and over again if u type in a 16 letter string thanks!!! System.out.print("Enter lett [More]
Hai..., I have a problem of API javax.rmi.PortableRemoteObject; when I compile a class using java 1.3, it can't find the API,where I should find this API? if in java.sun.com where is it? Thank, ciou, sudartoHi, javax.rmi.* is contained in J2EE. Pleas [More]