Hi geoff5,

Thank you very much for your help. Because of it, I'm making progress. I've done as your suggested, using the code that you specified. (Fields!Gender.Value happens to be the...

OK, I'm tryihng to use the Lookup() function. Here's what I've got in the expression:

=Lookup(First(Fields!Gender.Value, "RfsDataSet"), First(Fields!Gender.Value, "GenderDataSet"), First(Fields!GenderDesc.Value, "GenderDataSet"), "GenderDataSet")

When I compile the application I get the following error...

Although the lookup table is in the same database, so modifying the query would be easily done, I think I'll try using the Lookup() function. I could use the experience...

As an accidental DBA myself, I give your comments a hearty "Here! Here!", Steve.

I just encountered this error, and am now downloading 2008 R2 SP1, to apply in hopes that it resolves this problem.

Michael Valentine Jones (6/5/2013)

---

SQL server CALs are not for concurrent users.

You need a CAL for each user or client that accesses SQL Server either directly or indirectly via a middle...

I enjoyed this article, Steve, thanks for writing it and pointing to the "joy of being a programmer" blog article. Programming is my first job responsibility, and being a DBA...

Interesting article. As someone whose possibly facing a change, and considering doing more DBA activities, I learned from what you've said here, Hilda, thanks.

We are looking to upgrade, but that's because we're still at SQL 2005. However, I'm interested in how this discussion goes, so will watch people's answers.

I work primarily as a developer, so I prefer a quiet office. I've worked, as a developer, in an open office, but that tended to be too distracting.

I've just checked, and there is no ExecutionLog2 table in my ReportServer database. There is an ExecutionLog table there, though, and so I checked that out. I ran the report...

That's a good question, and I don't know the answer to it. I'm not familiar with ExecutionLog2, but will look it up.

Good question, Jack, yes I have tried running IE as an Administrator. I and tried it running the 32-bit version on his machine as well. (He has a 64-bit Windows...

I'd like to add more to what I just said. For years we've been running Windows XP Pro on all users' desktops. This year we're transitioning to Windows 7 Pro....

Hi Jack,

Other users are experiencing the same problem.