Post reply

Search Box in ssrs

  • September 19, 2013 at 8:16 pm

    #280003

    Helo Everyone,

    i have some wierd requirement i need a search box in ssrs i have all databases name in a table if i search like %ST%

    it should display all databases that has st in it testDB,TwistDB etc...

    please let me know if u have any idea how to do this.

    Thanks,

    A

  • September 20, 2013 at 6:52 am

    #1651894

    If I understand what you are asking, you want to have a parameter that allows you to search by only a portion of a value, as opposed to entering a full value.

    1. Create a parameter (this will be your search box)

    2. Right click on the Data set under Report Data on the left side of BIDS and select Dataset Properties.

    3. Choose Parameters

    4. Edit the Parameter value (this is your search box) by click on the fx on the right side.

    5. Enter ="%" & Parameters!YourParam.Value & "%" replacing "YourParam" with the actual parameter name.

    6. In the Query Designer add LIKE @YourParam to the filter for the column you are looking to search in.

    If I misunderstood what you have asked, my apologies. 🙂

  • September 20, 2013 at 7:10 am

    #1651905

    If you dont mind can i get a clear picture what should i do with this below statement

    5. Enter ="%" & Parameters!YourParam.Value & "%" replacing "YourParam" with the actual parameter name.

    6. In the Query Designer add LIKE @YourParam to the filter for the column you are looking to search in.

    5--> let say i have parameter name @dbserach

    so what should i write

    6--> where dbname like @dbsearch is this correct

    sorry i am new to this

  • September 20, 2013 at 7:23 am

    #1651917

    And if possible how to create search box using this parameter with placeholder

    sorry asking u 2 much help

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply