Data Report/Crystal Report Problem

[ISChana]

Dear All

Pl. help me on this ;;

I had made data report but i was unable to put sr no. in the report..pl. suggest how to do that

then i tried to make this report in Crystal report. Serial no probelm was solved but then problem came of filtering the records.

i like to filter records based on a particular date(Entered by the user)e.g. user enter date in field dt_input
i wrote following query

cr.selectionformula="table.field=#dt_input#"

but problem was not solved
so please suggest the solution..

regards

Inderjeet

 

[PatrickIRL]

try

cr.selectionformula="{table.field}=#dt_input#"

Note the extra curly brackets..

Patrick

 

[ISChana]

i tried the same but actually access has DATE/TIME fields while through VB coding it goes DATE only

that's why error comes..

error in record selection formula
A date time s required here

so please suggest..

 

[vidru]

Using redsmooth's example, try using Crystal's CDateTime function to cast the date to a Date/Time:

cr.selectionformula="{table.field}=CDateTime('" & dt_input & "')"

-dave

 

[NightGhos]

I don't have right now Crystal Reports on this computer but i remember that crytal use this format yy/mm/dd on a function called date so try this

cr.selectionformula="#table=Date(" & year(dtinput) & "," & month(dtinput) & "," & day(dtinput) & ")"



===================================
Never underestimate the power of stupid people in big numbers
===================================