Showing posts with label customise. Show all posts
Showing posts with label customise. Show all posts

Sunday, March 25, 2012

Customising toolbar in the browser of RS HTML viewer

Dear friends,

please help me by commenting on my query.

Query::

I want to know how to customise the tool bar in RS HTML viewer, we can hide or show the toolbar using rc:toolbar= false/true, But i want to customise the tool bar.

ie, There is a combo for export formats to export the displaying reports. I want to customise that combo. I can clear the items by removing the extension element in the config of RS, but i want to do it in run time .

ie, My different reports should show different export formats simulteniously

You can customize the individual items on the toolbar with the information below:

http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx

However, there is no way to dynamically customize the rendering extensions that can be used at runtime (or on a per-report basis). You essentially enable or disable each rendering extension in the config files, and based on this work, certain formats show or don't show in the combo-box.

If you *must* have this functionality, I'd suggest that you turn off the toolbar completely and create your own version of the HTML toolbar which handles paging, zooming, etc. via URL Access (There is a sample of this in SSRS 2000). If you go this route, YOU can choose what rendering extensions to show the user in your own combo-box...However this will take a fair amount of work.

|||

As u said i checked the path

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\styles

the Styles folder doesn't exist. my version is RS 2000 enterprise Edition.

i searched for .css files in my installation folder i only got one major css ie ,reportingservices.css in

Reportmanager\styles

|||

It's very helpful and good article.

but can we make the changes in main "htmlviewer.css" and we got the reflected changes in all the reportserver reports.so by doing this we don't have to make another copy of css file and give "rc:Stylesheet=cssfilename".

i have also second question is there any way by which we can pass "rc:Stylesheet=cssfilename" URL to parent report to child report(by drilling down-jump to report) method.

thanks in advance.

|||

i didnt see any provision for adding url parameters in child reports. but we shall try one thing .

In your parent u add a parametr in some name "stylesheet" , and pass the value . this we can do . and while making the chil report u can assign parametrs or that , so create a parameter in the name "rc:Stylesheet" and select the value . the value is the parent parame value

ie , "rc:Stylesheet = stylesheet "

hope u will inform me regarding this

|||

Hai it's good idea, thanks ..

i did one try and it's working.

i had add "rc:Stylesheet=cssfilename" in my parent report, now when i am drilling down to child report

"rc:Stylesheet=cssfilename" parameter will automatcally carried forward to next report(child report).so there is no problem

for passing "rc:Stylesheet=cssfilename" one report to another report.

but i try your solution in different case, because i have also problem while passing "rs:clearsession=true" to other report.

Thanks,
Sanket.

|||

Hi .

I had made the changes in respective CSS file for hiding print icon in report toolbar and deployed report in local reporting

service machine (LAN) and our onsite machine.

but the problem i am facing is when i am accessing my local reporting server machine at that time print icon is not

visible.so it's as per my requirement. but when i am accessing our onsite machine reporting server at that time i seen print

icon and it's only seen in my PC, my other team members doesn't seen that print icon both on local reporting service machine

and onsite reporting service machine.

can anyone help me out in this issue, because it's very urgent ..

Thanks,
Sanket.

Customising toolbar in the browser of RS HTML viewer

Dear friends,

please help me by commenting on my query.

Query::

I want to know how to customise the tool bar in RS HTML viewer, we can hide or show the toolbar using rc:toolbar= false/true, But i want to customise the tool bar.

ie, There is a combo for export formats to export the displaying reports. I want to customise that combo. I can clear the items by removing the extension element in the config of RS, but i want to do it in run time .

ie, My different reports should show different export formats simulteniously

You can customize the individual items on the toolbar with the information below:

http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx

However, there is no way to dynamically customize the rendering extensions that can be used at runtime (or on a per-report basis). You essentially enable or disable each rendering extension in the config files, and based on this work, certain formats show or don't show in the combo-box.

