Can you post a really brief description of what you're modeling and your table definitions on the part you're having trouble with? (start with only maybe two or three...

"You can get the job on the basis on your SQL certificate"... depends a lot on how big the pool of available SQL developers is in your area, I guess....

In the 2008 version, there's a whole chapter on Customizing Security.

Thanks SQLBuddy! Way to live up to your moniker! I'll check them out.

Are there any good tutorials online anywhere? I guess I'll see if there's anything on the MS website... or PragmaticWorks.

Okay, I'll have a look.

Pieter

Are you trying to create a crosstab of some type? Or are you trying to create something that looks like labels? Both are reasonably easy in SSRS.

You can...

Right-click on the CustomerName...

Grasshopper,

There's a really good article on referring to controls and their properties on the dying website AccessWeb, which is here: http://www.mvps.org/access. Look for an article by Keri Hardwick. ...

The usual way to do something like that is to do an outer join to the destination table and only insert the values that don't exist there already.

Good points... good to hear I'm just behind on the learning curve... and not just headed off in the wrong direction.

Silly me. Didn't even think of using a trace! Schooled again!

This might help.

http://sqlfool.com/2009/08/find-recently-executed-stored-procedures/

But you could also do something simple like creating a simple logging table (ObjectName, ExecuteDate) and then create another stored procedure to do the insert...

CREATE PROCEDURE

uspLogSprocExecution(

@ObjName)

AS

BEGIN

SET NOCOUNT...

Oh, I see now... pity, because as I said, it's simple in SSRS. Did it in about 30 seconds. Normally, you do all the formatting in the front end...

David,

This was really easy in SSRS. Here are the steps:

1. Add a tablix to the report canvas (or whatever it's called).

2. Add Order Qty and Bin Qty to the...