oops.. i thought you using hospital system.
in this case you need to know the information that saved in your system (e.g.: PxMRN, DateDiagnose, Results, etc.).
after you find out those information than you can work inside CR.
in order to get a result that you want you need to put create some parameters (as you request, date range,etc.).
to create a params:
1. click 'View' menu
2. click 'Field Explorer'
you will find some Main information for the fields.
one of them is 'Parameter Fields'.
3. right click on 'Parameter Fields'
4. select 'New'
5. type parameter name (DateFrom, DateTo --> create it separately)
where the Type is 'Date'.
6. click 'Ok'
steps to create selection record:
1. click on menu Report - Selection Formula - Record
it will appear a window for 'Formula Workshop'.
2. in here you can type the filter as below.
{tbl.servicedate}>={?DateFrom} and {tbl.servicedate}<={?DateTo}
3. close & save
and run the report by pressing F5.
the report will prompt you for the date.
till here you know how to create params in CR and filter your report based on the params.
Other option, if you know the SQL command to run the report then you can type those SQL command in CR.
e.g.:
select PxMRNo, DateSrvce, PxDiagnose, PxNote from PxResultTable
where DateSrvce>=('2010-04-01') and DateSrvce<=('2010/04/30')
hope it help.
IP Logged
