How to Navigate in same excelsheet report tabs using hyperlink

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.


 


 


 


 


 


 


 


Comments

  • edited 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 WongClement Wong EM mod
    edited 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.


    Clement Wong
    Principal Analytics Architect

    OpenText Corporation
    http://www.actuate.com | http://www.opentext.com

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


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

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

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

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

    Clement Wong
    Principal Analytics Architect

    OpenText Corporation
    http://www.actuate.com | http://www.opentext.com

Sign In or Register to comment.