How to Navigate in same excelsheet report tabs using hyperlink

PriyaK · September 8, 2015

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.

PaulCooper · September 8, 2015

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 https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/UserProperties)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 · September 8, 2015

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.

PriyaK · September 9, 2015

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

birtCubes · October 28, 2017

@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 · October 30, 2017

@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 · October 30, 2017

@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 · October 31, 2017

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

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

How to Navigate in same excelsheet report tabs using hyperlink

Comments