Flatfile Destination Variable Filename

Why does the raw file have an option for a variable path and the flat file destination does not? Not having this feature makes it impossible to work with variable environments. Please add this option to the Flatfile Destination.You can use expressions on the flat file destination to change the location of the file.|||Thank you so much for your quick reply. I have the flat file destination highlighted but there are no properties for Expressions. I also looked in the connection properties also and could not locate a place to do this. I ended up writing a vb script but I would like to have the ability to do it graphically. The SSIS team definately needs to set up a way to set Global Variables (which could contain file path settings) via a sql statement. They also need variable file pathes exactly like the raw file.|||When you right-click on the flat file connection manager, you can select properties. In there is an Expressions property. You'll want to set the ConnectionString property to the full path containing the file.|||Oh awesome! Thanks Phil.

FixedHeader + ToggleItem-Autoscrolling

Hi @.All,

SSRS offers for a table control the nice feature "Fixed Header" (so called in the Properties Box) or "Header should remain visible while scrolling" (so called in the context Properties Window). This works fine.

SSRS has an other (auto-)scrolling-feature for drilldown, e.g. when you have a long list of data in the first column of a table, that are toggle-items for drilldown and you click on such a "+" sign for drilldown, SSRS scrolls the toggled item to the top position of the table chart controll. This works fine.

But... with both features together SSRS scrolls the row selected for drilldown under the fixed header!

For the user, it looks like the data has gone. They have to undo the SSRS drilldown-autoscrolling to see the data again they have choosen to drilldown.

The bug is that SSRS doesn't substract the header-hight from the top position of the table chart for the new (auto)scrolling position.

Has anyone found the same problem and has a workaround? E.g. can the mechanism of drilldown-autoscrolling be turned off? With what property?

Thanks for any help in advance!

Cheers,

Mobi

Hi,

Does anyone have a solution for this. Is it a bug and has it been reported to microsoft?

Cheers,

Dottyoz

FixedHeader + ToggleItem-Autoscrolling

Hi @.All,

SSRS offers for a table control the nice feature "Fixed Header" (so called in the Properties Box) or "Header should remain visible while scrolling" (so called in the context Properties Window). This works fine.

SSRS has an other (auto-)scrolling-feature for drilldown, e.g. when you have a long list of data in the first column of a table, that are toggle-items for drilldown and you click on such a "+" sign for drilldown, SSRS scrolls the toggled item to the top position of the table chart controll. This works fine.

But... with both features together SSRS scrolls the row selected for drilldown under the fixed header!

For the user, it looks like the data has gone. They have to undo the SSRS drilldown-autoscrolling to see the data again they have choosen to drilldown.

The bug is that SSRS doesn't substract the header-hight from the top position of the table chart for the new (auto)scrolling position.

Has anyone found the same problem and has a workaround? E.g. can the mechanism of drilldown-autoscrolling be turned off? With what property?

Thanks for any help in advance!

Cheers,

Mobi

Hi,

Does anyone have a solution for this. Is it a bug and has it been reported to microsoft?

Cheers,

Dottyoz