[thelist] MS Reporting Services & Local 'Filter' Files

James Conley Conleyj at kubota-kma.com
Tue Mar 21 11:33:33 CST 2006


Sorry for the late response - I don't know if anyone answered your
question but based upon my work with Reporting Services I don't know of
any easy [nor any complicated] way of achieving that. 

James c

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Luther, Ron
Sent: Tuesday, March 14, 2006 3:34 PM
To: thelist at lists.evolt.org
Subject: [thelist] MS Reporting Services & Local 'Filter' Files

Hola Evolistas,


Not looking for code here.  Looking for a "yeah it's easy", a "nope - it
can't be done", or a "yeah, kinda, but it's really really hard" from
folks more familiar with MS Reporting Services than I am ... (which
pretty much means everybody).

Can you set up a report in MS Reporting Services and let your users
filter the results of that report (either before or after report
execution - I'm not picky on the timing yet) using, as filter values,
the contents of an Excel or Text file stored on their local hard drive?

Example -- Report brings back 12,000 records of Inventory data. 
User wants to only see records involving the 264 part numbers she has
stored in a local Excel file.  [These part numbers do not have a common
'grouping' attribute that is currently stored in the data warehouse.]


Can do?    Can do easily?


Thanks,

RonL.

[This is 'easy' to do using Brio or the 'full client' flavor of Business
Objects.]



More information about the thelist mailing list