I just created a report with 3 tablixes on one page. (Mind you, none had many rows...) One thing you might check is whether there are Page Breaks set...

Something like this should work:

SELECT PhoneNum

, CHARINDEX('-',PhoneNum,1) AS ci

, LEFT(PhoneNum,CHARINDEX('-',PhoneNum,1)-1) AS code

, RIGHT(PhoneNum,LEN(PhoneNum)-CHARINDEX('-',PhoneNum,1))

FROM

(SELECT '123-12323' As PhoneNum

UNION ALL

SELECT '1234-1222') a;

I asked a DW guy about that not terribly long ago. He said that you have basically two fact tables which share the same dimension tables. The dimension tables...

SSIS is maybe the easiest. If you save the package, you can re-run it or add a conditional split so it only imports new records.

If you saved the Excel file...

My data is fake, because I didnt have yours.

SELECT 1111 AS MRN, 'hdhdhd' AS FirstName, 'hdhdhd' AS LastName, '5/21/2015' AS Date_Filled, 'Tylenol' AS...

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