knopix Posted May 24, 2013 Posted May 24, 2013 please help me to filter reports by date, by day ? Module ISAPI application how?Thanks Regards Knopix Quote
rencarnacion Posted May 24, 2013 Posted May 24, 2013 You should explain better what you really want to do. I guess that You want filter to the data of the Query that report is Using , so You must to put parameters to the query and you can filter when ever you want But Again Explain Better what you really want to Do Ronny Encarnacion Quote
knopix Posted May 30, 2013 Author Posted May 30, 2013 I want to join multiple tables and filter reports by date Regards Knopix Quote
Ronak Posted May 31, 2013 Posted May 31, 2013 hello, I used to filter in this way, this may help select ...from A,B,C,D where (convert(Char(8), A.RefDate, 112) between :SYMD and :EYMD) and (convert(Char(8), B.RefDate, 112) between :SYMD1 and :EYMD1) ... may google for the help for MS SQL convert function ... var SYMD, EYMD : String;begin SYMD:=FormatDateTime('YYYYMMDD', DatePkrSDate.DateTime); EYMD:=FormatDateTime('YYYYMMDD', DatePkrEDate.DateTime); MyQuery.Parameters.ParamByName('SYMD').Value:= SYMD; MyQuery.Parameters.ParamByName('EYMD').Value:= EYMD; MyQuery.Parameters.ParamByName('SYMD1').Value:= SYMD; MyQuery.Parameters.ParamByName('EYMD1').Value:= EYMD; MyQuery.Open; end Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.