Solved

Formating the data fields in the report

Posted on 2004-08-03
8
205 Views
Last Modified: 2010-04-23
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
Comment
Question by:jra2002
  • 4
  • 3
8 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 11707169
What kind of report are you talking about?

Bob
0
 
LVL 7

Accepted Solution

by:
natloz earned 20 total points
ID: 11707247
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
 
LVL 7

Expert Comment

by:natloz
ID: 11707262
Only make the text field tall enough for one line of text with this solution.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

 

Author Comment

by:jra2002
ID: 11707741
It is a crystal report
0
 

Author Comment

by:jra2002
ID: 11707811
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
 

Author Comment

by:jra2002
ID: 11707849
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
 
LVL 7

Expert Comment

by:natloz
ID: 11709361
bee_zee@interbaun.com
0
 

Author Comment

by:jra2002
ID: 11709687
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: 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

Suggested Solutions

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

839 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