XLCubed101

If you have multiple reports calling a master report like this : You can XL3WebReportLink to jump to the master report. Do you know that you can use this also to see which report is calling the master report and use this info to jump back. Add the following (WEB) parameter to your master report: CallingReportName CallingReportAdress CallingReportWorksheet From your linking report create a link using XL3WebReportLink including these parameters: =XL3WebReportLink( "Master Report.xml";"<<Master Report Name>>";0; "CallingReportName";"<<Linking Report Namer>>"; "CallingReportAdress";"Linking Report.xml"; "CallingReportWorksheet";"Sheet1"; "XL3ActiveWorksheetname";"Sheet1";"closecopies";TRUE) On your master report you now can make a back link like: =XL3WebReportLink( ...

We needed a Q&D way for our clients to indicatie te location of their pain in/on there body. This is how we did it using XLCubed: - Import a picture into Excel, either using Matt Parkers site: Pic to Excel. Or use a bit of C#: PicToExcelV2 ! Don't go overboard with the resolution, larger then 50 x 50 will kill the performance of the browser! Basically you will get a sheet with lots of small cells where the background color is the pixel color:   Each cell has the following formula: "=XL3Link(XL3Address($A$1);" ";3;XL3Address($CA$55);"Click 23 , 15   ";"XL3Tooltip";"Click to indicate were you have pain") The yellow numbers are the X and Y coordinates. Use a viewport to integrate on other pages: