Skip to Content
author's profile photo Former Member
0
Former Member

Dynamic Webserver in OpenDoc

Posted on Oct 08, 2010 at 05:34 PM 12 Views

Hi,

Is there a way to specify the CurrentWebServer in the Opendocument function within a crystal report. We are using the link as

http:// :8080/OpenDocument/opendoc/ logonVintela.do?appKind=InfoView&sRefresh=Y&isApplication=true&sType=rpt&iDocID=

When promoting this to Prod we had to manually update the devwebserver to Prodwebserver.

I did create a Repository custom function as

CurrentWebServer = http:// :8080/OpenDocument/opendoc/ logonVintela.do?

in each of the environment and added it to the report and used this instead of the 1st URL. But when this report is promoted to prod the report custom function still reads the formula from the Stage. I had to manually go in the report and re add the custom function from the repository. Bottom line is this approach is not working for us.

I know that it will pick up the currentwebserver if we write the formula as

/OpenDocument/opendoc/logonVintela.do?appKind=InfoView&sRefresh=Y&isApplication=true&sType=rpt&iDocID=

but this will not work for us either as this will not work if it viewed from pdf or excel. Please let me know if there a working solution for this.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2010 at 06:33 PM
    1

    It is common problem.

    Development: http://< dev webserver>:8080/OpenDocument/opendoc/logonVintela.do?appKind=InfoView&sRefresh=Y&isApplication=true&sType=rpt&iDocID=

    Quality: http://< qa webserver>:8080/OpenDocument/opendoc/logonVintela.do?appKind=InfoView&sRefresh=Y&isApplication=true&sType=rpt&iDocID=

    Production: http://< prod webserver>:8080/OpenDocument/opendoc/logonVintela.do?appKind=InfoView&sRefresh=Y&isApplication=true&sType=rpt&iDocID=

    If you mentioned your environment name, you have to do as stated after migration.

    To avoid this:(as posted), instead of using <server name> just leave it as dots...

    http://../OpenDocument/opendoc/logonVintela.do?appKind=InfoView&sRefresh=Y&isApplication=true&sType=rpt&iDocID=23165

    Which should work on all environments.

    Thank You!!

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 08, 2010 at 08:51 PM

      Hi,

      Thanks for the replies, I know the .. approach which I mentioned in the post as well.

      If we don't include any webserver in the OpenDoc link it will not work from any exported format such as Excel and pdf. We have a lot of users who will drill through the report from email attachments.

      Is there a way to enforce the Report custom function to use repository custom function when promoted to a different environment.

      Thanks,

      Goutham.

      Edited by: Goutham Penumatsa on Oct 8, 2010 10:55 PM

  • author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2010 at 06:06 PM
    0

    instead of hard coding the webserver name use two dots .. it automatically takes the webserver it is running on

    eg:

    http://../OpenDocument/opendoc/logonVintela.do?appKind=InfoView&sRefresh=Y&isApplication=true&sType=rpt&iDocID=

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.