everybody except 1 login which is non-sa in sql server 2000.
Even sa should not be able to access the schema.
Also are there anyways encrypt data in sql server 2000w
Anyone who has access to the database has access to examine, but not
necessarily modify, the schema.
If you Google for encryption and SQL Server you should find a couple of
hits. I assume that you want the data encrypted in the database.
If you mean the files themselves, an alternative is to use NTFS encryption
on the files.
Russell Fields
"w" <wilcorning@.hotmail.com> wrote in message
news:6a24cdf7.0402261134.be0b6ca@.posting.google.com...
> everybody except 1 login which is non-sa in sql server 2000.
> Even sa should not be able to access the schema.
> Also are there anyways encrypt data in sql server 2000
Showing posts with label hide. Show all posts
Showing posts with label hide. Show all posts
Sunday, February 19, 2012
How to i hide my database schema from...
everybody except 1 login which is non-sa in sql server 2000.
Even sa should not be able to access the schema.
Also are there anyways encrypt data in sql server 2000w
Anyone who has access to the database has access to examine, but not
necessarily modify, the schema.
If you Google for encryption and SQL Server you should find a couple of
hits. I assume that you want the data encrypted in the database.
If you mean the files themselves, an alternative is to use NTFS encryption
on the files.
Russell Fields
"w" <wilcorning@.hotmail.com> wrote in message
news:6a24cdf7.0402261134.be0b6ca@.posting.google.com...
> everybody except 1 login which is non-sa in sql server 2000.
> Even sa should not be able to access the schema.
> Also are there anyways encrypt data in sql server 2000
Even sa should not be able to access the schema.
Also are there anyways encrypt data in sql server 2000w
Anyone who has access to the database has access to examine, but not
necessarily modify, the schema.
If you Google for encryption and SQL Server you should find a couple of
hits. I assume that you want the data encrypted in the database.
If you mean the files themselves, an alternative is to use NTFS encryption
on the files.
Russell Fields
"w" <wilcorning@.hotmail.com> wrote in message
news:6a24cdf7.0402261134.be0b6ca@.posting.google.com...
> everybody except 1 login which is non-sa in sql server 2000.
> Even sa should not be able to access the schema.
> Also are there anyways encrypt data in sql server 2000
How to hide/show parameter dynamic?
There is a date range parameter in my rdl, the list value is "This Week","This Month", "This Year" and "Custom", when user choose "Custom", then display two parameter "Date From" and "Date To" to select custom date range.
My question, how to show "Date From" and "Date To" when user choose "Custom", and will hide these two parameter when user choose other item.
Thanks
You don't say what kind of element Date To and Date From are, but if they are text boxes with lables, you can change their Visible property from "False" to "True" or vice versa, depending on what the user has selected. I suggest that the default poroperty should be False., then make them Visisble if the user chooses "Custom"|||Thanks for you reply
But the parameter's visible property cannot support formula, and I cannot get the change event of parameter "Date Range", such as selectedIndexChange
I use SRS2005, the "Date Range" is a dropdownlist, "Date From" and "Date To" may be the text box
How to hide/show parameter dynamic?
There is a date range parameter in my rdl, the list value is "This
Week","This Month", "This Year" and "Custom", when user choose "Custom", then
display two parameter "Date From" and "Date To" to select custom date range.
My question, how to show "Date From" and "Date To" when user choose
"Custom", and will hide these two parameters when user choose other item.
I use SRS2005
If cannot design the above function, I want to know, how to set the layout
of 3 parameters as:
Date Range ______
Date From ______ Date To ______
The SRS will display as:
Date Range ______ Date From ______
Date To ______
ThanksIf the parameters values are coming from query byway of datasets then it can
be cascaded so whn you select "custom" then it displayes the from and to
otherwise I suppose it is not possible. when you create 3 parameters then it
displays all 3.
Amarnath
"icyer" wrote:
> There is a date range parameter in my rdl, the list value is "This
> Week","This Month", "This Year" and "Custom", when user choose "Custom", then
> display two parameter "Date From" and "Date To" to select custom date range.
> My question, how to show "Date From" and "Date To" when user choose
> "Custom", and will hide these two parameters when user choose other item.
> I use SRS2005
> If cannot design the above function, I want to know, how to set the layout
> of 3 parameters as:
> Date Range ______
> Date From ______ Date To ______
> The SRS will display as:
> Date Range ______ Date From ______
> Date To ______
> Thanks
>|||Hi
I'd be curious as to your coding behind this. I need to do similar in
giving a list that has predefined dates to be passed except when the user
chooses their own dates.
Thanks
chelle
"icyer" wrote:
> There is a date range parameter in my rdl, the list value is "This
> Week","This Month", "This Year" and "Custom", when user choose "Custom", then
> display two parameter "Date From" and "Date To" to select custom date range.
> My question, how to show "Date From" and "Date To" when user choose
> "Custom", and will hide these two parameters when user choose other item.
> I use SRS2005
> If cannot design the above function, I want to know, how to set the layout
> of 3 parameters as:
> Date Range ______
> Date From ______ Date To ______
> The SRS will display as:
> Date Range ______ Date From ______
> Date To ______
> Thanks
>
Week","This Month", "This Year" and "Custom", when user choose "Custom", then
display two parameter "Date From" and "Date To" to select custom date range.
My question, how to show "Date From" and "Date To" when user choose
"Custom", and will hide these two parameters when user choose other item.
I use SRS2005
If cannot design the above function, I want to know, how to set the layout
of 3 parameters as:
Date Range ______
Date From ______ Date To ______
The SRS will display as:
Date Range ______ Date From ______
Date To ______
ThanksIf the parameters values are coming from query byway of datasets then it can
be cascaded so whn you select "custom" then it displayes the from and to
otherwise I suppose it is not possible. when you create 3 parameters then it
displays all 3.
Amarnath
"icyer" wrote:
> There is a date range parameter in my rdl, the list value is "This
> Week","This Month", "This Year" and "Custom", when user choose "Custom", then
> display two parameter "Date From" and "Date To" to select custom date range.
> My question, how to show "Date From" and "Date To" when user choose
> "Custom", and will hide these two parameters when user choose other item.
> I use SRS2005
> If cannot design the above function, I want to know, how to set the layout
> of 3 parameters as:
> Date Range ______
> Date From ______ Date To ______
> The SRS will display as:
> Date Range ______ Date From ______
> Date To ______
> Thanks
>|||Hi
I'd be curious as to your coding behind this. I need to do similar in
giving a list that has predefined dates to be passed except when the user
chooses their own dates.
Thanks
chelle
"icyer" wrote:
> There is a date range parameter in my rdl, the list value is "This
> Week","This Month", "This Year" and "Custom", when user choose "Custom", then
> display two parameter "Date From" and "Date To" to select custom date range.
> My question, how to show "Date From" and "Date To" when user choose
> "Custom", and will hide these two parameters when user choose other item.
> I use SRS2005
> If cannot design the above function, I want to know, how to set the layout
> of 3 parameters as:
> Date Range ______
> Date From ______ Date To ______
> The SRS will display as:
> Date Range ______ Date From ______
> Date To ______
> Thanks
>
How to hide/Remove the first row of the CSV file?
I have created one report and exported in CSV file. But in CSV file, it
shows the Textbox names, table names etc in the first row. i dont want
to show the first row of the CSV result. any idea how to hide/Remove
the first row?
Regards,
VinodHmmm...tough one...
I would say you should setup a link to print another report that is the
same data but w/o the headers...There is probably a better solution but
this one would be fairly easy. If its something that you are scheduling
to be created on a share or sent out w/o headers, why include them on
the report at all?
Hope this helps!
--
Ben Sullins
http://bensullins.com
shows the Textbox names, table names etc in the first row. i dont want
to show the first row of the CSV result. any idea how to hide/Remove
the first row?
Regards,
VinodHmmm...tough one...
I would say you should setup a link to print another report that is the
same data but w/o the headers...There is probably a better solution but
this one would be fairly easy. If its something that you are scheduling
to be created on a share or sent out w/o headers, why include them on
the report at all?
Hope this helps!
--
Ben Sullins
http://bensullins.com
How to hide URL when display reports in reporting services
Hi ,
How can I hide the URL information when I open a report, some with parameters and some do not have
parameters. Is there anyway or properties in RS that I can set to have it hide all the important information,
like datasource, credentials, parameters, and display the report like a aspx page instead?
Or does this need to have special programming to make this happen? and if so, what do I need to do?
thanks very much
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1906571&SiteID=1
How to hide unauthorized databases with SQL 2005?
Hi,
I have configure permission for userA and he can access only one database.
When user estabilish the connection via management studio, though he cannot
access other databases, he can see them. Is it possible to hide other
databases for userA?
Appreciate all your reply.
ShaneVIEW ANY DATABASE is granted to public by default. If you want to remove
this permission from userA:
USE master
DENY VIEW ANY DATABASE TO userA
Although the user still has VIEW ANY DATABASE via public role membership,
the DENY takes precedence.
You could also REVOKE VIEW ANY DATABASE from public and then selectively
grant that permission to users as you see fit.
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:e50gEfAaGHA.3704@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have configure permission for userA and he can access only one database.
> When user estabilish the connection via management studio, though he
> cannot access other databases, he can see them. Is it possible to hide
> other databases for userA?
> Appreciate all your reply.
> Shane
>|||Thanks for the reply Dan. But the problem is, this statement applies for all
databases that is not what I want. I need to allow userA to see one databas
e while denying other databases. Is it possible. Have I missed anything?
Shane
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message news:%2
300soIBaGHA.3304@.TK2MSFTNGP04.phx.gbl...
VIEW ANY DATABASE is granted to public by default. If you want to remove
this permission from userA:
USE master
DENY VIEW ANY DATABASE TO userA
Although the user still has VIEW ANY DATABASE via public role membership,
the DENY takes precedence.
You could also REVOKE VIEW ANY DATABASE from public and then selectively
grant that permission to users as you see fit.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:e50gEfAaGHA.3704@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have configure permission for userA and he can access only one database.
> When user estabilish the connection via management studio, though he
> cannot access other databases, he can see them. Is it possible to hide
> other databases for userA?
> Appreciate all your reply.
> Shane
>|||SL
Well, this unwanted user must be connected via SSMS (am I right?) and if you
have not added him/her to the database , he/she will see the database's nam
e but cannot access to
"SL Coder" <sl_coder@.hotmail.com> wrote in message news:eV8jH9BaGHA.4116@.TK2
MSFTNGP05.phx.gbl...
Thanks for the reply Dan. But the problem is, this statement applies for all
databases that is not what I want. I need to allow userA to see one databas
e while denying other databases. Is it possible. Have I missed anything?
Shane
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message news:%2
300soIBaGHA.3304@.TK2MSFTNGP04.phx.gbl...
VIEW ANY DATABASE is granted to public by default. If you want to remove
this permission from userA:
USE master
DENY VIEW ANY DATABASE TO userA
Although the user still has VIEW ANY DATABASE via public role membership,
the DENY takes precedence.
You could also REVOKE VIEW ANY DATABASE from public and then selectively
grant that permission to users as you see fit.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:e50gEfAaGHA.3704@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have configure permission for userA and he can access only one database.
> When user estabilish the connection via management studio, though he
> cannot access other databases, he can see them. Is it possible to hide
> other databases for userA?
> Appreciate all your reply.
> Shane
>|||After VIEW ANY DATABASE is denied, only master, tempdb, and databases that
the login owns are visible. Other databases that the user can access are
not enumerated but can still be accessed directly by setting the database
context (e.g. USE). Unfortunately, SSMS Object Explorer functionality is
limited to visible databases.
The reason for this behavior is that it is necessary to open each database
on the server to determine whether or not a non-privileged login has
database access. This caused performance issues on servers with a lot
(100's) of databases.
If this feature is important to you, make a suggestion (or vote on the
importance if already submitted) at the product feedback center:
http://lab.msdn.microsoft.com/produ...ck/default.aspx
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:eV8jH9BaGHA.4116@.TK2MSFTNGP05.phx.gbl...
Thanks for the reply Dan. But the problem is, this statement applies for all
databases that is not what I want. I need to allow userA to see one database
while denying other databases. Is it possible. Have I missed anything?
Shane
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:%2300soIBaGHA.3304@.TK2MSFTNGP04.phx.gbl...
VIEW ANY DATABASE is granted to public by default. If you want to remove
this permission from userA:
USE master
DENY VIEW ANY DATABASE TO userA
Although the user still has VIEW ANY DATABASE via public role membership,
the DENY takes precedence.
You could also REVOKE VIEW ANY DATABASE from public and then selectively
grant that permission to users as you see fit.
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:e50gEfAaGHA.3704@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have configure permission for userA and he can access only one
database.
> When user estabilish the connection via management studio, though he
> cannot access other databases, he can see them. Is it possible to hide
> other databases for userA?
> Appreciate all your reply.
> Shane
>
I have configure permission for userA and he can access only one database.
When user estabilish the connection via management studio, though he cannot
access other databases, he can see them. Is it possible to hide other
databases for userA?
Appreciate all your reply.
ShaneVIEW ANY DATABASE is granted to public by default. If you want to remove
this permission from userA:
USE master
DENY VIEW ANY DATABASE TO userA
Although the user still has VIEW ANY DATABASE via public role membership,
the DENY takes precedence.
You could also REVOKE VIEW ANY DATABASE from public and then selectively
grant that permission to users as you see fit.
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:e50gEfAaGHA.3704@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have configure permission for userA and he can access only one database.
> When user estabilish the connection via management studio, though he
> cannot access other databases, he can see them. Is it possible to hide
> other databases for userA?
> Appreciate all your reply.
> Shane
>|||Thanks for the reply Dan. But the problem is, this statement applies for all
databases that is not what I want. I need to allow userA to see one databas
e while denying other databases. Is it possible. Have I missed anything?
Shane
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message news:%2
300soIBaGHA.3304@.TK2MSFTNGP04.phx.gbl...
VIEW ANY DATABASE is granted to public by default. If you want to remove
this permission from userA:
USE master
DENY VIEW ANY DATABASE TO userA
Although the user still has VIEW ANY DATABASE via public role membership,
the DENY takes precedence.
You could also REVOKE VIEW ANY DATABASE from public and then selectively
grant that permission to users as you see fit.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:e50gEfAaGHA.3704@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have configure permission for userA and he can access only one database.
> When user estabilish the connection via management studio, though he
> cannot access other databases, he can see them. Is it possible to hide
> other databases for userA?
> Appreciate all your reply.
> Shane
>|||SL
Well, this unwanted user must be connected via SSMS (am I right?) and if you
have not added him/her to the database , he/she will see the database's nam
e but cannot access to
"SL Coder" <sl_coder@.hotmail.com> wrote in message news:eV8jH9BaGHA.4116@.TK2
MSFTNGP05.phx.gbl...
Thanks for the reply Dan. But the problem is, this statement applies for all
databases that is not what I want. I need to allow userA to see one databas
e while denying other databases. Is it possible. Have I missed anything?
Shane
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message news:%2
300soIBaGHA.3304@.TK2MSFTNGP04.phx.gbl...
VIEW ANY DATABASE is granted to public by default. If you want to remove
this permission from userA:
USE master
DENY VIEW ANY DATABASE TO userA
Although the user still has VIEW ANY DATABASE via public role membership,
the DENY takes precedence.
You could also REVOKE VIEW ANY DATABASE from public and then selectively
grant that permission to users as you see fit.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:e50gEfAaGHA.3704@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have configure permission for userA and he can access only one database.
> When user estabilish the connection via management studio, though he
> cannot access other databases, he can see them. Is it possible to hide
> other databases for userA?
> Appreciate all your reply.
> Shane
>|||After VIEW ANY DATABASE is denied, only master, tempdb, and databases that
the login owns are visible. Other databases that the user can access are
not enumerated but can still be accessed directly by setting the database
context (e.g. USE). Unfortunately, SSMS Object Explorer functionality is
limited to visible databases.
The reason for this behavior is that it is necessary to open each database
on the server to determine whether or not a non-privileged login has
database access. This caused performance issues on servers with a lot
(100's) of databases.
If this feature is important to you, make a suggestion (or vote on the
importance if already submitted) at the product feedback center:
http://lab.msdn.microsoft.com/produ...ck/default.aspx
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:eV8jH9BaGHA.4116@.TK2MSFTNGP05.phx.gbl...
Thanks for the reply Dan. But the problem is, this statement applies for all
databases that is not what I want. I need to allow userA to see one database
while denying other databases. Is it possible. Have I missed anything?
Shane
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:%2300soIBaGHA.3304@.TK2MSFTNGP04.phx.gbl...
VIEW ANY DATABASE is granted to public by default. If you want to remove
this permission from userA:
USE master
DENY VIEW ANY DATABASE TO userA
Although the user still has VIEW ANY DATABASE via public role membership,
the DENY takes precedence.
You could also REVOKE VIEW ANY DATABASE from public and then selectively
grant that permission to users as you see fit.
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@.hotmail.com> wrote in message
news:e50gEfAaGHA.3704@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I have configure permission for userA and he can access only one
database.
> When user estabilish the connection via management studio, though he
> cannot access other databases, he can see them. Is it possible to hide
> other databases for userA?
> Appreciate all your reply.
> Shane
>
How to hide triggers from SQL Server?
Hi,
I wonder whether there is a way to temporarily hide triggers from SQL Server
2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want t
o
do this is because even though I disable triggers, SQL Server will take time
s
to evaluate whether the trigger is disabled or not. Based on my own testing
,
an alter table statement can be 2 to 3 times faster without trigger comparin
g
to disabled triggers.
Thanks for any help,
PeterHi Peter
Disabling the triggers is the best you can do unless you drop and re-create
them.
Out of interest Is there alot of code in these triggers or are they nested?
John
"Peter" wrote:
> Hi,
> I wonder whether there is a way to temporarily hide triggers from SQL Serv
er
> 2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want
to
> do this is because even though I disable triggers, SQL Server will take ti
mes
> to evaluate whether the trigger is disabled or not. Based on my own testi
ng,
> an alter table statement can be 2 to 3 times faster without trigger compar
ing
> to disabled triggers.
>
> Thanks for any help,
> Peter|||Hi Peter
Disabling the triggers is the best you can do unless you drop and re-create
them.
Out of interest Is there alot of code in these triggers or are they nested?
John
"Peter" wrote:
> Hi,
> I wonder whether there is a way to temporarily hide triggers from SQL Serv
er
> 2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want
to
> do this is because even though I disable triggers, SQL Server will take ti
mes
> to evaluate whether the trigger is disabled or not. Based on my own testi
ng,
> an alter table statement can be 2 to 3 times faster without trigger compar
ing
> to disabled triggers.
>
> Thanks for any help,
> Peter
I wonder whether there is a way to temporarily hide triggers from SQL Server
2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want t
o
do this is because even though I disable triggers, SQL Server will take time
s
to evaluate whether the trigger is disabled or not. Based on my own testing
,
an alter table statement can be 2 to 3 times faster without trigger comparin
g
to disabled triggers.
Thanks for any help,
PeterHi Peter
Disabling the triggers is the best you can do unless you drop and re-create
them.
Out of interest Is there alot of code in these triggers or are they nested?
John
"Peter" wrote:
> Hi,
> I wonder whether there is a way to temporarily hide triggers from SQL Serv
er
> 2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want
to
> do this is because even though I disable triggers, SQL Server will take ti
mes
> to evaluate whether the trigger is disabled or not. Based on my own testi
ng,
> an alter table statement can be 2 to 3 times faster without trigger compar
ing
> to disabled triggers.
>
> Thanks for any help,
> Peter|||Hi Peter
Disabling the triggers is the best you can do unless you drop and re-create
them.
Out of interest Is there alot of code in these triggers or are they nested?
John
"Peter" wrote:
> Hi,
> I wonder whether there is a way to temporarily hide triggers from SQL Serv
er
> 2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want
to
> do this is because even though I disable triggers, SQL Server will take ti
mes
> to evaluate whether the trigger is disabled or not. Based on my own testi
ng,
> an alter table statement can be 2 to 3 times faster without trigger compar
ing
> to disabled triggers.
>
> Thanks for any help,
> Peter
How to hide triggers from SQL Server?
Hi,
I wonder whether there is a way to temporarily hide triggers from SQL Server
2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want to
do this is because even though I disable triggers, SQL Server will take times
to evaluate whether the trigger is disabled or not. Based on my own testing,
an alter table statement can be 2 to 3 times faster without trigger comparing
to disabled triggers.
Thanks for any help,
PeterHi Peter
Disabling the triggers is the best you can do unless you drop and re-create
them.
Out of interest Is there alot of code in these triggers or are they nested?
John
"Peter" wrote:
> Hi,
> I wonder whether there is a way to temporarily hide triggers from SQL Server
> 2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want to
> do this is because even though I disable triggers, SQL Server will take times
> to evaluate whether the trigger is disabled or not. Based on my own testing,
> an alter table statement can be 2 to 3 times faster without trigger comparing
> to disabled triggers.
>
> Thanks for any help,
> Peter
I wonder whether there is a way to temporarily hide triggers from SQL Server
2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want to
do this is because even though I disable triggers, SQL Server will take times
to evaluate whether the trigger is disabled or not. Based on my own testing,
an alter table statement can be 2 to 3 times faster without trigger comparing
to disabled triggers.
Thanks for any help,
PeterHi Peter
Disabling the triggers is the best you can do unless you drop and re-create
them.
Out of interest Is there alot of code in these triggers or are they nested?
John
"Peter" wrote:
> Hi,
> I wonder whether there is a way to temporarily hide triggers from SQL Server
> 2000, SQL Server 2005 and SQL Server 2005 Express. The reason that I want to
> do this is because even though I disable triggers, SQL Server will take times
> to evaluate whether the trigger is disabled or not. Based on my own testing,
> an alter table statement can be 2 to 3 times faster without trigger comparing
> to disabled triggers.
>
> Thanks for any help,
> Peter
How to hide the print button on the toolbar?
I want to force users to export my report into PDF or Excel then print from
those applications. So I want to hide the print button on the toolbar. Does
anybody know how to hide the print button on the toolbar?
Thanks a lot.Set the RS property EnableClientPrinting. The only way to set this property
is by making a SOAP request. You will then need to restart IIS to ensure
that RS picks up the new property.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"BF" <BF@.discussions.microsoft.com> wrote in message
news:1EE8F83A-365C-4279-8D82-ED612459DAF2@.microsoft.com...
>I want to force users to export my report into PDF or Excel then print from
> those applications. So I want to hide the print button on the toolbar.
> Does
> anybody know how to hide the print button on the toolbar?
> Thanks a lot.|||Hi Daniel,
Thanks for the reply. But can you give me some detail information about how
to set the RS property EnableClientPrinting through SOAP request?
Thanks.
"Daniel Reib (MSFT)" wrote:
> Set the RS property EnableClientPrinting. The only way to set this property
> is by making a SOAP request. You will then need to restart IIS to ensure
> that RS picks up the new property.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "BF" <BF@.discussions.microsoft.com> wrote in message
> news:1EE8F83A-365C-4279-8D82-ED612459DAF2@.microsoft.com...
> >I want to force users to export my report into PDF or Excel then print from
> > those applications. So I want to hide the print button on the toolbar.
> > Does
> > anybody know how to hide the print button on the toolbar?
> >
> > Thanks a lot.
>
>|||Please read the following KB article:
http://support.microsoft.com/kb/897121/
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"BF" <BF@.discussions.microsoft.com> wrote in message
news:E4CF5F41-E688-46BD-A8D1-C0D6BDE1C188@.microsoft.com...
> Hi Daniel,
> Thanks for the reply. But can you give me some detail information about
> how
> to set the RS property EnableClientPrinting through SOAP request?
> Thanks.
>
> "Daniel Reib (MSFT)" wrote:
>> Set the RS property EnableClientPrinting. The only way to set this
>> property
>> is by making a SOAP request. You will then need to restart IIS to ensure
>> that RS picks up the new property.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "BF" <BF@.discussions.microsoft.com> wrote in message
>> news:1EE8F83A-365C-4279-8D82-ED612459DAF2@.microsoft.com...
>> >I want to force users to export my report into PDF or Excel then print
>> >from
>> > those applications. So I want to hide the print button on the toolbar.
>> > Does
>> > anybody know how to hide the print button on the toolbar?
>> >
>> > Thanks a lot.
>>
those applications. So I want to hide the print button on the toolbar. Does
anybody know how to hide the print button on the toolbar?
Thanks a lot.Set the RS property EnableClientPrinting. The only way to set this property
is by making a SOAP request. You will then need to restart IIS to ensure
that RS picks up the new property.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"BF" <BF@.discussions.microsoft.com> wrote in message
news:1EE8F83A-365C-4279-8D82-ED612459DAF2@.microsoft.com...
>I want to force users to export my report into PDF or Excel then print from
> those applications. So I want to hide the print button on the toolbar.
> Does
> anybody know how to hide the print button on the toolbar?
> Thanks a lot.|||Hi Daniel,
Thanks for the reply. But can you give me some detail information about how
to set the RS property EnableClientPrinting through SOAP request?
Thanks.
"Daniel Reib (MSFT)" wrote:
> Set the RS property EnableClientPrinting. The only way to set this property
> is by making a SOAP request. You will then need to restart IIS to ensure
> that RS picks up the new property.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "BF" <BF@.discussions.microsoft.com> wrote in message
> news:1EE8F83A-365C-4279-8D82-ED612459DAF2@.microsoft.com...
> >I want to force users to export my report into PDF or Excel then print from
> > those applications. So I want to hide the print button on the toolbar.
> > Does
> > anybody know how to hide the print button on the toolbar?
> >
> > Thanks a lot.
>
>|||Please read the following KB article:
http://support.microsoft.com/kb/897121/
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"BF" <BF@.discussions.microsoft.com> wrote in message
news:E4CF5F41-E688-46BD-A8D1-C0D6BDE1C188@.microsoft.com...
> Hi Daniel,
> Thanks for the reply. But can you give me some detail information about
> how
> to set the RS property EnableClientPrinting through SOAP request?
> Thanks.
>
> "Daniel Reib (MSFT)" wrote:
>> Set the RS property EnableClientPrinting. The only way to set this
>> property
>> is by making a SOAP request. You will then need to restart IIS to ensure
>> that RS picks up the new property.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "BF" <BF@.discussions.microsoft.com> wrote in message
>> news:1EE8F83A-365C-4279-8D82-ED612459DAF2@.microsoft.com...
>> >I want to force users to export my report into PDF or Excel then print
>> >from
>> > those applications. So I want to hide the print button on the toolbar.
>> > Does
>> > anybody know how to hide the print button on the toolbar?
>> >
>> > Thanks a lot.
>>
How to hide the Print button of the toolbar?
There is Print Button on the ToolBar,I want hide it,How can I do?
Hi, have a look here:
http://msdn2.microsoft.com/en-us/library/ms155874.aspx
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Have a look here:http://support.microsoft.com/kb/897121/en-us
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
How to hide the plus/minus toggle icon?
Hi,
I have matrix details shown or hidden by toggling visibility based upon a
field. Works great, except that I want to hide the plus/minus icon from the
user. (Whether or not the detail is visible is based upon a report
parameter, in case you were wondering. Some users are privileged and can
see detail, others can't.)
Anyone know how to do this?
Thanks,
C17C17,
I setup a conditional display of the drill-down icon on a table report
similar to your situation. Here's what I did:
1) Make sure that drill-down is enabled by setting the Hidden value
of the Visibility property for the row to True, and also setting a
toggle field in the ToggleItem property.
2) Insert a new column to the left of the drill-down field on the
report and set the column size to 0.25in (you'll need at least .15in
to fully display the icon).
3) In the textbox where you'll display drill-down icon, set the
Hidden value of the Visibility property using an in-line IF statement
to test for your logic. I tested against a data field being null, but
you would test for a parameter condition.
My example: =IIF(Fields!InvoiceLineItemDetail.Value Is Nothing,
True, False)
Your example: =IIF(Parameters!UserHasPermission.Value = "Yes", True,
False)
Does this help you?
BTW - this tip is mentioned on a Reporting Services Monthly Newsletter
at www.reportarchitex.com
Matt A|||Very clever! I think it will work. Thanks Matt!
--c17
"MattA" <mattarabas@.gmail.com> wrote in message
news:1135021652.747713.223160@.g14g2000cwa.googlegroups.com...
> C17,
> I setup a conditional display of the drill-down icon on a table report
> similar to your situation. Here's what I did:
> 1) Make sure that drill-down is enabled by setting the Hidden value
> of the Visibility property for the row to True, and also setting a
> toggle field in the ToggleItem property.
> 2) Insert a new column to the left of the drill-down field on the
> report and set the column size to 0.25in (you'll need at least .15in
> to fully display the icon).
> 3) In the textbox where you'll display drill-down icon, set the
> Hidden value of the Visibility property using an in-line IF statement
> to test for your logic. I tested against a data field being null, but
> you would test for a parameter condition.
> My example: =IIF(Fields!InvoiceLineItemDetail.Value Is Nothing,
> True, False)
> Your example: =IIF(Parameters!UserHasPermission.Value = "Yes", True,
> False)
> Does this help you?
> BTW - this tip is mentioned on a Reporting Services Monthly Newsletter
> at www.reportarchitex.com
> Matt A
>
I have matrix details shown or hidden by toggling visibility based upon a
field. Works great, except that I want to hide the plus/minus icon from the
user. (Whether or not the detail is visible is based upon a report
parameter, in case you were wondering. Some users are privileged and can
see detail, others can't.)
Anyone know how to do this?
Thanks,
C17C17,
I setup a conditional display of the drill-down icon on a table report
similar to your situation. Here's what I did:
1) Make sure that drill-down is enabled by setting the Hidden value
of the Visibility property for the row to True, and also setting a
toggle field in the ToggleItem property.
2) Insert a new column to the left of the drill-down field on the
report and set the column size to 0.25in (you'll need at least .15in
to fully display the icon).
3) In the textbox where you'll display drill-down icon, set the
Hidden value of the Visibility property using an in-line IF statement
to test for your logic. I tested against a data field being null, but
you would test for a parameter condition.
My example: =IIF(Fields!InvoiceLineItemDetail.Value Is Nothing,
True, False)
Your example: =IIF(Parameters!UserHasPermission.Value = "Yes", True,
False)
Does this help you?
BTW - this tip is mentioned on a Reporting Services Monthly Newsletter
at www.reportarchitex.com
Matt A|||Very clever! I think it will work. Thanks Matt!
--c17
"MattA" <mattarabas@.gmail.com> wrote in message
news:1135021652.747713.223160@.g14g2000cwa.googlegroups.com...
> C17,
> I setup a conditional display of the drill-down icon on a table report
> similar to your situation. Here's what I did:
> 1) Make sure that drill-down is enabled by setting the Hidden value
> of the Visibility property for the row to True, and also setting a
> toggle field in the ToggleItem property.
> 2) Insert a new column to the left of the drill-down field on the
> report and set the column size to 0.25in (you'll need at least .15in
> to fully display the icon).
> 3) In the textbox where you'll display drill-down icon, set the
> Hidden value of the Visibility property using an in-line IF statement
> to test for your logic. I tested against a data field being null, but
> you would test for a parameter condition.
> My example: =IIF(Fields!InvoiceLineItemDetail.Value Is Nothing,
> True, False)
> Your example: =IIF(Parameters!UserHasPermission.Value = "Yes", True,
> False)
> Does this help you?
> BTW - this tip is mentioned on a Reporting Services Monthly Newsletter
> at www.reportarchitex.com
> Matt A
>
How to hide textboxes in PDFs but not in HTML?
Is there a way to hide textboxes (or any element) when the report is in non-HTML view?
The reason for this is that I have several drill-through features that the users fail to see, so I thought I'd put some help texts in the report ("click skill title to show skill report"). This help texts are totally meaningless on a PDF or in Excel though, and I'd like to get rid of them there. Any ideas?
There is no way to do automatically.
One idea would be to use a parameter such a View having options for target output mode e.g. HTML, PDF, Excel etc. and then have conditional logic in your report to show/hide elements based on the target output.
It's not automatic, but it's an option.
How to hide table columns for users without permission in SQL Tool
Hi,
I already set select permission to certain columns in a table for a user.
BUt the user still can view all the columns in the Enterprise Manager/ SQL
Mgt Studio. HOw to hide those columns without permission ?
Hi
If restrict access to the table by use stored procedures then the user does
not need permissions on the table directly. You can also be granular to
column level what permissions are granted.
Not giving them access to Enterprise Manager may also be an idea.
John
"Wan" wrote:
> Hi,
> I already set select permission to certain columns in a table for a user.
> BUt the user still can view all the columns in the Enterprise Manager/ SQL
> Mgt Studio. HOw to hide those columns without permission ?
|||Hi
Just to add, you may not exclude the user seeing the existance of the column
even if you have denied them permissions to see the data.
John
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> If restrict access to the table by use stored procedures then the user does
> not need permissions on the table directly. You can also be granular to
> column level what permissions are granted.
> Not giving them access to Enterprise Manager may also be an idea.
> John
> "Wan" wrote:
I already set select permission to certain columns in a table for a user.
BUt the user still can view all the columns in the Enterprise Manager/ SQL
Mgt Studio. HOw to hide those columns without permission ?
Hi
If restrict access to the table by use stored procedures then the user does
not need permissions on the table directly. You can also be granular to
column level what permissions are granted.
Not giving them access to Enterprise Manager may also be an idea.
John
"Wan" wrote:
> Hi,
> I already set select permission to certain columns in a table for a user.
> BUt the user still can view all the columns in the Enterprise Manager/ SQL
> Mgt Studio. HOw to hide those columns without permission ?
|||Hi
Just to add, you may not exclude the user seeing the existance of the column
even if you have denied them permissions to see the data.
John
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> If restrict access to the table by use stored procedures then the user does
> not need permissions on the table directly. You can also be granular to
> column level what permissions are granted.
> Not giving them access to Enterprise Manager may also be an idea.
> John
> "Wan" wrote:
How to hide table columns for users without permission in SQL Tool
Hi,
I already set select permission to certain columns in a table for a user.
BUt the user still can view all the columns in the Enterprise Manager/ SQL
Mgt Studio. HOw to hide those columns without permission ?Hi
If restrict access to the table by use stored procedures then the user does
not need permissions on the table directly. You can also be granular to
column level what permissions are granted.
Not giving them access to Enterprise Manager may also be an idea.
John
"Wan" wrote:
> Hi,
> I already set select permission to certain columns in a table for a user.
> BUt the user still can view all the columns in the Enterprise Manager/ SQL
> Mgt Studio. HOw to hide those columns without permission ?|||Hi
Just to add, you may not exclude the user seeing the existance of the column
even if you have denied them permissions to see the data.
John
"John Bell" wrote:
> Hi
> If restrict access to the table by use stored procedures then the user does
> not need permissions on the table directly. You can also be granular to
> column level what permissions are granted.
> Not giving them access to Enterprise Manager may also be an idea.
> John
> "Wan" wrote:
> > Hi,
> > I already set select permission to certain columns in a table for a user.
> > BUt the user still can view all the columns in the Enterprise Manager/ SQL
> > Mgt Studio. HOw to hide those columns without permission ?
I already set select permission to certain columns in a table for a user.
BUt the user still can view all the columns in the Enterprise Manager/ SQL
Mgt Studio. HOw to hide those columns without permission ?Hi
If restrict access to the table by use stored procedures then the user does
not need permissions on the table directly. You can also be granular to
column level what permissions are granted.
Not giving them access to Enterprise Manager may also be an idea.
John
"Wan" wrote:
> Hi,
> I already set select permission to certain columns in a table for a user.
> BUt the user still can view all the columns in the Enterprise Manager/ SQL
> Mgt Studio. HOw to hide those columns without permission ?|||Hi
Just to add, you may not exclude the user seeing the existance of the column
even if you have denied them permissions to see the data.
John
"John Bell" wrote:
> Hi
> If restrict access to the table by use stored procedures then the user does
> not need permissions on the table directly. You can also be granular to
> column level what permissions are granted.
> Not giving them access to Enterprise Manager may also be an idea.
> John
> "Wan" wrote:
> > Hi,
> > I already set select permission to certain columns in a table for a user.
> > BUt the user still can view all the columns in the Enterprise Manager/ SQL
> > Mgt Studio. HOw to hide those columns without permission ?
How to hide table columns for users without permission in SQL Tool
Hi,
I already set select permission to certain columns in a table for a user.
BUt the user still can view all the columns in the Enterprise Manager/ SQL
Mgt Studio. HOw to hide those columns without permission ?Hi
If restrict access to the table by use stored procedures then the user does
not need permissions on the table directly. You can also be granular to
column level what permissions are granted.
Not giving them access to Enterprise Manager may also be an idea.
John
"Wan" wrote:
> Hi,
> I already set select permission to certain columns in a table for a user.
> BUt the user still can view all the columns in the Enterprise Manager/ SQ
L
> Mgt Studio. HOw to hide those columns without permission ?
I already set select permission to certain columns in a table for a user.
BUt the user still can view all the columns in the Enterprise Manager/ SQL
Mgt Studio. HOw to hide those columns without permission ?Hi
If restrict access to the table by use stored procedures then the user does
not need permissions on the table directly. You can also be granular to
column level what permissions are granted.
Not giving them access to Enterprise Manager may also be an idea.
John
"Wan" wrote:
> Hi,
> I already set select permission to certain columns in a table for a user.
> BUt the user still can view all the columns in the Enterprise Manager/ SQ
L
> Mgt Studio. HOw to hide those columns without permission ?
how to hide system tables?
I just upsized from access to a new dbase and now I have all of these system
tables etc. I believe I was told that I could hide those some how?
I'm using Enterprise Manager
ThanksIn enterprise manager, right-click the server name and choose edit sql
server registration properties, then you'll see an option that reads show
system databases and system objects.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Robert Blackwell" <robbie@.NOspamwowcentral.com> wrote in message
news:O3FGz9tUDHA.392@.TK2MSFTNGP11.phx.gbl...
> I just upsized from access to a new dbase and now I have all of these
system
> tables etc. I believe I was told that I could hide those some how?
> I'm using Enterprise Manager
> Thanks
>|||http://www.aspfaq.com/2010
"Robert Blackwell" <robbie@.NOspamwowcentral.com> wrote in message
news:O3FGz9tUDHA.392@.TK2MSFTNGP11.phx.gbl...
> I just upsized from access to a new dbase and now I have all of these
system
> tables etc. I believe I was told that I could hide those some how?
> I'm using Enterprise Manager
> Thanks
>|||Thanks guys :o)
tables etc. I believe I was told that I could hide those some how?
I'm using Enterprise Manager
ThanksIn enterprise manager, right-click the server name and choose edit sql
server registration properties, then you'll see an option that reads show
system databases and system objects.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Robert Blackwell" <robbie@.NOspamwowcentral.com> wrote in message
news:O3FGz9tUDHA.392@.TK2MSFTNGP11.phx.gbl...
> I just upsized from access to a new dbase and now I have all of these
system
> tables etc. I believe I was told that I could hide those some how?
> I'm using Enterprise Manager
> Thanks
>|||http://www.aspfaq.com/2010
"Robert Blackwell" <robbie@.NOspamwowcentral.com> wrote in message
news:O3FGz9tUDHA.392@.TK2MSFTNGP11.phx.gbl...
> I just upsized from access to a new dbase and now I have all of these
system
> tables etc. I believe I was told that I could hide those some how?
> I'm using Enterprise Manager
> Thanks
>|||Thanks guys :o)
How to hide subtotals if only 1 row in group?
Hello,
I have established a group so that I can provide subtotals following the presentation of the group's detail rows. I'm finding that many of the groups have only one row and my subtotals just echo what was already presented on the detail line. The overall effect is confusing to the user and a real vertical space-waster.
Can someone give me a technique or expression for hiding subtotals when the group size is 1 but showing subtotals when the group size is >= 2? If I hide the group when the group size is 1 row then the one detail row is hidden as well, no?
Thanks!
BCB
You can give your visibility the expression to count rows in that group and then False if more than 1|||But I just want to hide the subtotal line. Won't your approach hide the one detail line that belongs to the group as well as the group footer that contains the redundant subtotals?
Thanks.
|||Gotcha, another technique would be to make the font white or transparent by using the sae kind of expression....in this case you can determine exactly which text blocks you want to use
only problem is spacing issues
|||I'm, essentially, trying to do the same thing.
In my case, my report is a list of employees that can be generated for either full timers, part timers, or both.
I've set up a group on the full/part time field FT_PT. There is no group header, just a group footer.
When I generate the report for both I get:
Department Header
Full-Time Detail
FT_PT Group Footer
Part-Time Detail
FT_PT Group Footer
Department Footer
This is perfect.
When I generate it for, say, just Full-Time, I get:
Department Header
Full-Time Detail
FT_PT Group Footer
Department Footer
I don't want to see the FT_PT group footer. What I want is:
Department Header
Full-Time Detail
Department Footer
Gotta be a way to do this without having a blank line where the Full-Time Group Footer would be, isn't there?
How to hide subtotals if only 1 row in group?
Hello,
I have established a group so that I can provide subtotals following the presentation of the group's detail rows. I'm finding that many of the groups have only one row and my subtotals just echo what was already presented on the detail line. The overall effect is confusing to the user and a real vertical space-waster.
Can someone give me a technique or expression for hiding subtotals when the group size is 1 but showing subtotals when the group size is >= 2? If I hide the group when the group size is 1 row then the one detail row is hidden as well, no?
Thanks!
BCB
You can give your visibility the expression to count rows in that group and then False if more than 1|||But I just want to hide the subtotal line. Won't your approach hide the one detail line that belongs to the group as well as the group footer that contains the redundant subtotals?
Thanks.
|||Gotcha, another technique would be to make the font white or transparent by using the sae kind of expression....in this case you can determine exactly which text blocks you want to use
only problem is spacing issues
|||I'm, essentially, trying to do the same thing.
In my case, my report is a list of employees that can be generated for either full timers, part timers, or both.
I've set up a group on the full/part time field FT_PT. There is no group header, just a group footer.
When I generate the report for both I get:
Department Header
Full-Time Detail
FT_PT Group Footer
Part-Time Detail
FT_PT Group Footer
Department Footer
This is perfect.
When I generate it for, say, just Full-Time, I get:
Department Header
Full-Time Detail
FT_PT Group Footer
Department Footer
I don't want to see the FT_PT group footer. What I want is:
Department Header
Full-Time Detail
Department Footer
Gotta be a way to do this without having a blank line where the Full-Time Group Footer would be, isn't there?
How to HIDE SQL Server on LAN?
Hi everybodyIn my web application I am using SQL Server 2000. But as we all know, its presence in the network is visible to all the clients in the network. Anybody who has SQL Server client installed and knows the password of the database would be able to access DB remotely and this is what I don't want. I want user to access my database only when they are loggedon on physically (directly) on the machine on which SQL Server is installed.Your replies are awaited.Thanks in advance.Regards,Zulfiqar Dhuka
Go to Sql Server Enterprise Manager.
1. Expand Sql Server Group.
2. Select Server Node (local)
3. Right Click Select Properties, then select Security tab.
4. Select Authentication to Windows only, then OK
Subscribe to:
Posts (Atom)