This isn't a VB question, but I'm not sure where else I could post this
as I didn't see any other groups related to Crystal Reports.

    Here's the situation.  I'm using Crystal Reports with Magic help desk,
and have made a custom report in Crystal which prints out a summary of open
help desk tickets, sorted by the help desk analyst's name, and group that
they're assigned to.  I have Adobe Photodeluxe installed, and print to the
PDF Writer driver to create the PDF to distribute to all of the executives.
I have been asked to create a separate report for group managers which only
contain the information that pertains to their groups, and also a report for
each help desk analyst which contains only their tickets.  If I was printing
these out, it wouldn't be such a big deal since I could just set the proper
group headers to print on a separate page.  But since I am printing to PDF,
and it's the PDF's that need to be distributed, I'm at a total loss.  Aside
from creating a separate .RPT for each individual (80 or so reports), is
there any way to automate this process?   This is something that would have
to be executed every day.  Help!!
-Keith

-----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
http://www.*-*-*.com/ - The #1 Newsgroup Service in the World!
 Check out our new Unlimited Server. No Download or Time Limits!
-----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----

Hi Keith,

Perhaps you didn't intend your question to be a VB question, but if I wanted to
automate the production of some 80 different Crystal reports I would most
probably use VB to do it.  I don't know of any way that it could be done using
Crystal Reports by itself (which does not prove that it can't be done, of
course).

For example, if you ran reports manually for your individual analysts you would
not need separate .RPT files for each.  You could use one .RPT file and include
a parameter field in your record selection formula which would require the user
to specify the analyst's name for each individula report.  A VB program using
the CRYSTL32.OCX control could loop through all the analysts: for each analyst
it would pass the appropriate name to the parameter field and then print the
corresponding report.  Printing to PDF files might add a bit of a complication
since the user is asked to confirm or reset the name of the .PDF file.  However,
I'm pretty sure that a VB program could include Windows API code to send
appropriate keystrokes to this user input window to set appropriate file names
thus avoiding the need for user input.

If you don't have VB, but you do have MS Access and could access your data with
it (sorry for the pun!), you could use the built-in Visual Basic for
Applications with the CRYSTL32.OCX control to do the job.

Whether all of this would be worth the effort is another matter, but if you need
some 80 reports every day, perhaps it would.

Another thought.  If you did take this approach, the VB(A) program could also
include code to E-mail the reports directly to the persons concerned.

Regards,

John..............

I've got a VB app that does exactly what you want.  Create your report with
a parameter to select the manager, and with the multirun feature of
cViewMANAGER,  create a list of manager and destination (email address).

PDF export is supported if youv'e got CR8.0 or CR8.5 but not with prior
versions.  Seagate Info will also do this, but you'll need version 7.5 to
support PDF as an output format, and it's a lot more expensive.  Crystal
Enterprise doesn't email output, just puts it on the server and delivers via
a browser.

Email me for further details.