If you *must* have this functionality, I'd suggest that you turn off the toolbar completely and create your own version of the HTML toolbar which handles paging, zooming, etc. via URL Access (There is a sample of this in SSRS 2000). If you go this route, YOU can choose what rendering extensions to show the user in your own combo-box...However this will take a fair amount of work.

|||

As u said i checked the path

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\styles

the Styles folder doesn't exist. my version is RS 2000 enterprise Edition.

i searched for .css files in my installation folder i only got one major css ie ,reportingservices.css in

Reportmanager\styles

|||

It's very helpful and good article.

but can we make the changes in main "htmlviewer.css" and we got the reflected changes in all the reportserver reports.so by doing this we don't have to make another copy of css file and give "rc:Stylesheet=cssfilename".

i have also second question is there any way by which we can pass "rc:Stylesheet=cssfilename" URL to parent report to child report(by drilling down-jump to report) method.

thanks in advance.

|||

i didnt see any provision for adding url parameters in child reports. but we shall try one thing .

In your parent u add a parametr in some name "stylesheet" , and pass the value . this we can do . and while making the chil report u can assign parametrs or that , so create a parameter in the name "rc:Stylesheet" and select the value . the value is the parent parame value

ie , "rc:Stylesheet = stylesheet "

hope u will inform me regarding this

|||

Hai it's good idea, thanks ..

i did one try and it's working.

i had add "rc:Stylesheet=cssfilename" in my parent report, now when i am drilling down to child report

"rc:Stylesheet=cssfilename" parameter will automatcally carried forward to next report(child report).so there is no problem

for passing "rc:Stylesheet=cssfilename" one report to another report.

but i try your solution in different case, because i have also problem while passing "rs:clearsession=true" to other report.

Thanks,
Sanket.

|||

Hi .

I had made the changes in respective CSS file for hiding print icon in report toolbar and deployed report in local reporting

service machine (LAN) and our onsite machine.

but the problem i am facing is when i am accessing my local reporting server machine at that time print icon is not

visible.so it's as per my requirement. but when i am accessing our onsite machine reporting server at that time i seen print

icon and it's only seen in my PC, my other team members doesn't seen that print icon both on local reporting service machine

and onsite reporting service machine.

can anyone help me out in this issue, because it's very urgent ..

Thanks,
Sanket.

Customising Legends for chart

Hi to all,

A query about legends in a chart, is it possible to customise legends in chart? I have used formula fields as the value of a pie chart and apparently the legend shows "@." infront of the fieldname... I'd like to have my own legend name for reading friendliness.

Thanks.

-HenryAnd for your information I am using Crystal Report included with VS.net 2003.

Cheers.

-Henry|||i'm having the same problem..

anyone der to help?|||Hi Cynthia, it has been many years since I have post my question... But I think I don't have a solution. I believe a full version of Crystal Report allow renaming field name.|||ok. where can i get the full version of Crystal report? is it consider an additional component to integrate into visual studio?

Customise Report Parameters in Report Manager

Is it possible to add custom controls in for parameters in report manager?

I have a parameter that requires the user to click a button and select a bunch of things in another form. How can i do this in reporting services?

I also would like to change the layout of the parameters toolbar, ie. make text boxes smaller widths, show/hide parameters based on other parameter values.

I know i could write my own web page that does this and hide the parameters toolbar when they run the report, but this would mean that we lose other functionality that report manager has, eg. scheduling.

Does anyone know if customising the report manager will become available in a later version?

You're correct that you can't customize Report Manager like this in RS 2005. You're also correct that if you wrote your own app using the Reporting controls in VS 2005, you'd have a lot of flexibility.

As for whether you'll be able to do this customization of RM in a later version, I doubt it, but there is "talk" of shipping add'l VS Reporting controls for things like scheduling and security, so you could build your own RM implementation.

Customise Report Parameters in Report Manager

Is it possible to add custom controls in for parameters in report manager?

I have a parameter that requires the user to click a button and select a bunch of things in another form. How can i do this in reporting services?

