Results 1 to 3 of 3

Thread: Crystal record selection

  1. Nov 24th, 2008, 09:04 AM #1
    EyeTalion
    EyeTalion is offline

    Thread Starter
    Frenzied Member EyeTalion's Avatar
    Join Date
    Jul 2000
    Location
    New York
    Posts
    1,075

    Crystal record selection

    I'm trying to filter my search using a LIKE clause, but it's bouncing back a err msg that a string is required. Any suggestions?

    Code:
    rpt.DataDefinition.RecordSelectionFormula = "{tcts_twy_part_numbers.twy_part_no} LIKE '%" & 
gPartNoSearchValue & "%'"
    Last edited by Hack; Nov 24th, 2008 at 01:26 PM.
    It's tough being an unhandled exception...

    ___________
    VB.NET 2008
    VB.NET 2010
    ORACLE 11g
    CRYSTAL 11
    Reply With Quote Reply With Quote
  2. Nov 24th, 2008, 01:27 PM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Crystal record selection

    Moved To Reporting
    Reply With Quote Reply With Quote
  3. Nov 24th, 2008, 02:04 PM #3
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Crystal record selection

    When editing the rpt in the Crystal Reports ide, try using the expert to define a Record Selection Formula
    Just to see how it is build then delete it
    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