Link to home
Get AccessLog in
Avatar of mcjann
mcjann

asked on

What internet address is the user pulling a report on.

Experts,

Using Crystal Report 2008 (version 12.1.0.892) with web application "TrackWise" (version 7.9)

TrackWise users can login into one of three URLs to generate the report. The report has a field for document ID that is hyperlinked to access the specific document. The problem is that the formatting formula specifies one of the URLs and if that is not the one the user is logged into the link does not work.

Is there a way, in Crystal, to detect the URL the user has accessed. This will enable me to use if statement so the hyperlink works correctly.

Any thoughts or Additional Questions Out There?
Avatar of bbao
bbao
Flag of Australia image

better have an example please??
Avatar of Mike McCracken
Mike McCracken

I don't think there is a way to detect the path the user logged in from.

Can a user log in from any of the 3 URLs or does he log in from the same URL everytime?

mlmcc
Avatar of mcjann

ASKER

User can login on any one of the available links. Once logged in user navigates to a screen to generate the report. Is possible to get the URL from the properties of the current web page?

I can right click the page, access the properties and get this information:  http://cvusat-s3793/TWQA/servlet/TeamAccess/RASViewer?action=execute&report_type=multi

If that can be access programmatically I can use instring function to look for s3793, or s3794 or s3795 then set the hyper link based on that.
You might be able to write a UFL that Crystal can call to get that information.  The result of that formula would be the input to retrieve the document.


mlmcc
ASKER CERTIFIED SOLUTION
Avatar of mcjann
mcjann

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of mcjann

ASKER

Found and posted a solution to my own question.