We use Microsoft Visual Source Safe - I dislike it intensely! - just my opinion but one to stay away from..

Right click on the chart background (inside your axis not the chart area surrounding it) 4th option down "Show Secondary Axis"

Andy

Welcome 🙂

Hi

Missing a bracket at the end of the expression

=IIF(Parameters!Option.Value= 1, First(Fields!Name.Value, "DataSet1"),First(Fields!Name.Value,"DataSet2"))

Andy

Hi

Yes you add it as a child group

Then use the parent row add the client name and any summary data you wish and the detailed data should be added to...

Just my two cents but I much prefer to use the SQL Server Config files rather than XML

I find it much easier to maintain and make changes if necessary...

Thanks for the information Koen

Right I'll stop hijacking the OP's thread now! 😉

Andy

Hi

Yes this is possible

You need to create another group within your Client group and call it Detail or something

Then in the Detail group properties go to the visibility section...

Then the package is not failing and your job will continue to complete successfully - you need to set the task to fail the package on failure in the properties...

Sounds like the Package is possibly not failing - what is the failure message you get when you run the package, or is it just the one task failing and...

Sorry to jump in but a quick question.

Koen: What is your opinion on Cognos Express? I have a friend who is currently working...

Temp Tables and Table Variables certainly have their uses especially if you have a large script with using many in-line views like this. I've managed to get scripts that just...

Based upon the lack of information you have provided - unfortunately not

Your welcome - hope it works for you 🙂

I haven't got time at the moment to tidy up the SQL or check the result accuracy for that matter (I'll leave that part up to you!)

However take a look...