Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing users in CE9 Query

Status
Not open for further replies.
Bobbber

Bobbber

Programmer
Sep 6, 2002
83
TR
Hi ppl,

I use the following type of WHERE statement all the time :

WHERE SI_PROGID='CrystalEnterprise.Report'


Is there a SI_PROGID which defines users instead of reports!?!?!?

Thanks!



Stay Blue, Bob. x
 
Sort by date Sort by votes
SELECT SI_ID, SI_NAME FROM CI_systemOBJECTS WHERE SI_PROGID = 'CrystalEnterprise.User'
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dellguy
  • Locked
  • Question
DB connection alias in CMC
Replies
1
Views
179
kray4660
kray4660
hpl2001
  • Locked
  • Question
Fields missing in link window
Replies
1
Views
183
kray4660
kray4660
smmaruf82
  • Locked
  • Question
How to Fixed 4 Column in Crystal Report Crosstab
Replies
1
Views
200
lbass
lbass
joshidharmesh
  • Locked
  • Question
Crystal report formula field query
Replies
3
Views
257
kray4660
kray4660
kdavis6416
  • Locked
  • Question
Find email-addressess with CSP Query Builder and other detail information about reports
Replies
0
Views
97
kdavis6416
kdavis6416

Part and Inventory Search

Sponsor

Back
Top