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

If you're trying to go to a specific order number, then yes.

you have to add a parameter to the report you're opening (a hidden one is fine). And then in the calling report, you have to specify that parameter to...

Is this a one time thing? Does the destination database and the tables already exist in the destination? SSIS could do it. Not enough details to know...