out put not displaying correctly

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

out put not displaying correctly

Author

Topic

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-14 : 11:22:59

please help

see my sp.

--
--drop table vvv
--create table vvv(rowid integer identity(1,1), ccc text)
--exec vvvvvvv
alter procedure vvvvvvv
as
begin
IF not EXISTS(SELECT name 
	  FROM 	 sysobjects 
	  WHERE  name = N'vvv' 
	  AND 	 type = 'U')
   create table vvv(rowid integer identity(1,1), ccc text)

--select * from vvv
--delete vvv

DECLARE @SSTR AS VARCHAR(8000)
SET @SSTR =Replicate(' ',15) +  + '#1' + '|' + Replicate(' ',15) +  + '#2' + '|' +
Replicate(' ',15) +  + '#3' + '|' +
Replicate(' ',15) +  + '#4' + '|' +
Replicate(' ',15) +  + '#5' + '|' +
Replicate(' ',15) +  + '#6' + '|' 

--SELECT CHARINDEX('#1',@SSTR)
--select  @SSTR = STUFF(@SSTR ,1 ,CHARINDEX('#1',@SSTR),'cccccccccckumar')
--select  @SSTR = STUFF(@SSTR ,1 ,CHARINDEX('#2',@SSTR),'cccccccccckumar')
--select  @SSTR = STUFF(@SSTR ,CHARINDEX('#1',@SSTR),1,convert(char(8),'cccccccccckk'))
---select  @SSTR = STUFF(@SSTR ,CHARINDEX('#3',@SSTR)-15,1,convert(char(8),'cccccccccckk'))
---select  @SSTR = STUFF(@SSTR ,CHARINDEX('#4',@SSTR)-15,1,convert(char(8),'gfdfgd'))
--select CHARINDEX('#1|',@SSTR)
---select CHARINDEX('#2|',@SSTR)
--select substring(@SSTR,CHARINDEX('#1|',@SSTR)+2,CHARINDEX('#2|',@SSTR)-CHARINDEX('#1|',@SSTR)+2)
--select @sstr=
select  @SSTR = STUFF(@SSTR ,1,CHARINDEX('#1|',@SSTR)-5,convert(char(11),'vvccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#1|',@SSTR)+3,CHARINDEX('#2|',@SSTR)-CHARINDEX('#1|',@SSTR)-3,convert(char(15),'vvcccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#2|',@SSTR)+3,CHARINDEX('#3|',@SSTR)-CHARINDEX('#2|',@SSTR)-3,convert(char(15),'vvcccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#3|',@SSTR)+3,CHARINDEX('#4|',@SSTR)-CHARINDEX('#3|',@SSTR)-3,convert(char(15),'vvcccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#4|',@SSTR)+3,CHARINDEX('#5|',@SSTR)-CHARINDEX('#4|',@SSTR)-3,convert(char(15),'vvcccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#5|',@SSTR)+3,CHARINDEX('#6|',@SSTR)-CHARINDEX('#5|',@SSTR)-3,convert(char(15),'vvcccccccccc'))
--select @sstr
select @sstr=replace(@SSTR,'#1','  ')
select @sstr=replace(@SSTR,'#2','  ')
select @sstr=replace(@SSTR,'#3','  ')
select @sstr=replace(@SSTR,'#4','  ')
select @sstr=replace(@SSTR,'#5','  ')
select @sstr=replace(@SSTR,'#6','  ')
INSERT INTO VVV
select @sstr
SET @SSTR =Replicate(' ',15) +  + '#1' + '|' + Replicate(' ',15) +  + '#2' + '|' +
Replicate(' ',15) +  + '#3' + '|' +
Replicate(' ',15) +  + '#4' + '|' +
Replicate(' ',15) +  + '#5' + '|' +
Replicate(' ',15) +  + '#6' + '|' 
select  @SSTR = STUFF(@SSTR ,1,CHARINDEX('#1|',@SSTR)-5,convert(char(11),'vvcvvvvvvvvvvvvvvvvcccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#1|',@SSTR)+3,CHARINDEX('#2|',@SSTR)-CHARINDEX('#1|',@SSTR)-3,convert(char(15),'vvvvvvvv'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#2|',@SSTR)+3,CHARINDEX('#3|',@SSTR)-CHARINDEX('#2|',@SSTR)-3,convert(char(15),'vvcvvvvvvvvvvvvccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#3|',@SSTR)+3,CHARINDEX('#4|',@SSTR)-CHARINDEX('#3|',@SSTR)-3,convert(char(15),'vvccvvvvvvcccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#4|',@SSTR)+3,CHARINDEX('#5|',@SSTR)-CHARINDEX('#4|',@SSTR)-3,convert(char(15),'vvccvvvvvvvvcccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#5|',@SSTR)+3,CHARINDEX('#6|',@SSTR)-CHARINDEX('#5|',@SSTR)-3,convert(char(15),'vvccvvvvvvvvvvvvvvvvvvvvcccccccc'))
select @sstr=replace(@SSTR,'#1','  ')
select @sstr=replace(@SSTR,'#2','  ')
select @sstr=replace(@SSTR,'#3','  ')
select @sstr=replace(@SSTR,'#4','  ')
select @sstr=replace(@SSTR,'#5','  ')
select @sstr=replace(@SSTR,'#6','  ')
INSERT INTO VVV
select @sstr
SET @SSTR =Replicate(' ',15) +  + '#1' + '|' + Replicate(' ',15) +  + '#2' + '|' +
Replicate(' ',15) +  + '#3' + '|' +
Replicate(' ',15) +  + '#4' + '|' +
Replicate(' ',15) +  + '#5' + '|' +
Replicate(' ',15) +  + '#6' + '|' 
select  @SSTR = STUFF(@SSTR ,1,CHARINDEX('#1|',@SSTR)-5,convert(char(11),'vvcssssssssssssssscccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#1|',@SSTR)+3,CHARINDEX('#2|',@SSTR)-CHARINDEX('#1|',@SSTR)-3,convert(char(15),'vvccccvvvvvvvvvvvvvvvvvcccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#2|',@SSTR)+3,CHARINDEX('#3|',@SSTR)-CHARINDEX('#2|',@SSTR)-3,convert(char(15),'vvcccccvvvvvvvvvccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#3|',@SSTR)+3,CHARINDEX('#4|',@SSTR)-CHARINDEX('#3|',@SSTR)-3,convert(char(15),'vvccccvvvvvvvvvvvvvcccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#4|',@SSTR)+3,CHARINDEX('#5|',@SSTR)-CHARINDEX('#4|',@SSTR)-3,convert(char(15),'vvcccvvvvvvvvvvvvvvvvvvvvvvvvvvvccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#5|',@SSTR)+3,CHARINDEX('#6|',@SSTR)-CHARINDEX('#5|',@SSTR)-3,convert(char(15),'vvccccvvvvvvvvvvvvvvvvvvvvvvcccccc'))
select @sstr=replace(@SSTR,'#1','  ')
select @sstr=replace(@SSTR,'#2','  ')
select @sstr=replace(@SSTR,'#3','  ')
select @sstr=replace(@SSTR,'#4','  ')
select @sstr=replace(@SSTR,'#5','  ')
select @sstr=replace(@SSTR,'#6','  ')
INSERT INTO VVV
select @sstr
SET @SSTR =Replicate(' ',15) +  + '#1' + '|' + Replicate(' ',15) +  + '#2' + '|' +
Replicate(' ',15) +  + '#3' + '|' +
Replicate(' ',15) +  + '#4' + '|' +
Replicate(' ',15) +  + '#5' + '|' +
Replicate(' ',15) +  + '#6' + '|' 
select  @SSTR = STUFF(@SSTR ,1,CHARINDEX('#1|',@SSTR)-5,convert(char(11),'vvccccccffffffffffffffffc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#1|',@SSTR)+3,CHARINDEX('#2|',@SSTR)-CHARINDEX('#1|',@SSTR)-3,convert(char(15),'vvccvvvvvvvcccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#2|',@SSTR)+3,CHARINDEX('#3|',@SSTR)-CHARINDEX('#2|',@SSTR)-3,convert(char(15),'vvcvvvvvvvvvvvvvccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#3|',@SSTR)+3,CHARINDEX('#4|',@SSTR)-CHARINDEX('#3|',@SSTR)-3,convert(char(15),'vvcvvvvvvvvvvvvvvvccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#4|',@SSTR)+3,CHARINDEX('#5|',@SSTR)-CHARINDEX('#4|',@SSTR)-3,convert(char(15),'vvcvvvvvvvvvvvvvvccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#5|',@SSTR)+3,CHARINDEX('#6|',@SSTR)-CHARINDEX('#5|',@SSTR)-3,convert(char(15),'vvccvvvvvvvvvvvvvvvvvvvvvvcccccccc'))
select @sstr=replace(@SSTR,'#1','  ')
select @sstr=replace(@SSTR,'#2','  ')
select @sstr=replace(@SSTR,'#3','  ')
select @sstr=replace(@SSTR,'#4','  ')
select @sstr=replace(@SSTR,'#5','  ')
select @sstr=replace(@SSTR,'#6','  ')
INSERT INTO VVV
select @sstr
SET @SSTR =Replicate(' ',15) +  + '#1' + '|' + Replicate(' ',15) +  + '#2' + '|' +
Replicate(' ',15) +  + '#3' + '|' +
Replicate(' ',15) +  + '#4' + '|' +
Replicate(' ',15) +  + '#5' + '|' +
Replicate(' ',15) +  + '#6' + '|' 
select  @SSTR = STUFF(@SSTR ,1,CHARINDEX('#1|',@SSTR)-5,convert(char(11),'vvcxxxxxxxxxxxxxxccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#1|',@SSTR)+3,CHARINDEX('#2|',@SSTR)-CHARINDEX('#1|',@SSTR)-3,convert(char(15),'vvcxxxxxxxxxxxxxccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#2|',@SSTR)+3,CHARINDEX('#3|',@SSTR)-CHARINDEX('#2|',@SSTR)-3,convert(char(15),'vvcxxxxxxxccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#3|',@SSTR)+3,CHARINDEX('#4|',@SSTR)-CHARINDEX('#3|',@SSTR)-3,convert(char(15),'vvccxxxxxxxxxxxxcccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#4|',@SSTR)+3,CHARINDEX('#5|',@SSTR)-CHARINDEX('#4|',@SSTR)-3,convert(char(15),'vvcxxxxxxxxxccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#5|',@SSTR)+3,CHARINDEX('#6|',@SSTR)-CHARINDEX('#5|',@SSTR)-3,convert(char(15),'vvcxxxxxxxxxxccccccccc'))
select @sstr=replace(@SSTR,'#1','  ')
select @sstr=replace(@SSTR,'#2','  ')
select @sstr=replace(@SSTR,'#3','  ')
select @sstr=replace(@SSTR,'#4','  ')
select @sstr=replace(@SSTR,'#5','  ')
select @sstr=replace(@SSTR,'#6','  ')
INSERT INTO VVV
select @sstr
SET @SSTR =Replicate(' ',15) +  + '#1' + '|' + Replicate(' ',15) +  + '#2' + '|' +
Replicate(' ',15) +  + '#3' + '|' +
Replicate(' ',15) +  + '#4' + '|' +
Replicate(' ',15) +  + '#5' + '|' +
Replicate(' ',15) +  + '#6' + '|' 
select  @SSTR = STUFF(@SSTR ,1,CHARINDEX('#1|',@SSTR)-5,convert(char(11),'vassssssssssssssssssssvccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#1|',@SSTR)+3,CHARINDEX('#2|',@SSTR)-CHARINDEX('#1|',@SSTR)-3,convert(char(15),'vvxxxxxxxxxxcccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#2|',@SSTR)+3,CHARINDEX('#3|',@SSTR)-CHARINDEX('#2|',@SSTR)-3,convert(char(15),'vvxxxxxxxxxcccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#3|',@SSTR)+3,CHARINDEX('#4|',@SSTR)-CHARINDEX('#3|',@SSTR)-3,convert(char(15),'vvccxxxxxxxxcccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#4|',@SSTR)+3,CHARINDEX('#5|',@SSTR)-CHARINDEX('#4|',@SSTR)-3,convert(char(15),'vvcxxxxxxxxxccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#5|',@SSTR)+3,CHARINDEX('#6|',@SSTR)-CHARINDEX('#5|',@SSTR)-3,convert(char(15),'vvcxxxxxxxxxxxxccccccccc'))
select @sstr=replace(@SSTR,'#1','  ')
select @sstr=replace(@SSTR,'#2','  ')
select @sstr=replace(@SSTR,'#3','  ')
select @sstr=replace(@SSTR,'#4','  ')
select @sstr=replace(@SSTR,'#5','  ')
select @sstr=replace(@SSTR,'#6','  ')
INSERT INTO VVV
select @sstr
SET @SSTR =Replicate(' ',15) +  + '#1' + '|' + Replicate(' ',15) +  + '#2' + '|' +
Replicate(' ',15) +  + '#3' + '|' +
Replicate(' ',15) +  + '#4' + '|' +
Replicate(' ',15) +  + '#5' + '|' +
Replicate(' ',15) +  + '#6' + '|' 
select  @SSTR = STUFF(@SSTR ,1,CHARINDEX('#1|',@SSTR)-5,convert(char(11),'vvcxxxxxxxxxxxxxxxxxxxxxcccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#1|',@SSTR)+3,CHARINDEX('#2|',@SSTR)-CHARINDEX('#1|',@SSTR)-3,convert(char(15),'vvccccxxxxxxxxxxxcccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#2|',@SSTR)+3,CHARINDEX('#3|',@SSTR)-CHARINDEX('#2|',@SSTR)-3,convert(char(15),'vxxxxxxxxxxxxvcccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#3|',@SSTR)+3,CHARINDEX('#4|',@SSTR)-CHARINDEX('#3|',@SSTR)-3,convert(char(15),'vvccxxxxxxxcccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#4|',@SSTR)+3,CHARINDEX('#5|',@SSTR)-CHARINDEX('#4|',@SSTR)-3,convert(char(15),'vvxxxxxxxxxxxxxxxcccccccccc'))
select  @SSTR = STUFF(@SSTR ,CHARINDEX('#5|',@SSTR)+3,CHARINDEX('#6|',@SSTR)-CHARINDEX('#5|',@SSTR)-3,convert(char(15),'vvxxxxxxxxxxxxxxxxcccccccccc'))



select @sstr=replace(@SSTR,'#1','  ')
select @sstr=replace(@SSTR,'#2','  ')
select @sstr=replace(@SSTR,'#3','  ')
select @sstr=replace(@SSTR,'#4','  ')
select @sstr=replace(@SSTR,'#5','  ')
select @sstr=replace(@SSTR,'#6','  ')

INSERT INTO VVV

select @sstr

select * from vvv

end

just run this code

in reporting service i just need to diaply this field but is not aligned correctly.
in sql the output is correct but why not in reporting service .
please just run this script and see.

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-14 : 11:28:50

see this sql output properly aligned

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-14 : 11:31:41

se in sql reporting
i put that filed in a table

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-14 : 11:34:30

see in reprot server o/p is not alligned
[img][/http://img63.imageshack.us/img63/9194/clip37rd.jpgimg]

please help

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-14 : 11:35:55

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-14 : 13:05:52

problem solved it was an issue with the font settings

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-09-14 : 13:07:47

For future reference, you should include all of this information in your first post. When other people see multiple posts have been made to a thread, they might think it has been answered already. So rather than adding additional information in a new post, go back and edit your original so that it appears to us that it isn't solved.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources