Here is what I used to populate my DataSet

SELECT 'ABC' AS Company, 1000000 AS Revenue UNION ALL

SELECT 'DEF' AS Company, 1550000 AS Revenue UNION ALL

SELECT 'GHI' AS Company, 2100000 AS...

Not really.

If you click the control flow tab, in the toolbox under Control Flow Items, I see it as the fourth item, "Sequence Container"

http://www.bidn.com/blogs/TomLannen/bidn-blog/2620/using-sequence-containers-in-ssis

It #1 Contols Flow, Logical blocks of...

I'm not as OCD about where the connectors go, I also try to understand that the SSIS GUI is not intended to be Visio. Other than providing tons of Space...

You can.

Create a new report, Place a table, create a dataset that will have the multiple companies and embed the existing report into the table as a subreport. Using the...

I'm afraid we do not have anything to go off of to help you.

If I wanted to write a report that compared Ducks to Cars how would I do it?

The...

Wouldnt the size of the database be the MDF size + the LDF size?

No one minds helping, but if you want us to do your job for you, I'm sure...

Use Nested iif, or Switch

iif(Fields!ActualPerformanceMinBenchmark.Value > 0, Fields!ActualPerformanceMinBenchmark.Value*500,iif(Fields!ActualPerformanceTargetBenchmark.Value<0,Fields!ActualPerformanceTargetBenchmark.Value*300,0))

Edit:Switch Example

Switch(Fields!ActualPerformanceMinBenchmark.Value>500,Fields!ActualPerformanceMinBenchmark.Value*500,Fields!ActualPerformanceTargetBenchmark.Value<0,Fields!ActualPerformanceTargetBenchmark.Value*300,0)

What have you tried?

a couple hints.

Use the case statement, wrapped in Min, or Max

Group by Col 1, Col 2

Check this out.

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Welcome to the wonderful world of SSRS. 😀

Try putting your 3 groupings into rectangles.

When you are making your report columnar such as you are some items don't respect each other...

If this is a fixed filter then you can filter it at the tablix, or Dataset level.

This should help.

http://www.mssqltips.com/sqlservertip/2597/dataset-and-tablix-filtering-in-sql-server-reporting-services/%5B/url%5D

I believe your parameter expression is invalid.

You should try.

="<XML><CalendarDate> " + = FormatDatetime(Parameters!Date.Value.ShortDate).ToString()+ "</CalendarDate> </XML>"

You can't Sum ReportItems!, You can reference them for other formulas.

You need to sum the underlying data. but I'm not sure if that helps you in your scenario.

There's 2 ways to do it.

Leave the Formula the way you have it as

=sum(Fields!selling_price.value)

and then in the properties of the Textbox change the number format (Right Click on Textbox, TextBox...

Your example does not look like there's a logical grouping available.

You can Hide the detail Row by right clicking the Row And Select Row Visibility --> Hide. and Then Check...

Right, you need to modify your query to always return the missing values even if there were none sold.

The report doesn't or shouldn't know whats missing, thats up to the...