dynamic report using store procedure in vb.net

[seep]

hi..

i wanted report that will display any record of database on any search criteria and from any date. suppose reports to view all emloyess of hospital that are male from 6th september o 20th september. or the report may be to view all patients who r suffering from cough and are male etc. so who it would be possible to do that using store procedure or any other solution.

[kenobewan]

Have you tried select * from tblHospital or do you mean that you need a joint query that access more than one table? What have you tried so far?