Here's a screenshot of what I did. Hopefully it's clearer now.

One day, I promise to learn to read!

If you have to do this in SSIS, I'm at a loss...

Check out Jeff Moden's articles on Crosstabs & Pivots Part I[/url]...

you can't open it directly. You have to import it into an SSRS report project first.

(If you're using Excel 2013, you can do all this in Excel. Just create...

Just click the Edit Attachments below the message, then you can upload the file. ...

Put the Copay column into the same group as MRN and then use FIRST(Fields!Copay.Value)

Sounds like you need to use EXISTS and a subquery instead of INNER JOIN.

Your subquery would return all CustomerIDs who had 'Policy X', and then you'd use exists...

SELECT c.CustomerID, c.PolicyNumber

FROM...

What kind of grouping do you have in your report? Could you post some sample data (not real please - we don't want to see anything we are not supposed...

I used your data and just copied it to a text file. Then on the Data tab, I chose From Text, and specified during that process that the recorddate...

Wow... from what century did you get that example from?

For starters, your parameters aren't declared. The easy way to reuse parameters is to declare them first and then...

One thing that nobody has mentioned is the fact that you may have to rewrite VBA code. Can work great if your front end and back end are Access,...

(Pretending to be Steve, but not as smart)...

You write to a temp table the same way you write to any other table.

INSERT INTO #tempTable(col1,col2,col3)

VALUES ('col1value','col2value','col3value');

OR

INSERT INTO #tempTable(col1,col2,col3)

SELECT colA, colB, colC

FROM...

I should have realized that you can't use that expression in the filter. I was just trying to point you in the right direction (and that part seems to...

You probably need to change the stored procedure something like this:

SELECT

DM.DriveID,

DM.FromDateTime,

Acct.AccountID,

Acct.Name,

Inc.Description [Incentive],

DPaCT.ProcedureProjection [Proc_Proj],

DPaCT.ProductProjection [Prod_Proj],

DPaCT.ProceduresPerformed [Proc_Perf],

DPaCT.ProductsCollected [Prod_Coll],

DPaCT.QNS [QNS],

DPaCT.FTD [FTD],

(isnull(DPaCT.ProductsCollected,0))-(isnull(DPaCT.ProceduresPerformed,0)) [DRBC]

,ROW_NUMBER() OVER (PARTITION BY Act.Name ORDER BY Acct.Name) AS rn /* note...

Maybe

=DateAdd(DateInterval.Day, -1, Today)

(wow, makes me hate SSRS!!!)

Something like this?

SELECT x.id

, DENSE_RANK() OVER (ORDER BY x.id) as DenseRnk

FROM

(SELECT 'A123' AS ID

UNION ALL

SELECT 'A124'

UNION ALL

SELECT 'A124'

UNION ALL

SELECT 'A123'

UNION ALL

SELECT 'A127') x

And then do like Phil said and...