SSRS 3.0 Parameters input issue

  • Hi all,

    I am building a report that will make a comparison with figures for the last 3 months, and last 12 months. For this I will build 3 datasets with the exact same structure, with the difference that I need each one of them the data will be different.

    The way I am trying to do it is to go to a specific dataset and on the parameters tab choose the parameter and do as example below:

    =Parameters!Period.Value-3

    The parameter above would be for the dataset that needs to show the figures for the last quarter, the period field is an integer and every month as a number attached, so I figured that if for this specific dataset in the parameters tab there is an instruction for the parameter in the expression it should work...

    It doesn't, anyone has a suggestion for this?

    Best regards,

    Daniel

  • It should work, can you check in dataset how is parameter mapped.

    Regards
    Durai Nagarajan

  • durai nagarajan (8/19/2013)


    It should work, can you check in dataset how is parameter mapped.

    Hi Durai, not sure what you are asking could you be more specific?

    Many thanks,

    Daniel

  • in dataset check what is showing in parameter section and see the mapping

    you may get the problem.

    and what is the exact error you are getting.

    Regards
    Durai Nagarajan

  • Well still not sure what you mean about parameter mapping...

    See below the error message:

    An error has occurred during report processing. (rsProcessingAborted)

    The Value expression for the query parameter ‘@Period’ contains an error: Operator '-' is not defined for type 'Object()' and type 'Integer'. (rsRuntimeErrorInExpression)

  • [quote-0The way I am trying to do it is to go to a specific dataset and on the parameters tab choose the parameter and do as example below:

    =Parameters!Period.Value-3

    [/quote-0]

    This is where i am referring to and see the attached image for usage

    Regards
    Durai Nagarajan

  • Hi Durai, got it see below:

    Parameter name: @Period

    Parameter Value: =Parameters!Period.Value - 3

    Thanks,

    Daniel

  • This is what i have tried it is working, can you delete the dataset and create again.

    Regards
    Durai Nagarajan

  • Hi Durai,

    I recreated but still not working, let me just recapitulate to se if I didn't left nothing out that might help on the solution for this issue:

    Purpose of report: comparing current results against last result 3 months ago

    Nbr of datasets: two datasets

    Nbr of parameters: one (each month is represented by a integer number, for example July, 2013 is 273)

    How to: The intention is to have the parameter mapped to one of the datasets changed through an expression (=Parameters!Period.Value -3) the other dataset will have the parameter mapping unchanged (=Parameters!Period.Value)

    Best regards,

    Daniel

  • If it is not working take the same parameter and map it to a variable inside the dataset and minus it by 3 , really amusing it works perfect for me but trying it out in 2005 ssrs..

    Regards
    Durai Nagarajan

  • Hi guys,

    Still not working, any other suggestion?

    Many thanks,

    Daniel

  • I think you are missing something can u have the parameters printed in a textbox and see whether it is as per you requirement or not.

    Regards
    Durai Nagarajan

  • Daniel,

    Check if Parameter!i.value an integer. if it is a text it will take integer values but will error out on calculations.

  • Hi Durai,

    Sorry for not answering, it is working now, many thanks for your support.

    Best regards,

    Daniel

Viewing 14 posts - 1 through 13 (of 13 total)

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