Programmatically hiding chart on the report page.

I need to show or hide a chart on my my report based on the result of the
dataset.
I tied to assign an expression to Visible.Hidden property of the chart like
that "=First(Fields.Visible.value)" WHERE I assigned 0 or 1 to the 'Visible'
column of my dataset. It did not work. Is there a way to do that?
Thank you,The result of the Visibility.Hidden expression has to be a boolean value and
not an integer value.
Try this instead:
=(0 = First(Fields.Visible.value))
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Simon Gold" <SimonGold@.discussions.microsoft.com> wrote in message
news:A7C5B8B9-5D26-43EE-B82B-0EAF7418AA7F@.microsoft.com...
>I need to show or hide a chart on my my report based on the result of the
> dataset.
> I tied to assign an expression to Visible.Hidden property of the chart
> like
> that "=First(Fields.Visible.value)" WHERE I assigned 0 or 1 to the
> 'Visible'
> column of my dataset. It did not work. Is there a way to do that?
> Thank you,
>

Programmatically Create a Lookup Transform

Hi,

i'm creating a Lookup programmatically. But i can't find out how to assign the ConnectionManager that references the lookup data.
Do you have an example for me?

Many thanks in advance.
Stefan L.

Use the RuntimeConnectionCollection of the component (IDTSComponentMetaData90). This is the same pattern as a you use for a source or destination, but any component can specifyc runtime connections, as indeed the lookup does.

component.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(package.Connections[0]);

|||Hi,

Great! It works! Thank you very much!

Stefan L.
|||

I am new to SSIS programming and having trouble using JoinToReferenceColumns (

http://msdn2.microsoft.com/en-us/library/ms136014.aspx#lookup ) property of lookup transformation. Can you please post a code sample?

Programmatically Create a Lookup Transform

Hi,

i'm creating a Lookup programmatically. But i can't find out how to assign the ConnectionManager that references the lookup data.
Do you have an example for me?

Many thanks in advance.
Stefan L.

Use the RuntimeConnectionCollection of the component (IDTSComponentMetaData90). This is the same pattern as a you use for a source or destination, but any component can specifyc runtime connections, as indeed the lookup does.

component.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(package.Connections[0]);

|||Hi,

Great! It works! Thank you very much!

Stefan L.|||

I am new to SSIS programming and having trouble using JoinToReferenceColumns (

http://msdn2.microsoft.com/en-us/library/ms136014.aspx#lookup ) property of lookup transformation. Can you please post a code sample?

program flow question

I am trying to figure out how to make a report stop at a certain value. For example say I have five categories that I can assign an item. I would like to be able to have the report pull just the first category that applies to the item. For instance I have a bike that falls under categories 1 and 3 and a car the falls under 2, 3, and 5. How can I make it so the report will only show the details that apply to the first category the item falls under. Thanks.

So do you have a category field coming in the dataset agianst your items, and user is gonna select one category or may be more than one.

If i got it correct this can be done by using filter the dataset for that parameter may be using where clause or may be using dataset filter or even at table filter.

|||Actually I was able to solve this problem. I changed the view I was pulling from so the categories would be assigned numbers. Then I declare a varable and set it to Min(category) with the same from and where clauses. Then I just add to the where clause to have the catergory equal the varable set to min.