Showing posts with label property. Show all posts
Showing posts with label property. Show all posts

Wednesday, March 28, 2012

Is there a property in the report designer to set a report, datasource, etc to be hidden in repo

Is there a property you can set in report designer to make a report or datasource hidden in report manager? I am making a rss script to deploy all datasources and reports, but some I want hidden. If you can't set it in report designer is there a way to set the property in the rss script for the reports and datasources? Thanks.

There is no property that can be set from report designer.

You can hide report or datasource by setting property "Hidden" to true

Dim Properties() As Property = New Property(0) {}
Dim hidden as new Property
hidden.Name="Hidden"
hidden.Value = "true"
Properties (0) = hidden
RS.CreateReport(Report, Parent, Overwrite, Definition, Properties)

Wednesday, March 21, 2012

is that possible to prevent modifying the name of an IDTSInputColumn90?

Hi,

I'm building a custom SSIS data flow component and I create myself input and output columns from a custom property of my pipeline component. That's why I don't want the user to modify the name of the input and output columns by using the advanced editor.

Is there a way either to make input/output column properties - at least the name - readonly or to override any PipelineComponent method to throw an exception like we do when we want to prevent the user from adding/removing input/output colulmns with methods like PipelineComponent.DeleteOutputColumn?

Thanks for your help,

David

Have you tried SetInputColumnProperty? The name is a property, but I have vague recollection that you cannot use that method to set the name, and end up having to do it on the IDTSInputColumn90 reference directly.

Can you detect a change, and pick this up in Validate? If you can detect a change you could return VS_NEEDSNEWMETADATA, and then correct the problem in ReinitializeMetaData. Not as proactive as preventing a change, but maybe it is better than nothing?

|||

I've tried SetInputColumnProperty but it is called only for custom properties...and the name is not a custom property.

I any case, like you said, when the user modifies the name of an input column, Validate is called and I can detect the error...

Thanks