Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Crystal Report Filter Post Reply Post New Topic
Author Message
amc1890
Newbie
Newbie


Joined: 21 Feb 2011
Location: Philippines
Online Status: Offline
Posts: 8
Quote amc1890 Replybullet Topic: Crystal Report Filter
    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.

IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet 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.
IP IP Logged
amc1890
Newbie
Newbie


Joined: 21 Feb 2011
Location: Philippines
Online Status: Offline
Posts: 8
Quote amc1890 Replybullet 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?
IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet 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?


Edited by Keikoku - 24 Feb 2011 at 2:32am
IP IP Logged
amc1890
Newbie
Newbie


Joined: 21 Feb 2011
Location: Philippines
Online Status: Offline
Posts: 8
Quote amc1890 Replybullet 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
IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet 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.

Edited by Keikoku - 25 Feb 2011 at 3:04am
IP IP Logged
amc1890
Newbie
Newbie


Joined: 21 Feb 2011
Location: Philippines
Online Status: Offline
Posts: 8
Quote amc1890 Replybullet 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
IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet Posted: 01 Mar 2011 at 2:51am
Don't use parameters. Just specify exactly what you want to filter in the selection formula.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.