Re: SQL Server - PDF

Crystal reports Enterprise allows you to save a report definition in RDL
Format, so in that way you can port them easily to SQL Reporting Services.

Within SQL Server Reporting Services you can set up email subscriptions for
report delivery.

If you can save the report from within Crystal what else you can do is send
it using SQL Server 2005 database mail which uses SMTP.

Email from within SQL can be send using sp_send_dbmail.


--
__________________________________________________
Dandy Weyn - Dandyman (r)

MCSE-MCSA-MCDBA-MCDST-MCT Community Leader
MCTS SQL 2005- MCITP Database Administrator
Author of Sybex Exam Study Guide MCTS SQL 2005

http://www.dandyman.net
"Rogers" <rogers@xxxxxxxxxxx> wrote in message
news:u0D$gkTxGHA.4752@xxxxxxxxxxxxxxxxxxxxxxx
Dear Professional,

I have created one crystal report which pointing to our sql server
database, I want to automate this process. I want to convert crystal
report to PDF and send email to our customer through SQL Server, is it
possible?.

Thanks




.

Relevant Pages

  • Re: Nearest Common Ancestor Report (XDb1s $1000 Challenge)
    ... >the report via SQL Server's Query Analyzer? ... Issue asynchronous command to save RAM table to HD. ... There is no such thing as a "RAM table" in MS SQL ... documantation of SQL Server, avaialble on the CD but can be browsed ...
    (comp.object)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • .Net framework error
    ... Unfortunately the information is very limited and usually the report just ... The application is a front end for a SQL Server 2005 Express database, ... connection string in the app config file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: VB6; Migration from Crystal 8.5 to Crystal 10
    ... I used to assign a SQL query to a report using the .SQLQueryString property. ... the application reference to Project Reference: Crystal Reports ActiveX Designer ... I resolved the ADO error by switching to ODBC, away from the SQL Server ...
    (microsoft.public.vb.crystal)
  • Re: Access using SQL Server only DB
    ... I recommend you re-write that report to use a SQL Pass Through Query so you ... It all works except for one report. ... > of creating such a relationship i SQL Server! ...
    (microsoft.public.access.externaldata)
Loading