Showing posts with label printing. Show all posts
Showing posts with label printing. Show all posts

Wednesday, March 28, 2012

if exists help

Hi There,
What is the problem here, I can not find out, it always execute sql instead
of printing 'no'
if exists (select * from dbo.sysobjects where id = object_id('dividend') )
if exists (select syscolumns.name
from sysobjects inner join
syscolumns on
sysobjects.id = syscolumns.id
where sysobjects.name = 'member' and syscolumns.name = 'adgdr1' )
begin
SELECT 'ADMINSYS_DN_AVC' as [SchemeName], MEMBER.[PLAN],
DIVIDEND.DIVIDREF, DIVIDEND.AMOUNT, DIVIDEND.TAX_RELIEF, DIVIDEND.SECURITYRF
,
DIVIDEND.TAX_REL_PD,
DIVIDEND.TAXTRAN
FROM MEMBER INNER JOIN
DIVIDEND ON MEMBER.[PLAN] = DIVIDEND.[PLAN]
WHERE (DIVIDEND.TAX_RELIEF <> 0) AND (DIVIDEND.TAXTRAN = 0) AND
(MEMBER.MigrationFlag = 'C') OR
(DIVIDEND.TAX_RELIEF <> 0) AND (DIVIDEND.TAXTRAN IS
NULL) AND (MEMBER.MigrationFlag = 'C')
end
else
print 'no'
if write something like this it works fine
if exists (select * from dbo.sysobjects where id = object_id('dividend') )
if exists (select syscolumns.name
from sysobjects inner join
syscolumns on
sysobjects.id = syscolumns.id
where sysobjects.name = 'member' and syscolumns.name = 'addkr1' )
print 'yes'
else
print 'no'
Thanks
GaneshGanesh wrote:
> Hi There,
> What is the problem here, I can not find out, it always execute sql
> instead of printing 'no'
>
> if exists (select * from dbo.sysobjects where id =
> object_id('dividend') )
> if exists (select syscolumns.name
> from sysobjects inner join
> syscolumns on
> sysobjects.id = syscolumns.id
> where sysobjects.name = 'member' and syscolumns.name = 'adgdr1' )
> begin
> SELECT 'ADMINSYS_DN_AVC' as [SchemeName], MEMBER.[PLAN],
> DIVIDEND.DIVIDREF, DIVIDEND.AMOUNT, DIVIDEND.TAX_RELIEF,
> DIVIDEND.SECURITYRF, DIVIDEND.TAX_REL_PD,
> DIVIDEND.TAXTRAN
> FROM MEMBER INNER JOIN
> DIVIDEND ON MEMBER.[PLAN] = DIVIDEND.[PLAN]
> WHERE (DIVIDEND.TAX_RELIEF <> 0) AND (DIVIDEND.TAXTRAN = 0) AND
> (MEMBER.MigrationFlag = 'C') OR
> (DIVIDEND.TAX_RELIEF <> 0) AND (DIVIDEND.TAXTRAN
> IS NULL) AND (MEMBER.MigrationFlag = 'C')
> end
> else
> print 'no'
>
> if write something like this it works fine
>
> if exists (select * from dbo.sysobjects where id =
> object_id('dividend') )
> if exists (select syscolumns.name
> from sysobjects inner join
> syscolumns on
> sysobjects.id = syscolumns.id
> where sysobjects.name = 'member' and syscolumns.name = 'addkr1' )
> print 'yes'
> else
> print 'no'
Can you explain what you want the script to do so we can validate the
code you posted?
David Gugick - SQL Server MVP
Quest Software|||I have to guess a bit here.
Change the beginning of your procedure to this:

