Revenant (11/3/2011)

1960s ( Does anyone else have the feeling that this decade is going to be a mirror of the 60s? )

You could also use a SWITCH

SWITCH(thiscolumn.this = "Y",what happens when it is Y,

thiscolumn.this = "N", what happens when it is N)

You would write this as

=IIF(thiscolumn.this = "Y",Put what you want to happen when the expression is true here, put what you want to happen when expression is false here)

I don't know for a fact that this is in here, but I would check the report.config file for a setting that controls that.

This indicates to me that you have trailing spaces on your data. Try adding RTRIM (I would probably also add LTRIM) to your data, or a TRIM to your textbox....

Smörgåsbord

In a CSV file the name of the column headers are the names of the textboxes where the data resides in the report. If you go right click on...

If your parent group is based on Name, then add a header and put your name there instead of in the detail.

mysticism

As far as I know the CSV is about as raw as you can get. What are the problems with the CSV format as the raw data?

You want a table at the bottom, what do you want above the table?

Pretentious

To my knowledge there is not a transform in SSIS that would do this sort of field by field comparison natively, easily. You could use a Conditional Split comparing...

I think you can follow two paths here, but I can't speak as to the best choice or many of the details.

1. Use SSRS Security Extensions to create a custom...

trivia