none
Stop Multi-Value from Passing Feedline or carriage return. RRS feed

  • Question

  • I have a query that has an In statement.

    I have a parameter that takes multiple values.

    The field is text

    The values can be pasted from Excel, notepad, etc...

    Example values:

    A

    B

    C

    What is passed in the query N 'A',N 'B' N 'C'

    Result: Query times out.

    If N removed manually, query runs fine.

    Is there a way to make Report Builder not pass the line feed?

    Tried: Copying  from Toad directly.

    Copying and pasting into  Notepad, Notepad ++  and then into report.

    Do not expect user to go through hoops to put it into a format that Report Builder can send correctly.

    version:  Report Builder 3.0

    Connection: Oracle

    Friday, October 18, 2019 5:16 PM

All replies

  • Hi,

    How are you using the IN statement in sql query ? 

    You could try:

    1. Adding a hidden parameter B, set it value =JOIN(Paramaters!OriginalPara.value,","). Then, in your query,  use sql split function to this new parameter B.

    or 

    2. Donnot set IN statement in the query, try use filter in the dataset property tabs. Use IN here instead of using it directly in the query.

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, October 21, 2019 2:29 AM