ElmDutch
asked on
Passing Date peramiters from VB to crystal9 into a record formula
I am passing in my VB application the report selection date into the following fields
CRXReport.FormulaFields(3) .Text = (Day(txtmaxvaldt))
CRXReport.FormulaFields(4) .Text = (Month(txtmaxvaldt))
CRXReport.FormulaFields(5) .Text = (Year(txtmaxvaldt))
I have watched these field loads through the DEBUGER and the fields look to be loaded correctly, but when the report is executed it returns nothing but the report form.
The crystal9 record selection formula in question is
{CMINV_INV_EXTRACT.CASE_NO } like "DU*" and
{CMINV_INV_EXTRACT.SYSTEM_ ORIG_CD} in ["1", "2", "3"] and
{CMINV_INV_EXTRACT.VALUATI ON_DT} = Date ( {@tstyyyy},{@tstmm},{@tstd d})
I load this Date info through the crystal 9 formula expert and the report loads. I need to know what I am missing in this load process
Thanks for your help
CRXReport.FormulaFields(3)
CRXReport.FormulaFields(4)
CRXReport.FormulaFields(5)
I have watched these field loads through the DEBUGER and the fields look to be loaded correctly, but when the report is executed it returns nothing but the report form.
The crystal9 record selection formula in question is
{CMINV_INV_EXTRACT.CASE_NO
{CMINV_INV_EXTRACT.SYSTEM_
{CMINV_INV_EXTRACT.VALUATI
I load this Date info through the crystal 9 formula expert and the report loads. I need to know what I am missing in this load process
Thanks for your help
ASKER
this is true -- oracle date filed is 10/29/2004 00:00:00
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Another way
{CMINV_INV_EXTRACT.VALUATI ON_DT} >= Date ( {@tstyyyy},{@tstmm},{@tstd d}) AND
{CMINV_INV_EXTRACT.VALUATI ON_DT} < Date ( {@tstyyyy},{@tstmm},{@tstd d}+1)
mlmcc
{CMINV_INV_EXTRACT.VALUATI
{CMINV_INV_EXTRACT.VALUATI
mlmcc
Should have solved it.
mlmcc
mlmcc
mlmcc