Jump to content

Recommended Posts

Posted

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 

Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...