Re: [RBASE-L] - Where do I set my Vars?

2023-11-09 Thread Ronald C Peterson 
What about using a numeric data type with fixed decimal location as a primary 
key?


From: rbase-l@googlegroups.com  on behalf of 
javier.valen...@vtgonline.com 
Sent: Wednesday, November 8, 2023 6:07 PM
To: rbase-l@googlegroups.com 
Subject: RE: [RBASE-L] - Where do I set my Vars?


If I understand correctly, by Universal Key you mean a Primary Key with Foreign 
keys linked. I personally would not use a real or double type as Primary key, 
precisely because of the problems you are encountering. You can have the same 
value generated at different time and depending on how is computed can default 
to a different valuer, or two different values that default to the same value. 
All my primary keys, and by extension foreign keys, have the type INTEGER or 
TEXT.

Now, if you want to change the type, you need to go to all the linked tables, 
disable the primary/foreign link to the primary table an rename them to a 
temporary name. Then, you can go to the primary table and change the type to 
what ever you need it to be, and the n go back to the secondary tables and 
change the name back to the original at which time they will adopt the new type 
and then re-ink them to the primary table, makes sense? There is a rename 
command, but if I recall correctly, will not work with linked columns. If you 
are going to do this, I would suggest converting your REAL values to INTEGER 
and use them as the primary key.

At one time, I had the need to change the text length of several primary 
columns and their corresponding foreign columns in numerous tables as the needs 
changed. I wrote a program where you would select the name of the primary 
table, primary key and the new length and the application would do the entire 
process described above automatically. If you need to do this once, you can do 
it manually; however, if you have multiple occurrences, writing a program to do 
it would be the best way.



Javier,



Javier Valencia, PE

14315 S Twilight Ln

Olathe, KS 66062

913-915-3137





From: rbase-l@googlegroups.com  On Behalf Of Lin 
MacDonald
Sent: Wednesday, November 8, 2023 3:02 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Where do I set my Vars?



Sadly, that's about when I wrote this!  It is a Universal Key attached to 
several other tables so I can't really change it to a double, I guess



Lin



On Wed, Nov 8, 2023, at 12:43 PM, 'Karen Tellef' via RBASE-L wrote:





Welcome to the not-so-wonderful world of the "REAL" datatype.  Long ago in DOS 
days that was the only datatype (other than currency) that allowed decimals.  
Unfortunately it isn't real accurate IMO (pun intended).  Most of us switched 
all those Real numbers to the DOUBLE datatype.  With Double, a 104.31 is always 
stored and displayed exactly as 104.31.  With Real, internally that number may 
be stored as something like 104.309187983.  So depending on your display 
formatting, you could get different representations to the screen.



Looks like the 000.## type of formatting might be truncating.  In my example, 
it would display as 104.30 or 104.309 even tho the number is actually 104.31.  
Someone else suggested using the ROUND function if you know how many decimal 
places you want displayed.



Karen





On Wednesday, November 8, 2023 at 01:47:25 PM CST, 
lin...@gmail.com<mailto:lin...@gmail.com> 
mailto:linc...@gmail.com>> wrote:





Hello Razzak,



Thank you - that is what I was looking for.  I knew there was a simple solution.



I am getting a strange output though:  the real number stored is 104.31

000.## prints as 104.30

000.### prints as 104.309



This is an unusual situation where the number stored could possibly be 4 
numbers to the left of the decimal and 3 to the right (we have never had more 
than 2 to the right)



thanks for the help!



Lin

On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote:



Lin,



Here's how ...



Please take a look at the attached illustration.

  *   Open the report in Report Designer
  *   Right-click on the Variable Object and select Display Format
  *   Under the Display Format option change the Display Format to 0.000
  *   Click on the [OK] button to save the Display Format
  *   Click on the [Preview] Tab to preview while still in Report Designer
  *   Save the report and close the Report Designer

That's all there is to it!



I hope it helps!



