You could always just add a column to the addresses table to indicate what type it is (home or work). Then you would just write a case statement to...

Kazmerelda (12/2/2016)

---

So I currently have it so that if the date is the current month, then a red line goes around the column within the matrix report that I have.

What...

" However if I want domain user testdomain/testuser to have access that has been user within the entire database for that user " ???

You can create users and groups in...

You'd have to do something in your stored procedure.

Here's an example of getting all the invoices with fewer than 3 line items:

SELECT i.InvoiceID

FROM Sales.Invoices i INNER JOIN Sales.InvoiceLines il

ON i.InvoiceID...

Okay... rereading this... A Calendar table won't necessarily work. I think this will only work if you know what month all of the absents occurred in. If you can't...

Please do everyone a favor and read this article Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Saying please and thank you without actually listening...

Oh, I get it... you're trying to do the matrix as a crosstab or whatever inside SQL instead of doing it in SSRS. Doing it in SSRS is really...

Maybe I'm missing something, but if you have a bunch of events over a span of time, you could have EventType on columns, Months on rows, and then a count...

I modified the code to make sure it would work... so this is a little different than the last version. Should work with strings of any length as long as...

Sorry, but I beg to differ on your formula... How about

=Right(User!UserID,InStr(User!UserID,"\",CompareMethod.Text)-1)

I'm not sure where you got the value of 10 from... maybe the length of your servername?

As to where...

Some sample data to play with would help a LOT.

One way of doing it is this:

SELECT 100 As Amount, 'AB' AS CustomerID

UNION ALL

SELECT 200 , 'CD'

UNION ALL

SELECT 300, 'BB'

then folks...

I have a stored procedure that returns records by a patient's location in the hospital. I want to be able to return all records EXCEPT those in location = C3....

Without more details, it's hard to know what the right tool is for the job. The flexible part sounds a bit like it could be done in PowerPivot, but...

Or SSAS and Excel?

I'm sure people here can solve the problem. Like I said before, this is a classic Database 101 assignment. The point is for YOU to do it and make mistakes...