Post reply

Searching in Parameters

  • April 14, 2016 at 9:29 am

    #325643

    Hello,

    How do I search for a word that starts with a specific letter in a parameter within a matrix report using SSRS 2012? My parameter works if I type out the full word.

    For example I have this as my data.

    B00055

    B00060

    B00065

    C00100

    C00200

    D00001

    D00002

    D00003

    If I type D00003 in my parameter I will get the record D00003 which is good but I want to be able to type out "D" and get all three records that start with "D".

    Any ideas? I figured it would be "D*" like in Access but it gives me a blank report.

    DP

  • April 14, 2016 at 9:46 am

    #1872047

    Duplicate post, continue here: http://www.sqlservercentral.com/Forums/Topic1777814-2799-1.aspx

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 1 (of 1 total)

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