Very Best Regards,



Razzak





[https://groups.google.com/group/rbase-l/attach/3c656e7487c2d/image.png?part=0.1&view=1]



On 11/07/2023 8:53 PM EST Lin MacDonald 
mailto:li...@fastmail.fm>> wrote:





This will sound silly, but I am working on a system that I wrote several years 
ago, but can't remember most of what I wrote!



I have a report that prints a Var (type: Real)  It is now printing it with 7 
places after the decimal point.  I need it to print a max of 3 places.  Where 
do I set t

RE: [RBASE-L] - Where do I set my Vars?

2023-11-08 Thread javier.valencia 
If I understand correctly, by Universal Key you mean a Primary Key with Foreign 
keys linked. I personally would not use a real or double type as Primary key, 
precisely because of the problems you are encountering. You can have the same 
value generated at different time and depending on how is computed can default 
to a different valuer, or two different values that default to the same value. 
All my primary keys, and by extension foreign keys, have the type INTEGER or 
TEXT.

Now, if you want to change the type, you need to go to all the linked tables, 
disable the primary/foreign link to the primary table an rename them to a 
temporary name. Then, you can go to the primary table and change the type to 
what ever you need it to be, and the n go back to the secondary tables and 
change the name back to the original at which time they will adopt the new type 
and then re-ink them to the primary table, makes sense? There is a rename 
command, but if I recall correctly, will not work with linked columns. If you 
are going to do this, I would suggest converting your REAL values to INTEGER 
and use them as the primary key.

At one time, I had the need to change the text length of several primary 
columns and their corresponding foreign columns in numerous tables as the needs 
changed. I wrote a program where you would select the name of the primary 
table, primary key and the new length and the application would do the entire 
process described above automatically. If you need to do this once, you can do 
it manually; however, if you have multiple occurrences, writing a program to do 
it would be the best way.

 

Javier,

 

Javier Valencia, PE

14315 S Twilight Ln

Olathe, KS 66062

913-915-3137

 

 

From: rbase-l@googlegroups.com  On Behalf Of Lin 
MacDonald
Sent: Wednesday, November 8, 2023 3:02 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Where do I set my Vars?

 

Sadly, that's about when I wrote this!  It is a Universal Key attached to 
several other tables so I can't really change it to a double, I guess

 

Lin

 

On Wed, Nov 8, 2023, at 12:43 PM, 'Karen Tellef' via RBASE-L wrote:

 

 

Welcome to the not-so-wonderful world of the "REAL" datatype.  Long ago in DOS 
days that was the only datatype (other than currency) that allowed decimals.  
Unfortunately it isn't real accurate IMO (pun intended).  Most of us switched 
all those Real numbers to the DOUBLE datatype.  With Double, a 104.31 is always 
stored and displayed exactly as 104.31.  With Real, internally that number may 
be stored as something like 104.309187983.  So depending on your display 
formatting, you could get different representations to the screen. 

 

Looks like the 000.## type of formatting might be truncating.  In my example, 
it would display as 104.30 or 104.309 even tho the number is actually 104.31.  
Someone else suggested using the ROUND function if you know how many decimal 
places you want displayed.

 

Karen

 

 

On Wednesday, November 8, 2023 at 01:47:25 PM CST, lin...@gmail.com 
<mailto:lin...@gmail.com>  mailto:linc...@gmail.com> > 
wrote:

 

 

Hello Razzak,

 

Thank you - that is what I was looking for.  I knew there was a simple solution.

 

I am getting a strange output though:  the real number stored is 104.31

000.## prints as 104.30

000.### prints as 104.309

 

This is an unusual situation where the number stored could possibly be 4 
numbers to the left of the decimal and 3 to the right (we have never had more 
than 2 to the right)

 

thanks for the help!

 

Lin

On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote:

 

Lin,

 

Here's how ...

 

Please take a look at the attached illustration.

*   Open the report in Report Designer
*   Right-click on the Variable Object and select Display Format
*   Under the Display Format option change the Display Format to 0.000
*   Click on the [OK] button to save the Display Format
*   Click on the [Preview] Tab to preview while still in Report Designer
*   Save the report and close the Report Designer

That's all there is to it!

 

I hope it helps!

 

Very Best Regards,

 

Razzak 

 

 

  
<https://groups.google.com/group/rbase-l/attach/3c656e7487c2d/image.png?part=0.1&view=1>
 

 

On 11/07/2023 8:53 PM EST Lin MacDonald mailto:li...@fastmail.fm> > wrote:

 

 

This will sound silly, but I am working on a system that I wrote several years 
ago, but can't remember most of what I wrote! 

 

I have a report that prints a Var (type: Real)  It is now printing it with 7 
places after the decimal point.  I need it to print a max of 3 places.  Where 
do I set the number of places?  I honestly can't rmemeber!

 

Lin

 

--

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

Re: [RBASE-L] - Where do I set my Vars?

2023-11-08 Thread Lin MacDonald 
That's really helpful.  Thank you!

On Wed, Nov 8, 2023, at 12:56 PM, Bruce Chitiea wrote:
> I try to have all calculation and data-formation issues squared away before 
> applying display formatting. So, from R:SYNTAX, this might be helpful:
> *(BRND(***arg1,arg2,arg3***))*
> 
> Rounds REAL, DOUBLE, or CURRENCY data to a specific number of decimal places 
> and allows specification of the number of significant digits to return. 
> *Arg1* is the value to be rounded. *Arg2* is the number of significant digits 
> to return, and *Arg3* is the precision. The precision is specified as a 
> decimal number, for example, .01 rounds to two decimal places.
> 
> In the following example, the value of vresult is 1234.57.
> 
> SET VAR vresult = (BRND(1234.5678342,8,.01))
> 
> ***
> 
> The datatype may then be easily redefined to suit your purpose, so that 
> display formatting is reliable child's play:
> 
> SET VAR vresult DOUBLE
> 
> SET VAR vresult TEXT
> 
> SET VAR vresult CURRENCY
> 
> Best, Bruce
> 
> -- Original Message --
> From "'Karen Tellef' via RBASE-L" 
> To "rbase-l@googlegroups.com" 
> Date 11/8/2023 12:43:13 PM
> Subject Re: [RBASE-L] - Where do I set my Vars?
> 
>> 
>> 
>> Welcome to the not-so-wonderful world of the "REAL" datatype.  Long ago in 
>> DOS days that was the only datatype (other than currency) that allowed 
>> decimals.  Unfortunately it isn't real accurate IMO (pun intended).  Most of 
>> us switched all those Real numbers to the DOUBLE datatype.  With Double, a 
>> 104.31 is always stored and displayed exactly as 104.31.  With Real, 
>> internally that number may be stored as something like 104.309187983.  So 
>> depending on your display formatting, you could get different 
>> representations to the screen. 
>> 
>> Looks like the 000.## type of formatting might be truncating.  In my 
>> example, it would display as 104.30 or 104.309 even tho the number is 
>> actually 104.31.  Someone else suggested using the ROUND function if you 
>> know how many decimal places you want displayed.
>> 
>> Karen
>> 
>> 
>> On Wednesday, November 8, 2023 at 01:47:25 PM CST, lin...@gmail.com 
>>  wrote:
>> 
>> 
>> Hello Razzak,
>> 
>> Thank you - that is what I was looking for.  I knew there was a simple 
>> solution.
>> 
>> I am getting a strange output though:  the real number stored is 104.31
>> 000.## prints as 104.30
>> 000.### prints as 104.309
>> 
>> This is an unusual situation where the number stored could possibly be 4 
>> numbers to the left of the decimal and 3 to the right (we have never had 
>> more than 2 to the right)
>> 
>> thanks for the help!
>> 
>> Lin
>> On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote:
>>> __
>>> Lin,
>>>  
>>> Here's how ...
>>>  
>>> Please take a look at the attached illustration.
>>>  • Open the report in Report Designer
>>>  • Right-click on the Variable Object and select Display Format
>>>  • Under the Display Format option change the Display Format to *0.000*
>>>  • Click on the [OK] button to save the Display Format
>>>  • Click on the [Preview] Tab to preview while still in Report Designer
>>>  • Save the report and close the Report Designer
>>> That's all there is to it!
>>>  
>>> I hope it helps!
>>>  
>>> Very Best Regards,
>>>  
>>> Razzak 
>>>  
>>>  
>>> 
>>>> 
>>>> On 11/07/2023 8:53 PM EST Lin MacDonald  wrote:
>>>>  
>>>>  
>>>> This will sound silly, but I am working on a system that I wrote several 
>>>> years ago, but can't remember most of what I wrote! 
>>>>  
>>>> I have a report that prints a Var (type: Real)  It is now printing it with 
>>>> 7 places after the decimal point.  I need it to print a max of 3 places.  
>>>> Where do I set the number of places?  I honestly can't rmemeber!
>>>>  
>>>> Lin
>>>>  
>>>> 
>>>> --
>>>> 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 rbase-l+

Re: [RBASE-L] - Where do I set my Vars?

2023-11-08 Thread Lin MacDonald 
Sadly, that's about when I wrote this!  It is a Universal Key attached to 
several other tables so I can't really change it to a double, I guess

Lin

On Wed, Nov 8, 2023, at 12:43 PM, 'Karen Tellef' via RBASE-L wrote:
> 
> 
> Welcome to the not-so-wonderful world of the "REAL" datatype.  Long ago in 
> DOS days that was the only datatype (other than currency) that allowed 
> decimals.  Unfortunately it isn't real accurate IMO (pun intended).  Most of 
> us switched all those Real numbers to the DOUBLE datatype.  With Double, a 
> 104.31 is always stored and displayed exactly as 104.31.  With Real, 
> internally that number may be stored as something like 104.309187983.  So 
> depending on your display formatting, you could get different representations 
> to the screen. 
> 
> Looks like the 000.## type of formatting might be truncating.  In my example, 
> it would display as 104.30 or 104.309 even tho the number is actually 104.31. 
>  Someone else suggested using the ROUND function if you know how many decimal 
> places you want displayed.
> 
> Karen
> 
> 
> On Wednesday, November 8, 2023 at 01:47:25 PM CST, lin...@gmail.com 
>  wrote:
> 
> 
> Hello Razzak,
> 
> Thank you - that is what I was looking for.  I knew there was a simple 
> solution.
> 
> I am getting a strange output though:  the real number stored is 104.31
> 000.## prints as 104.30
> 000.### prints as 104.309
> 
> This is an unusual situation where the number stored could possibly be 4 
> numbers to the left of the decimal and 3 to the right (we have never had more 
> than 2 to the right)
> 
> thanks for the help!
> 
> Lin
> On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote:
>> __
>> Lin,
>>  
>> Here's how ...
>>  
>> Please take a look at the attached illustration.
>>  • Open the report in Report Designer
>>  • Right-click on the Variable Object and select Display Format
>>  • Under the Display Format option change the Display Format to *0.000*
>>  • Click on the [OK] button to save the Display Format
>>  • Click on the [Preview] Tab to preview while still in Report Designer
>>  • Save the report and close the Report Designer
>> That's all there is to it!
>>  
>> I hope it helps!
>>  
>> Very Best Regards,
>>  
>> Razzak 
>>  
>>  
>> 
>>> 
>>> On 11/07/2023 8:53 PM EST Lin MacDonald  wrote:
>>>  
>>>  
>>> This will sound silly, but I am working on a system that I wrote several 
>>> years ago, but can't remember most of what I wrote! 
>>>  
>>> I have a report that prints a Var (type: Real)  It is now printing it with 
>>> 7 places after the decimal point.  I need it to print a max of 3 places.  
>>> Where do I set the number of places?  I honestly can't rmemeber!
>>>  
>>> Lin
>>>  
>>> 
>>> --
>>> 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 rbase-l+u...@googlegroups.com.
>>> 
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com
>>>  
>>> .
> 
> 
> -- 
> 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 rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.com
>  
> 
> .
> 
> 
> -- 
> 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 rbase-l+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/1942164164.930636.1699476193291%40mail.yahoo.com
>  
> .

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/c022b428-2852-45c0-bb15

Re[2]: [RBASE-L] - Where do I set my Vars?

2023-11-08 Thread Bruce Chitiea 
I try to have all calculation and data-formation issues squared away 
before applying display formatting. So, from R:SYNTAX, this might be 
helpful:

(BRND(arg1,arg2,arg3))

Rounds REAL, DOUBLE, or CURRENCY data to a specific number of decimal 
places and allows specification of the number of significant digits to 
return. Arg1 is the value to be rounded. Arg2 is the number of 
significant digits to return, and Arg3 is the precision. The precision 
is specified as a decimal number, for example, .01 rounds to two decimal 
places.


In the following example, the value of vresult is 1234.57.

SET VAR vresult = (BRND(1234.5678342,8,.01))

***

The datatype may then be easily redefined to suit your purpose, so that 
display formatting is reliable child's play:


SET VAR vresult DOUBLE

SET VAR vresult TEXT

SET VAR vresult CURRENCY

Best, Bruce

-- Original Message --

From "'Karen Tellef' via RBASE-L" 

To "rbase-l@googlegroups.com" 
Date 11/8/2023 12:43:13 PM
Subject Re: [RBASE-L] - Where do I set my Vars?



Welcome to the not-so-wonderful world of the "REAL" datatype.  Long ago 
in DOS days that was the only datatype (other than currency) that 
allowed decimals.  Unfortunately it isn't real accurate IMO (pun 
intended).  Most of us switched all those Real numbers to the DOUBLE 
datatype.  With Double, a 104.31 is always stored and displayed exactly 
as 104.31.  With Real, internally that number may be stored as 
something like 104.309187983.  So depending on your display formatting, 
you could get different representations to the screen.


