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?
Crystal Reports

Avatar of undefined
Last Comment
mcjann

8/22/2022 - Mon
bbao

better have an example please??
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
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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Mike McCracken

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
mcjann

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mcjann

ASKER
Found and posted a solution to my own question.