CrystalReportViewer1.SelectionFormula error

[ehx6]

Hi, I am trying to use the selection fourmula to filter the return data from the report. I am able to use the selection formula on any field in the report, but when I have a derived field in Crystal report ( Formual Field ) I am not able to use it in the CrystalReportViewer1.SelectionFormula on the aspx page. your help is appreciated.
thanks
EHx


The error:
<Record Selection>. ' {v_sales_price_vs_cost.Project_Name} = 'Avonlea 24 ft Townhomes' and {v_sales_price_vs_cost.Unite_type_Name} = '' and {sales_price_vs_cost_swmIII.@Option_Profit} >= .6 ' This field name is not known. Details: errorKind

 

[randysmid]

HI,
I wasn't able to get that to work either, so I invented my own technique. I wrote an FAQ on the topic of passing criteria from a separate form to the ASPX form that contains the report viewer. You can find it at: FAQ766-5471

The really nice part of this technique is that it pushes down the actual retrieval of the records to the database server, rather than letting all the records return to the client for filtering.


HTH,
Randy Smith, MCP
California Teachers Association