Looks like the 000.## type of formatting might be truncating.  In my 
example, it would display as 104.30 or 104.309 even tho the number is 
actually 104.31.  Someone else suggested using the ROUND function if 
you know how many decimal places you want displayed.


Karen


On Wednesday, November 8, 2023 at 01:47:25 PM CST, lin...@gmail.com 
 wrote:



Hello Razzak,

Thank you - that is what I was looking for.  I knew there was a simple 
solution.


I am getting a strange output though:  the real number stored is 104.31
000.## prints as 104.30
000.### prints as 104.309

This is an unusual situation where the number stored could possibly be 
4 numbers to the left of the decimal and 3 to the right (we have never 
had more than 2 to the right)


thanks for the help!

Lin

On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote:

Lin,

Here's how ...

Please take a look at the attached illustration.
Open the report in Report Designer
Right-click on the Variable Object and select Display Format
Under the Display Format option change the Display Format to 0.000
Click on the [OK] button to save the Display Format
Click on the [Preview] Tab to preview while still in Report Designer
Save the report and close the Report Designer
That's all there is to it!

I hope it helps!

Very Best Regards,

Razzak



On 11/07/2023 8:53 PM EST Lin MacDonald  wrote:


This will sound silly, but I am working on a system that I wrote 
several years ago, but can't remember most of what I wrote!


