Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: how to get the current report server name ? Post Reply Post New Topic
Author Message
daren771
Newbie
Newbie


Joined: 18 Aug 2007
Location: Singapore
Online Status: Offline
Posts: 3
Quote daren771 Replybullet Topic: how to get the current report server name ?
    Posted: 23 Nov 2007 at 7:36pm
How to get the current report server name like

reportserver1.com.sg (the server where i generate my report)   out of ALL the

report servers return from the below sql?

SELECT SI_NAME, SI_FRIENDLY_NAME FROM CI_SYSTEMOBJECTS
Where SI_PROGID='CrystalEnterprise.Server'
AND SI_SERVER_KIND = 'aps'
AND    SI_SERVER_IS_ALIVE = 1

this query will return
    reportserver1.cms.aps
    reportserver1.cms

    reportserver2.cms.aps
    reportserver2.cms

    reportserver3.cms.aps     
    reportserver3.cms
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.020 seconds.