Defining a time period parameter.

• hayess-788389

  SSC Journeyman

  Points: 91

  More actions

  June 27, 2008 at 1:08 pm

  #189867

  Hey Guys and Gals,

  I've created a few reports that prompt with a date time parameter when running the report. I'd like to allow subscriptions, but I can't use this parameter because it requires a date entry. I'm pretty sure I need to create a new report with the time period parameter so it can use today, weekly or monthly instead of a user entered date. Here's the query in XML for the existing:

  Select u.Usetime, a.AccessCode, a.Name, u.VisualID

  From Usage u inner join AccessCodes a

  On u.AccessCode = a.AccessCode

  where (a.AccessCode < '28') AND (u.VisualID Like '%251______%') AND (u.Usetime > @rdate) AND (u.Usetime < @rdate + 1)

  Order By u.VisualID ASC

  Any direction on how to proceed would be greatly appreciated.

  Thanks

• hayess-788389

  SSC Journeyman

  Points: 91

  More actions

  June 27, 2008 at 1:15 pm

  #835598

  Forgot to comment out the code:

  <!--

  -->

• hayess-788389

  SSC Journeyman

  Points: 91

  More actions

  June 27, 2008 at 1:18 pm

  #835601

  Well I guess it won't let me add any XML whatsoever.