Results 1 to 4 of 4

Thread: Datareport problem

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2002
    Posts
    179

    Datareport problem

    Hii

    I would like to get a daily report on the Date that I select from 2 different tables. I have attached a zip file that has the Database and an HTML file of the dailyreport that im getting when i tried, and an excel sheet the way I want to have the report.
    When I print a report I get it in the way, I have attached the dailyreport.
    How can I eliminate repeating of records.
    how should i work with it and how should i group the records...?
    Attached Files Attached Files

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

    Re: Datareport problem

    Moved to reporting section.

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

    Re: Datareport problem

    Haven't looked into your attachment but you can try using DISTINCT to remove repeating records...
    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

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Aug 2002
    Posts
    179

    Re: Datareport problem

    i tried with distinct command but thats also not working..
    could you pls look into the attachments and let me know what is going wrong.

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