How to create a report(crystal) in vb.net from multiple tables by filtering all tables

How to create a report(crystal) in vb.net from multiple tables by
filtering all tables

Im using sql server. I have 2 tables (ex. Student_info and T_Fees).. This
is the structure...
table structure I want to create a report that will display students who
pay on the specific date I want to view, which will filter the Date_pay
from T_Fees Table, BUT I want it to display by their Status which will
filter the status from my another table, Student_Info Table...
For example I want to display all student who pay by July 30 2013 but all
regular students only. so my output will be:
output