December 22, 2010, 11:28 AMMicrofich
Authentication: Passing credentials
Scenario: Self Service app
Graph drills down to EXL2K report 1.
EXL2K report 1, column 1, drills to EXL2K report 2
Issue: EXL2K report 1 is now out-of-session, so it gets prompted for id/pw to execute drill to report 2.
I don't want users to have to re-authenticate.
Incomplete solution 1: Modify cgivars.wfs to pass IBIC_user and IBIC_pass, making them available as variables to the
Problem: PW shows in tool tip text when hovering over link. Need to encrypt the pw or remove tool tip text.
Note, we're 7.6.2 so the 'ALT' parameter for tool tip text is unavailable.
Other solutions: Tried 'CopySessionVarToWFVar' with no luck.
Tried 'CopyHTTPCookieToWFVar', which passes the string encrypted, so I cannot parse out the PW portion.
Is this variable still useable somehow?
Any insight would be appreciated.
December 23, 2010, 08:36 AM<JG>
Only real option in 76 to hide the mouseover is to use a template macro to set the screentip
very simple for a single worksheet
For Each r In ActiveSheet.UsedRange
If r.Hyperlinks.Count > 0 Then
r.Hyperlinks(1).ScreenTip = "Whaterver text you want to see"
If you have multiple sheets then you need an outer loop to go through all the sheets
December 24, 2010, 08:33 AMMicrofich
Yes, templates w/work fine and thanks for the idea but I am trying to avoid templates for this application.