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

"but that didn't work because the selected DateGroup column needs to show even if there is no data for it."

If you outer join the DateGroup columns to the other data,...

Not entirely sure where your columns start and stop...

Could you provide a CREATE TABLE script and some INSERT scripts to populate your table?

Or something like this? It's just hard...