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!

Using SMTP default values for reports

Status
Not open for further replies.
mdwyer

mdwyer

Programmer
Oct 9, 2003
389
US
We have SMTP configured and working in our CE9 installation. We also customized ePortfolio to eliminate fields that we don't want the users to enter.

We now want to obtain values for some of these fields from the server defaults, entered in the CMC / Manage Servers / Soiver.report / Destinations / CrystalEnterprise.Smtp / Properties.

Schedule.csp queries the Report object with SELECT SI_DEST_SCHEDULEOPTIONS FROM CI_SYSTEMOBJECTS WHERE SI_PARENTID = 29 AND SI_NAME = 'CrystalEnterprise.Smtp'.

What is the corresponding query that selects the Server defaults SI_DEST_SCHEDULEOPTIONS?

Thanks,
Mike
 
Status
Not open for further replies.

Similar threads

jchewsmith
  • Locked
  • Question
Delivery Rules for Publications
Replies
0
Views
219
jchewsmith
jchewsmith
hpl2001
  • Locked
  • Question
BI4/Crystal 2016 upgrade issue with scheduled reports
Replies
1
Views
194
hilfy
hilfy
allyne
  • Locked
  • Question
RE: Sub Reports with parameters 1
Replies
3
Views
201
allyne
allyne
n2nuk
  • Locked
  • Question
Migrating reports from CR server 2013 to CR Server 2016
Replies
6
Views
384
n2nuk
n2nuk
IanWaterman
  • Locked
  • Question
Guest Using all Licences
Replies
2
Views
168
IanWaterman
IanWaterman

Part and Inventory Search

Sponsor

Back
Top