Results 1 to 3 of 3

Thread: select record in data report

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Feb 2009
    Posts
    211

    select record in data report

    hello !
    im new in data report. im using vb6 and ms access. is it possible that you create a query where in you are going to select which record will be shown in data report then print on runtime. im making a barcode system, barcode number is my primary key.

  2. #2
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: select record in data report

    Yes you can change the sql source of your report's DataSource. In the sample attached below you can use

    Code:
    SELECT ID,a,b,c,d FROM test WHERE ID = 51
    Attached Files Attached Files
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  3. #3
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: select record in data report

    Moved To Reporting

Posting Permissions

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



Click Here to Expand Forum to Full Width