I am having a problem with the Crystal Reports viewer in vb.net 2003. I have conditionally formatted the details section of the report in the built-in report designer using parameter values that the user is prompted for (a date range). I'm trying to get records to show that are only in that date range, but it is showing all of them instead. I am grabbing data from a MySQL 5 table. Here is the relevant report-loading code:

VB Code:
  1. Imports CrystalDecisions.CrystalReports.Engine
  2. Imports CrystalDecisions.Shared
  3. Imports MySql.Data.MySqlClient
  4. Imports System.Data
  5.  
  6. Public Class fclsShowReport
  7.     Inherits System.Windows.Forms.Form
  8.  
  9. #Region " Windows Form Designer generated code "
  10. <code cut>
  11. #End Region
  12.  
  13.     Public conn As New MySqlConnection
  14.     Public comm As New MySqlCommand
  15.     Public da As New MySqlDataAdapter
  16.     Public dtcustomerinfo As New DataTable
  17.     Public dtaccountinfo As New DataTable
  18.     Public dstransactioninfo As New DataSet
  19.     Public rowindexdtcustomerinfo As New Double
  20.     Public rowindexdtaccountinfo As New Double
  21.     Public rowindexdttransactioninfo As New Double
  22.     Dim myReport As New ReportDocument
  23.     Public SQL As String
  24.  
  25.     Private Sub fclsShowReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
  26.         crViewer.Width = fclsShowReport.ActiveForm.Width - 10
  27.         crViewer.Height = fclsShowReport.ActiveForm.Height - 10
  28.         SQL = "SELECT AccountNumber,Description,Amount,Date,customerinfo.CustID,TransactionNumber,LastName,FirstName FROM CustomerInfo INNER JOIN Transactions ON CustomerInfo.CustID = Transactions.CustID"
  29.         conn.ConnectionString = "server=localhost;user id=root;password=;database=finance_records"
  30.         Try
  31.             conn.Open()
  32.             comm.CommandText = SQL
  33.             comm.Connection = conn
  34.  
  35.             da.SelectCommand = comm
  36.             da.Fill(dstransactioninfo)
  37.  
  38.             myReport.Load("..\CustomerStatement.rpt")
  39.             myReport.SetDataSource(dstransactioninfo)
  40.             crViewer.ReportSource = myReport
  41.         Catch ex As Exception
  42.             MessageBox.Show(ex.Message, "Report could not be created", MessageBoxButtons.OK, MessageBoxIcon.Error)
  43.         End Try
  44.     End Sub
  45.  
  46.     Private Sub fclsShowReport_Resize(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Resize
  47.         crViewer.Width = fclsShowReport.ActiveForm.Width - 10
  48.         crViewer.Height = fclsShowReport.ActiveForm.Height - 10
  49.     End Sub
  50.  
  51. End Class

The formula I placed into the conditional suppress section of the details section is this:
{Table.Date} < {?BeginningDate} AND {Table.Date} > {?EndingDate}

If any additional information is required, I would be happy to oblige.

Thanks in advance.