Printing multiple formats from within one report

[butkus]

I have built an elaborate report and am using Crystal Enterprise to deliver it to my users. The report uses many shared variables to drive on-demand sub-reports.

The report is used to generate letters of varying style and two different languages, it pulls recipient data and various other data elemnets from many DB2 tables.

What I would like to do is use another on-demand sub-report (that uses the same shared variable running the rest of the sub-reports) to produce the envelope after the letter is generated.

The only problem is when I change the page layout for the new sub-report to Envelope 10, the rest of the report uses this setting and that just won't do.

Any ideas? Can this be handled in a formula someplace?

FYI, the entire report was built using Crystal Syntax.

Thanks in advance for any assistance.

James Carruth
Network Administrator

 

[chelseatech]

As you are using Crystal Enterprise use a hyperlink from the main report to your envelope report, and keep that envelope report seperate.

The stationery belongs to the entire report, so if you switch to Envelope10, the entire report will switch.

the other option is to control the seperate reprot via the RDC and some ASP code. But it will need to be a seperate envelope report. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Ngolem]

I am not certain how you are doing this.....ie. generating a letter + envelope from the same report.

not so much the mechanics of the report itself...that is easy enough to handle but rather the printing....How does the envelope get fed into the printer following the letter??

Perhaps you could print labels that could be attached to an envelope with address information rather than completely changing the report layout....but even then you run into a problem of co-ordinating the label sheet versus normal paper. Jim Broadbent

 

[butkus]

Chelseatech - I thought that by using an on-demand sub-report, that I would be using a seperate report(sort of). The new sub-report was built as a new file and incorporated into the main (but it did not keep the page layout setting after incorporation).

The problem I face is this, the users must authenticate to the data source when they invoke the report. In an attempt to reduce the number of times required to authenticate, I simply populated shared string variables with the content of the data elements - and that drives the sub-reports rather than having the user re-authenticate for every subreport.

If I build a completely different report, then the user will be force to re-authenicate and provide the parameter again. These are things I was trying to avoid. But, if it can't be done - then it can't be done.

James Carruth
Network Administrator