What's your expected result?

If you're using 2010, then PowerPivot is not installed by default. (Actually, I don't think it was developed until after 2010 came out.) You have to go to MS and...

I'm cheating for a minute and assuming you're using 2012 (which you're likely not)...

CREATE TABLE salesData

(date_created date,

sales money);

GO

INSERT INTO salesData (date_created, sales)

VALUES ('6-23-15', '20000.00'),

('6-24-15', '22000.00'),

('6-25-15', '25000.00'),

('6-26-15', '28500.00'),

('6-27-15', '32000.00');

-- 2012 solution

--...

UNION your real result set with something like

SELECT Null, Null, Null

FROM Tally

WHERE n<=@NumRows

you would need to figure out the count of missing rows to do it, but that would be...

"because I think Power BI currently only works with SSAS cubes and is online only"

I've seen one of the WiseOwl folks (see YouTube for the video) create a Power BI...

Couple things: this...

=SUM(Fields!PersonID.Value, "datasetname")

doesn't really make sense. PersonID.Value is essentially a random meaningless number. why not COUNT?

The other thing you may need to look into is either LOOKUP...

You need sp_MSforeachdb. Look through BOL. There's an example here[/url]:

http://www.mssqltips.com/sqlservertip/1414/run-same-command-on-all-sql-server-databases-without-cursors/

Okay, got some nice fake consumable data? Doesn't have to be real, just has to be representative of your table structure(s) ... or the output of your stored procedure...

And please...

If all you want to do is divide your counts over a fixed population size, then it's easy. Create a variable and populate it with a COUNT from your...

Given the data, this works:

SELECT RecID

, BO_ID

, Code

, Code_Date

, MAX(CD1) AS Msg1

, MAX(CD2) AS Msg2

, MAX(CD3) AS Msg3

FROM

(SELECT 1380900 AS RecID

,'XZ01' AS BO_ID

, 12 AS Code

, '1/16/2015' AS Code_Date

, 'P302'...

Try this:

...

WHERE TT11.Period>=@BeginPeriod

AND TT11.Period<=@EndPeriod

Instead of

=iif( Fields!ColA.Value<>Fields!ColB,"Red","Green")

try

=iif( Fields!ColA.Value=Fields!ColB,"Green","Red")

CYA and make a backup and keep it in a safe place...

then offer to sell it to him later... No, just kidding about the last part.

Here's one I did based on the database provided by Itzik Ben-Gan in his book. It's the same kind of Customers/Orders/Line Items database. What I'm doing is showing all...

This will return all APInvoiceNum values that contain at least one IT-related expense.

SELECT APInvoiceNum AS Invoice

FROM GLJrnDt1

WHERE GlJrnDt1.SegValue BETWEEN '310100' AND '330500'

/* You may not need these extra filters here...