SQL Queries in Formula in CrystalReports

view full story

http://serverfault.com – I have student Database. I have generated CrystalReport for Student's Exam Details having Name,ObtainedMarks,PassNumber. Now I just want to display top 3 rankers in report. For that I want to use a formula. So is it possible to write a SQL like query in Formula like: select "ExamNameWise"."Name" from "ExamNameWise" where "ExamNameWise"."PassNumber" = "1" How can I get the name of student having passNumber = "1" ? My table Structure is like this: http://stackoverflow.com/questions/11845426/issue-related-to-formula-in-... I am Using SQLServer 2008 Thanks.. (HowTos)