This one is for RS 2000, but the majority of it applies to 05. I like this one because it really digs into the inner workings of RS.

Hitchikers Guide to...

My personal opinion would be to use a linking table to hold the employeeID and projectID. This way if an employee doesn't have a project, then there simply wouldn't be...

This seems to work for me. If still getting incorrect results, please post the data that's being calced wrong.

SELECT

    numberOfOrders = COUNT(DISTINCT s0.soNo)

    ,nullShip = SUM(CASE...

An important note. Unless you have a unique/primary key that identifies each unique order line item, any orders with all info the same will cause erronious dups. so if you...

OK, This appears to get what you want. It may not be the most optimized solution though.

/* lets put all of the...

What if the order that was split had one on time and one late. Do you need a result set of 3 orders and 2 onTime? or do you need...

Can you not refer to invShp instead of shpQty?

Can you post the DDL for all tables involved and sample data for them as well?

Read up on WITH ROLLUP in BOL....

User permissions/object owner.

Move the check into the join clause....

SELECT     comment.comment_id, comment.comment, comment.post_id, comment.comment_date, aspnet_Users.UserId, aspnet_Users.UserName,

                      user_pic.user_pic, user_pic.user_pic_default

FROM         comment INNER JOIN

                      aspnet_Users ON comment.userid = aspnet_Users.UserId LEFT OUTER JOIN

                      user_pic ON...

If I understand you correctly, then just remove the "(user_pic.user_pic_default = 'y') AND" from your WHERE clause.

This will return ALL records for the postId regardless of the default value.

What happens when you put http:///ReportServer in a new browser window?

Yeah, I'm just having issues getting around the windows authentication required to "hit" the server.

FYI, we did find a work around though. Since our site's login page is .NET, which...

Ben,

Thanks, but you can't pass windows authenication via the URL, only the DB credentials can be passed that way.