June 27, 2008 at 1:08 pm
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
June 27, 2008 at 1:15 pm
Forgot to comment out the code:
<!--
-->
June 27, 2008 at 1:18 pm
Well I guess it won't let me add any XML whatsoever.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply