I work in a small shop (just 2 of us), and so having direct access to tables & views is SOP. Sorry.

I agree with you, JJ, that education people should have an exposure to programming, but not necessarily a high level of proficiency at it. It's somewhat analogous to elective courses...

I agree with this article. It seems obvious to me (I am a developer first, DBA second), but the linked to article pointed out things I didn't think of. For...

OK, I've added our Domain Users group to the logins for SQL 2008 R2 Express on my PC. It's server role is public. Domain User's default database is the database...

Hi Lowell,

Thank you for your reply. So are you suggesting I go with option 2, use a SQL user instead of integrated security?

I thought that performing a refresh would cause the dataset to update, so that's what I tried. It seemed to include the GenderDesc column, but it left the old Gender...

I've performed the left join to the Gender table in the stored procedure. It works fine. But for some reason the SSRS report refuses to see the change in the...

Yes, geoff5, I agree with you. Since we're currently at SQL 2005, I'm going to have to change the stored procedure.

Well, I've done that, but for some reason the RDLC...

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...