Now there's a nifty piece of code I need to book mark. Thanks, toolman!

Matt,

Part of my problem was that I was using a dynamic SQL string to create a PIVOT of the totals to get my group totals for the subreport. I've...

Matt,

You're da bomb! Thanks, that worked perfectly.

Don't know what I'd ever do without you. @=)

Dave,

90%? Depends. How comfortable do you actually feel with the material? Do you think you could pass the exam, no distractions, without having a copy of BOL...

Question on the insurance issue. Are you guys just talking about health insurance or other kinds of insurance?

What if you're a FTE someplace else (with health insurance) and doing...

Matt,

Yes, I did put the subreport in the group footer, and ended up getting all total lines on each individual group.

I'm going back to the end users to see if...

Adding to what George said, if you have the SA pwd, then you definitely have the ability to back up your own databases. I would assume the MAS people...

I'm going to have to get back to you on the "permit in database role" stuff for SA, but I wanted to mention something to you about your last post.

If...

I did actually have the subreport parameterized, but maybe I set it up wrong. Thanks, Matt. I'll look into it.

What it means is they've packaged their datafixes in an .msi or something similar which has the SA account hardcoded into it and it just prompts for a password.

I've seen...

Matt,

I'm not sure Rollup is going to work with this. The detail takes the PaidAmt and divides it by #Claims. I'm not quite sure what the load process...

I'm thinking about this report and-ideally-here's what I'd like to do.

Have 2 datasets. DataSet1 is the detail. DataSet2 is the totals.

Write some sort of expression or code where...

You also need to discuss with your contractee how often you plan to invoice them and how long they have to pay you. This is VERY IMPORTANT. If...

Unfortunately, you can't just not use SQL Server every day. You have to make time. Schedule yourself during lunch or an hour before / after work and use...

Jack & Matt,

You were both right. Non-numeric empty string that I couldn't fix on the query side. Had to mask it in the report.

Thanks to both of you...