Custom Code for DateTime comparison In SQL Reporting Services 2005

NinjaDragonfly — Wed, 16 Sep 2009 19:32:08 GMT

Hello Folks!

For the first time I need to create a bit of custom code for a report and can not quiet get it all toghether, so I am asking the folks smarter then me, i.e. you.

I have need to compare the system datetime to an existing datetime (time_due) in a table I am using for a report to tell if the "time_due" is "overdue". I do have a dataset that gives me the system datetime, apparently the simplest part of the task. But as to the correct custom code I'm lost. I have queried online for guidence but haven't quiet found something that works, and so confusing myself.

Any suggestions and guidence will be greatly appriciated!!

Karen (aka NinjaDragonfly)

Re: Reporting Services User Defined Ad Hoc Reports

geoff5 — Tue, 19 May 2009 01:45:30 GMT

I just joined this community moments ago, but I have some experience with Reporting Services, and I've done several with user-supplied parameters like you are trying to do. It is quite easy to add a parameter to the Data Source query. All you have to do is add a T-SQL variable to the query statement, generally in the WHERE clause. SSRS will recognize that it needs a value to fill the parameter, and it will generate a prompt at the top of the report output page to capture the user input. It defaults to a data type of text generally, but you can further define what data type you want, and you can even provide a default value. All you have to do is go to the Report > Report Parameters menu option while you are on the Layout tab. For example you could have as part of your query: WHERE [table].YearColumn = @ReportYear Then using the Report Parameters option you can define Year as an integer value and even define the default value of @ReportYear as year(getdate()) to always default to the current year. This is the easiest way to define parameters. Hope this helps, Geoff

Search results matching tag 'Reporting Services'

Custom Code for DateTime comparison In SQL Reporting Services 2005

Re: Reporting Services User Defined Ad Hoc Reports