
Crystal Question - Printing multiple jobs from one report
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..............
Quote:
> 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.newsfeeds.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! ==-----