I think he's talking about something more like this, but this is PowerView in Excel 2013...

http://office.microsoft.com/en-us/excel-help/maps-in-power-view-HA103005792.aspx

Luis,

Outer apply... I should have figured. Still trying to get my head around that one... I mean, I know what it does, but remembering to use it... I...

That's what I was thinking at first, but the two values are not in the same record. That's why there's all the weird coding...

This seems to work... If you post consumable data (create table scripts, and inserts), it's a lot easier for people to help you - since you've set up the...

DECLARE @InputString VARCHAR(15) = '1.234;0;0;0;0;0;0;0';

PRINT LEFT(@InputString,(CHARINDEX(';',@InputString,1)-1));

Not much to go on here, but there are two parts to filtering a dataset if you are using report-level parameters that you define yourself (as opposed to inheriting them...

What type is the parameter? Should be an integer. then you can do something like

=Parameters!EndWeekNo.Value + 1

I would put it all in the stored procedure, and if you can avoid using the view, do it. Think about what would happen if your view got dropped...

The only way I can think of doing it is by adding a parameter that prompts for Export format, and then hiding the tablixes you don't want exported. maybe...

Most likely because there's a significant difference between the meaning of @StatisticsDate and StatisticsDate in your statement.

@StatisticsDate is always a variable. When the parser sees "StatisticsDate" it has to...

Did you compare it to a standard MAX(Date) with a GROUP BY clause?

Too young? No such thing, I think.

Too inexperienced? That's another question entirely.

If you really want to be an SSRS expert, you need to learn T-SQL (Microsoft's version of...

So do you really mean "page breaks" instead of "control breaks"?

maybe this discussion will help?

http://social.msdn.microsoft.com/Forums/en-US/2f09b99b-bec2-443d-b78a-308d83132200/conditional-page-breaks-in-ssrs

Is using SSRS an option or do you need to do it in T-SQL? The nice thing about doing it in SSRS is that the columns are dynamic.

select only the data from the first table that is not available in the second table

SELECT A.*

FROM A LEFT JOIN B ON

(several joins - on the columns that match)

WHERE B.ForeignKey...