Hey Doug, putting the parameter in the main report did the trick. Thanks a lot for the reply!!

OK, when I view the datasets window and identify one of the fields I wish to show in the tablix, then drop it in the intended column, it doesn't have...

Hi higgim,

I put a tablix on the report so that it is isolated from anything else. There is no grouping set up. When I attempt to fill one...

djj, that's a good idea. I will likely make views for my novice users.

Thanks,

Hey [Evil] Craig, sorry for the delay in responding. I didn't check back on this thread after making my final argument. I agree with the AD approach, but...

OK, I finally got it working. This page was invaluable:

http://www.mssqltips.com/sqlservertip/2844/working-with-multiselect-parameters-for-ssrs-reports/

I changed the type of the parameter to text. Then I removed the filter on the detail...

MyDoggieJessie, that sounds like a very cool idea. I will recommend this. Thanks for the reply!

Hi MyDoggieJessie,

The data analysts in question probably will be overwhelmed by SSMS. That's why I was trying to obtain access to the database via ODBC/MS Access. Otherwise, it...

Hi MyDoggieJessie and humbleDBA, I appreciate the replies. My goal is to enable a group of about 4 people to view data via ODBC from a government database, which...

The typical problem with using a specific user account is that network admins often require a password change every X days. That would mean you have to change it...

Are you using a Data Flow Task? Or, a Script Task?

Where I wrote:

"I haven't been able to get the job to call a SSIS package that calls the batch file (using an Execute Process task) under the Service Account credentials....

I have found that with conditional processing, a sequence container is pretty nifty. The sequence container produces a single result (i.e., success or fail) instead of each task having...

Getting a package to work as well as a job as it does in BIDS is one of the most common and frustrating challenges SSIS developers experience. Often, a...

I would keep all the insert/update/delete logic possible in a single stored procedure, and just have SSIS call the procedure. This minimizes the number of connections the package makes...