Jeffrey Williams-493691 (5/15/2011)

---

LM1 (5/11/2011)

---

You can use the following to convert the date column to the date with a time of midnight:

SELECT DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0) AS DateOnly

(Replace GETDATE() with...

Revenant (12/9/2010)

---

I have to get into meetings for the rest of the day, so I will take a stab based on what I think I know.

I suggest that you add...

Here's my Query for the Matrix tablix :

SELECT WorkDate, TimecardCode, Hours, Amount, Code, ClientName, Inception, YEAR(WorkDate) AS WorkYear, Sub_Code

FROM ...

I asked this question a while back. And the answerrrrrrr is.......

if you click on the yellow area of your design screen, then view the Report Properties. Then scroll down through...

This is what I've done.

1) Created a report with a Matrix object.

2) Adjusted Report Properties to print in landscape on legal. Margins all the way around are .50.

3) When I...

I adjust it in both place, the design view and in print setup.

Here's something that I've done. I have a few Crystal reports that have subreports in them. I was trying to created an SSRS report exactly the same as the Crystal...

We're not on R2. Manager wants to wait until 2010 releases. So for now, trying to find a trick to make this work.

getoffmyfoot (10/1/2010)

---

so what you are after is seeing for a particular row, what percentage that row is of the total?

I think the functionality you are after is you want to...

SWEET!! Thanks! I knew it had to be something minor.