Solved

Crystal Report Height of Textbox

Posted on 2011-03-25
19
2,000 Views
Last Modified: 2012-05-11
Is there a way to get the height of a record of detail section in crystal report?
What i'm trying to do is I have two textboxes, one line and other one is actual data (memo type)
While the data can grow as much as it can, the line box does not grow with the data box,
since it has fixed height.

Is there a way to set up the line textbox so that height of line changes according to the memo textbox in that row?
0
Comment
Question by:kmc10314
  • 10
  • 7
  • 2
19 Comments
 
LVL 26

Expert Comment

by:Kurt Reinhardt
Comment Utility
Draw an actual box around the text box instead of using borders.  Set the property of the box to "Extend to bottom of section when printing". This will ensure the height of the box will match the height of the memo field.

~Kurt
0
 

Author Comment

by:kmc10314
Comment Utility
May be i'm not clear again.
I have not just one textbox with line but bunch of them..
so putting border around textbox wouldn't work
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
Comment Utility
Perhaps if you upload a screenshot it would help.

~Kurt
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
I don't follow either.

Is this a verical line?
If so you could just turn on the left or right border?

Can you show a snapshot of you want?

mlmcc
0
 

Author Comment

by:kmc10314
Comment Utility
This is what I want.
I want the lines next to the text change dynamically Situation
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Can you us ethe right and left borders?

Is this the full height of the section?
One thing I have done is to insert a section below it and have the line start hwere I want in the section next to the field then extend it through so it ends just in the next section

In your case try inserting another detail or whatever section it is.  If you use th enext section type the line will extend to the end of the report

mlmcc
0
 

Author Comment

by:kmc10314
Comment Utility
OK. the lines there are textboxes with no text, but left border
0
 

Author Comment

by:kmc10314
Comment Utility
Do you see how there is two Ds and they are different in size?
The memo (where it says "My Text Goes Here. This HeightVaries") can be one line or 10 lines.
It varies according to what it brings from the DB.

I want lined textboxes to change the height accordingly
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
Do the lines start in the group header and you want them to go through the details?

Same idea will work just sart a LINE in the group header and end it in the group footer.

mlmcc
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:kmc10314
Comment Utility
I made it so the line exists in detail only.
I tried to draw line so that it can see in group header, detail, group footer, but crystal does not let me do that
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
It does in mine so long as the line starts in the group header.

You have to do it in design mode.

mlmcc
0
 

Author Comment

by:kmc10314
Comment Utility
are you talking the line?
i'm not talking about line.. I'm talking about the textbox that is used as line by turning on border
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
A text box can't span sections.  You need to use a line to do that.
The only way a text box can grow is to have the information in them force it larger.

An idea.  Put the same information in the text box and format it so the font color matches the backgorund

A better way .
Delete the text box.
Start a line in the section that is the same height as the text box (design mode)
Right click the line
Click FORMAT LINE
Set the property (as noted above) GROW TO END OF SECTION

mlmcc
0
 

Author Comment

by:kmc10314
Comment Utility
The reason that I use the textbox is i need to create a condition where it can be suppressed.
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Then you will probably have to try the method using one with data in it, othewise textboxes can't grow.

If you just copy the field you have and set it to font color the same as the background and add the line it should work

mlmcc
0
 

Author Comment

by:kmc10314
Comment Utility
It should work in theory.
What happens is that because i have to extend the size of textbox according to the memo textbox,
the white color overwrites one another
0
 

Author Comment

by:kmc10314
Comment Utility
Here is the new picture... of my dilemma Example Example
0
 

Author Closing Comment

by:kmc10314
Comment Utility
I just decided to go with your method and use section experts to suppress data, instead of using textbox
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
>>What happens is that because i have to extend the size of textbox according to the memo textbox,
the white color overwrites one another

You have to make sure the boxes used for the lines don't cover other fields.  You can right click the fields and send them to the BACK.

mlmcc
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now