Thank you for your reply.

I am using SQL 2000, sorry I did not mention that.

Thanks

Gary

Thank you Lynn for your response.

I have been offline for a few days and have not been able to try your solution.

What I had been trying was using a series...

Thank you Craig and Sean,

The problem was user error.

There were in fact no duplicate but at the time I was certain there were.

I was at the end of an 18...

Craig,

thank you for your response.

However it returned no results.

Gary

I figured out the solution.

Original Query

select 0, 'All'

union

Select statusid, statusdescription

from status order by statusid

Improved query

select 0 as statusid , 'All' as statusdescription

union

Select statusid, statusdescription

from status...

Steve, thanks for the reply.

That was my suspicion all along.

Gary

Thank you for the link.

I will check it out.

Gary

Thank you for the reports.

I downloaded the zip file, extracted the rdl files and imported them into a reporting project.

I like the design and choice of color for the reports.

They...

To close the loop on this, so to say.

This error:

Msg 5120 Level 16, State 5, Line 1

Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\ftrow_CompanyKeyword.ndf". Operating System error 2:...

For those that might see this thread. I have solved the issue.

I placed a table control on to my report.

on the detail row, left hand side, I clicked and added...

I have been experimenting by putting text boxes in rectangles, leaving them out of rectangles, using no rectangles at all and still nothing is working. This really sucks.

The text box...

Thanks for the reply. Yes SSRS is loads of fun :angry:

I meant to explain that each of the groupings are in their own rectangles.

Are you saying to put all my...

Thanks for the response

here is a sample of the desired output.

for report_id 1

511153872003-12-13 11:37:00.000

for report_id 2

nothing returned because a 1 does not follow a 2

For report_id 3

nothing returned because a...

For completeness, I got this to work

I changed the requirements so to speak.

Instead of trying to export from excel into separate text files I exported excel into a table in...

Greg,

thanks for pointing me in the right direction. I have several constraints but missed that one somehow.

Gary