I have a report that prints a Var (type: Real)  It is now printing it 
with 7 places after the decimal point.  I need it to print a max of 3 
places.  Where do I set the number of places?  I honestly can't 
rmemeber!


Lin


--
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 rbase-l+u...@googlegroups.com.


To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com 
<https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com?utm_medium=email&utm_source=footer>.


--
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 rbase-l+unsubscr...@googlegroups.com.

To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.com 
<https://groups.google.com/d/msgid/rbase-l/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.com?utm_medium=email&utm_source=footer>

.


--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1942

Re: [RBASE-L] - Where do I set my Vars?

2023-11-08 Thread 'Karen Tellef' via RBASE-L 
 
Welcome to the not-so-wonderful world of the "REAL" datatype.  Long ago in DOS 
days that was the only datatype (other than currency) that allowed decimals.  
Unfortunately it isn't real accurate IMO (pun intended).  Most of us switched 
all those Real numbers to the DOUBLE datatype.  With Double, a 104.31 is always 
stored and displayed exactly as 104.31.  With Real, internally that number may 
be stored as something like 104.309187983.  So depending on your display 
formatting, you could get different representations to the screen.  

Looks like the 000.## type of formatting might be truncating.  In my example, 
it would display as 104.30 or 104.309 even tho the number is actually 104.31.  
Someone else suggested using the ROUND function if you know how many decimal 
places you want displayed.

