| Author |
 Topic  |
|
|
Johny.Eduardo
Starting Member
Singapore
3 Posts |
 Posted - 11/03/2012 : 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
India
47173 Posts |
Posted - 11/03/2012 : 22:45:26
|
can you post whats the expression used for showing description?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
Johny.Eduardo
Starting Member
Singapore
3 Posts |
Posted - 11/04/2012 : 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
|
Edited by - Johny.Eduardo on 11/04/2012 09:36:25 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
Posted - 11/04/2012 : 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/
|
|
|
|
Johny.Eduardo
Starting Member
Singapore
3 Posts |
Posted - 11/04/2012 : 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 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47173 Posts |
Posted - 11/05/2012 : 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/
|
|
|
| |
Topic |
|
Reporting service give different resullt
