none
Doud about how to use a parameter in a Dataset RRS feed

  • Question

  • Hi I hope someone can help me.

    I need to implement a parameter in a dataset, I had already made the parameter (@Comp) this contents 3 numbers as values,

    I try to use it in a sentence like this 

    ......

     'XXX.dbo.'@Comp'_Table_X'

    .....

    but

    But the system says: Invalid object name  'XXX.dbo.'@Comp'_Table_X'

    Thanks in advance.

    Wednesday, November 13, 2019 11:22 PM

All replies

  • Hi Luis,

    Could you provide more clear sample code?
    You could show us you grammar with AdventureWorks Database. Also the quota notation should be clear  as exactly how you have set them.

     

    Still, I highly recommend to go through the tutorial here for using parameter in SSRS dataset. Tutorial: Add a Parameter to Your Report (Report Builder). After reading this , you would get a much better view and practice for ssrs parameters.

    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.

    Thursday, November 14, 2019 7:22 AM