Formulas in Crystal Report 4.6 ActiveX, 2° 
Author Message
 Formulas in Crystal Report 4.6 ActiveX, 2°

 I can't pass VB data to formulas (error message !), I only can pass fixed
 values ?

 Is it possible to to pass Vb datas ? ant how ?

 - what is possible :
         CrystalReport1.GroupSelectionFormula =
 "totext({SpringCalendar.EvtsDates}) = 'string'"

 -what I want :
         Dim myStr as string
         myStr = "11/05/97"
         CrystalReport1.GroupSelectionFormula =
 "totext({SpringCalendar.EvtsDates}) = myStr"

 Or something like that...

 Thanks

 ___________________Alain Sgalou



Sat, 13 Apr 2002 03:00:00 GMT
 Formulas in Crystal Report 4.6 ActiveX, 2°

Hello:

if your the EvtsDates is a text field then use
         CrystalReport1.GroupSelectionFormula=
"{SpringCalendar.EvtsDates})='" &  myStr & "'"

if your the EvtsDates is a date field  then use
        CrystalReport1.GroupSelectionFormula=
"{SpringCalendar.EvtsDates})=Date(" &  Year(myStr) & "," & Month(myStr) _

& "," & Day(myStr) & ")"

Hope this what you want. Regards.



Sat, 13 Apr 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Formulas in Crystal Report 4.6 ActiveX

2. ActiveX Crystal Report Control 4.6

3. VB5 and Crystal Reports 4.6.

4. 2 unlinked tables in one crystal report 4.6 ???

5. Migrating from Crystal Reports 4.6 to 5.0 Professional.

6. Access 2000 and Crystal Reports 4.6

7. 2 unlinked tables in one crystal report 4.6 ????

8. Sybase ASE ODBC driver ( version 3.50.00.10 ) and Crystal Reports 4.6 error

9. Crystal Rpts 4.6 and Secured Access Db

10. Converting from VB4 to VB5 with Crystal 4.6

11. VB5 - Crystal 4.6 :o/


 
Powered by phpBB® Forum Software