Karen

On Wednesday, November 8, 2023 at 01:47:25 PM CST, lin...@gmail.com 
 wrote:  
 
 Hello Razzak,
Thank you - that is what I was looking for.  I knew there was a simple solution.
I am getting a strange output though:  the real number stored is 104.31    
000.## prints as 104.30    000.### prints as 104.309
This is an unusual situation where the number stored could possibly be 4 
numbers to the left of the decimal and 3 to the right (we have never had more 
than 2 to the right)
thanks for the help!
Lin

On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote:

   Lin,       Here's how ...       Please take a look at the attached 
illustration. 
   - Open the report in Report Designer
   - Right-click on the Variable Object and select Display Format
   - Under the Display Format option change the Display Format to 0.000
   - Click on the [OK] button to save the Display Format
   - Click on the [Preview] Tab to preview while still in Report Designer
   - Save the report and close the Report Designer
  That's all there is to it!       I hope it helps!       Very Best Regards,    
   Razzak          


  On 11/07/2023 8:53 PM EST Lin MacDonald  wrote:           
This will sound silly, but I am working on a system that I wrote several years 
ago, but can't remember most of what I wrote!        I have a report that 
prints a Var (type: Real)  It is now printing it with 7 places after the 
decimal point.  I need it to print a max of 3 places.  Where do I set the 
number of places?  I honestly can't rmemeber!       Lin  
 


 -- 


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 rbase-l+u...@googlegroups.com. 
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com.
 



