Crystal Report 8.5

vb6 Brazil
  • 18 years ago

    Hi,


    I have a form with two DTPickers and i'd like to use them to filter my query and show it using a Crystal Report. I already designed the report and it works fine, but when i try the filter, it keeps showing all the records (up to 200) - and i'm sure the interval has only a few records (5)


    This is what i'm trying:

    Code:

           wsql = "{ado.Inicio} IN Date(" & _
               Format(DTVIncioDE.Value, "YYYY,MM,DD") & _
               ") TO Date(" & _
               Format(DTInicioAte.Value, "YYYY,MM,DD") & ")"
       With FrmCREDetalhadaCli 'auto generated Crystal Report Preview form
           creDetalhadaCli.RecordSelectionFormula = wsql
           .Show vbModal
       End With



    Thank u very much,
    Dirso

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Walking on water and developing software from a specification are easy if both are frozen.” - Edward V Berard