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

I think I have it...

does this look right?

The next trick is going to be figuring out how to save this so it's compatible with SSRS 2008, since I did...

I'm working on it... it's giving me fits getting it exactly right... (Seems it should be easy, but maybe it's not as easy as it looks...) more when I think...

a hyperlink goes nowhere unless you tell it an address (or in this case some records to jump to).

What does the signature of your stored procedure look like? (what parameters does it expect and what types are they?) What are you doing with the parameters so...