To refer to other report items such as text boxes use...

=ReportItems!textBox1.value

This is another classic example of how a "tally" or "numbers" table can be used. We'll see if Jeff's around 😀

First, if you haven't create a numbers/tally table you'll need...

I've tested this as best I could without sample data, but all that your really doing here is saying that if the @period is 'A' for Academic and the month...

Can you provide the DDL (create scripts) for the tables, or at least the relevant columns and their datatypes. Sample data would be nice too. 😉

Thanks Jeff! I've never worked with Oracle so that info was very informative ... :hehe:

I haven't tried this but, just found it...http://www.data-for-all.com/blog/index.php?p=119

(from Ken's suggestion)

:w00t: I missed that little Oracle reference.

Try this: (moving your MAX statement inside the CASE)

SELECT

CASE WHEN MAX(somedate) IS NULL THEN GETDATE() ELSE somedate END AS...

I don't think you need to use CASE at all.

SELECT

ISNULL(MAX(somedate),GETDATE()) AS somedate

FROM trydates

WHERE somedate < (GETDATE()-4)

Opus,

You'll have to modify this to fit your needs, but this should get you there.

DECLARE @studInfo TABLE (student VARCHAR(10), period CHAR(2), absents INT)

INSERT @studInfo

SELECT 'Student1', '2A',...

NICE noeld

Right, but what we're saying here...

Why are you passing a '' to an INT parameter in the first place?

OK, I'm having a BAD DAY here... LOL

I need to slow down and read what I type .. 😀

CREATE PROCEDURE Test

@employee int = NULL

AS

SELECT * FROM Employees

WHERE EmployeeID = @Employee...

OOPS, my fault.:w00t:

You ARE right. I hadn't changed the '' to 0. :hehe:

change the code to ...

CREATE PROCEDURE Test

@employee int = NULL

AS

SELECT * FROM Employees

WHERE EmployeeID = @Employee or ISNULL(@Employee,...

I disagree, in my example if you pass a zero, then...