Page/Report Break per Account

[HoosHot]

Hi. I have a table that contains account_id and dollar amounts. I am basically trying to generate a bill per account. How can I get Crystal Reports 8.0 to create a new report (page break) per account? Right now, if I just put account in my report, I can group by account. As I mentioned, I am generating paper bills for my clients; of course it doesn't make sense to have many clients per page.

Thanks
mnguyen_va@yahoo.com

 

[kenhamady]

Once you have grouped by account it is pretty easy. Use "Format - Section" to open the section expert, highlight the group footer for "Account" and check "New Page After". Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[HoosHot]

Hi Ken and Friends,

Background:
I am generating monthly paper bills for my clients. I am reading from one table that has, for example in April, 3928 rows and 10 distinct accounts. The way I'm doing my Crystal Reports right now is, I'm generating one report, grouping by account and every account starts on a new page. So, for example, account AAA starts on page 1 and goes to page 23; account BBB starts on page 24 and goes to page 29; account CCC starts on page 30 and goes to page 69; etc. etc. etc...

Is it possible for me to somehow generate 10 different reports from this one report? I would like to save/export a different file for each account. I need to do this because in addition to printing paper bills for the clients, I also need to send them an exported/saved/soft-copy of their bill. Obviously, I cannot send a CRW to account BBB and tell them to only look at pages 24-29 (in the above example).

I don't want to have 10 reports all the same, except have a where clause like "where account = AAA", "where account = "BBB", etc. Each month, I may have new accounts added, I may have accounts deleted. (It is NOT feasible for me to create a .crw for every account because we add/delete accounts everyday. We also have 100s and 1000s of accounts.)

Thank you for your thoughts
mnguyen_va@yahoo.com

 

[kenhamady]

You want to export a different file per group. Sorry, I am pretty sure that Crystal Reports doesn't supports this. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)