<b>Date from and through and QuickReports</b>

[heydyrtt]

I'm using two datepickers components, one is a from date and the other the through date. I need the dates that were selected to show on the report that will be printed from the user selecting the dates. example: Sales from 12/01/2002 thru 12/30/2002. I'm using quickreports.


Any help

Thanks

heydyrtt

 

[BTecho]

Hi there

One way is to filter the dataset the QuickReport is connected to. For example, if you use a TTable you can use the Filter property or OnFilterRecord event or if you use a TQuery you can use SQL.

Then after the print or preview has finished clear the filter. If I remember correctly you can do that on the AfterPrint/AfterPreview event of TQuickRep

Fore more info please checkout C++Builder help and these links below:

http://www.temporaldoorway.com/programming/cbuilder/databaseandbde/index.htm

http://www.njnet.edu.cn/info/ebook/c++/cppbuilder/toc.htm

http://delphi.about.com/cs/sqlanddelphi/index.htm

QuickReport tutorial and faq

http://delphi.about.com/library/bluc/text/uc051701a.htm

http://www.qusoft.com/QuickReportFAQ.doc

 

[pheuvel]

Gday there,

In my report classes, I generally create a "SetParams" method. In your case, I would create one as:

void __fastcall TMyReport::SetParams(TDateTime fromdate, TDateTime todate)
{
// do something with dates
DateLabel->Caption =
fromdate.FormatString("dd-mmm-yyyy&quot +
" to " +
todate.FormatString("dd-mmm-yyyy"
}

Then call the method with the selected dates prior to calling the report. E.g:

MyReport->SetParams(fromdate->Date, todate->Date);
MyReport->Preview();

Hope this helps...

Regards,
Pat