Go to this link:

http://www.mhprofessional.com/product.php?cat=112&isbn=0072262397

on the left of the screen in the downloads section click on Code and save the zip file. The database install is included in...

We removed these same files. On some computers we could see the RSPrintClient class files in the download programs folder and we removed those as well. We just...

This was one of the most frustrating and difficult problems we had to work through. Solutions would work on some computers and not others.

I checked with our...

We went through this same issue several months back. The problem is that the new print control won't load over the old print control. You will need to...

OK. I got it to work, finally.

I deleted all the RSClientPrint files from Windows\System32 and then tried again. Everything installed correctly after that and print is now working.

Now...

I'm trying to print the report directly from the Report Manager on the SQL Server Reporting Services server.

When SP3 was first installed and I tested the print, I immediately got...

Thanks Luke. I forwarded the link you provided to our tech support team for them to look at. The strange thing is that I do have admin rights...

Thanks for the reply and link. However, I checked one of the computers with the problem and it already has all the RSClientPrint rll files. The print was...

Thank you so much. I did not know about the view definition feature in SQL Server 2005. Apparently the DBA does not know about it either. This...

None of the answers are correct.

PK_ID - 4

Name - 102

Profession - 202

all the bit fields - 1

DOB - 4

Total = 313

nvarchar fields take 2 x the max length + 2...

I think I found my solution. This seems to work.

ISNULL(REPLACE(Convert(char(10), date_Field, 101), '/',''),'00000000')

I'm not sure I entirely understand your question, but it sounds like you want to convert rows to columns. You might looks into using PIVOT in your query.

Check in...

Replace your if statement with the following:

Set @end_date = ISNULL(@end_date, @start_date).

The ISNULL() function replaces a null value with the specified replacement value. It is not used to check for...

Have you checked in the main report to make sure that you don't have something ahead of the sub-report set to page break at the end?  I had a similar problem on...

How are you looking at the file after you export it?  Are you opening it in Notepad or in Excel?  If you are opening it it Excel, try opening it...