I also would like to change the layout of the parameters toolbar, ie. make text boxes smaller widths, show/hide parameters based on other parameter values.

I know i could write my own web page that does this and hide the parameters toolbar when they run the report, but this would mean that we lose other functionality that report manager has, eg. scheduling.

Does anyone know if customising the report manager will become available in a later version?

You're correct that you can't customize Report Manager like this in RS 2005. You're also correct that if you wrote your own app using the Reporting controls in VS 2005, you'd have a lot of flexibility.

As for whether you'll be able to do this customization of RM in a later version, I doubt it, but there is "talk" of shipping add'l VS Reporting controls for things like scheduling and security, so you could build your own RM implementation.

Customise Report Manager

Hello
We have Reporting Services 2005 and was wondering if it is possible to
customise Report Manager interface and possibly add a company logo and maybe
status messages of when the databse was last refreshed?
Kind regards
Ricky
(SS2005/SSRS2005)This is from Books Online:
You can customize Report Manager in very limited ways. You can modify the
application title on the Site Settings page. If you are a Web developer, you
can modify the style sheets that contain the style information used by
Report Manager. Because Report Manager is not specifically designed to
support customization, you must thoroughly test any modification that you
make. If you find that Report Manager does not meet your needs, you can
develop a custom report viewer or configure SharePoint Web parts to find and
view reports in a SharePoint site.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ricky" <r@.msn.com> wrote in message
news:%23AwNV1eMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Hello
> We have Reporting Services 2005 and was wondering if it is possible to
> customise Report Manager interface and possibly add a company logo and
> maybe status messages of when the databse was last refreshed?
> Kind regards
> Ricky
> (SS2005/SSRS2005)
>|||Hi there
Sure you can add your company logo with these steps:
1. Make your logo an 46 x 48 jpg image file
2. Rename it to 48folderopen.jpg
3. Look for folder "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager\images" or where you install RSS2005
4. Rename the 48folderopen.jpg to 49folderopen_old.jpg (not necessary, but
it is always a good idea to have backup)
5. Copy your logo (renamed in step 2) to "C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportManager\images"
6. Enjoy
"Ricky" <r@.msn.com> escribió en el mensaje
news:%23AwNV1eMIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Hello
> We have Reporting Services 2005 and was wondering if it is possible to
> customise Report Manager interface and possibly add a company logo and
> maybe status messages of when the databse was last refreshed?
> Kind regards
> Ricky
> (SS2005/SSRS2005)
>|||Hello Morales
Thank you for you message, sounds promising. I'm assuming this swaps an
exisitng logo?
Incidently, I don't suppose you have had any experience modifying the
colours, fonts etc..?
Kind regards
Ricky
"CEMorales" <carlos_enrique_morales@.hotmail.com> wrote in message
news:u1AipmwMIHA.1204@.TK2MSFTNGP03.phx.gbl...
> Hi there
> Sure you can add your company logo with these steps:
> 1. Make your logo an 46 x 48 jpg image file
> 2. Rename it to 48folderopen.jpg
> 3. Look for folder "C:\Program Files\Microsoft SQL
> Server\MSSQL.3\Reporting Services\ReportManager\images" or where you
> install RSS2005
> 4. Rename the 48folderopen.jpg to 49folderopen_old.jpg (not necessary, but
> it is always a good idea to have backup)
> 5. Copy your logo (renamed in step 2) to "C:\Program Files\Microsoft SQL
> Server\MSSQL.3\Reporting Services\ReportManager\images"
> 6. Enjoy
>
> "Ricky" <r@.msn.com> escribió en el mensaje
> news:%23AwNV1eMIHA.4880@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> We have Reporting Services 2005 and was wondering if it is possible to
>> customise Report Manager interface and possibly add a company logo and
>> maybe status messages of when the databse was last refreshed?
>> Kind regards
>> Ricky
>> (SS2005/SSRS2005)
>

Tuesday, March 20, 2012

custom sp_browsereplcmds

