Home Forums Reporting Services Reporting Services Need help in Building a parameterized Report. RE: Need help in Building a parameterized Report.

  • December 27, 2012 at 6:33 am

    #1571845

    Mac1986 (12/27/2012)

    Thanks Rob..Is there a way to that user selects a date in the top filter and in the respective WQ.WorkQueueRunGroupRunID assigned to that date gets selected in the where clause.????

    I asking this because the results are 100% accurate if we use the Unique Column 'WQ.WorkQueueRunGroupRunID'

    I'm not sure what you're asking, but the WHERE clause I showed you will give you all records with the WorkQueueStartWorkDate between the start and end dates (inclusive). Is the problem because your jobs cross midnight (12am) and span multiple days? If so, just add the time element so that you're only getting the records you're after.

    HTH,

    Rob