If you right-click the Reports folder in Solution Explorer, and select Add>New Item> and then select Report (not Wizard), you should get a blank report that opens. At that...

Alan.B (10/2/2014)

---

pietlinden (10/1/2014)

---

Is there any alternative to building your own SSAS cubes to report against? I would have sworn that SSAS creates an object that can be reported on...

Guess I have to learn how to build a cube... oh well.

Oh, okay. So right now you have a shared data source. If you Right-Click on the Reports folder in the Solution Explorer, you can add a report (if...

Took me a minute to figure out what you did. If you've created a shared datasource, the Report can't see it yet. You have to create a datasource...

Since I'm trying to learn how to do all this better, I figured I would see if i could get it to work...

SELECT ContractNo

, Pkg

, GrpNo

, Subgroup

, split.ItemNumber

, Item =...

Oh... I thought you already had a report-level parameter... maybe that was part of my problem. Glad you got it sorted.

The only way for SSRS to know is if you specify a dataset for the parameter to get its values from. If you right-click on your parameter, and go...

However, the Value field in the dropdown list (CityID in your example) isn't making the connection to the main dataset query where clause (even though the spelling is the same)....

Shouting isn't necessary... all caps is hard to read...

okay... this is a classic gaps & islands question - well covered in Itzik Ben-Gan's book on T-SQL 2012 Window functions, and...

Say you have this stored procedure to return a list of cities with their corresponding CityIDs (which are numeric)

CREATE PROC uspGetCityIDs

AS

SELECT CityID, CityName

FROM Cities

ORDER BY CityName;

then you could create a...

Great! I must be learning!

I can upload the RDL file... I based it on a stored procedure

CREATE PROCEDURE [dbo].[JamesSalesSummary]

AS

SELECT

SalespersonRep AS Sales_Person

, CustomerName

, YEAR(InvoiceDate) AS InvoiceYear

, MONTH(InvoiceDate) AS InvoiceMonth

, InvoiceLineAmount

, COGSAmount

, InvoiceLineAmount - COGSAmount...

The good news is that I think this is right... the hassle is that I am using SSRS 2012. (No 2012 functions in this at all, though.)

Here's the layout....

DECLARE @currMonthNum INT,

@lastDayMonth INT

SET @currMonthNum = DATEPART(MM, GETDATE())

IF @currMonthNum IN (1, 3, 5, 7, 8, 10, 12)

SET @lastDayMonth = 31

IF @currMonthNum = 2

SET @lastDayMonth = 28

IF @currMonthNum IN (4, 6,...