knopix Posted May 24, 2013 Share Posted May 24, 2013 please help me to filter reports by date, by day ? Module ISAPI application how?Thanks Regards Knopix Link to comment Share on other sites More sharing options...
rencarnacion Posted May 24, 2013 Share 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 Link to comment Share on other sites More sharing options...
knopix Posted May 30, 2013 Author Share Posted May 30, 2013 I want to join multiple tables and filter reports by date Regards Knopix Link to comment Share on other sites More sharing options...
Ronak Posted May 31, 2013 Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now