With corrected item 06 ....
Cathy,
I'm so glad that it made your entire week, maybe year!
Since you are using the DB Memo Control, the report display is the
true representation of the actual data in the column.
However, if you wish to limit the number of characters based on total
characters per line, depending upon the font name
and size used, first you will need to calculate the approximate
number of characters that you would like to see in 4 lines.
Let's say that all together you only want to show 400 characters.
Then, use that number to capture the exact characters
from the NOTE column ...
01. Define a report variable as expression, such as:
Expression Name: vShowData
Type: NOTE
Expression: (SGET(columnname,400,1))
Calculate On: D
02. Now delete the DB Memo Control and just place a "Variable Memo"
control on the Detail Band.
03. Associate the Variable Memo control with the Variable defined as
Report Expression (vShowData)
04. Adjust the Width accordingly
05. Adjust the Height high enough to only show one line
06. Right-click on the Variable Memo control and select "Stretch" property
That should provide you with the desired outcome.
Hope it helps!
Very Best R:egards,
Razzak
At 09:58 AM 12/31/2017, Cathy Grimes wrote:
Razzak,
THANK YOU SO MUCH!! IT WORKS!! You have just made my
entire week, maybe year (and saved lots of paper to boot!).
Is there ANY chance I can specific a MAXIMUM number of
lines? Some of my details take up 10+ lines I don't want to print
more than 4).
Cathy Grimes
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of A. Razzak Memon
Sent: Sunday, December 31, 2017 6:19 AM
To: [email protected]
Subject: Re: [RBASE-L] - Would Really Appreciate Any Help with R:Base Problem
Cathy,
Make the control as small in Height as much as to show only one line
and then use the Stretch property to stretch the height when applicable.
The Stretch property determines whether the Height of the memo
automatically stretches to allow the entire contents of the memo to be printed.
Here is how ...
While in Report Designer:
01. Place the DB Memo control on the Detail Band and then associate
it with the NOTE column 02. Adjust the Width accordingly 03. Adjust
the Height to as high as to only show one line 04. Right-click on
the DB Memo control and select "Stretch" property
That's all there is to it!
Very Best R:egards,
Razzak
At 08:56 AM 12/31/2017, Cathy Grimes wrote:
>How do I make my NOTE column in R:BASE REPORT adjust by size when
>printing? My report printouts waste space because my NOTE column will
>NOT adjust to the size of the actual notes I make for EACH entry (i.e.,
>I spaced it for 4 lines, but entries with only 1 line still print out
>with 4 lines of space (3 lines blank in this case).
>
>Is there any fairly easy way to make the NOTE printout size adjustable
>to whatever the actual size is? I have almost no tech knowledge, but
>did manage to create several tables and many forms and reports.
>
>I have R:Base Extreme 9.5(32). I am an END USER, NOT a developer. I
>have been using - and updating- R:Base versions for decades now, but I
>only use it for my hobbies (mainly logging my music and video
>collections with notes).
>
>Thank you in advance for any help you can give me. One of my reports
>is 400 pages, so saving the extra space would really help.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
--- You received this message because you are subscribed to the
Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
