[Webinar] Streamline your web hosting managementRegister Today

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

Formating the data fields in the report

On the report

I am displaying following fields

AA NO  MW    HOURS  STATUS    SCHEDULE DATE
DESC
------------------------------------------------------------
As Description is varchar field so after displaying other fields on the
next line I am displaying Description
After that I am displaying one static line

----------------------------

But discription is varchar(1000). Sometimes it has only 50 chars
then there is too much  gap between the data and static line
How should I make it to come together

for eg:

___________________________________________________________________________
24,310 15.00 8.00 TENTATIVE. 07/28/2004 12:00:00AM
REQUEST UNIT 2-E PULVERIZER OUT OF SERVICE FOR A P.M. (CPM PULV-IX1C)
(DWP) PERFORM PULVERIZER PM AT
PREDETERMINED INTERVAL (PULV, PULE & PULF)
___________________________________________________________________________
24,347 30.00 10.00 TENTATIVE. 07/28/2004 12:00:00AM
6F PULV PM
___________________________________________________________________________
24,309 15.00 8.00 TENTATIVE. 07/28/2004 12:00:00AM
REQUEST UNIT 2-A PULVERIZER OUT OF SERVICE FOR A P.M. (CPM PULV-IX1C)
(DWP) PERFORM PULVERIZER PM AT
PREDETERMINED INTERVAL (PULV, PULE & PULF)
___________________________________________________________________________
24,353 30.00 10.00 TENTATIVE. 07/28/2004 12:00:00AM
6C PULV PM

___________________________________________________________________________
24,372 50.00 7.00 TENTATIVE. 07/28/2004 12:00:00AM
UNIT 7A2 PULVERIZER (CPM-PULV-IX1C) OFF-LINE 35,000 TONS PERIODIC
PHYSICAL AND VISUAL INSPECTION.


___________________________________________________________________________

Thanks
0
jra2002
Asked:
jra2002
  • 4
  • 3
1 Solution
 
Bob LearnedCommented:
What kind of report are you talking about?

Bob
0
 
natlozCommented:
If it is Crystal Reports...Make the text field the width of the report but on line and change the Property of the field CANGROW to TRUE.
0
 
natlozCommented:
Only make the text field tall enough for one line of text with this solution.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
jra2002Author Commented:
It is a crystal report
0
 
jra2002Author Commented:
As suggested I had done for Description as one line

But at few places the dashed line is just comming as continuation of the work description in the same line

0
 
jra2002Author Commented:
if you can send me the email id I can send you the report how it is looking as a PDF file, may be it will give more clarification regarding what I am looking for
0
 
natlozCommented:
bee_zee@interbaun.com
0
 
jra2002Author Commented:
Thanks I got it.  Previously I was doing in the text object manually I am inserting line

But when Used Insert Line, my problem got fixed. I am working on customization of
the report for your reference I will send it to you once i will finish

Thanks
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.

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