Customize Report manager Homepage

Hi, I wanted to put my company name instead of "Home" in the reporting
services manager. I tried to search the whole reporting services folder for
the text "Home" and not able to figureout how to change it. Looks like we
cannot change the text?
Any ideas?
Thanks
"Hausbro" <Hausbro@.discussions.microsoft.com> wrote in message
news:B79622C2-29E0-4A66-8F8D-E838A4B65CE7@.microsoft.com...
> Does it work to just put an ® after the uppertitle in the html source
code?
>
> "jsteensen" wrote:
>
> > Hausbro,
> >
> > Thanks - that solved part of my problem - upsizing and bolding the site
name
> > text (used msrs-uppertitle) and un-bolding the page name
(msrs-lowertitle).
> > Any hint on how to superscript a ® in the uppertitle? I'm not very good
at
> > style sheets.
> >
> > John
> >
> > "Hausbro" wrote:
> >
> > > If you view the source there is a file called 'ReportingServices.css'
that
> > > should contain formatting for the page.
> > >
> > > The following classes effect the text 'Home':
> > >
> > > msrs-lowertitle
> > > msrs-banner
> > > msrs-selectedTab
> > > msrs-normal
> > >
> > > You can find more by simply viewing the source and finding out what
class
> > > they are tied to.
> > >
> > > Hope that helps...
> > >
> > > "jsteensen" wrote:
> > >
> > > > Terry,
> > > >
> > > > I changed the folder icon to a corporate logo on the Report Manager
Home
> > > > page by:
> > > >
> > > > 1) doing view source on the page and noting that folder icon was
> > > > 48folderopen.jpg
> > > > 2) found that icon in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting
> > > > Services\ReportManager\images
> > > > 3) found that it was a 48x48 jpg image
> > > > 4) produced a 48x48 jpg image of the corporate logo
> > > > 5) renamed 48folderopen.jpg to 48folderopen_orig.jpg (in case I
wanted to go
> > > > back)
> > > > 6) renamed the 48x48 corp logo to 48folderopen.jpg and finally
> > > > 7) copied the logo into the image folder above and hit refresh
> > > >
> > > > This worked for me. Hope it helps.
> > > >
> > > > Still haven't figured out how to fancy up the Site Name yet.
> > > >
> > > > John
> > > >
> > > > "Terry" wrote:
> > > >
> > > > > Hi All,
> > > > > There is a posting in this forum already about this...but it
doesnt really
> > > > > tell me how to modify the home page. Like the previous user who
posted a
> > > > > message I am wanting to put our organisations logo on the home
page. Any
> > > > > suggestions would be much appreciated.
> > > > >
> > > > > Regards,
> > > > > TerryYou can put a logo into by changing the background-image style in the
ReportingServices.css file under the ReportManager/styles folder.
"Sri" wrote:
> Hi, I wanted to put my company name instead of "Home" in the reporting
> services manager. I tried to search the whole reporting services folder for
> the text "Home" and not able to figureout how to change it. Looks like we
> cannot change the text?
> Any ideas?
> Thanks
>
> "Hausbro" <Hausbro@.discussions.microsoft.com> wrote in message
> news:B79622C2-29E0-4A66-8F8D-E838A4B65CE7@.microsoft.com...
> > Does it work to just put an ® after the uppertitle in the html source
> code?
> >
> > "jsteensen" wrote:
> >
> > > Hausbro,
> > >
> > > Thanks - that solved part of my problem - upsizing and bolding the site
> name
> > > text (used msrs-uppertitle) and un-bolding the page name
> (msrs-lowertitle).
> > > Any hint on how to superscript a ® in the uppertitle? I'm not very good
> at
> > > style sheets.
> > >
> > > John
> > >
> > > "Hausbro" wrote:
> > >
> > > > If you view the source there is a file called 'ReportingServices.css'
> that
> > > > should contain formatting for the page.
> > > >
> > > > The following classes effect the text 'Home':
> > > >
> > > > msrs-lowertitle
> > > > msrs-banner
> > > > msrs-selectedTab
> > > > msrs-normal
> > > >
> > > > You can find more by simply viewing the source and finding out what
> class
> > > > they are tied to.
> > > >
> > > > Hope that helps...
> > > >
> > > > "jsteensen" wrote:
> > > >
> > > > > Terry,
> > > > >
> > > > > I changed the folder icon to a corporate logo on the Report Manager
> Home
> > > > > page by:
> > > > >
> > > > > 1) doing view source on the page and noting that folder icon was
> > > > > 48folderopen.jpg
> > > > > 2) found that icon in C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting
> > > > > Services\ReportManager\images
> > > > > 3) found that it was a 48x48 jpg image
> > > > > 4) produced a 48x48 jpg image of the corporate logo
> > > > > 5) renamed 48folderopen.jpg to 48folderopen_orig.jpg (in case I
> wanted to go
> > > > > back)
> > > > > 6) renamed the 48x48 corp logo to 48folderopen.jpg and finally
> > > > > 7) copied the logo into the image folder above and hit refresh
> > > > >
> > > > > This worked for me. Hope it helps.
> > > > >
> > > > > Still haven't figured out how to fancy up the Site Name yet.
> > > > >
> > > > > John
> > > > >
> > > > > "Terry" wrote:
> > > > >
> > > > > > Hi All,
> > > > > > There is a posting in this forum already about this...but it
> doesnt really
> > > > > > tell me how to modify the home page. Like the previous user who
> posted a
> > > > > > message I am wanting to put our organisations logo on the home
> page. Any
> > > > > > suggestions would be much appreciated.
> > > > > >
> > > > > > Regards,
> > > > > > Terry
>
>
>

