There is no way for reporting services to get around limitations in excel.

your going to have to make the report send out less data.

Reporting services has many known issues with...

Sure Can you post an example of your first one?

you can create a function

that does the trim, replace, and isnull (if your supplying a stating string on isnull)

See Create function...

what exactly are you trying to accomplish?

Usually this kind of formatting is done on the presentation layer. IE Report or Webpage.

Are you exporting this data for someone?

Why are you dynamically...

If your using Microsoft Sql Server management studio this is Configurable.

(actually almost the exact same in query analyzer)

Tool--> Options -->Query Results --> Sql Server --> Results to Text.

Change output format...

your query is fairly simple, why do you need to use dynamic sql?

Here is a good article to read.

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

for your ID's parameter I suggest using the last method where you...

Depends on how you want it to look, but you can certainly do it like this.

Declare @minage as int

set @minage = 0

Declare @maxage as int

set @maxage = 13 -- 5...

Also the ability to wrap your column names with the " depends on your Quoted_Identifier setting.

From Books Online

http://msdn.microsoft.com/en-us/library/ms174393(SQL.90).aspx

SET QUOTED_IDENTIFIER (Transact-SQL)

Causes SQL Server 2005 to follow the SQL-92 rules regarding quotation...

Group by forces you to designate all non aggregate values in your group by clause which ensures sql can aggregate by all possible values.

If you don't want it in your...

are you trying to exceed the nvarchar(4000) to use in an sp_executesql statement?

I don't know that you can.

what in the world are you trying to execute that is that long?

Just...

Isn't it great there's a place you can go to get someone to do all your work for you. :hehe::cool:

LOL @ Jeff:w00t:

Well If it is not inserting any rows, and no errors are being returned, then it seems to me that it is going into the Update statement.

Manually run the stored...

<%

dim sJustify

iAsmtID = request.QueryString("iAsmtID")

sQuest = request.QueryString("sQuest")

'sJustify = request.Form("sJustify")

'Set Conn = Server.CreateObject("ADODB.Connection")

' Conn.open My_Conn

'str = "if not exists (SELECT * FROM Checklist_Justify WHERE iAsmtID="&iAsmtID&")"

'str = "INSERT INTO Checklist_Justify (iAsmtID, sQuest, sJustify)...

No, Pivot, and Unpivot are new in sql2k5.

Since you posted in 2k5 forum we assumed that is what u were using.

Please Post your entire query.

Your error message indicates that there is no column named '400.PatientAge'

or column named 'PatientSex'