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]> 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
--- 
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.

Reply via email to