-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.com.
  

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1942164164.930636.1699476193291%40mail.yahoo.com.

Re: [RBASE-L] - Where do I set my Vars?

2023-11-08 Thread lin...@gmail.com 
Hello Razzak,

Thank you - that is what I was looking for.  I knew there was a simple 
solution.

I am getting a strange output though:  the real number stored is 104.31
000.## prints as 104.30
000.### prints as 104.309

This is an unusual situation where the number stored could possibly be 4 
numbers to the left of the decimal and 3 to the right (we have never had 
more than 2 to the right)

thanks for the help!

Lin

On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote:

> Lin, 
>   
> Here's how ... 
>   
> Please take a look at the attached illustration. 
>
>- Open the report in Report Designer 
>- Right-click on the Variable Object and select Display Format 
>- Under the Display Format option change the Display Format to *0.000* 
>- Click on the [OK] button to save the Display Format 
>- Click on the [Preview] Tab to preview while still in Report Designer 
>- Save the report and close the Report Designer 
>
> That's all there is to it! 
>   
> I hope it helps! 
>   
> Very Best Regards, 
>   
> Razzak  
>   
>   
>
> On 11/07/2023 8:53 PM EST Lin MacDonald  wrote: 
>   
>   
> This will sound silly, but I am working on a system that I wrote several 
> years ago, but can't remember most of what I wrote!  
>   
> I have a report that prints a Var (type: Real)  It is now printing it with 
> 7 places after the decimal point.  I need it to print a max of 3 places.  
> Where do I set the number of places?  I honestly can't rmemeber! 
>   
> Lin 
>
>  
>
> -- 
>
> 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 rbase-l+u...@googlegroups.com. 
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com
>  
> .
>  
>
>
>

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.com.

