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
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Reporting service give different resullt

Author  Topic 

Johny.Eduardo
Starting Member

3 Posts

Posted - 2012-11-03 : 19:27:03
Hi Experts,


After deploying the reports that developed using reporting service, the result of the view report in the internet explorer is different with the result of view report in the visual studio.

here is the visual studio view report result and IE view report result screen capture that available in this link:
http://scn.sap.com/thread/3261168

I am using windows pro 7 and sql 2008 r2 standard edition. My SAP B1 is SAP B1 8.82 PL08. Please help how to make the view report in the IE as same as view report in the visual studio ? I appreciate your help so much. Thank you

Johny
27 Views

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-11-03 : 22:45:26
can you post whats the expression used for showing description?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Johny.Eduardo
Starting Member

3 Posts

Posted - 2012-11-04 : 09:25:30
quote:
Originally posted by visakh16

can you post whats the expression used for showing description?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/





Hi Visakh,


Thank you for your prompt reply.

Here is the expression I am using:
update #COAStruct
set AcctName =
case levels
when 1 then '' + AcctName
when 2 then ' ' + AcctName
when 3 then ' ' + AcctName
when 4 then ' ' + AcctName
when 5 then ' ' + AcctName
else '????????????????????????'
end

Here is scn link that showing the screen capture of the expression:

http://scn.sap.com/thread/3261168



The complete scripts are as follows:

create table #COAStruct (ID int identity(1,1),AcctCode nvarchar(20),AcctName nvarchar(200),FormatCode nvarchar(20),
levels int, SortingCode nvarchar(100),FatherNum nvarchar(20) )

declare @level table (ID int identity(1,1),AcctCode nvarchar(100), AcctName nvarchar(100))

insert into @level
select AcctCode,AcctName
from OACT
where levels = 1


declare @Count int
select @Count = count(*)
from @level
declare @Step int
set @Step = 1
declare @AcctCode nvarchar(100)
while @Step <= @Count
begin
select @AcctCode = AcctCode from @level where ID = @Step
insert into #COAStruct
select AcctCode,AcctName,FormatCode,levels,'',FatherNum
from oact
where AcctCode = @AcctCode

exec "@SING_GEN_COA_SUBPROC" @AcctCode
insert into #COAStruct
select AcctCode,'Total '+AcctName,FormatCode,levels,'',FatherNum
from oact
where AcctCode = @AcctCode

set @Step = @Step + 1
end

update #COAStruct
set SortingCode = [DBO].[@SING_UDF_PADL] (cast(ID as nvarchar(20)),'0',10)

update #COAStruct
set AcctName =
case levels
when 1 then '' + AcctName
when 2 then ' ' + AcctName
when 3 then ' ' + AcctName
when 4 then ' ' + AcctName
when 5 then ' ' + AcctName
else '????????????????????????'
end

declare @CharLen int
declare @TotalString nvarchar(30)

if @Levels = 1
begin
set @CharLen = 10
set @TotalString = '-Total '
end
else
if @Levels = 2
begin
set @CharLen = 12
set @TotalString = '- Total '
end
else
if @Levels = 3
begin
set @CharLen = 17
set @TotalString = '- Total '
end
else
if @Levels = 4
begin
set @CharLen = 22
set @TotalString = '- Total '
end
else
if @Levels = 5
begin
set @CharLen = 27
set @TotalString = '- Total '
end

Please help me to solve this problem. Thank you


Regads,
Johny
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-11-04 : 11:25:08
why not do the spacing inside report using SSRS expression? you can use Spaces() function for that

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Johny.Eduardo
Starting Member

3 Posts

Posted - 2012-11-04 : 17:16:13
quote:
Originally posted by visakh16

why not do the spacing inside report using SSRS expression? you can use Spaces() function for that

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/





I have used it but it is not working. The report still shows different result of view report.

I have checked that the both view reports are same if I am using SQL 2008 and windows 7 ultimate.
Is it bugs in the SQL 2008 R2 ?


Thanks and Rgds,
Johny
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-11-05 : 21:12:56
I'm aware any bugs like that. It might have to do with browser i guess. Try in lower version of IE and see

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -