Anyone come across this one:
I have a report that has to print out its figures in Euros or Dollars - I
pass in the locale code as a parameter (DE-DE or EN-US) respectively and
change the language of the report to one of those values via an expression.
The report runs, looks fine on any PC over the web. US countries have their
figures preceded by a $, European countries figures are preceded by a Euro
symbol. When I come to export the results to PDF, again its fine on my PC,
but the same report exported on seemingly arbitrary PC's elsewhere in the
building have the numerical figures garbled into some unrecognisable font.
Any ideas?
MickIf anyone is interested, this was an Adobe issue - v5 doesn't support the
Euro symbol (upgrading to V6 solved the problem)
"Mick Horne" <mick.horne@.conchango.com> wrote in message
news:%23cgQs2eXEHA.952@.TK2MSFTNGP10.phx.gbl...
> Anyone come across this one:
> I have a report that has to print out its figures in Euros or Dollars - I
> pass in the locale code as a parameter (DE-DE or EN-US) respectively and
> change the language of the report to one of those values via an
expression.
> The report runs, looks fine on any PC over the web. US countries have
their
> figures preceded by a $, European countries figures are preceded by a Euro
> symbol. When I come to export the results to PDF, again its fine on my
PC,
> but the same report exported on seemingly arbitrary PC's elsewhere in the
> building have the numerical figures garbled into some unrecognisable font.
> Any ideas?
> Mick
>
Showing posts with label across. Show all posts
Showing posts with label across. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
Pblm with Nested transactions
Friends,
I've a very basic doubt with Nested transactions (across procedures) in SQL Server and i guess the given below sample code illustarates my doubt well more than my words ..
I've a Proc1 like this
create procedure sp_proc1
as
begin
begin tran sp_proc1
insert into tab1 values (1,2)
exec sp_proc2 1
if <Some cdn statement>
rollback tran sp_proc1
else
commit tran sp_proc1
end
and called proc sp_proc2 is like this
create procedure sp_proc2
(
@.val1 int
)
as
begin tran proc2
update tab2 set col1 = 5
IF <some cdn statement>
begin
rollback tran proc2
end
else
begin
commit tran proc2
end
The pblm is when the 1st proc is executed and when the cdn statement in the 2nd proc is sucess, then it results with the error
Failed to retreive execution plan: Cannot roll back proc2. No transaction or savepoint of that name was found.
any suggestions
--SQLPgmrbegin tran proc2
update tab2 set col1 = 5
IF <some cdn statement> << Checking your tab2 but it still in tran !
begin
...
I think you probably are trying to check some thing that you are not commit yet!
I've a very basic doubt with Nested transactions (across procedures) in SQL Server and i guess the given below sample code illustarates my doubt well more than my words ..
I've a Proc1 like this
create procedure sp_proc1
as
begin
begin tran sp_proc1
insert into tab1 values (1,2)
exec sp_proc2 1
if <Some cdn statement>
rollback tran sp_proc1
else
commit tran sp_proc1
end
and called proc sp_proc2 is like this
create procedure sp_proc2
(
@.val1 int
)
as
begin tran proc2
update tab2 set col1 = 5
IF <some cdn statement>
begin
rollback tran proc2
end
else
begin
commit tran proc2
end
The pblm is when the 1st proc is executed and when the cdn statement in the 2nd proc is sucess, then it results with the error
Failed to retreive execution plan: Cannot roll back proc2. No transaction or savepoint of that name was found.
any suggestions
--SQLPgmrbegin tran proc2
update tab2 set col1 = 5
IF <some cdn statement> << Checking your tab2 but it still in tran !
begin
...
I think you probably are trying to check some thing that you are not commit yet!
Monday, March 12, 2012
PATCH for Article 817326
I am desperately looking for the patch across the internet
cause i really need this fix basically for WINDOWS
platform listed as follows:
Msbase.jar v 2.2.0030
Mssqlserver.jar v 2.2.0030
Msutil.jar v 2.2.0030
Please advise where can i extract all these patches.
DondonYou need to contact Microsoft product support. As the article states, the
fix is only available directly through them. You won't readily find them on
the Internet because of this.
"Dondon" <dondon@.newspage.com.sg> wrote in message
news:016701c38707$3bd80700$a001280a@.phx.gbl...
> I am desperately looking for the patch across the internet
> cause i really need this fix basically for WINDOWS
> platform listed as follows:
> Msbase.jar v 2.2.0030
> Mssqlserver.jar v 2.2.0030
> Msutil.jar v 2.2.0030
> Please advise where can i extract all these patches.
> Dondon
cause i really need this fix basically for WINDOWS
platform listed as follows:
Msbase.jar v 2.2.0030
Mssqlserver.jar v 2.2.0030
Msutil.jar v 2.2.0030
Please advise where can i extract all these patches.
DondonYou need to contact Microsoft product support. As the article states, the
fix is only available directly through them. You won't readily find them on
the Internet because of this.
"Dondon" <dondon@.newspage.com.sg> wrote in message
news:016701c38707$3bd80700$a001280a@.phx.gbl...
> I am desperately looking for the patch across the internet
> cause i really need this fix basically for WINDOWS
> platform listed as follows:
> Msbase.jar v 2.2.0030
> Mssqlserver.jar v 2.2.0030
> Msutil.jar v 2.2.0030
> Please advise where can i extract all these patches.
> Dondon
Subscribe to:
Posts (Atom)