If I understand correctly, this can be achieved by using DrillThrough action on textboxes of your left column?

have you explored that option ?

Basically you would be drilliing through a different...

A quick check...

What does below return in your textbox ?

=IIF((Parameters!Facility.Value < 3), Fields!Field1.Value, Fields!Field2.Value)

AND then also try this.

=IIF((Parameters!Facility.Value = "3"), Fields!Field1.Value, Fields!Field2.Value)

-- This should work if your Parameter is -...

The reason I intend to use ReportItems is - There is no column grouping in my Tablix and the structure of Tablix is fixed.

If it helps....

Hi Thanks for your help...

My bad that I didn't mentioned earlier, I have played around with Cangrow and CanShrink properties, they WEREN'T useful for me.

the alignments to check are a...

Hi Koen,

Yes I can do that. What I really wanted to know was, "Is there a way creating Aggregations outside BIDS" ?

Perhaps NO.

Athar

Hi,

I have the password of the package and I am using the correct password to open it (trying to open it, I mean)

Athar

Hi Phil,

when you say - "I'm not sure about this method", Can you please suggest an alternate to this ?

Can Transactions and Containers solve the problem here ?

I am sure...

Hi Phil,

Glad that you asked.

Quickly answering your Question on why row-by-row....

This SSIS package was taking in excess of 40 min to run. The Issue here was that SSIS would update...

Thanks for the response.

The Server has Framework 3.5 installed however. Just wanted to know reinstalling Framework 2.0 would help ??

Thanks Chris and Mark. Exactly what I needed.

Here it is....

CREATE TABLE [dbo].[tmpTable](

[ColA] [nchar](10) NOT NULL,

[ColB] [nchar](10) NULL,

[ColC] [nchar](10) NULL,

[ColD] [nchar](10) NULL,

[ColE] [nchar](10) NULL,

[ColF] [nchar](10) NULL,

CONSTRAINT [PK_tmpTable] PRIMARY KEY CLUSTERED

(

[ColA] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

OK. So it seems that the issue is due to different versions of SQL Server.

Machine where it was developed had SQL Server 2008R2 and the other Dev server where I...

Hi there,

Can you please publish the solution if you have got one? It might help others as well. Thanks.

Hi,

This is not a very common Issue so just by going that screenshot of legend wouldn't help probably.

You can add more details, if the screenshot of the report would...

Hi,

This is not a very common Issue so just by going that screenshot of legend wouldn't help probably.

You can add more details, if the screenshot of the report would...