Custom Userform for entering paremeters

How would I intergrate a userform into a report?
I have no problem creating the form in VB.
I want to use the form instead of the default paremeter controls that RS
uses. The form will ask a series of paremeters many of which will be an
either/or and create the SQL statement for which I would then want to pass on
to Reporting Services to get the data for the report.
Just point me in the right direction.David wrote:
> How would I intergrate a userform into a report?
> I want to use the form instead of the default paremeter controls that
> RS uses. The form will ask a series of paremeters many of which will
> be an either/or and create the SQL statement for which I would then
> want to pass on to Reporting Services to get the data for the report.
> Just point me in the right direction.
Use the report viewer control on a asp.net webform
regards
Frank

Custom Drilldown Objects

Is there anyway to make an image or text be the drilldown activator instead
of the dinky little + - symbols?
thanks in advance,
caseyUnfortunately, no. This has been on our wishlist for a while, but we
haven't gotten to it yet.
(Note: Technically this would be possible by postprocessing the HTML if you
happen to be embedding RS into your own application)
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Casey" <coronaride@.yahoo.com> wrote in message
news:OF9dkfAdEHA.3020@.TK2MSFTNGP11.phx.gbl...
> Is there anyway to make an image or text be the drilldown activator
instead
> of the dinky little + - symbols?
> thanks in advance,
> casey
>|||I think that there is commercailly available .Net control for this...
Do a'Google
HTH
JeffP...
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:uIQvbsBdEHA.384@.TK2MSFTNGP10.phx.gbl...
> Unfortunately, no. This has been on our wishlist for a while, but we
> haven't gotten to it yet.
> (Note: Technically this would be possible by postprocessing the HTML if you
> happen to be embedding RS into your own application)
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "Casey" <coronaride@.yahoo.com> wrote in message
> news:OF9dkfAdEHA.3020@.TK2MSFTNGP11.phx.gbl...
> > Is there anyway to make an image or text be the drilldown activator
> instead
> > of the dinky little + - symbols?
> >
> > thanks in advance,
> > casey
> >
> >
>

Cursors vs. Queries

Can someone give me an example of when I would use a cursor instead of a que
ryIf you can use a query to get what you want you should never use a cursor.
Cursors are best for maintenance type tasks where you need to loop thru say
a collection of tables and do something such as reindexing. As for data use
they should be used as a last resort only. Sometimes it is just not
practical or even feasible to issue strictly set based commands and get what
you want so a cursor might be necessary. For instance if you have to do
some work on each row that can only be done thru calling a stored
procedure(s) you might create a cursor and loop thru calling it for each
row. Otherwise try to use standard set based commands.
Andrew J. Kelly SQL MVP
"Vincent Jones" <vncntj@.hotmail.com> wrote in message
news:ba2a2d30.0401140615.581598f2@.posting.google.com...

quote:

---

> Can someone give me an example of when I would use a cursor instead of a

---

query|||In a properly designed database the occassions when a cursor is a good and
efficient solution to a problem are rare.
Sometimes cursors are useful for certain administrative functions or for
processes such as Andrew described.
Very occassionally you find a data manipulation problem which doesn't have a
feasible set-based solution. If you think you've encountered one of those
situations then post your problem here and see if someone else can suggest
an alternative.
In reality, many examples of cursor code are written by programmers who
aren't familiar with SQL and are more comfortable with row-by-row sequential
processing than with set-based SELECT statements. So for data manipulation
problems my general rule would be: If you think you need a cursor - think
again. If you're sure you need a cursor - get a second opinion.
David Portas
--
Please reply only to the newsgroup
--

Cursors vs. Queries

Can someone give me an example of when I would use a cursor instead of a queryIf you can use a query to get what you want you should never use a cursor.
Cursors are best for maintenance type tasks where you need to loop thru say
a collection of tables and do something such as reindexing. As for data use
they should be used as a last resort only. Sometimes it is just not
practical or even feasible to issue strictly set based commands and get what
you want so a cursor might be necessary. For instance if you have to do
some work on each row that can only be done thru calling a stored
procedure(s) you might create a cursor and loop thru calling it for each
row. Otherwise try to use standard set based commands.
--
Andrew J. Kelly SQL MVP
"Vincent Jones" <vncntj@.hotmail.com> wrote in message
news:ba2a2d30.0401140615.581598f2@.posting.google.com...
> Can someone give me an example of when I would use a cursor instead of a
query|||One query statement is much faster than the equivalent
Cursor query.
If I am correct (and please tell me if I'm wrong) its
about 20 times faster than putting the same statement in a
cursor.
However cursors are more controllable, and better for
error checking and error recovery.
My rule of thumb.
If you can get a way with using a query then use it,
however you will need cursors to do anything complex.
J
>--Original Message--
>Can someone give me an example of when I would use a
cursor instead of a query
>.
>|||In a properly designed database the occassions when a cursor is a good and
efficient solution to a problem are rare.
Sometimes cursors are useful for certain administrative functions or for
processes such as Andrew described.
Very occassionally you find a data manipulation problem which doesn't have a
feasible set-based solution. If you think you've encountered one of those
situations then post your problem here and see if someone else can suggest
an alternative.
In reality, many examples of cursor code are written by programmers who
aren't familiar with SQL and are more comfortable with row-by-row sequential
processing than with set-based SELECT statements. So for data manipulation
problems my general rule would be: If you think you need a cursor - think
again. If you're sure you need a cursor - get a second opinion.
--
David Portas
--
Please reply only to the newsgroup
--|||> however you will need cursors to do anything complex.
Could you give an example of a problem that is too complex for a query
solution?
--
David Portas
--
Please reply only to the newsgroup
--