> if exists (select * from dbo.sysobjects where id = object_id('dividend') )
AND exists (select syscolumns.name ...
"Ganesh" <gsganesh@.yahoo.com> wrote in message
news:99A82BDA-F5B5-40DC-8C18-434D6B9C2665@.microsoft.com...
> Hi There,
> What is the problem here, I can not find out, it always execute sql
> instead
> of printing 'no'
>
> if exists (select * from dbo.sysobjects where id = object_id('dividend') )
> if exists (select syscolumns.name
> from sysobjects inner join
> syscolumns on
> sysobjects.id = syscolumns.id
> where sysobjects.name = 'member' and syscolumns.name = 'adgdr1' )
> begin
> SELECT 'ADMINSYS_DN_AVC' as [SchemeName], MEMBER.[PLAN],
> DIVIDEND.DIVIDREF, DIVIDEND.AMOUNT, DIVIDEND.TAX_RELIEF,
> DIVIDEND.SECURITYRF,
> DIVIDEND.TAX_REL_PD,
> DIVIDEND.TAXTRAN
> FROM MEMBER INNER JOIN
> DIVIDEND ON MEMBER.[PLAN] = DIVIDEND.[PLAN]
> WHERE (DIVIDEND.TAX_RELIEF <> 0) AND (DIVIDEND.TAXTRAN = 0) AND
> (MEMBER.MigrationFlag = 'C') OR
> (DIVIDEND.TAX_RELIEF <> 0) AND (DIVIDEND.TAXTRAN IS
> NULL) AND (MEMBER.MigrationFlag = 'C')
> end
> else
> print 'no'
>
> if write something like this it works fine
>
> if exists (select * from dbo.sysobjects where id = object_id('dividend') )
> if exists (select syscolumns.name
> from sysobjects inner join
> syscolumns on
> sysobjects.id = syscolumns.id
> where sysobjects.name = 'member' and syscolumns.name = 'addkr1' )
> print 'yes'
> else
> print 'no'
>
> --
> Thanks
> Ganesh|||Basically,
I want to execute a select statement based on the table and field existence
for each database
/* Powered by General SQL Parser at www.sqlparser.com */
IF EXISTS (SELECT *
FROM DBO.SYSOBJECTS
WHERE ID = OBJECT_ID('dividend'))
AND EXISTS (SELECT SYSCOLUMNS.NAME
FROM SYSOBJECTS
INNER JOIN SYSCOLUMNS
ON SYSOBJECTS.ID = SYSCOLUMNS.ID
WHERE SYSOBJECTS.NAME = 'member'
AND SYSCOLUMNS.NAME = 'adgdr1')
BEGIN
SELECT 'ADMINSYS_DN_AVC' AS [SchemeName],
MEMBER.[PLAN],
DIVIDEND.DIVIDREF,
DIVIDEND.AMOUNT,
DIVIDEND.TAX_RELIEF,
DIVIDEND.SECURITYRF,
DIVIDEND.TAX_REL_PD,
DIVIDEND.TAXTRAN
FROM MEMBER
INNER JOIN DIVIDEND
ON MEMBER.[PLAN] = DIVIDEND.[PLAN]
WHERE (DIVIDEND.TAX_RELIEF <> 0)
AND (DIVIDEND.TAXTRAN = 0)
AND (MEMBER.MIGRATIONFLAG = 'C')
OR (DIVIDEND.TAX_RELIEF <> 0)
AND (DIVIDEND.TAXTRAN IS NULL )
AND (MEMBER.MIGRATIONFLAG = 'C')
END
ELSE
PRINT 'no'
Thanks
Ganesh
"Raymond D'Anjou" wrote:

> I have to guess a bit here.
> Change the beginning of your procedure to this:
>
> AND exists (select syscolumns.name ...
> "Ganesh" <gsganesh@.yahoo.com> wrote in message
> news:99A82BDA-F5B5-40DC-8C18-434D6B9C2665@.microsoft.com...
>
>

Monday, March 26, 2012

IE Scripts and Printing Error

hi i am using the RSS 2000 version with the service pack 2. it all works fine in my development machine and other test machines in the office but when i take it out into the real world and try to print IE says it cant run some scripts. i have checked the ie security settings and tried enabling all scripts and still the report viewer insists it cant run some scripts and gives me an error. does any one know where i can change settings to enable my reports to print? the computers i am working on are under a domain with its own security settings i know nothing about but if there is anything i can change on the client machine's IE configuration to enable scripts specific to reporting services to run that will be good to know.
ah.. finally found some old posts that talked about this in this forum. finally all fixed up thanks to google search. damned forum search didn't turn up anything. grrrrr!!!
|||Can you please share where you found this information? I, too, have been looking for a solution and have been unsuccessful so far. Thanks|||I am facing similar problem, when print button is pressed, from a modal dialog window, i get an error 0x80004005 which states "Error occurred while printing", when I press OK, I get the IE script error, I am calling the report into a modal dialog window from an ASP page. I have Windows 2000 sp 4, IE 6.0 (no SP applied.)|||The problem was solved after installation of an older version of Windows 2000 Server. One thing is clear that there is a need to look into the reporting services, it is having so many bugs and since last one year microsoft has released no service pack for it. There is no proper support for it.sql

IE Scripts and Printing Error

hi i am using the RSS 2000 version with the service pack 2. it all works fine in my development machine and other test machines in the office but when i take it out into the real world and try to print IE says it cant run some scripts. i have checked the ie security settings and tried enabling all scripts and still the report viewer insists it cant run some scripts and gives me an error. does any one know where i can change settings to enable my reports to print? the computers i am working on are under a domain with its own security settings i know nothing about but if there is anything i can change on the client machine's IE configuration to enable scripts specific to reporting services to run that will be good to know.
ah.. finally found some old posts that talked about this in this forum. finally all fixed up thanks to google search. damned forum search didn't turn up anything. grrrrr!!!
|||Can you please share where you found this information? I, too, have been looking for a solution and have been unsuccessful so far. Thanks|||I am facing similar problem, when print button is pressed, from a modal dialog window, i get an error 0x80004005 which states "Error occurred while printing", when I press OK, I get the IE script error, I am calling the report into a modal dialog window from an ASP page. I have Windows 2000 sp 4, IE 6.0 (no SP applied.)|||The problem was solved after installation of an older version of Windows 2000 Server. One thing is clear that there is a need to look into the reporting services, it is having so many bugs and since last one year microsoft has released no service pack for it. There is no proper support for it.

Friday, March 23, 2012

IE browser not printing multiple page reports

Hi,
We are currently running RS 2000, sp2. When the user prints a multiple paged
report from the IE browser, it is printing the current page only. Is this an
issue or is it just a setting of some sort?
Thanks for your help!It sounds to me like you are using the printing functionality from IE, not
the new print icon on the toolbar of Report Manager.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:8C8E0E0A-FCF1-4803-B360-B3B95267B118@.microsoft.com...
> Hi,
> We are currently running RS 2000, sp2. When the user prints a multiple
> paged
> report from the IE browser, it is printing the current page only. Is this
> an
> issue or is it just a setting of some sort?
> Thanks for your help!