Thank you for your feedback!

On my place (BIDS 2008), when I use a multi-valued text parameter, the 'carriage return' is automatically converted to ', '.

So I am able to either pass it to...

I use multi-valued parameter for this situation.

Looks like you need a Group Number for the group1, RunningValue may help.

Try following Backgroundcolor expression for both Group2 and Detail Row.

=IIF( RunningValue(Fields!Group1FieldName.Value, CountDistinct, Nothing) MOD 2, "green","blue")

I just gave it a try. Attached is a simple sample that based on the AdventureWorks database.

It should turn the drill-down, and the highest level shown in the same column.

Regrading...

Jack Corbett, thanks for your reply, it helps me.

erdem1973, sorry, I was wrong.

I'm not an expert. I think you can try adding another detail row. and then

put the current information in the original row, put the preview week information in the...

I think just try put the highest level under the lowest level. In other words, when adding the parent group, put the parent information in the footer row.

If following is the results of you dataset, you don't need a matrix report

col1 YYYYDD col2 col3 Total

A 200901 1 2 3

A 200902 4 1 5

B 200902 1 1 2

B...

For example, if you use "c:\temp\test.txt" as filename, it includes location.

or, using two variables, one represents location, one for filename, in your expression editor, concatenate these two.

take a look at this

http://agilebi.com/cs/blogs/jwelch/archive/2007/05/08/handling-flat-files-with-varying-numbers-of-columns.aspx

Not sure which way you accomplish this.

On the Excel Destination, if you select "Table or View" data access mode, when click the "New" to popup the Create "Table window",...

Hi kbatta, Thank you for this post. It helps me too.

If you pass a DATE type parameter, it should work.

For example, create a DateTime variable, and map it with DATE data type.

Yes, I mean BIDS, sorry for the typo.

My previous reply was based on the assumption that the executable needs input parameter(s).

Whenever you guys have better ideas, please share with us....