Showing posts with label html. Show all posts
Showing posts with label html. 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.

Thursday, March 22, 2012

Custom Toolbars

Has anyone developed a custom toolbar in lieu of using the html viewer that
comes standard with SRS? Specifically, toolbars accessed through URL Access
to the report server.
If so, can you direct me to some knowledge bases articles or examples of how
they've been developed or deployed? Thanks!Brian,
With version 1.0 of RS you cannot replace the HTML toolbar. If you don't
like it, you could develop your own ASP.NET page which will have a custom
toolbar and render the report in the page.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Brian Eckert" <BrianEckert@.discussions.microsoft.com> wrote in message
news:1D6F08A6-BC4C-4E4E-9FFB-40C2A6ABAC5A@.microsoft.com...
> Has anyone developed a custom toolbar in lieu of using the html viewer
that
> comes standard with SRS? Specifically, toolbars accessed through URL
Access
> to the report server.
> If so, can you direct me to some knowledge bases articles or examples of
how
> they've been developed or deployed? Thanks!|||Teo,
Thanks but what I am looking for is a good knowledge base article or even
some code to use as example of doing just what you say...building a .NET page
that imitates the HTML toolbar. Basically, I just need some guidance on
talking to a RS Report from a standard .NET aspx page.
"Teo Lachev [MVP]" wrote:
> Brian,
> With version 1.0 of RS you cannot replace the HTML toolbar. If you don't
> like it, you could develop your own ASP.NET page which will have a custom
> toolbar and render the report in the page.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "Brian Eckert" <BrianEckert@.discussions.microsoft.com> wrote in message
> news:1D6F08A6-BC4C-4E4E-9FFB-40C2A6ABAC5A@.microsoft.com...
> > Has anyone developed a custom toolbar in lieu of using the html viewer
> that
> > comes standard with SRS? Specifically, toolbars accessed through URL
> Access
> > to the report server.
> >
> > If so, can you direct me to some knowledge bases articles or examples of
> how
> > they've been developed or deployed? Thanks!
>
>|||Brian,
<shameless self-promotion>
Well, my book has a whole chapter devoted on integrating RS with web-based
app. If you don't think like reading and buying it you could download the
book source code. There you will find an enhanced version of the
ReportViewer (AWReportViewer). It is a ASP.NET web control which supports
rendering reports on the client (URL addressability) and server side (SOAP).
Talking about articles, the good news is that I wrote an article on
web-based reporting for Visual Basic Developer magazine
(http://www.pinnaclepublishing.com/ME2/Audiences/default.asp). The bad news
is that it requires paid access :-(. I hope MSDN will pick it up soon.
</shameless self-promotion>
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Brian Eckert" <BrianEckert@.discussions.microsoft.com> wrote in message
news:1E92BF28-CFFF-40C2-AB30-E2C02BD389DB@.microsoft.com...
> Teo,
> Thanks but what I am looking for is a good knowledge base article or even
> some code to use as example of doing just what you say...building a .NET
page
> that imitates the HTML toolbar. Basically, I just need some guidance on
> talking to a RS Report from a standard .NET aspx page.
> "Teo Lachev [MVP]" wrote:
> > Brian,
> >
> > With version 1.0 of RS you cannot replace the HTML toolbar. If you don't
> > like it, you could develop your own ASP.NET page which will have a
custom
> > toolbar and render the report in the page.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MVP [SQL Server], MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > Publisher website: http://www.manning.com/lachev
> > Buy it from Amazon.com: http://shrinkster.com/eq
> > Home page and blog: http://www.prologika.com/
> > ---
> >
> > "Brian Eckert" <BrianEckert@.discussions.microsoft.com> wrote in message
> > news:1D6F08A6-BC4C-4E4E-9FFB-40C2A6ABAC5A@.microsoft.com...
> > > Has anyone developed a custom toolbar in lieu of using the html viewer
> > that
> > > comes standard with SRS? Specifically, toolbars accessed through URL
> > Access
> > > to the report server.
> > >
> > > If so, can you direct me to some knowledge bases articles or examples
of
> > how
> > > they've been developed or deployed? Thanks!
> >
> >
> >|||Thanks Teo...I will take a look...with our those wonderful promotions, it's
the least I could do
Brian
"Teo Lachev [MVP]" wrote:
> Brian,
> <shameless self-promotion>
> Well, my book has a whole chapter devoted on integrating RS with web-based
> app. If you don't think like reading and buying it you could download the
> book source code. There you will find an enhanced version of the
> ReportViewer (AWReportViewer). It is a ASP.NET web control which supports
> rendering reports on the client (URL addressability) and server side (SOAP).
> Talking about articles, the good news is that I wrote an article on
> web-based reporting for Visual Basic Developer magazine
> (http://www.pinnaclepublishing.com/ME2/Audiences/default.asp). The bad news
> is that it requires paid access :-(. I hope MSDN will pick it up soon.
> </shameless self-promotion>
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "Brian Eckert" <BrianEckert@.discussions.microsoft.com> wrote in message
> news:1E92BF28-CFFF-40C2-AB30-E2C02BD389DB@.microsoft.com...
> > Teo,
> >
> > Thanks but what I am looking for is a good knowledge base article or even
> > some code to use as example of doing just what you say...building a .NET
> page
> > that imitates the HTML toolbar. Basically, I just need some guidance on
> > talking to a RS Report from a standard .NET aspx page.
> >
> > "Teo Lachev [MVP]" wrote:
> >
> > > Brian,
> > >
> > > With version 1.0 of RS you cannot replace the HTML toolbar. If you don't
> > > like it, you could develop your own ASP.NET page which will have a
> custom
> > > toolbar and render the report in the page.
> > >
> > > --
> > > Hope this helps.
> > >
> > > ---
> > > Teo Lachev, MVP [SQL Server], MCSD, MCT
> > > Author: "Microsoft Reporting Services in Action"
> > > Publisher website: http://www.manning.com/lachev
> > > Buy it from Amazon.com: http://shrinkster.com/eq
> > > Home page and blog: http://www.prologika.com/
> > > ---
> > >
> > > "Brian Eckert" <BrianEckert@.discussions.microsoft.com> wrote in message
> > > news:1D6F08A6-BC4C-4E4E-9FFB-40C2A6ABAC5A@.microsoft.com...
> > > > Has anyone developed a custom toolbar in lieu of using the html viewer
> > > that
> > > > comes standard with SRS? Specifically, toolbars accessed through URL
> > > Access
> > > > to the report server.
> > > >
> > > > If so, can you direct me to some knowledge bases articles or examples
> of
> > > how
> > > > they've been developed or deployed? Thanks!
> > >
> > >
> > >
>
>

Monday, March 19, 2012

Custom Rendering Extension for HTML Fields

I am using RS 2005, a "comments" field in a database contains HTML content. When rendering the field on the report it displays raw HTML.

Does anybody knows about a custom rendering extension that will render HTML content?

Thanks

Fernando

Has anyone resolved this? I am facing a similar issue. My website has form that takes comments via FreeTextBox. It is probably similar to what is used on this FORUM! The FreeTextBox control returns text with HTML tags throughout. I need to display the same data via Reporting Services. Currently using SQL Server 2000, Migrating to 2005 soon.

This has to be a common scenario. How about a third party control?

Thanks.

|||

This is currently not supported. See http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx. We are working on this for an upcoming release.

Custom Rendering Extension for HTML Fields

I am using RS 2005, a "comments" field in a database contains HTML content. When rendering the field on the report it displays raw HTML.

Does anybody knows about a custom rendering extension that will render HTML content?

Thanks

Fernando

Has anyone resolved this? I am facing a similar issue. My website has form that takes comments via FreeTextBox. It is probably similar to what is used on this FORUM! The FreeTextBox control returns text with HTML tags throughout. I need to display the same data via Reporting Services. Currently using SQL Server 2000, Migrating to 2005 soon.

This has to be a common scenario. How about a third party control?

Thanks.

|||

This is currently not supported. See http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx. We are working on this for an upcoming release.

Custom Rendering Extension for HTML Fields

I am using RS 2005, a "comments" field in a database contains HTML content. When rendering the field on the report it displays raw HTML.

Does anybody knows about a custom rendering extension that will render HTML content?

Thanks

Fernando

Has anyone resolved this? I am facing a similar issue. My website has form that takes comments via FreeTextBox. It is probably similar to what is used on this FORUM! The FreeTextBox control returns text with HTML tags throughout. I need to display the same data via Reporting Services. Currently using SQL Server 2000, Migrating to 2005 soon.

This has to be a common scenario. How about a third party control?

Thanks.

|||

This is currently not supported. See http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx. We are working on this for an upcoming release.