Crystal Question - Printing multiple jobs from one report 
Author Message
 Crystal Question - Printing multiple jobs from one report

    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!  ==-----



Sat, 06 Mar 2004 23:39:12 GMT  
 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!  ==-----



Sun, 07 Mar 2004 08:03:00 GMT  
 Crystal Question - Printing multiple jobs from one report
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.


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!  ==-----



Sun, 07 Mar 2004 16:03:10 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Multiple Print Jobs from one report

2. Printing multiple CR7 Reports as one job

3. Combining multiple print jobs into one job/ActiveReports Problem

4. Printing multiple reports as a single print job (or email)

5. q:Crystal reports multiple heading sections in one report

6. How to compile multiple reports into one executable under Crystal Report 6.0

7. Printing multiple page report to multiple bins for collating vb4.0 Crystal 5

8. Printing multiple reports as one report

9. Linking different reports into one print job

10. Printing Crystal Reports without Crystal Control ActiveX or Crystal Reports API call

11. Printing multiple reports..at one time !

12. printing the same record multiple times in Crystal Reports

 

 
Powered by phpBB® Forum Software