SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Reporting service give different resullt
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Johny.Eduardo
Starting Member

Singapore
3 Posts

Posted - 11/03/2012 :  19:27:03  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 11/03/2012 :  22:45:26  Show Profile  Reply with Quote
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

Singapore
3 Posts

Posted - 11/04/2012 :  09:25:30  Show Profile  Reply with Quote
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

Edited by - Johny.Eduardo on 11/04/2012 09:36:25
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 11/04/2012 :  11:25:08  Show Profile  Reply with Quote
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

Singapore
3 Posts

Posted - 11/04/2012 :  17:16:13  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 11/05/2012 :  21:12:56  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000