how to filter the Report

[ismailkhannasar]

Dear , i have make a report which has 1000 of rows of various projects but i want to get only filter the data (Same as we have in Excel) to provide only those project data which i have selected in list . how to filter the data





thanks

[qa12dx]

on the button u want to use to open the report, use properties-onclick event. u can use macro or vb.

below is an example of a report i made. it is to show a report for a date range. first i have criteria that askes the user to choose dates if user hasn't before click the button. if date range is selected then open the report for the range;

If (Eval("[Forms]![SB02_01_PrintOut_menu]![from_dt] Is Null Or [Forms]![SB02_01_PrintOut_menu]![to_dt] Is Null")) Then
Beep
MsgBox "Please Select both date fields ", vbInformation, "Guide"
End If
If (Eval("[Forms]![SB02_01_PrintOut_menu]![from_dt] Is Null Or [Forms]![SB02_01_PrintOut_menu]![to_dt] Is Null")) Then
End
End If
DoCmd.OpenReport "R010_01_Recieve", acViewReport, "", "[Q010_00_Recieve_ALL_PRINT]![dt] Between [Forms]![SB02_01_PrintOut_menu]![from_dt] And [Forms]![SB02_01_PrintOut_menu]![to_dt]", acNormal

[NTC]

one can filter a report 2 ways:

at the record source level of the report - using a query as the record source - and define the query so it only returns the records that are wanted.

at the report level - by defining the filter property found in the report's property. it can be manually entered - and permanent for the report - or it can be dynamically entered as part of the opening argument for the report. You will want to research the opening argument information for reports and modify the button or command that opens the report to include the filter info.

hope this helps.