I am new to SSRS also, but this book helped me "Applied Microsoft SQL Server 2008 Reporting Services" by Teo Lachev

The extra to the book is the video's he has...

Do you have a SQL Query?

Can you insert a screenshot of what you are talking about?

Thanks for all your help I ended up using a negative in SSRS.

(SELECT CONVERT(VARCHAR(12), TimeStart, 114)) AS timestart,

(SELECT CONVERT(VARCHAR(12), TimeEnd, 114)) AS timeend

And this in SSRS:

=Fields!TimeEnd.Value-Fields!TimeStart.Value

Thank's again for this great...

I got it to work:

SELECT [NAME],

SUBSTRING([NAME], CHARINDEX(',', [NAME]) + 1, LEN([NAME])) AS FName,

SUBSTRING([NAME], 1, CHARINDEX(',', [NAME] )-1) AS LName

FROM dbo.MyTable

I would have liked 3 rows, but 2...

That seems to be working just as this:

SELECT SUBSTRING(NAME, 1, CHARINDEX(',', NAME )-1) AS LName,

CASE WHEN CHARINDEX(' ',REVERSE(NAME)) = 2

THEN ...

No the data is more like this:

CULLER,PETER O

FRAZIER,BRANDON

MCNEAL,CHRIS Z

LIBBY,JOHN L

BASS,BILL

I just want to split up the data, so I can use it in Reporting Services.

FName+' '+MName+' '+LName ...

When you are creating a report in SSRS right click on the non-table part of the report and, point to Insert, and then click Header or Footer.

Do you have "DROP TABLE #BASE" at the bottom of your Stored Procedure?

If so highlight the DROP TABLE #???? and Execute in SQL Server

If I am working on a...

You might want to check this out also:

http://www.ebooks-space.com/

Also new at SQL - Reporting Services

😀 Thank You it worked

I appricate the help...

Try This from http://support.microsoft.com/default.aspx?scid=kb;en-us;896861

Method 1: Disable the loopback check

Follow these steps:1. Click Start, click Run, type regedit, and then click OK.

2. In Registry Editor, locate and...