Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, ShyamThere are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.

Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!

Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, Shyam
There are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.

Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!

Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, Shyam
There are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.

Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!

Is there any way to blank out certain columns in a single sele

The users doesn't want the data for these 4 columns to print out unless the
formID is one of the ones selected. I can use "" instead. The dataset is
sent to Crystal Report to print out so it's better using "". I think Crysta
l
prints out the word "NULL" if they're set to NULL.
Thanks.
"Raymond D'Anjou" wrote:

> Add a Case for each of these columns.
> Example:
> ...CASE when b.formID in ('2', '16', '11', '12', '1', '13', '10') then NU
LL
> else b.form end as form,...
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:9BD3F043-072D-4598-B2BB-BA63529EA142@.microsoft.com...
>
>I don't know anything about Crystal report.
You can use '' for Text datatypes but the numerics and dates may not give
you what you want.
You may have to do a bit of CASTing for these types.
If the users can only choose 1 formID, just build your query differently in
C#.
if formid in ('2', '16', '11', '12', '1', '13', '10') then
select t.tid, t.tdate, t.trip_ticket,t.source,'' AS form, '' AS
formdate, '' AS printed,...
else
select t.tid,t.tdate,t.trip_ticket,t.source,b.form, b.formdate,
b.printed,
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:D27DCE8F-4B22-41C1-BDDF-A344467FCD63@.microsoft.com...
> The users doesn't want the data for these 4 columns to print out unless
> the
> formID is one of the ones selected. I can use "" instead. The dataset is
> sent to Crystal Report to print out so it's better using "". I think
> Crystal
> prints out the word "NULL" if they're set to NULL.
> Thanks.
> "Raymond D'Anjou" wrote:
>|||Hi,Thank you for the reply. I think the system got messed up here. The
"NULL" answer was address to Mesa's question.
My question for you is: Do I just append the "Case..." to the end of my
select
statement?
"Alpha" wrote:
> The users doesn't want the data for these 4 columns to print out unless th
e
> formID is one of the ones selected. I can use "" instead. The dataset is
> sent to Crystal Report to print out so it's better using "". I think Crys
tal
> prints out the word "NULL" if they're set to NULL.
> Thanks.
> "Raymond D'Anjou" wrote:
>|||No, the Case replaces the column name in your Select statement.
So, instead of:
select b.form,...
select CASE when b.formID in ('2', '16', '11', '12', '1', '13', '10') then
NULL else b.form end as form,
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:ED00B94C-E471-4508-9F1C-D8E2803E47EC@.microsoft.com...
> Hi,Thank you for the reply. I think the system got messed up here. The
> "NULL" answer was address to Mesa's question.
> My question for you is: Do I just append the "Case..." to the end of my
> select
> statement?
>
> "Alpha" wrote:
>

Is there any tool for printing all table structure of a database

Dear all,
I am wondering if there is any tool which allows us to print out the table
structure of all tables in a database. Anyone knows?
Thanks a lot.Hi,
Query the below system view.
INFORMATION_SCHEMA.COLUMNS
Thanks
Hari
SQL Server MVP
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.|||Right-Click your database, select All Tasks and then select Generate SQL
Scripts
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.|||On Fri, 26 Aug 2005 19:56:01 -0700, "Ivan"
<Ivan@.discussions.microsoft.com> wrote:
>I am wondering if there is any tool which allows us to print out the table
>structure of all tables in a database. Anyone knows?
>Thanks a lot.
Besides the previous two answers, also look at the diagram feature in
Enterprise Manager!
J.|||> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
If "print" really means "paper", check out the Schema Printing features
in our tool called Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Is there any tool for printing all table structure of a database

Dear all,
I am wondering if there is any tool which allows us to print out the table
structure of all tables in a database. Anyone knows?
Thanks a lot.
Hi,
Query the below system view.
INFORMATION_SCHEMA.COLUMNS
Thanks
Hari
SQL Server MVP
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
|||Right-Click your database, select All Tasks and then select Generate SQL
Scripts
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
|||On Fri, 26 Aug 2005 19:56:01 -0700, "Ivan"
<Ivan@.discussions.microsoft.com> wrote:
>I am wondering if there is any tool which allows us to print out the table
>structure of all tables in a database. Anyone knows?
>Thanks a lot.
Besides the previous two answers, also look at the diagram feature in
Enterprise Manager!
J.
|||
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
If "print" really means "paper", check out the Schema Printing features
in our tool called Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Is there any tool for printing all table structure of a database

Dear all,
I am wondering if there is any tool which allows us to print out the table
structure of all tables in a database. Anyone knows?
Thanks a lot.Hi,
Query the below system view.
INFORMATION_SCHEMA.COLUMNS
Thanks
Hari
SQL Server MVP
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.|||Right-Click your database, select All Tasks and then select Generate SQL
Scripts
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.|||On Fri, 26 Aug 2005 19:56:01 -0700, "Ivan"
<Ivan@.discussions.microsoft.com> wrote:
>I am wondering if there is any tool which allows us to print out the table
>structure of all tables in a database. Anyone knows?
>Thanks a lot.
Besides the previous two answers, also look at the diagram feature in
Enterprise Manager!
J.|||
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
If "print" really means "paper", check out the Schema Printing features
in our tool called Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com