Here's to a peaceful, happy, healthy, and prosperous 2018!
Very Best R:egards,
Razzak
At 11:10 AM 12/31/2017, Cathy Grimes wrote:
Razzak,
IT WORKED! THANK YOU SO MUCH...YOU'RE TERRIFIC! I'm so
excited to be able to print reports the way I want to after all these years.
Hope you - and all you other R:Base developers - a very
happy and successful New Year.
Cathy
-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of A. Razzak Memon
Sent: Sunday, December 31, 2017 7:34 AM
To: [email protected]
Subject: RE: [RBASE-L] - Would Really Appreciate Any Help with R:Base Problem
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.
