How to Navigate in same excelsheet report tabs using hyperlink

PriyaK · 2015-09-08T09:02:23+00:00

Hi, I have requirement in that we have to link same excelsheet data from different tabs using hyperlink. For example. In excelsheet I am using two tables to display data i.e Customer Table and Order Table. On first sheet I am…

PriyaK

Hi,
 
 
I have requirement in that we have to link same excelsheet data from different tabs using hyperlink.
 
For example. In excelsheet I am using two tables to display data i.e Customer Table and Order Table.
 
On first sheet I am displaying CustomerData and in remaining sheets I am displaying Customer Order details.
 
I have attached sample report.
 
So when you click CustomerNumber from first sheet (ex. 114) then user should be navigated to tab 114.
 
How can we achieve this in BIRT. I am using BIRT 4.5.0 version.
 
Please let me know if anyone knows anything about this.
 
Thanks in advance.

Find more posts tagged with

Comments

PaulCooper

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.
 
Regards,
 
Paul

Clement Wong

You can do this in BIRT by simply assigning the hyperlink in the format as follows:
<pre class="_prettyXprint">
"#" + row["CUSTOMERNUMBER"] + "!A1"</pre>
See the attached example. It was written and tested in BIRT 4.5.0, and exported as XLSX.

Topic37204_Excel Sheet Hyperlinks__cwong.rptdesign

PriyaK

I Really appreciate your quick help Clement and Paul. Its working as expected. Once again thanks for your help

.

birtCubes

@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!

birtCubes

@PriyaK said:
I Really appreciate your quick help Clement and Paul. Its working as expected. Once again thanks for your help .

@PriyaK : how did you get it working? could you please share your result?

birtCubes

@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?

Clement Wong

The previous .rptdesign attachments have not yet been migrated over to this new forum.

Attached is the example. Please rename the .txt to .rptdesign.

Topic_37204_Excel Sheet Hyperlinks__cwong.rptdesign.RENAME.txt