Yup, I'm being stupid... figured it out... I had to select the formula for the Measure first!

(still kinda wish PowerBI Desktop acted just a little more like Excel!!!)

You can use an FTP task in SSIS. You might want to look at Brian Knight's book. Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

It covers the basics...

Steve,

you can add as many datasets to your report as you like... the caveat is that you can only use one dataset at a time in a single tablix/matrix.

If you...

Once you create a dataset, you can convert it to a shared dataset. Shared datasets can be used in multiple reports, because they "belong to" the solution, not the...

https://www.mssqltips.com/sqlservertip/3549/inventory-sql-server-services-version-and-edition/

If you want to learn PowerPivot, get Rob Collie's book. Takes a bit to get your head around, but he's really good at walking you through a lot of stuff....

You could do this in PowerPivot... makes it really easy... You can use PowerBI, which is a free download too... if you can get someone to install it for you....

Instead of using a tablix, use a matrix. then put the date field in the columns part of the matrix and you should be off to the races.

You have to join the two tables somehow

the INSERT INTO part is a bit of a red herring.

SELECT A.Field1, B.Field3

FROM A INNER JOIN B ON A.SomeKey = B.OtherKey

WHERE...

then you just...

post the CREATE TABLE and INSERT scripts so we have some data to work with. what version of SQL Server are you using?

Jason Selburg wrote an article with his code that does all this. without Enterprise edition. Probably worth a read.

HTH,

Pieter

Thanks for the create table/insert scripts. That helps a lot. One more thing, though. Could you post your expected output? Is the age of the dog significant...

where? Why not re-post the whole thing?

<DDL statements to create tables>

<DML to get at least part of the way there>?

If you're only using one dataset, you could have several tablixes on your report and do different summaries in each one. No need to nest at all. I did...

one option is to use subreport(s).