The name I'm thinking of (a slang term) could actually be more related to the From clause than the join. Another example would be like this:

Select c.strReceiptNo, d.strName

from dbo.tblControlLog...

Not 10 seconds after I posted this I spotted the problem. If you notice there is a space after the single quote in the Position parameter before the word '...

I knew that....:blush:..Thanks a bunch!

Hope this helps.

SSC Topic Click Here

MSDN Topic Click Here[/url]

Try this:

Month(Parameters!MyDate.Value)

Year(Parameters!MyDate.Value)

Also look at the ReportSchedule table in the ReportServer catalog for your timed subscriptions.

And, if you happen to use one of the 3rd party reporting tools (developed around .net and...

You are definitely not going to see the columns render in HTML. If you're still not seeing them in a pdf then maybe the report width is the problem (although...

Lynn, Thanks for the help and suggestions. I'm hoping what I provide here is adequate.

I have the following sample data. The current code in my previous thread does work as...

This works fine for attendance dates (Infractions) that are within my specified date range, but retains the Amnesty attendance date for Infraction Dates that fall outside that specified range.

How can...

Thanks a bunch Lynn. 😀

Here's the Sample Data:

Current Result Set

guidAttendanceCodeChildrenID guidAssociateAttendanceCodeID AttendanceCode Date

NULL ...

Thanks a bunch for the link. I'll check it out. Cheers.

This is great. I'm assuming the time elements in the ExecutionLog table are in ms, is that correct? And, Where can I go to for a full explanation of all...

I've got the Microsoft books including SQL Server 2005 Analysis Services - Step By Step by Jacobson, Misner, and Hitachi Consulting which is very good but I would also recommend...

I know this should be obvious, but has the Layout Height property of that Row been increased? Click on that Row, then go to Properties and make sure Layout /...