Sorry about the spacing! Extra spaces got removed from my post ?????

Thomas,

This isn't the most efficient, but it works...

----------------------------

SELECT

ID,

Number,

Name,

Date

FROM

CLASS

WHERE

Number NOT IN

...

I'm not 100% sure, but I believe it's microsoft

Drew,

Is this a fresh install of RS or one that's been up for a while?

Have you recently moved or restored the RS Database?

Issue resolved after a great loss of hair.

Solution, as provided online was to re-install the ASP.NET files by running "aspnet_regiis.exe -c" THIS DID NOT WORK.

After stumbling around, I tried "aspnet_regiis...

Hello,

This is only an observation that may assist you. From my experience, the extra columns appear when you have more than one table in your report, and the widths and...

The font is installed on the webserver! That's the weird part. And you can "export" the file into Excel and print it fine, you just can't print from the web...

TABLE SCRIPT

-------------------------------------------------------------------------------------

CREATE TABLE [dbo].[tblRTPs] (

 [RtpID] [int] IDENTITY (1, 1) NOT NULL ,

 [PersonID] [int] NOT NULL ,

 [WeekID] [int] NOT NULL ,

 [PointsEarned] [int] NOT NULL

) ON [PRIMARY]

GO

-------------------------------------------------------------------------------------

MY WORKING SP

-------------------------------------------------------------------------------------

SET QUOTED_IDENTIFIER ON

GO

SET...

Perfect Farrell! I knew there was a simple way. Thank you!

Thanks to ALL for your replies. In the end I went with the function, and it works great!

Francis,

That worked for what I needed. Just for curiosity though, is there an easy way to get the multiple entries in one field?

So if ....

Customer_Contact_ID    Customer    Location   Region                ...

Port 80 is default and 443 is for HTTPS.