on 04-02-2015 7:05 AM
Hi All,
I can be able to filter the data in the report by using parameters till now. Is there any scope to filter the data in crystal reports other than by parameters, if there is a possibility please share here. . using crystal reports 2011.
Regards,
Santhosh.S
Hi,
You can filter data using Record selection by using "Report --> Selection Formulas --> Record" option, where in, you can enter your own filter criteria on database fields.
Please explain more on your requirement.
Thanks,
Raghavendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raghavendra,
I think, the one which you had mentioned "selecting formulas" and "select expert" are both same. I mean to say is both are using parameters. I want it by using other than parameters to filter the data.
After reading your answer, I'm into another confusion . Difference between select expert and selecting formulas.
-Santhosh
Hi,
Yes, both will be for same functionality i.e to filter the data to be displayed in report based on some condition.
But, the difference between Select expert and Selection Formula is that, Select expert allows you to only select database fields (not allowing you to write customized code or our own code).
Where as, using Selection Formula, we can select the database field as in Select Expert option, along with that, we can write our own formula content using existing report formulae also.
You can see the difference by clicking on each of those 2 options.
Thanks,
Raghavendra
Whatever you do in the 'Select Expert' gets converted to a 'Selection Formula' which is accessed via Report > Selection Formulas > Record.
Think of the Select Expert as the 'GUI' and the Selection Formulas as the 'Command Prompt'. More advanced users prefer using Selection Formulas.
Coming back to your original question, if you do not want to filter records via a prompt, you can 'hardcode' values in the Selection Formula if you're reporting directly against tables/views.
If you're reporting against a Command Object (SQL Query added via the 'Add Command' option), then you should add the filter condition as a where clause.
Other ways to filter records are using the Group Selection Formula (similar to the having clause) or a conditional suppression formula for the sections - both of these methods filter records locally.
-Abhilash
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.