Skip to Content
avatar image
Former Member

Problems with List Of Values ​​in Crystal Reports 2013

I have the following problem in Crystal Reports 2013, I'm trying to create a parameter with List Of Values, on the list of cities and do not want to leave the securities or cities starting with the letter "B". and do not like to do with this; I've already made filters on the same field and still keep coming out all values. someone could help me.

LOV.png (39.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 16, 2014 at 03:09 PM

    Hi Roger,

    Do you mean to say that you do don't want the LOV to show cities that start with the letter 'B'?

    If yes, then you'd need to create a SQL Query with the distinct clause that returns all cities except the ones that start with 'B'.

    You can then add this SQL Query as a Command Object in the report (make sure you DO NOT join this sql to the existing tables) and point the parameter to the field in this command object.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded