dbTalk Databases Forums  

Adding two columns to recordset in code for report to display

comp.databases.btrieve comp.databases.btrieve


Discuss Adding two columns to recordset in code for report to display in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robin
 
Posts: n/a

Default Adding two columns to recordset in code for report to display - 06-25-2004 , 03:17 PM






Hello all,

I'm working with a database that doesn't have all the values I need
for a report, so I'm doing some calculations in code and then need to
pass two additional calculated values for each record back to the
report to display. For reasons I won't go into here I can't ask the
report to do the calculations. How can I do this? I'm using VB6, CR9
and a Pervasive 2000i database.

Thanks so much.


Robin

Reply With Quote
  #2  
Old   
Robin
 
Posts: n/a

Default Re: Adding two columns to recordset in code for report to display - 06-28-2004 , 06:52 PM






In case anyone else has this problem/question, I been able to solve
this issue by creating a CSV file from code and then running my report
on that "recordset." If anyone has a better solution that this one,
please let me know.



duncanstreet2004 (AT) yahoo (DOT) com (Robin) wrote in message news:<19e358cb.0406251217.699ad1d1 (AT) posting (DOT) google.com>...
Quote:
Hello all,

I'm working with a database that doesn't have all the values I need
for a report, so I'm doing some calculations in code and then need to
pass two additional calculated values for each record back to the
report to display. For reasons I won't go into here I can't ask the
report to do the calculations. How can I do this? I'm using VB6, CR9
and a Pervasive 2000i database.

Thanks so much.


Robin

Reply With Quote
  #3  
Old   
Robin
 
Posts: n/a

Default Re: Adding two columns to recordset in code for report to display - 06-28-2004 , 06:55 PM



I have been able to solve this issue by creating a CSV file from code
and running my report on that.




duncanstreet2004 (AT) yahoo (DOT) com (Robin) wrote in message news:<19e358cb.0406251217.699ad1d1 (AT) posting (DOT) google.com>...
Quote:
Hello all,

I'm working with a database that doesn't have all the values I need
for a report, so I'm doing some calculations in code and then need to
pass two additional calculated values for each record back to the
report to display. For reasons I won't go into here I can't ask the
report to do the calculations. How can I do this? I'm using VB6, CR9
and a Pervasive 2000i database.

Thanks so much.


Robin

Reply With Quote
  #4  
Old   
Guy Dawson
 
Posts: n/a

Default Re: Adding two columns to recordset in code for report to display - 06-29-2004 , 07:57 AM



Robin wrote:

Quote:
In case anyone else has this problem/question, I been able to solve
this issue by creating a CSV file from code and then running my report
on that "recordset." If anyone has a better solution that this one,
please let me know.

I think that's as good as it's going to get short of writing the
data to a tempory table. If you can't do the calculations in the
report you have to do them elsewhere, put them in a temporary
record set and report on that.

Quote:
duncanstreet2004 (AT) yahoo (DOT) com (Robin) wrote in message news:<19e358cb.0406251217.699ad1d1 (AT) posting (DOT) google.com>...

Hello all,

I'm working with a database that doesn't have all the values I need
for a report, so I'm doing some calculations in code and then need to
pass two additional calculated values for each record back to the
report to display. For reasons I won't go into here I can't ask the
report to do the calculations. How can I do this? I'm using VB6, CR9
and a Pervasive 2000i database.

Thanks so much.


Robin

--
Guy
-- --------------------------------------------------------------------
Guy Dawson I.T. Manager Crossflight Ltd
gnues (AT) crossflight (DOT) co.uk


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.