Hi NG
I want to customise sp_browsereplcomdands.
I use an vb-Datagrid for output. The Grid can't show varbinary.
Thats why I need an additional column: cast (xact_seqno as bigint)
--CODE:
declare @.query nvarchar(4000),
@.dbname nvarchar(128)
set @.query='select xact_seqno,
originator_id,publisher_database_id,article_id,typ e,convert(int,partial_command),command
from MSrepl_commands order by originator_id, publisher_database_id,
xact_seqno,article_id,command_id'
set @.dbname='distribution'
exec master..xp_printstatements @.query, @.dbname
--WORKS FINE
--BUT
declare @.query nvarchar(4000), @.dbname nvarchar(128)
set @.query=
'select xact_seqno,
originator_id,publisher_database_id,article_id,typ e,convert(int,partial_command),command
from
MSrepl_commands order by originator_id, publisher_database_id,
xact_seqno,article_id,command_id,
convert(bigint, xact_seqno)' --< --
set @.dbname='distribution' exec master..xp_printstatements @.query,
@.dbname
--DOWN'T Show the additional Column, an alias is not possible
It seems, the parameter of xp_printstatements are not flexible to
parse an additonal column.
Any ideas?
Thanks Thomas
push the commands off into a separate table like this
sp_browsereplcmds @.results_table='test'
The schema looks like this
CREATE TABLE [dbo].[test] (
[xact_seqno] [varbinary] (16) NULL ,
[originator_id] [int] NULL ,
[publisher_database_id] [int] NULL ,
[article_id] [int] NULL ,
[type] [int] NULL ,
[command] [nvarchar] (1024) NULL
) ON [PRIMARY]
GO
alter table test
add transaction_sequenceno bigint
go
update test set transaction_sequenceno =convert(bigint, xact_seqno)
GO
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:4213a36c.181072656@.news.t-online.de...
> Hi NG
> I want to customise sp_browsereplcomdands.
> I use an vb-Datagrid for output. The Grid can't show varbinary.
> Thats why I need an additional column: cast (xact_seqno as bigint)
> --CODE:
> declare @.query nvarchar(4000),
> @.dbname nvarchar(128)
> set @.query='select xact_seqno,
>
originator_id,publisher_database_id,article_id,typ e,convert(int,partial_comm
and),command
> from MSrepl_commands order by originator_id, publisher_database_id,
> xact_seqno,article_id,command_id'
> set @.dbname='distribution'
> exec master..xp_printstatements @.query, @.dbname
> --WORKS FINE
> --BUT
> declare @.query nvarchar(4000), @.dbname nvarchar(128)
> set @.query=
> 'select xact_seqno,
>
originator_id,publisher_database_id,article_id,typ e,convert(int,partial_comm
and),command
> from
> MSrepl_commands order by originator_id, publisher_database_id,
> xact_seqno,article_id,command_id,
> convert(bigint, xact_seqno)' --< --
> set @.dbname='distribution' exec master..xp_printstatements @.query,
> @.dbname
>
> --DOWN'T Show the additional Column, an alias is not possible
>
> It seems, the parameter of xp_printstatements are not flexible to
> parse an additonal column.
>
> Any ideas?
> Thanks Thomas
|||thanks
I've seen this code inside sp_browsereplcmds.
But I hoped, there was another way.
Thomas
On Wed, 16 Feb 2005 15:38:13 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>push the commands off into a separate table like this
>sp_browsereplcmds @.results_table='test'
>The schema looks like this
>CREATE TABLE [dbo].[test] (
> [xact_seqno] [varbinary] (16) NULL ,
> [originator_id] [int] NULL ,
> [publisher_database_id] [int] NULL ,
> [article_id] [int] NULL ,
> [type] [int] NULL ,
> [command] [nvarchar] (1024) NULL
>) ON [PRIMARY]
>GO
>alter table test
>add transaction_sequenceno bigint
>go
>update test set transaction_sequenceno =convert(bigint, xact_seqno)
>GO
sql