Results 1 to 3 of 3

Thread: Crystal Rpts setting selection

  1. #1

    Thread Starter
    Junior Member
    Join Date
    May 1999
    Location
    Duluth
    Posts
    16

    Post

    Hi

    I was wondering if anyone knows the proper syntax to set the selection formuala in VB6. I tried it in the crystal control as follows:
    {Query.WATER_TIMBER} = "W" and I also tried to set it in my code which is my ultimate goal. However when I do this my report does not display which I am assuming means that the formula is wrong because it works fine with out it. I also tried setting parameters to get the proper selection and that does not want to work either so I think i have a simple syntax prob. Thanks for the reply

    Rings

  2. #2
    Member
    Join Date
    Feb 1999
    Location
    Lexington,kentucky,USA
    Posts
    61

    Post

    crystalreport1.selectionformula="{query.Water_timber}='W'"


    I hope this helps

  3. #3
    Member
    Join Date
    Feb 1999
    Location
    Lexington,kentucky,USA
    Posts
    61

    Post

    Just making sure:

    There is a quote before and after W.

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