Results 1 to 6 of 6

Thread: Filter reports by date

  1. Jan 8th, 2009, 09:04 AM #1
    Zainab
    Zainab is offline

    Thread Starter
    Member
    Join Date
    Jul 2006
    Posts
    49

    Filter reports by date

    Hi,
    Im using DataEnvironment to create reports. Ive used command named DailySales_Grouping which is grouped by Bill Number. The following is the code to filter data is placed in the cmdShowReport click event. The problem is that it displays error saying Failed getting rowset from the current datasource. Could someone help me with this?

    Code:
      DataEnvironment1.rsDailySales_Grouping.Filter = "Date = " & frmInvoice.lblDate.Caption & ""
  rptDailySales.Refresh
  If rptDailySales.Visible = False Then rptDailySales.Show
    Reply With Quote Reply With Quote
  2. Jan 8th, 2009, 09:18 AM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Filter reports by date

    If your database is Access then could you try this?
    Code:
    DataEnvironment1.rsDailySales_Grouping.Filter = "Date = #" & frmInvoice.lblDate.Caption & "#"
    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
    Reply With Quote Reply With Quote
  3. Jan 8th, 2009, 09:45 AM #3
    Zainab
    Zainab is offline

    Thread Starter
    Member
    Join Date
    Jul 2006
    Posts
    49

    Re: Filter reports by date

    No its still not working.
    Reply With Quote Reply With Quote
  4. Jan 8th, 2009, 09:47 AM #4
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Filter reports by date

    Does it still raise the error?
    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
    Reply With Quote Reply With Quote
  6. Jan 8th, 2009, 10:00 AM #5
    Zainab
    Zainab is offline

    Thread Starter
    Member
    Join Date
    Jul 2006
    Posts
    49

    Re: Filter reports by date

    Yes it gives the same error.
    Reply With Quote Reply With Quote
  7. Jan 9th, 2009, 03:51 PM #6
    wes4dbt
    wes4dbt is offline
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,513

    Re: Filter reports by date

    See what happens when you try this,
    Code:
    msgbox frmInvoice.lblDate.Caption
    It looks like the code in post 2 should work.
    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