Solved

Crystal Report letter size layout on one page

Posted on 2013-06-05
6
568 Views
Last Modified: 2013-06-05
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
Comment
Question by:Taras
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 18

Assisted Solution

by:UnifiedIS
UnifiedIS earned 250 total points
ID: 39222893
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
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 39222905
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
 

Author Comment

by:Taras
ID: 39223459
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
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.

 
LVL 100

Expert Comment

by:mlmcc
ID: 39223518
What do you mean subrecords?

mlmcc
0
 

Author Comment

by:Taras
ID: 39223666
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
 

Author Closing Comment

by:Taras
ID: 39223672
Thanks both, you gave me good directions it looks ok now.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

742 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question