• Briceston (10/29/2013)


    Hi,

    I have a SSRS report with four parameters,and I want to be able to enter information for two of the parameters and run the report opposed to all four of them. However, when I select allow blanks and only select the parameters that I want to run the report by, the report comes back blank

    Essentially, I want to be able to the run report by different parameters without having to enter information for all parameters at the same time.

    What is the correct way of going about this?

    Thanks!

    Please post the query for the dataset. If the report executes then the parameters are allowing blanks / nulls. Usually something like :

    Select ...

    From ....

    Where Colour = @Colour

    If @Colour allows blanks then only rows with blank '' will match.

    Try:

    Select ...

    From ....

    Where Colour = @Colour or @Colour = ''

    Fitz