calculated field using record num in report problem with 4.5 dos 
Author Message
 calculated field using record num in report problem with 4.5 dos
I need to create a calculated field in a report that maps record 1 to 120, 2
to 130, 4 to 140 and so on.  When I try use the record number [#], Paradox
will not accept it and gives me an error message.  The calc'd field should
have looked like this "10*[#]+110" to perform as wished.  It is just the
reference to the record number that is hosing me up.  Any ideas?


Sun, 18 Dec 2005 23:55:01 GMT
 calculated field using record num in report problem with 4.5 dos

Here's an example of how. Adapt it to your own circumstances as
appropriate:

1. Create a new report
2. Add a TableFrame object to the AllRecords band
3. Right-click the TableFrame and select Define Table
4. Select a table and bind two fields
5. Select the left-most column (click in the third row until the
column selects) and insert a new column - it will now be the new
left-most column
6. Define the field; drop the field list and select "Record
Number".
7. Repeat step 5
8. Define this new field as a calculated field with the formula

( 10 * Record_Number ) + 110

Run report

QED.

You can, of course, arrange things so that the Record Number
field is not visible, and you can drag that field into another
column and dispense with the column entirely !

hth

Mike



Quote:
> I need to create a calculated field in a report that maps record 1 to 120, 2
> to 130, 4 to 140 and so on.  When I try use the record number [#], Paradox
> will not accept it and gives me an error message.  The calc'd field should
> have looked like this "10*[#]+110" to perform as wished.  It is just the
> reference to the record number that is hosing me up.  Any ideas?



Mon, 19 Dec 2005 00:15:46 GMT
 calculated field using record num in report problem with 4.5 dos
Mike,

Those don't like like PdoxDOS instructions to me.

--
Kevin
(if you email me, make sure to DeSpamulate my address)
------------------------------
-     Kevin Donaker-Ring     -
-  Executive Director, AISE  -
-    http://www.aise.com     -
------------------------------

Quote:

> Here's an example of how. Adapt it to your own circumstances as
> appropriate:

> 1. Create a new report
> 2. Add a TableFrame object to the AllRecords band
> 3. Right-click the TableFrame and select Define Table
> 4. Select a table and bind two fields
> 5. Select the left-most column (click in the third row until the
> column selects) and insert a new column - it will now be the new
> left-most column
> 6. Define the field; drop the field list and select "Record
> Number".
> 7. Repeat step 5
> 8. Define this new field as a calculated field with the formula

> ( 10 * Record_Number ) + 110

> Run report

> QED.

> You can, of course, arrange things so that the Record Number
> field is not visible, and you can drag that field into another
> column and dispense with the column entirely !

> hth

> Mike



>>I need to create a calculated field in a report that maps record 1 to 120, 2
>>to 130, 4 to 140 and so on.  When I try use the record number [#], Paradox
>>will not accept it and gives me an error message.  The calc'd field should
>>have looked like this "10*[#]+110" to perform as wished.  It is just the
>>reference to the record number that is hosing me up.  Any ideas?



Mon, 19 Dec 2005 07:01:36 GMT
 calculated field using record num in report problem with 4.5 dos

Quote:

> Those don't like like PdoxDOS instructions to me.

I didn't notice that it said DOS either..

--

Steve Green - Diamond Software Group, Inc - Waldorf Maryland USA
Corel CTech Paradox - http://www.diamondsg.com - Support/Downloads/Links
---------------------------------------------------------------------------------
Do you need a Sanity Check? http://www.diamondsg.com/sanity.htm
Upgrade/Downgrade versions? http://www.diamondsg.com/upgrade.htm
-------------------------------------------------------------------------



Mon, 19 Dec 2005 07:19:44 GMT
 calculated field using record num in report problem with 4.5 dos

Quote:

> I need to create a calculated field in a report that maps record 1 to 120, 2
> to 130, 4 to 140 and so on.  When I try use the record number [#], Paradox
> will not accept it and gives me an error message.

in a PdoxDOS report, you can't do it that way.. if you *must* use Recno() in a
calc, you'll need to create an extra field, SCAN the table to seed it with
RECNO(), then use that field in your calcs..

--

Steve Green - Diamond Software Group, Inc - Waldorf Maryland USA
Corel CTech Paradox - http://www.diamondsg.com - Support/Downloads/Links
---------------------------------------------------------------------------------

Do you need a Sanity Check? http://www.diamondsg.com/sanity.htm
Upgrade/Downgrade versions? http://www.diamondsg.com/upgrade.htm
-------------------------------------------------------------------------



Mon, 19 Dec 2005 07:20:53 GMT
 calculated field using record num in report problem with 4.5 dos
They're not ... I didn't read the last word in the title because
it truncated. Sorry. However, maybe Steve can tell you if the
same principle holds true ...

Mike



Quote:
> Mike,

> Those don't like like PdoxDOS instructions to me.



Mon, 19 Dec 2005 22:20:04 GMT
 calculated field using record num in report problem with 4.5 dos
Thanks, I shall give that a try.


Quote:

> > I need to create a calculated field in a report that maps record 1 to
120, 2
> > to 130, 4 to 140 and so on.  When I try use the record number [#],
Paradox
> > will not accept it and gives me an error message.

> in a PdoxDOS report, you can't do it that way.. if you *must* use Recno()
in a
> calc, you'll need to create an extra field, SCAN the table to seed it with
> RECNO(), then use that field in your calcs..

> --

> Steve Green - Diamond Software Group, Inc - Waldorf Maryland USA
> Corel CTech Paradox - http://www.diamondsg.com - Support/Downloads/Links
> --------------------------------------------------------------------------
-------

> Do you need a Sanity Check? http://www.diamondsg.com/sanity.htm
> Upgrade/Downgrade versions? http://www.diamondsg.com/upgrade.htm
> -------------------------------------------------------------------------



Sat, 24 Dec 2005 11:05:48 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Calculated field in form, Paradox 4.5 dos

2. Calculated Field Problem. Delphi w/ Pdox 4.5 Table

3. PDX 4.5 for Dos Sum Field on Page Problem

4. DOS 4.5 Runtime used in Win95 - Problem??

5. Dos4.5-Report/calculated field using lookup table field

6. Dos4.5-Report/calculated field using lookup table field

7. Report in dos 4.5

8. Crystal Reports and Pdox 4.5 Dos

9. Reports for Paradox 4.5 Dos

10. embeded ascii text in pdox dos 4.5 report

11. Paradox Dos 4.5 & Printing Reports

12. Report Generator Paradox for DOS 4.5 databases


 
Powered by phpBB® Forum Software