RE: [RBASE-L] - Where do I set my Vars?

2023-11-07 Thread 'Philippe Gosselin' via RBASE-L 
You can modify the “Display format” in your report.

 

Best regards,

 

Philippe Gosselin

General manager

 <mailto:p...@canl.nc> p...@canl.nc 

BP 3899 - 98846 Noumea – New Calédonia

Tel : +687 27.62.23 / Mobile : +687 77.15.76

 



 

De : rbase-l@googlegroups.com  De la part de Steve 
Sweeney
Envoyé : mercredi 8 novembre 2023 13:36
À : rbase-l@googlegroups.com
Objet : RE: [RBASE-L] - Where do I set my Vars?

 

SET V v3 REAL = .#PI

SHOW V v3

 3.141593

SET V v3 = (ROUND(.v3,3))

SHOW V v3

3.142

 

From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>  
mailto:rbase-l@googlegroups.com> > On Behalf Of Lin 
MacDonald
Sent: Tuesday, November 7, 2023 5:54 PM
To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
Subject: [RBASE-L] - Where do I set my Vars?

 

This will sound silly, but I am working on a system that I wrote several years 
ago, but can't remember most of what I wrote! 

 

I have a report that prints a Var (type: Real)  It is now printing it with 7 
places after the decimal point.  I need it to print a max of 3 places.  Where 
do I set the number of places?  I honestly can't rmemeber!

 

Lin

-- 
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 rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com
 
<https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com?utm_medium=email&utm_source=footer>
 .

-- 
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 rbase-l+unsubscr...@googlegroups.com 
<mailto:rbase-l+unsubscr...@googlegroups.com> .
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/SN6PR03MB3727CD7E5CC9D7145472AB3689A8A%40SN6PR03MB3727.namprd03.prod.outlook.com
 
<https://groups.google.com/d/msgid/rbase-l/SN6PR03MB3727CD7E5CC9D7145472AB3689A8A%40SN6PR03MB3727.namprd03.prod.outlook.com?utm_medium=email&utm_source=footer>
 .

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/003701da11ed%2493726500%24ba572f00%24%40canl.nc.

RE: [RBASE-L] - Where do I set my Vars?

2023-11-07 Thread Steve Sweeney 
SET V v3 REAL = .#PI
SHOW V v3
 3.141593
SET V v3 = (ROUND(.v3,3))
SHOW V v3
3.142

From: rbase-l@googlegroups.com  On Behalf Of Lin 
MacDonald
Sent: Tuesday, November 7, 2023 5:54 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Where do I set my Vars?

This will sound silly, but I am working on a system that I wrote several years 
ago, but can't remember most of what I wrote!

I have a report that prints a Var (type: Real)  It is now printing it with 7 
places after the decimal point.  I need it to print a max of 3 places.  Where 
do I set the number of places?  I honestly can't rmemeber!

Lin
--
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com<https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com?utm_medium=email&utm_source=footer>.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/SN6PR03MB3727CD7E5CC9D7145472AB3689A8A%40SN6PR03MB3727.namprd03.prod.outlook.com.

[RBASE-L] - Where do I set my Vars?

2023-11-07 Thread Lin MacDonald 
This will sound silly, but I am working on a system that I wrote several years 
ago, but can't remember most of what I wrote! 

I have a report that prints a Var (type: Real)  It is now printing it with 7 
places after the decimal point.  I need it to print a max of 3 places.  Where 
do I set the number of places?  I honestly can't rmemeber!

Lin

-- 
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com.