Earlier I was using Access 97 based .mdb database file, DataReport and DataEnvironment to display a Report based on parameterised query, i.e. as per input from user records were displayed in the report. Suppose report was built to show records having "Delhi" in Address field, it was showing.
But now I have modified database file to Access 2007 type .accdb type and want to display a report based on query about City name in Address field so that if user wants to have report about only those records which have "Bangalore" in there Address field, it must get displayed.
How to achieve this, please help me. I don't want to use Crystal Reports. Report may be generated through DataReport and DataEnvironment or direct coding.
My table, suppose, contains fields viz. SNo, Name, Address, PhNo
Please help me with some code also as I am weak in reporting. Database file is Access 2007 type.