Crystal Reports: Use Data Set in Existing Columns to Generate a New Column 
Author Message
 Crystal Reports: Use Data Set in Existing Columns to Generate a New Column

Hi all,

I have an existing data set with several columnns shown in
the following:

   ChemName    Conc.   Flag   Limit1   Limit2  CQ  
   Benzene             <      1.0       2.0      
   Toluene       3.1          2.0       4.0    J
   Mercury       7.5          3.0       5.0    

I want to use the above information to generate a new
column "Result" that is formatted below:

  ChemName    Conc.   Flag  Limit1   Limit2  CQ   Result
   Benzene             <     1.0      2.0         U(<1.0)
   Toluene     3.1           2.0      4.0    J    3.1(J)
   Mercury     7.5           3.0      5.0         7.5

Please tell me which program of Crystal Reports and what
VBA codes we should use to generate the U(<1.0), 3.1(J)
and 7.5 in the "Results" column.

Thanks in advance,
Scott  Chang  



Sat, 02 Oct 2004 22:53:44 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Using an existing crystal report, but programmatically redirecting where/how the report gets its data

2. Crystal report with data in columns

3. using variables to set report column headings in access95

4. Adding new column to existing table

5. Adding new column to existing table

6. Adding new column to existing table

7. new columns in existing table

8. Data from hidden column or make column visible

9. add a column to an existing data table

10. add column to an existing data table

11. Report Columns in MS Data Report

12. Data error event hit err:Column(ordernr)does not exist in the appropriate rowset

 

 
Powered by phpBB® Forum Software