So I would try to use a SubSelect within the main query and ask for your group-count something like "SELECT COUNT(FieldName) FROM TABLEX WHERE ConditionField = X. if the cell content 'Deducted' then sumDeducted. if the cell content 'Accrued' then sumAccrued. I like to use crystal report count() function with condition. I want to know whether it is possible to get the number of times a person was present/absent and how it can be implemented. I have a Boolean field named Status in the report that indicate whether a person was present or not. and I have a column called 'Amount' in the table 'Transactions'. I am using SAP Crystal for VS 2010 to generate report.
so as the variable is incremented at each detail record how should the engine do that? I've three formula fields in crystal reports as follows: sumAccrued. So in this case, the report engine should know in advance not to print the whole groupheader-band if there are no records found in the group at the end. You said "suppress condition in crystal reports" ?!?! As in your initial post you want to "suppress" the whole group-header band if the actual group count is 0, right? just take a look at the reset-time COLUMN, so the value will be resetted at each column break.īut I still don't understand what you want to achieve. Now, when refreshing the report, if there is no data on the report it will display the value zero, but if there is records, it will display the record number for each row.Of course you could count also at column level. Hi all, I'm doing some reports where counting records is extensively used some of these counts have to be done based on some data in the returning Question about counting records based on condition Wrox Programmer Forums >.
In Crystal Reports designer, open your report, or create a new report off any data source.