This[/url] should be a good starting point.

David,

you could modify your stored procedure so that you can pass in a date and use something like this in your filter

If you could use DATEFROMPARTS, you'd be in the...

Not much to go on, but if each delegate is worth a specific amount, then you can do some counts and simple multiplication to compare to your break-even amount.

Without more...

Not a lot to go on.

How are you prompting the user for a date? What data type is your parameter?

Your stored procedures aren't really prefixed with sp_ ? You know that's for system stored procedures, right?

I did mine differently. I checked for existence of both class types in the "attends" table...

CREATE TABLE Student(

StudentID INT IDENTITY PRIMARY KEY,

FirstName VARCHAR(10) NOT NULL,

LastName VARCHAR(15) NOT NULL

);

GO

INSERT INTO...

If you have tons of databases to do it on, you could create a cursor to loop through the databases and then run the SQL to enable service broker. ...

You mean something like this? You'd need a Calendar table

SELECT *

FROM Calendar

WHERE TheDate>=GETDATE()-90;

toggle the visibility by making it depend on an expression might be an option.

you can only filter a dataset as a whole, not just a matrix or whatever where you use the dataset. Unless there's something I've been overlooking all this time.

One option might be SSIS to a new database? (then you can clean in between... in the SSIS pipe).

it's a star schema. It's just normalized a different way. One relatively painless way into understanding some of star schemas is Rob Collie's book "DAX Formulas for Power...

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...