How do I hide zeros w/o a conditional stmt

I need a way to format fields without having to write a conditional statement
based on each textbox's value. I'm dealing with hundreds of fields.
Something like a HideZeros setting on the field. Any help would be
appreciatedWhat I do is change the Format property of each textbox to a custom value:
#,##0.0;(#,##0.0);-
the 1st group is how to display positive values;
the 2nd is for negatives;
and the 3rd is for zeroes (I am just displaying a dash here).
good luck,
Greg
"Blake Gremillion" <BlakeGremillion@.discussions.microsoft.com> wrote in
message news:64AAF2A7-F92B-4E91-8F96-3A9AAB2088FC@.microsoft.com...
>I need a way to format fields without having to write a conditional
>statement
> based on each textbox's value. I'm dealing with hundreds of fields.
> Something like a HideZeros setting on the field. Any help would be
> appreciated|||Thanks!
Worked great. Any idea on how to use that with a Percentage field.
"Blake Gremillion" wrote:
> I need a way to format fields without having to write a conditional statement
> based on each textbox's value. I'm dealing with hundreds of fields.
> Something like a HideZeros setting on the field. Any help would be
> appreciated|||I would try custom again and this time use:
0.0%;(0.0%);-
I pesonally use custom with percentages anyways and use
P1
to get just one decimal place. I think the standard "percentage" option,
gives you two. Of course neither hides zeroes. ;(
Greg
"Blake Gremillion" <BlakeGremillion@.discussions.microsoft.com> wrote in
message news:0B62BEDB-123A-4B5A-B363-ACAF9759425C@.microsoft.com...
> Thanks!
> Worked great. Any idea on how to use that with a Percentage field.
>
>
> "Blake Gremillion" wrote:
>> I need a way to format fields without having to write a conditional
>> statement
>> based on each textbox's value. I'm dealing with hundreds of fields.
>> Something like a HideZeros setting on the field. Any help would be
>> appreciated|||Yeah, I think that's what I'll have to do instead of using the Px format.
Thanks Again!
"Greg Burns" wrote:
> I would try custom again and this time use:
> 0.0%;(0.0%);-
> I pesonally use custom with percentages anyways and use
> P1
> to get just one decimal place. I think the standard "percentage" option,
> gives you two. Of course neither hides zeroes. ;(
> Greg
>
> "Blake Gremillion" <BlakeGremillion@.discussions.microsoft.com> wrote in
> message news:0B62BEDB-123A-4B5A-B363-ACAF9759425C@.microsoft.com...
> > Thanks!
> >
> > Worked great. Any idea on how to use that with a Percentage field.
> >
> >
> >
> >
> > "Blake Gremillion" wrote:
> >
> >> I need a way to format fields without having to write a conditional
> >> statement
> >> based on each textbox's value. I'm dealing with hundreds of fields.
> >> Something like a HideZeros setting on the field. Any help would be
> >> appreciated
>
>

How do i hide my db 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 2000You don't. Answer in .server, but it is not much longer than this one.
"w" <wilcorning@.hotmail.com> wrote in message
news:6a24cdf7.0402261136.176d7b10@.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|||There are several third party products that will encrypt the data. A google
search should bring up several.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

How Do I Hide Internet Explorer Menu and Tool Bar

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

If I am understanding what you are asking, that is not possible with SSRS.

|||I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.|||Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report?parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe|||

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE ?

|||I'm not following you. Are browsing to the reports from within Report Manager? Or are you calling the report from another web page?

Joe|||I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.|||

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application? If so, you will have quite a bit of control over the web page. What tool are you using? Or are you creating the web page from "scratch"?

How Do I Hide Internet Explorer Menu and Tool Bar

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

If I am understanding what you are asking, that is not possible with SSRS.

|||I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.|||Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report?parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe|||

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE ?

|||I'm not following you. Are browsing to the reports from within Report Manager? Or are you calling the report from another web page?

Joe|||I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.|||

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application? If so, you will have quite a bit of control over the web page. What tool are you using? Or are you creating the web page from "scratch"?

sql

How Do I Hide Internet Explorer Menu and Tool Bar

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

If I am understanding what you are asking, that is not possible with SSRS.

|||I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.|||Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report?parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe|||

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE ?

|||I'm not following you. Are browsing to the reports from within Report Manager? Or are you calling the report from another web page?

Joe|||I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.|||

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application? If so, you will have quite a bit of control over the web page. What tool are you using? Or are you creating the web page from "scratch"?

How do I hide databases that I don't need to see?

Hello,
How do I hide databases that I don't need to see on a server? I am using
SQL Server Management Studio 2005.
Thanks!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-I don't think you can hide them in management studio, but you can
restrict access to them
by using
deny connect to guest.
So that only authorised user to particular database can access it.
Regards
Amish Shah|||"amish" <shahamishm@.gmail.com> wrote in news:1138703226.471823.58290
@.g43g2000cwa.googlegroups.com:

> I don't think you can hide them in management studio, but you can
> restrict access to them
> by using
> deny connect to guest.
> So that only authorised user to particular database can access it.
> Regards
> Amish Shah
>
Thank you Amish.
P.S. Cool name!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-|||Thanks
Amish is indian name, meaning is honesty and love.
Regards
Amish Shah

How do I hide databases that I don't need to see?

Hello,
How do I hide databases that I don't need to see on a server? I am using
SQL Server Management Studio 2005.
Thanks!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
I don't think you can hide them in management studio, but you can
restrict access to them
by using
deny connect to guest.
So that only authorised user to particular database can access it.
Regards
Amish Shah
|||"amish" <shahamishm@.gmail.com> wrote in news:1138703226.471823.58290
@.g43g2000cwa.googlegroups.com:

> I don't think you can hide them in management studio, but you can
> restrict access to them
> by using
> deny connect to guest.
> So that only authorised user to particular database can access it.
> Regards
> Amish Shah
>
Thank you Amish.
P.S. Cool name!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
|||Thanks
Amish is indian name, meaning is honesty and love.
Regards
Amish Shah

How do I hide databases that I don't need to see?

Hello,
How do I hide databases that I don't need to see on a server? I am using
SQL Server Management Studio 2005.
Thanks!
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-I don't think you can hide them in management studio, but you can
restrict access to them
by using
deny connect to guest.
So that only authorised user to particular database can access it.
Regards
Amish Shah|||"amish" <shahamishm@.gmail.com> wrote in news:1138703226.471823.58290
@.g43g2000cwa.googlegroups.com:
> I don't think you can hide them in management studio, but you can
> restrict access to them
> by using
> deny connect to guest.
> So that only authorised user to particular database can access it.
> Regards
> Amish Shah
>
Thank you Amish.
P.S. Cool name!
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-|||Thanks
Amish is indian name, meaning is honesty and love.
Regards
Amish Shah

How do I Hide Databases from External Users?

I am going to give user rights for an external user to connect to my SQL Server via Client Network Utility.

Atlough I have given user permissions to only access one database and not the whole list, how do I make sure that they cannot see all the other databases on my SQL Server?

I have 20 instances of databases on my SQL Server and ideally I would like to give 20 different people access - but each of them when they enter my SQL Server, should not even know that the other databases exist.

Thanks.RE:
Q1 I am going to give user rights for an external user to connect to my SQL Server via Client Network Utility.

Q2 Although I have given user permissions to only access one database and not the whole list, how do I make sure that they cannot see all the other databases on my SQL Server?

I have 20 instances of databases on my SQL Server and ideally I would like to give 20 different people access -

Q3 but each of them when they enter my SQL Server, should not even know that the other databases exist. Thanks.

A1 {What was meant is not 100% clear; however, bestowing "[user rights for an external user to connect to SQL Server]" would generally be accomplished within Enterprise Manager, *Query Analyser, osql, isql, or programmatically, i.e.(via an API: ADO, CLib, DMO, OLEDB, etc.,); but not via the Client Network Utility (at least not directly)?}

A2 One may meet such requirements by designing the user application(s), i.e.(the ones the users will use with their respective DBs), such that other DB catalogs are not displayed. (This is arguably probably one of the better means of meeting such a requirement.)

Note: Various "all encompassing" implementation approaches may entail significant negative consequences. For example this includes many implementations that:
a Deny users Select and Exec rights to certain objects in the Master DB.
b Modify / add objects to the Master DB (this option especially, is NOT recommended).
c Require special connectivity software that supports the desired feature set (custom made ODBC, Sql Server, OLEDB, etc., drivers).

A3 You may wish to verify that this is in fact an important requirement. (That is, one that is worth the ramifications of the means chosen to implement a design that will meet the requirement.) As noted in A2, maintainability and / or functionality may be impaired with some kinds of "DB hiding" implementation approaches.

--

* The following Special Stored Procedures are supported in MS Sql Server 2k (execute from QA, etc.) for managing security:
sp_addalias
sp_addapprole
sp_addgroup
sp_addlinkedsrvlogin
sp_addlogin
sp_addremotelogin
sp_addrole
sp_addrolemember
sp_addserver
sp_addsrvrolemember
sp_adduser
sp_approlepassword
sp_change_users_login
sp_changedbowner
sp_changegroup
sp_changeobjectowner
sp_dbfixedrolepermission
sp_defaultdb
sp_defaultlanguage
sp_denylogin
sp_dropalias
sp_dropapprole
sp_dropgroup
sp_droplinkedsrvlogin
sp_droplogin
sp_dropremotelogin
sp_droprole
sp_droprolemember
sp_dropserver
sp_dropsrvrolemember
sp_dropuser
sp_grantdbaccess
sp_grantlogin
sp_helpdbfixedrole
sp_helpgroup
sp_helplinkedsrvlogin
sp_helplogins
sp_helpntgroup
sp_helpremotelogin
sp_helprole
sp_helprolemember
sp_helprotect
sp_helpsrvrole
sp_helpsrvrolemember
sp_helpuser
sp_password
sp_remoteoption
sp_revokedbaccess
sp_revokelogin
sp_setapprole
sp_srvrolepermission
sp_validatelogins|||With what tools will your users be connecting to your Server? ODBC, OSQL, Enterprise Manager?|||Originally posted by Paul Young
With what tools will your users be connecting to your Server? ODBC, OSQL, Enterprise Manager?

Thank you for your posts :)

I am using EM to connect|||Great, what will your users use to connect?

If your users will use EM or Query Analyzer then they have enough to see the diffrent DBs with little to no effort. A knowlegable user can even see system tables via I/OSQL. Past that, in ODBC a use will still be able to get a list of DB's if they specify a database when setting up the DSN.sql

How do I hide a table in a report programatically?

Hi,
I have 2 tables in a report and, depending on which value a user picks in a
particular parameter, I want to display only one of the tables. Is there any
way to do something like, "IIF(parameters!param_A.value = "Y", visible = true, visible = false)" or something like that for a table?
--
Thanks,
JeffSet the table's Hidden property to an expression. For example:
=CBool(Parameters!HideTheTable.Value)
The Hidden property can be accessed by expanding Visibility... in the
Properties window.
HTH
On Oct 1, 3:39 pm, Jeff Stroope
<JeffStro...@.discussions.microsoft.com> wrote:
> Hi,
> I have 2 tables in a report and, depending on which value a user picks in a
> particular parameter, I want to display only one of the tables. Is there any
> way to do something like, "IIF(parameters!param_A.value = "Y", visible => true, visible = false)" or something like that for a table?
> --
> Thanks,
> Jeff|||On Oct 1, 5:39 pm, Jeff Stroope
<JeffStro...@.discussions.microsoft.com> wrote:
> Hi,
> I have 2 tables in a report and, depending on which value a user picks in a
> particular parameter, I want to display only one of the tables. Is there any
> way to do something like, "IIF(parameters!param_A.value = "Y", visible => true, visible = false)" or something like that for a table?
> --
> Thanks,
> Jeff
The best way to accomplish this is to control the data populating the
table controls at the stored procedure/query level that is sourcing
the report. For example, pass the parameter value back to the stored
procedure(s)/query(ies) and if it is a certain value, return an empty
resultset to the report. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Chris!
--
Thanks,
Jeff
"Chris Durkin" wrote:
> Set the table's Hidden property to an expression. For example:
> =CBool(Parameters!HideTheTable.Value)
>
> The Hidden property can be accessed by expanding Visibility... in the
> Properties window.
>
> HTH
>
> On Oct 1, 3:39 pm, Jeff Stroope
> <JeffStro...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I have 2 tables in a report and, depending on which value a user picks in a
> > particular parameter, I want to display only one of the tables. Is there any
> > way to do something like, "IIF(parameters!param_A.value = "Y", visible => > true, visible = false)" or something like that for a table?
> > --
> > Thanks,
> >
> > Jeff
>
>|||Thanks Enrique!
--
Thanks,
Jeff
"EMartinez" wrote:
> On Oct 1, 5:39 pm, Jeff Stroope
> <JeffStro...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I have 2 tables in a report and, depending on which value a user picks in a
> > particular parameter, I want to display only one of the tables. Is there any
> > way to do something like, "IIF(parameters!param_A.value = "Y", visible => > true, visible = false)" or something like that for a table?
> > --
> > Thanks,
> >
> > Jeff
>
> The best way to accomplish this is to control the data populating the
> table controls at the stored procedure/query level that is sourcing
> the report. For example, pass the parameter value back to the stored
> procedure(s)/query(ies) and if it is a certain value, return an empty
> resultset to the report. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>