I'm beginning to think that my problem is that the backend database is still at SQL 2005, regardless of the report writer (SSRS). Initially I wrote in the expression what...

geoff5,

This report started it's like as a SSRS 2005 report. I believe I started it with VS 2008 or earlier (can't remember now). I've migrated it to VS 2010, using...

OK, here's another image, with more details, including the menu items from Visual Studio, where I do the development. Hopefully this will show you the tablix you speak of.

[/url]

WPF RFS...

You can actually see the screen shot? I can't.

To answer your question, no the textboxes are not in a list. At least I'm pretty sure they're not in a list....

OK, geoff5, here's a screen capture of the report. I've circled in red, where I've currently got the lookup express. (I hope this works. When it comes to uploading photos...

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.