Jim this seems to be working, i just had to add one more thing — Shift With
Parent to all of the fields and it works great!
Thanks for you help — especially on a holiday :)
Cheers,
-Randy
----------------------------------------------------------------------------------------------------
If you want to go fast, go alone. If you want to go far, go together.
-African proverb
> On Apr 21, 2019, at 3:06 PM, Jim Belisle <[email protected]> wrote:
>
> Randy,
>
> Not sure but try this.
> 1) Make sure you settings for that band (section like detail, header or
> footer) where these fields are located is set to dynamic.
> 2) Right click on the control and check the choice “blank when zero”.
>
> James Belisle
>
> Making Information Systems People Friendly Since 1990
>
>
> From: [email protected] [mailto:[email protected]] On Behalf Of
> Randy Larsen
> Sent: Sunday, April 21, 2019 10:22 AM
> To: [email protected]
> Subject: [RBASE-L] - Reports
>
> Hi Folks,
>
> I’m trying to create a report and struggling with how to get the report to
> not show white space.
>
> I’m creating a report that will conditionally show data and labels if the
> data has a value greater than zero.
>
> This would be similar to the following code
>
> if dataField1 > 0 then
> Label1 dataField1 value
> EndIf
>
> If dataField2 > 0 then
> Label2 dataField1 value
> EndIf
>
> If dataField3 > 0 then
> Label3 dataField1 value
> EndIf
>
>
> If all data field values are greater than 0 i would get something like this:
>
> Label1 dataField1 value
> Label2 dataField2 value
> Label3 dataField3 value
>
>
> If data field2 < 0 than zero, i want that line to not display like such
>
> Label1 data field1 value
> Label3 data field3 value
>
>
>
> I’m not super familiar with all of the reporting functionality
>
> Any help is greatly appreciated!
>
> Thank you
>
>
> Cheers,
> -Randy
>
>
>
>
> ----------------------------------------------------------------------------------------------------
>
> If you want to go fast, go alone. If you want to go far, go together.
> -African proverb
>
>
>
>
>
> On Apr 20, 2019, at 11:46 AM, 'Karen Tellef' via RBASE-L
> <[email protected] <mailto:[email protected]>> wrote:
>
> Ah, I had 2 commands, I thought the "fittopage" was perhaps just a setting.
> I wondered why it printed out twice!
>
> So I removed my 2nd command and left just the "fittopage" but the picture is
> still very big and has only a small portion of the entire form. No different
> from the "printer"
>
> I am printing on a Brother laser jet
>
> Karen
>
>
>
>
> -----Original Message-----
> From: Paul Buckley <[email protected]
> <mailto:[email protected]>>
> To: rbase-l <[email protected] <mailto:[email protected]>>
> Sent: Sat, Apr 20, 2019 10:42 am
> Subject: RE: [RBASE-L] - Rbase_form Print options?
>
> Karen,
>
> I have a fairly large form and a Bit Button with the code below in the On
> Click EEP. May be this will work for you.
>
> PRNSETUP
> PRNSETUP LANDSCAPE
> PROPERTY RBASE_FORM PRINT 'FITTOPAGE'
> RETURN
>
> Good luck,
> Paul Buckley
>
> From: 'Karen Tellef' via RBASE-L <[email protected]
> <mailto:[email protected]>>
> Sent: April 20, 2019 9:16 AM
> To: [email protected] <mailto:[email protected]>
> Subject: [RBASE-L] - Rbase_form Print options?
>
> I want to put a "print this form" button on a very large form to send a
> print-screen to my printer. These are the only options I know that I can
> use, but only a portion of the form will print. Any other options I don't
> know about to shrink the picture onto one printer page, or another way to do
> it?
>
>
> PRNSETUP LANDSCAPE
> PROPERTY RBASE_FORM PRINT 'FITTOPAGE'
> PROPERTY RBASE_FORM PRINT 'PRINTER'
> PRNSETUP PORTRAIT
>
> Karen
>
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> <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]
> <mailto:[email protected]>.
> For more options, visit https://groups.google.com/d/optout
> <https://groups.google.com/d/optout>.
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> <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]
> <mailto:[email protected]>.
> For more options, visit https://groups.google.com/d/optout
> <https://groups.google.com/d/optout>.
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> <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]
> <mailto:[email protected]>.
> For more options, visit https://groups.google.com/d/optout
> <https://groups.google.com/d/optout>.
>
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> <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]
> <mailto:[email protected]>.
> For more options, visit https://groups.google.com/d/optout
> <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.
