Ho Sean & Lowell, updated my post - hope you will now understand what I am asking ?

Thanks

Thanks Bhuvnesh, after reading http://technet.microsoft.com/en-us/magazine/2008.11.sql.aspx?pr=blog, I realized that both Change Tracking and Change Data Capture suck.

Will rather use Trigger to collect changes to certain column/s in a...

Thanks Gail, created thread 'SQL 2008 R2 - CDC or Trigger'

Both a trigger and cdc (change data capture) can be enabled to monitor changes to a table. When would you use each of them ?

Both (ServerA - SQL Report Server + database) and (ServerB - SQL Cluster) have kerberos enabled.

Clients PC's connect to ServerA to run SQL Reports.

ServerA Report opens SQL stored...

Thanks Henrico. Already checked the URL's you posted.

4. Secure Store Proxy with Generated Key:

Configure the Secure Store Service (SharePoint Server 2010) -

http://technet.microsoft.com/en-us/library/ee806866.aspx

Thanks Lynn, as always your'e very Sharp (in fact sharper than C#), hmmm.

I require quick reply to my post, so I thought posting in Sharepoint and SSAS forums will do...

Thanks, will give it a try. Most reports have 5 logos (images), one for each department, so if finance user selects finance parameter (department), the finance logo is displayed, if...

Hi Paul, thanks for your quick response. Must admit, your method is much simpler. (wish I had your SQL knowledge).

The query is used as a filter - to remove all...

ramadesai108:

Is it possible to have a GROUP BY CLAUSE on only some selected fields, For example:

--------------------------

if col3 has an aggregrate (sum, count, etc.), and the rest don't, then the rest...

Hi Daniel Bowlin, I just updated my previous post.

Regards.

You can either have multi-select parameter or null, not both.

if using multi-select parameter and any agency_name and agency_id is null,

it wont display the record, so your best bet is...

You can add following to your SQL report Department dataset (to get department based on Userid):

SELECT DISTINCT Department

FROM mytable

WHERE User!Userid in (@Department)

---------------------------------------------------------------------------

Then simply go to SQL report @Department parameter, add...

When using Mod 2 - it get same result.

Perhaps there is a better method, search via google.com , if you find it please notify us via this forum page.

Hi Komal,

Martins method: DWH.dbo.Split_Values(@Store_Code_List,',') should be used in stored proc's where clause (not in from clause).

Whenever using SplitList / multivalue parameter function, call it from your where clause like -...