RE: Reporting Period validatetion

• Trybbe

  Hall of Fame

  Points: 3967

  More actions

  June 22, 2009 at 6:46 am

  #207189

  Hi

  Please I assist, My report has two parameters (StartPeriod and EndPeriod). How do I make sure that the user does not select the EndPeriod that's less than StartPeriod.

  Is there a way I can raise an error to provide a user friendly message?

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  June 22, 2009 at 9:46 am

  #1013407

  Suggest you examine the T-SQL function DATEDIFF in Books On Line (BOL)

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5cb7105e-c68b-43c2-ab2d-80e525526e27.htm

  Here is a very, very simple bit of T-SQL that will demonstrate the use of the function

  DECLARE @StartDate as DATETIME

  DECLARE @EndDate as DATETIME

  SET @StartDate ='6/20/2009'

  SET @EndDate = '6/02/2009'

  IF DATEDIFF(day,@StartDate,@EndDate) <=0

  BEGIN

  PRINT 'Invalid dates'

  END

  ELSE

  PRINT 'Valid dates'

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• Sneh Agrawal

  Right there with Babe

  Points: 770

  More actions

  June 23, 2009 at 4:01 pm

  #1014326

  1. Create a hidden parameter(for eg @Flag).

  2. Set the Falg value based on the SQL mentioned above. Set the Flag to 1 if start date > end date. 0 if start date < end date

  3. Create a text box with the Error Message. Place the textbox on the top of the report.

  4. Set the visibility property of main report table to: If flag=1 then hidden else visible

  5. Set the visibility property of textox to : If flag=1 then visible else hidden.