Post reply

Reporting services Parameters

  • June 9, 2008 at 8:31 am

    #192059

    I have created a report but need to pass a parameter to it to filter the data. the parameter is to only display data where a fields value is greater than the value entered in the parameter.

    Thanks in advance

  • June 10, 2008 at 3:57 am

    #826506

    hi,

    You can create parameter in reporting services. I hope you know how to create that. Say u have some date parameter - named it as @startdate and @enddate. when you call or write stored procedure/query, u need to say whatever your date from table is between this dates.

    Please send ur bit code sample and name of parameter.

    regards,

    vijay

  • June 10, 2008 at 3:29 pm

    #826995

    Hi

    Even I am struggling with how to do the validation of the parameters before it could hit the stored procedure. But had no success till now.

    if you are looking for displaying some message when nothing is returned by the stored procedure then you can set the NoRows property of the table.

    Namit

  • June 11, 2008 at 1:46 am

    #827099

    Would eleberate on the question a bit more please?

  • June 12, 2008 at 11:59 am

    #828037

    I did something like what you want, I think. I simply passed a parameter called days and the used a "where" to filter in my select statement.

    where datediff("d",cn.recorddate,cn.createddate) > @days

    In this case I calculate the difference between two date fields in days, and then filter out anything less then or equal to the parameter that is passed. you should be able to easily modify this to fit.

  • June 13, 2008 at 1:56 am

    #828292

    Thanks for the replies

    I have sorted it now

Viewing 6 posts - 1 through 5 (of 5 total)

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