cyrtsal report how to hide records based on condition of a field like date
hi all i have a question about hiding records in crystal report and i am using cyrstal report in vs 2008 ,i dont know its version as i am new in crystal reporting
lets say i have report like that
customer_Id customer_name OrderAmount Order_date
0 xyz 5 03/02/2010
1 abc 6 04/02/2010
3 dre 7 07/02/2009
4 开发者_C百科 kila 3 08/02/2009
i wana ask is there a pssibilty to hide the record if Order_Date year in 2009 and show only the records where Order_date year in 2010 to be like that :
customer_Id customer_name OrderAmount Order_date
0 xyz 5 03/02/2010
1 abc 6 04/02/2010
**note i do need the data of 2009 to make a bar chart for this year
thanks in advance
So the report itself will have a bar chart on to show 2009, but the list of records shouldn't show 2009?
Two options :
The first is a subreport.
The second is to use a suppression formula in the Details section that says "Year(Order_Date) = 2009".
精彩评论