Results 1 to 2 of 2

Thread: [RESOLVED] Parameterised Report with Access 2007

  1. Oct 21st, 2012, 07:40 AM #1
    Smartchap
    Smartchap is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2009
    Posts
    98

    Resolved [RESOLVED] Parameterised Report with Access 2007

    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.
    Thanks.
    Reply With Quote Reply With Quote
  2. Oct 23rd, 2012, 01:38 PM #2
    wes4dbt
    wes4dbt is offline
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,509

    Re: Parameterised Report with Access 2007

    What are you having trouble with? Creating the dataenvironment, the datareport, setting the parameters?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width