Crystal Report Filter
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12392
Printed Date: 05 May 2024 at 12:08pm
Topic: Crystal Report Filter
Posted By: amc1890
Subject: Crystal Report Filter
Date Posted: 21 Feb 2011 at 5:55pm
Good Day!!
Is it possible to filter my report from what I want?
for example,
I want to view students who passed on specific examination.
|
Replies:
Posted By: Keikoku
Date Posted: 22 Feb 2011 at 5:04am
|
Depending on the report, it may be accomplished differently, but it is possible and may be quite easy.
|
Posted By: amc1890
Date Posted: 23 Feb 2011 at 3:44pm
|
I am a beginner in using a crystal report, can you teach me how to do certain filter in specific report?
|
Posted By: Keikoku
Date Posted: 24 Feb 2011 at 2:31am
Can you describe what your data is like?
Are you retrieving values from a database?
Are there multiple examinations?
How do you determine whether someone has passed or failed?
|
Posted By: amc1890
Date Posted: 24 Feb 2011 at 5:57pm
My data is a section of one classroom.
Yes I am going to retrieve it from database
Yes it is possible to have a multiple examinations
Passed if he/she achieved 70% of total number of items given. Otherwise he/she fails the exam.
A big thanks for your response
|
Posted By: Keikoku
Date Posted: 25 Feb 2011 at 3:02am
You can use a "record select formula" to specify exactly what you want to see.
I am basing this procedure on CR XI so it may be different for you.
Once you have created your report with all the appropriate fields, open the formula editor and go to selection formuls --> record selection.
You will then define what kind of details you want to see. So if you want to see all students that have passed ExamA (ie: student's mark for ExamA >= 70%), assuming ExamA is a field on the report and is a number type, you would write using the format
{table.field} (some math operator) number
So if for example the table is called Results and the field for ExamA is just ExamA, and you want all students that passed, you would write
{Results.ExamA} >= 70
This tells crystal to show all records where the mark on ExamA is greater or equal to 70. Figure out how this would best go with your data.
|
Posted By: amc1890
Date Posted: 25 Feb 2011 at 3:47pm
I've been already used this.
I used textbox on this kind of filter.. but I want to remove on its form load the one that is prompting upon execution of my program. Can you help me to remove that?
Thanks again for your response
|
Posted By: Keikoku
Date Posted: 01 Mar 2011 at 2:51am
|
Don't use parameters. Just specify exactly what you want to filter in the selection formula.
|
|