How to Navigate in same excelsheet report tabs using hyperlink
<p> </p>
<p> </p>
<p>I have requirement in that we have to link same excelsheet data from different tabs using hyperlink.</p>
<p> </p>
<p>For example. In excelsheet I am using two tables to display data i.e Customer Table and Order Table.</p>
<p> </p>
<p>On first sheet I am displaying CustomerData and in remaining sheets I am displaying Customer Order details.</p>
<p> </p>
<p>I have attached sample report.</p>
<p> </p>
<p>So when you click CustomerNumber from first sheet (ex. 114) then user should be navigated to tab 114.</p>
<p> </p>
<p>How can we achieve this in BIRT. I am using BIRT 4.5.0 version.</p>
<p> </p>
<p>Please let me know if anyone knows anything about this.</p>
<p> </p>
<p>Thanks in advance.</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
Comments
-
<p>The only thing I can think of to help you is for you to use the Spudsoft Excel emitter and use the ExcelEmitter.TemplateFile setting (see <a data-ipb='nomediaparse' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/UserProperties)'>https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/UserProperties)</a>to point to a template excel file (it would have to be a macro-enabled .xlsm file). Then in that template add VBA code to the Workbook_Open() event to convert values in the first sheet, in the first column, from cell A2 down, where the content is not null and not already a hyperlink (to stop it converting again and again every time you open it), to hyperlinks pointing to the appropriate sheet.</p>
<p> </p>
<p>Regards,</p>
<p> </p>
<p>Paul</p>
0 -
<p>You can do this in BIRT by simply assigning the hyperlink in the format as follows:</p>
<pre class="_prettyXprint">
"#" + row["CUSTOMERNUMBER"] + "!A1"</pre>
<p>See the attached example. It was written and tested in BIRT 4.5.0, and exported as XLSX.</p>
Warning No formatter is installed for the format ipb0 -
@Clement Wong said:
You can do this in BIRT by simply assigning the hyperlink in the format as follows:
"#" + row["CUSTOMERNUMBER"] + "!A1"See the attached example. It was written and tested in BIRT 4.5.0, and exported as XLSX.
Where is attached example? It did not work for me with above format. Could you please help? thanks!
0 -
@birtCubes said:
@Clement Wong said:
You can do this in BIRT by simply assigning the hyperlink in the format as follows:
"#" + row["CUSTOMERNUMBER"] + "!A1"See the attached example. It was written and tested in BIRT 4.5.0, and exported as XLSX.
Where is attached example? It did not work for me with above format. Could you please help? thanks!
@Clement Wong could you please help?
0 -
The previous .rptdesign attachments have not yet been migrated over to this new forum.
Attached is the example. Please rename the .txt to .rptdesign.
Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management