If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

passing two queries in CR

hi.. i m making a university project on a dental clinic

i have two tables one containing information abt the visits in a dental clinic(tbl_daily_opd) and the other containing the details of the patient(tbl_patient).. tbl_daily_opd contains only the id of the patient.. i m printing tbl_daily_opd in the report with the patient name n id...

i also want to count the number of males and females on a particular date... and how many patients recieved a just medication and now many tooths were extracted(the column 'treatment' in tbl_daily_opd contains this information)..

how do i do this? by passing two queries in CR or is there some option in the expert editor which can accept select queries?

Re: passing two queries in CR

Welcome to CodeGuru forums!

It doesn't accept 2 queries but it allows to link the tables, in this case you may link the tbl_daily_opd table to tbl_patient table using the id of the patient...
once the tables are linked you may use all the fields from each table

* The Perfect Platform for Game Developers: Android
Developing rich, high performance Android games from the ground up is a daunting task. Intel has provided Android developers with a number of tools that can be leveraged by Android game developers.

* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.