...using SQL SERVER 2k
I know how to hide system objects in Enterprise Manager, but can this same
sort of thing be done in Query Analyzer... like what I see done on the Server
tab of Visual Studio?
thanks
kevin
No, that functionality is not available in QA. All you have is the pre-defined folders for user
tables and system tables. No such for stored procedures, but I hope that you don't have user
procedures in master? :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:56016547-01C2-4E59-9F6B-5FD784744711@.microsoft.com...
> ...using SQL SERVER 2k
> I know how to hide system objects in Enterprise Manager, but can this same
> sort of thing be done in Query Analyzer... like what I see done on the Server
> tab of Visual Studio?
> thanks
> kevin
|||"Tibor Karaszi" wrote:
> No, that functionality is not available in QA. All you have is the pre-defined folders for user
> tables and system tables. No such for stored procedures, but I hope that you don't have user
> procedures in master? :-)
No, of course not. And I am not referring to the master, model, etc database.
In Enterprise Manager, in user created databases there are a number of SPs,
tables and views that are hidden if you select to hide system objects.
Obviously SQL SERVER/EM is intelligent enough to recognize the difference,
but Query Analyzer doesn't seem to be able to. Even users restricted to a
single DB can see master in QA.
It leads to a lot of scrolling to get to that one SP.
thanks
kevin
|||I see what you mean.
QA:
Tables:
These are already in separate folders, right?
Procedures:
You can delete the dt_ procedures, but they will come back when anyone uses EM to create diagram
etc.
Views:
The three system views will always be shown.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:7BC4ED53-51A9-441C-BA8F-F5318B56FE7B@.microsoft.com...
> "Tibor Karaszi" wrote:
>
> No, of course not. And I am not referring to the master, model, etc database.
> In Enterprise Manager, in user created databases there are a number of SPs,
> tables and views that are hidden if you select to hide system objects.
> Obviously SQL SERVER/EM is intelligent enough to recognize the difference,
> but Query Analyzer doesn't seem to be able to. Even users restricted to a
> single DB can see master in QA.
> It leads to a lot of scrolling to get to that one SP.
> thanks
> kevin
|||Ah!!! Now you see. Its only the SP's that are a pain... honestly my middle
finger is cramping from all this damn scrolling. I just have to increase the
number of lines the scroll button moves with the mouse setup.
peace
kevin
"Tibor Karaszi" wrote:
> I see what you mean.
> QA:
> Tables:
> These are already in separate folders, right?
> Procedures:
> You can delete the dt_ procedures, but they will come back when anyone uses EM to create diagram
> etc.
> Views:
> The three system views will always be shown.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "kevin" <kevin@.discussions.microsoft.com> wrote in message
> news:7BC4ED53-51A9-441C-BA8F-F5318B56FE7B@.microsoft.com...
>
>
Showing posts with label hide. Show all posts
Showing posts with label hide. Show all posts
Thursday, March 29, 2012
Can I hide header of Report in browser, when I print using browser
Hi;
I am trying to use Printing in browser for reports which are developed in
SQL Reporting Services. Now, when I try to print reports using browsers and
go to file menu and select Print Preview then it preview all the stuff which
I have in browser including that header of report which is used to change
pages and exporting options. How can I hide that header when I print.
Thanks.
--
Essa, M. Mughal
Software Developer
iLogic Inc., CanadaOne solution would be to provide a "print format" button that would display
the report without the toolbar. (You can turn off the toolbar using URL
commands.)
"Essa" <essamughal@.hotmail.com> wrote in message
news:5E84C2B5-9753-4510-B5F3-14DD542920F3@.microsoft.com...
> Hi;
> I am trying to use Printing in browser for reports which are developed in
> SQL Reporting Services. Now, when I try to print reports using browsers
and
> go to file menu and select Print Preview then it preview all the stuff
which
> I have in browser including that header of report which is used to change
> pages and exporting options. How can I hide that header when I print.
> Thanks.
> --
> Essa, M. Mughal
> Software Developer
> iLogic Inc., Canada|||Printing from the browser is not recommended using SQL Server 2000 Reporting
Services (RTM and SP1). This issue will be addressed in an upcoming release.
Meanwhile, the recommened technique is to export to PDF and print using the
PDF file.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Essa" <essamughal@.hotmail.com> wrote in message
news:5E84C2B5-9753-4510-B5F3-14DD542920F3@.microsoft.com...
> Hi;
> I am trying to use Printing in browser for reports which are developed in
> SQL Reporting Services. Now, when I try to print reports using browsers
and
> go to file menu and select Print Preview then it preview all the stuff
which
> I have in browser including that header of report which is used to change
> pages and exporting options. How can I hide that header when I print.
> Thanks.
> --
> Essa, M. Mughal
> Software Developer
> iLogic Inc., Canada
I am trying to use Printing in browser for reports which are developed in
SQL Reporting Services. Now, when I try to print reports using browsers and
go to file menu and select Print Preview then it preview all the stuff which
I have in browser including that header of report which is used to change
pages and exporting options. How can I hide that header when I print.
Thanks.
--
Essa, M. Mughal
Software Developer
iLogic Inc., CanadaOne solution would be to provide a "print format" button that would display
the report without the toolbar. (You can turn off the toolbar using URL
commands.)
"Essa" <essamughal@.hotmail.com> wrote in message
news:5E84C2B5-9753-4510-B5F3-14DD542920F3@.microsoft.com...
> Hi;
> I am trying to use Printing in browser for reports which are developed in
> SQL Reporting Services. Now, when I try to print reports using browsers
and
> go to file menu and select Print Preview then it preview all the stuff
which
> I have in browser including that header of report which is used to change
> pages and exporting options. How can I hide that header when I print.
> Thanks.
> --
> Essa, M. Mughal
> Software Developer
> iLogic Inc., Canada|||Printing from the browser is not recommended using SQL Server 2000 Reporting
Services (RTM and SP1). This issue will be addressed in an upcoming release.
Meanwhile, the recommened technique is to export to PDF and print using the
PDF file.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Essa" <essamughal@.hotmail.com> wrote in message
news:5E84C2B5-9753-4510-B5F3-14DD542920F3@.microsoft.com...
> Hi;
> I am trying to use Printing in browser for reports which are developed in
> SQL Reporting Services. Now, when I try to print reports using browsers
and
> go to file menu and select Print Preview then it preview all the stuff
which
> I have in browser including that header of report which is used to change
> pages and exporting options. How can I hide that header when I print.
> Thanks.
> --
> Essa, M. Mughal
> Software Developer
> iLogic Inc., Canada
Can I hide displaying a certain member?
Hi,
I have a dimension called customers having the following levels:
ALL
Level 1 CustType
Level 2 Cust Rank
Level 3 Cust Name
Suppose that the possible CustTypes are "Potential", "Active", "Lost".
Is it possible to hide displaying Level 1 and below if the Custtype (Level 1) = "Potential"create a view on the table like select col1,col3 from the table and access (http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21175087.html#) the view.|||Thanks for the reply. Yup it seems that the view approach is what I will have to go with.
I have a dimension called customers having the following levels:
ALL
Level 1 CustType
Level 2 Cust Rank
Level 3 Cust Name
Suppose that the possible CustTypes are "Potential", "Active", "Lost".
Is it possible to hide displaying Level 1 and below if the Custtype (Level 1) = "Potential"create a view on the table like select col1,col3 from the table and access (http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21175087.html#) the view.|||Thanks for the reply. Yup it seems that the view approach is what I will have to go with.
Can I hide data fields in a Chart?
I have a Bar/Line Chart with two data fields. Field #1 is displayed as a bar,
Field #2 a line. I would like to allow the user to choose via a parameter if
the line is displayed.
I tried the following expression for the Field:
=iif(Parameters!ShowTrend.Value=True,Fields!Trend.Value,False)
But rather than hiding the line, it makes all values zero with the line
still showing.
Is there some way to hide the line?
Thanks.You may want to try:
=iif(Parameters!ShowTrend.Value=True, Fields!Trend.Value, Nothing)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bill" <bill@.discussions.microsoft.com> wrote in message
news:745AF66D-CC9D-4D91-845C-FD4227C08E59@.microsoft.com...
> I have a Bar/Line Chart with two data fields. Field #1 is displayed as a
bar,
> Field #2 a line. I would like to allow the user to choose via a parameter
if
> the line is displayed.
> I tried the following expression for the Field:
> =iif(Parameters!ShowTrend.Value=True,Fields!Trend.Value,False)
> But rather than hiding the line, it makes all values zero with the line
> still showing.
> Is there some way to hide the line?
> Thanks.
>|||Show/hide is not supported in charts.
But why don't you try a dynamic series grouping and filter those series
groupings that you don't want show (the Grouping&Sorting dialog for every
chart grouping has a filter tab where you can define expressions to filter
data). This should also take care of the chart legend issue.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bill" <bill@.discussions.microsoft.com> wrote in message
news:6B4516F9-D415-4522-838F-BCBAF0789F30@.microsoft.com...
> Thanks for the reply, but "Nothing" gives me the same results as "False"
...
> the line shows-up on bottom with zero values.
> I can get the effect of hiding (sort of) by setting color to transparent.
> But the data series still displays in the legend box.
> Is there no way to dynamically let the user specify what data elements
they
> want to show/hide on a chart?
> Bill
> "Robert Bruckner [MSFT]" wrote:
> > You may want to try:
> > =iif(Parameters!ShowTrend.Value=True, Fields!Trend.Value, Nothing)
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "bill" <bill@.discussions.microsoft.com> wrote in message
> > news:745AF66D-CC9D-4D91-845C-FD4227C08E59@.microsoft.com...
> > > I have a Bar/Line Chart with two data fields. Field #1 is displayed as
a
> > bar,
> > > Field #2 a line. I would like to allow the user to choose via a
parameter
> > if
> > > the line is displayed.
> > >
> > > I tried the following expression for the Field:
> > >
> > > =iif(Parameters!ShowTrend.Value=True,Fields!Trend.Value,False)
> > >
> > > But rather than hiding the line, it makes all values zero with the
line
> > > still showing.
> > >
> > > Is there some way to hide the line?
> > >
> > > Thanks.
> > >
> > >
> >
> >
> >
Field #2 a line. I would like to allow the user to choose via a parameter if
the line is displayed.
I tried the following expression for the Field:
=iif(Parameters!ShowTrend.Value=True,Fields!Trend.Value,False)
But rather than hiding the line, it makes all values zero with the line
still showing.
Is there some way to hide the line?
Thanks.You may want to try:
=iif(Parameters!ShowTrend.Value=True, Fields!Trend.Value, Nothing)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bill" <bill@.discussions.microsoft.com> wrote in message
news:745AF66D-CC9D-4D91-845C-FD4227C08E59@.microsoft.com...
> I have a Bar/Line Chart with two data fields. Field #1 is displayed as a
bar,
> Field #2 a line. I would like to allow the user to choose via a parameter
if
> the line is displayed.
> I tried the following expression for the Field:
> =iif(Parameters!ShowTrend.Value=True,Fields!Trend.Value,False)
> But rather than hiding the line, it makes all values zero with the line
> still showing.
> Is there some way to hide the line?
> Thanks.
>|||Show/hide is not supported in charts.
But why don't you try a dynamic series grouping and filter those series
groupings that you don't want show (the Grouping&Sorting dialog for every
chart grouping has a filter tab where you can define expressions to filter
data). This should also take care of the chart legend issue.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bill" <bill@.discussions.microsoft.com> wrote in message
news:6B4516F9-D415-4522-838F-BCBAF0789F30@.microsoft.com...
> Thanks for the reply, but "Nothing" gives me the same results as "False"
...
> the line shows-up on bottom with zero values.
> I can get the effect of hiding (sort of) by setting color to transparent.
> But the data series still displays in the legend box.
> Is there no way to dynamically let the user specify what data elements
they
> want to show/hide on a chart?
> Bill
> "Robert Bruckner [MSFT]" wrote:
> > You may want to try:
> > =iif(Parameters!ShowTrend.Value=True, Fields!Trend.Value, Nothing)
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "bill" <bill@.discussions.microsoft.com> wrote in message
> > news:745AF66D-CC9D-4D91-845C-FD4227C08E59@.microsoft.com...
> > > I have a Bar/Line Chart with two data fields. Field #1 is displayed as
a
> > bar,
> > > Field #2 a line. I would like to allow the user to choose via a
parameter
> > if
> > > the line is displayed.
> > >
> > > I tried the following expression for the Field:
> > >
> > > =iif(Parameters!ShowTrend.Value=True,Fields!Trend.Value,False)
> > >
> > > But rather than hiding the line, it makes all values zero with the
line
> > > still showing.
> > >
> > > Is there some way to hide the line?
> > >
> > > Thanks.
> > >
> > >
> >
> >
> >
Subscribe to:
Posts (Atom)