Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 584
  • Last Modified:

Crystal Report letter size layout on one page

I have CR XI R2
I have Client  letter layout  report legal size.
In this report I have next parts.

I have address part, Salutation  and then several  fields that I arranged around hardcoded text.
A Client  is connected to a cases (two fileds description and Amount) that are coming  from  20 similar tables.

 I need to show  those cases  for each client.

A client will never have all 20 present, the most he will have is  6 to 10 cases.
Then I have a “ Client Return”  part  with client address  and part that client fill in  on several lines and sent back by mail.

How to best arrange this layout to be printed on one paper legal size.
What I tried by now and is not working is this:

I tried to arrange this as:
Report header nothing in.
Page header here I put print date and company icon image.
Detail_a here I have address formula in text box that can grow.
Detail_b here are main info about 20 hardcoded text and fields together.
 
Then detail_c  here I have cases in formula inside text filed that can grow.
Report footer nothing in.

Page footer here I put client return part around 15 rows hardcoded text and address formula in box that can grow.
I have problem that detail part is appearing on two pages event if in detail c part I have 3 or 5 cases.
How to get this report print out on one page legal size?
0
Taras
Asked:
Taras
  • 3
  • 2
2 Solutions
 
UnifiedISCommented:
Which section appears to be taking up too much space?

Are all 20 items in detail_b supposed to show?
Are you suppressing detail_c if there isn't anything to print there?  

I would guess you will need to conditionally suppress some sections.  Also, make sure you don't have any sections that have new page after or new page before checked unless you also add a formula with a crystal function like NotOnLastRecord.
0
 
mlmccCommented:
You may not be able to if there is too much data.

Is there a single record for a client?

Have you considered using a group on the client with the client address information in the group header and footer?


mlmcc
0
 
TarasAuthor Commented:
Yes, all fields 5 or 6 and hard code text  in Detail_b have to show each time.

I am suppresing blank section for Detail_c

There is single record per  a client with possibility up to 20 "subrecords".
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
mlmccCommented:
What do you mean subrecords?

mlmcc
0
 
TarasAuthor Commented:
It is not good expresion,  no subrecords.  
I wanted to say  one record per client with  possilbe 20 cases, as they are going one below another in report Detail_c section.
I moved address in page header and it looks much better,  now almost done.
0
 
TarasAuthor Commented:
Thanks both, you gave me good directions it looks ok now.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now