Thanks 2 all

I could not understand this query because of less knowledge of relational algebra.

I got the ans after run below query

select A.*,B.* from TestTAble A right join TestTAble3 B...

Hi Calico,

May be something corrupted with your report. May be the 'image' of the SP is damaged in the .rpt file.

I did not find anything like that, I like...

Yes It will be default I checked.

But can we set default size of columns

Hi,

After Step 4 I have alter my proc many time and also try all options in report " VArify Database, Set location, etc"

Just now I drop proc and create again...

Yes

U will face collation error when u will create a temp table and join that table with yur Db Table.

I just change collation of My database due to this error.

To...

Hi,

All setting are same in sql server 2005 and is align with sql server 2000 database where report is running fine

My complete analysis is

1-- This report is running in sql server 2000

2-- I restore a copy of databse to Sql Sever 2005

3-- Report stops due to different collation between my...

But this report is running fine with blnk space and with sql server 2000

Yes If I just pass blank space report run correctly.

I like to remind once again that this problem comes only in report display if i run this proc in query...

-- sp_helptext mms_r_py_payroll_summ_cs_rep_1

-- MMS_R_PY_Payroll_Summ_CS_Rep_1 'Y','01','','','R016','R016','0461','0461','CA','','SL','22/11/2008','21/12/2008'

Create PROCEDURE MMS_R_PY_Payroll_Summ_CS_Rep_1(

...

This is My Proc It execute correctly and return some data but report just pick one charcter of each char and varchar datatype

-- MMS_R_PY_Payroll_Summ_CS_Rep_1 'Y','01','','','R016','R016','0461','0461','CA','','SL','22/11/2008','21/12/2008' ...

but problem is still there

Question is that

IF control is not steping in

following condition

Becoz @Par1 never be blank

if @Par1=''

begin

select ' ' Par1,' 'Par2,' ' Par3----Notice paas blank space and report work fine

end

then why it...

Gail

I have no intention to change collation of system table.

look below proc

Suppose I had a proc attached with a report

Create Proc ProcName

@PAr1 varchar(4)

@PAr2 varchar(4)

@PAr3 varchar(4)

as

if @Par1=''

begin

select '' Par1,''Par2,''Par3

return

end

Craete #Temp

(

PAr1 varchar(4)

PAr2...

Dear Gail

that is my actual problem

I did every thing my DB

and then check that there some few other collation for these system table.

may be these table is creating trouble...