Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing check stub information twice on the same page

Status
Not open for further replies.

maxshop

MIS
Jun 20, 2001
8
US
Hi,

I am fairly new to Crystal Reports, and have a check report that is designed (in Crystal Reports XI) to print the detail invoice information on the top stub and the check at the bottom. I would like to duplicate the top stub information into the middle section (i.e. the middle stub) of the page as well. How can I do it?

Here is some additional information on the current report:

1). Group Header # 3b: contains the detail column labels such as the Invoice #, Invoice Date, Gross Amt, etc.
2). Details a: contains the actual values for the above columns.
3). Group Footer # 2: contains the summary information for the above detail values. Ex: the total gross amt, etc.
4). Page Footer a: contains the check

Note: GH3b, Da & GF2 are printed on the top stub, and I would like to duplicate these on the middle stub. What's the best way to do it?

Also, is there a way to skip printing the check if the number of detail lines exceed a certain number? In other words, if the number of detail lines to be printed cannot fit on the stubs, I would like to skip printing the check on the 1st page, and continue printing the details on the second page, and then print the check on the 2nd page.

Any help would be appreciated.

Thanks!
 
I think you should move the check to a GF2c section and format it to print at the bottom of the page and suppress the page footer. Page footers retain space when you are conditionally suppressing them. Then save the report under a new name and bring it in again as a subreport and place the subreport in a GF2b section. Suppress the subreport sections that you don't want displayed, e.g., GF2c. The sub should be linked to the main report on the Group#1 and #2 fields.

-LB

 
I made the necessary changes as per lbass' suggestions (thanks lbass) and deployed the report in a test environment. Now, every time the user runs the report, its asking for a login name and password. The original report (i.e. prior to making the changes) never asked for this info.

Can anyone point me in the right direction?

Thanks
 
I think you should start a new post on this so you will get a response from other readers--since this is a different topic, and I don't know the answer. It might be most appropriate in the Crystal Reports Data Access forum766. You should identify your datasource when you do post.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top