Customize Report Manager

I would like to use Report Managers interface for choosing reports.

But all of the reports uses different dsu(datasourceuser) and dsp(datasourcepassword) depending on which user that is logon.

I would like to call the interface from a webapplication(where they have the current dsu & dsp).

Is there a way to customize Report Manager to save the dsu & dsp so users don't have to login for each report?

Or could I make a clever transformation from the Windows userid?

Or any other ideas?

There is not much you can do to customize report manager. I would recommend using Visual Studio 2005 to create a web application.

customized order by

I would like to some how customize my order by clause such that data gets
ordered in a very specific manner.
Please consider the following ddl
set nocount on
go
create table z_my_tbl_del
( i int,
n char(8)
)
go
insert z_my_tbl_del values(1,'aaa')
insert z_my_tbl_del values(1,'aaa')
insert z_my_tbl_del values(2,'bbb')
insert z_my_tbl_del values(2,'bbb')
insert z_my_tbl_del values(3,'ccc')
insert z_my_tbl_del values(3,'ccc')
insert z_my_tbl_del values(4,'ddd')
insert z_my_tbl_del values(4,'ddd')
insert z_my_tbl_del values(5,'eee')
insert z_my_tbl_del values(5,'eee')
go
select * from z_my_tbl_del
/*
/*
i n
-- --
1 aaa
1 aaa
2 bbb
2 bbb
3 ccc
3 ccc
4 ddd
4 ddd
5 eee
5 eee
*/
*/
go
drop table z_my_tbl_del
go
How can I write order by clause such that it orders by bbb first, then ddd
and then it would sort rest of the items regularly.
Please let me know if there is a way of doing it.
TIA...
/*
i n
-- --
2 bbb
2 bbb
4 ddd
4 ddd
1 aaa
1 aaa
3 ccc
3 ccc
5 eee
5 eee
*/ORDER BY CASE n WHEN 'bbb' THEN 1 WHEN 'ddd' THEN 2 ELSE 3 END, i
"sqlster" <trisha@.nospam.nospam> wrote in message
news:9524A826-4A16-4AED-A0E1-F7A4D9AAF4B2@.microsoft.com...
>I would like to some how customize my order by clause such that data gets
> ordered in a very specific manner.
> Please consider the following ddl
> set nocount on
> go
> create table z_my_tbl_del
> ( i int,
> n char(8)
> )
> go
> insert z_my_tbl_del values(1,'aaa')
> insert z_my_tbl_del values(1,'aaa')
> insert z_my_tbl_del values(2,'bbb')
> insert z_my_tbl_del values(2,'bbb')
> insert z_my_tbl_del values(3,'ccc')
> insert z_my_tbl_del values(3,'ccc')
> insert z_my_tbl_del values(4,'ddd')
> insert z_my_tbl_del values(4,'ddd')
> insert z_my_tbl_del values(5,'eee')
> insert z_my_tbl_del values(5,'eee')
> go
> select * from z_my_tbl_del
> /*
> /*
> i n
> -- --
> 1 aaa
> 1 aaa
> 2 bbb
> 2 bbb
> 3 ccc
> 3 ccc
> 4 ddd
> 4 ddd
> 5 eee
> 5 eee
> */
> */
> go
> drop table z_my_tbl_del
> go
> How can I write order by clause such that it orders by bbb first, then ddd
> and then it would sort rest of the items regularly.
> Please let me know if there is a way of doing it.
> TIA...
> /*
> i n
> -- --
> 2 bbb
> 2 bbb
> 4 ddd
> 4 ddd
> 1 aaa
> 1 aaa
> 3 ccc
> 3 ccc
> 5 eee
> 5 eee
> */
>|||Basically, you want 2 levels of ordering with the first level consisting of
an expression that evaluates 'bbb' and 'ddd' at the top of the list.
Modify your query like so:
select
*
from
#z_my_tbl_del
order by
case n
when 'bbb' then 1
when 'ddd' then 2
else 3
end,
n
"sqlster" <trisha@.nospam.nospam> wrote in message
news:9524A826-4A16-4AED-A0E1-F7A4D9AAF4B2@.microsoft.com...
>I would like to some how customize my order by clause such that data gets
> ordered in a very specific manner.
> Please consider the following ddl
> set nocount on
> go
> create table z_my_tbl_del
> ( i int,
> n char(8)
> )
> go
> insert z_my_tbl_del values(1,'aaa')
> insert z_my_tbl_del values(1,'aaa')
> insert z_my_tbl_del values(2,'bbb')
> insert z_my_tbl_del values(2,'bbb')
> insert z_my_tbl_del values(3,'ccc')
> insert z_my_tbl_del values(3,'ccc')
> insert z_my_tbl_del values(4,'ddd')
> insert z_my_tbl_del values(4,'ddd')
> insert z_my_tbl_del values(5,'eee')
> insert z_my_tbl_del values(5,'eee')
> go
> select * from z_my_tbl_del
> /*
> /*
> i n
> -- --
> 1 aaa
> 1 aaa
> 2 bbb
> 2 bbb
> 3 ccc
> 3 ccc
> 4 ddd
> 4 ddd
> 5 eee
> 5 eee
> */
> */
> go
> drop table z_my_tbl_del
> go
> How can I write order by clause such that it orders by bbb first, then ddd
> and then it would sort rest of the items regularly.
> Please let me know if there is a way of doing it.
> TIA...
> /*
> i n
> -- --
> 2 bbb
> 2 bbb
> 4 ddd
> 4 ddd
> 1 aaa
> 1 aaa
> 3 ccc
> 3 ccc
> 5 eee
> 5 eee
> */
>|||1) use table for the ordering
CREATE TABLE SpecialSort
(sort_order INTEGER NOT NULL,
n CHAR(3) NOT NULL);
INSERT INTO S.sort_order VALUES (1, 'bbb');
INSERT INTO S.sort_order VALUES (2, 'ddd');
INSERT INTO S.sort_order VALUES (3, 'aaa');
etc.
SELECT F.*, S.sort_order
FROM Foobar AS F, SpecialSort AS S
WHERE S.n = F.n
ORDER BY S.sort_order;
2) use a string
SELECT F.*, CHARINDEX (n, 'bbbdddaaaccceee') AS sort_order
FROM Foobar
ORDER BY sort_order;|||Why do you want to do this? Just one time? I would suggest that you add a
sort column to your actual table if you want to sort it differently
(especially since the client probably will want to change the sort
sometimes.) If it is just for certain reports, then implement a report sort
order table and you can then change the ordering at will.
create table sortOrder(
reportName varchar(10),
n varchar(8),
sortOrder int,
primary key (reportName, N),
unique (reportName, sortOrder)
)
insert into sortorder values('yours','bbb',1)
insert into sortorder values('yours','ddd',2)
select z_my_tbl_del.*
from z_my_tbl_del
left outer join sortorder
on z_my_tbl_del.n = sortOrder.n
and sortOrder.reportName = 'yours'
order by coalesce(sortorder.sortOrder,2000000000) asc, z_my_tbl_del.n
insert into sortorder values('yours','bbb',1)
insert into sortorder values('yours','ddd',2)
insert into sortorder values('mine','eee',1)
insert into sortorder values('mine','ddd',2)
insert into sortorder values('mine','aaa',3)
select z_my_tbl_del.*
from z_my_tbl_del
left outer join sortorder
on z_my_tbl_del.n = sortOrder.n
and sortOrder.reportName = 'mine'
order by coalesce(sortorder.sortOrder,2000000000) asc, z_my_tbl_del.n
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"sqlster" <trisha@.nospam.nospam> wrote in message
news:9524A826-4A16-4AED-A0E1-F7A4D9AAF4B2@.microsoft.com...
>I would like to some how customize my order by clause such that data gets
> ordered in a very specific manner.
> Please consider the following ddl
> set nocount on
> go
> create table z_my_tbl_del
> ( i int,
> n char(8)
> )
> go
> insert z_my_tbl_del values(1,'aaa')
> insert z_my_tbl_del values(1,'aaa')
> insert z_my_tbl_del values(2,'bbb')
> insert z_my_tbl_del values(2,'bbb')
> insert z_my_tbl_del values(3,'ccc')
> insert z_my_tbl_del values(3,'ccc')
> insert z_my_tbl_del values(4,'ddd')
> insert z_my_tbl_del values(4,'ddd')
> insert z_my_tbl_del values(5,'eee')
> insert z_my_tbl_del values(5,'eee')
> go
> select * from z_my_tbl_del
> /*
> /*
> i n
> -- --
> 1 aaa
> 1 aaa
> 2 bbb
> 2 bbb
> 3 ccc
> 3 ccc
> 4 ddd
> 4 ddd
> 5 eee
> 5 eee
> */
> */
> go
> drop table z_my_tbl_del
> go
> How can I write order by clause such that it orders by bbb first, then ddd
> and then it would sort rest of the items regularly.
> Please let me know if there is a way of doing it.
> TIA...
> /*
> i n
> -- --
> 2 bbb
> 2 bbb
> 4 ddd
> 4 ddd
> 1 aaa
> 1 aaa
> 3 ccc
> 3 ccc
> 5 eee
> 5 eee
> */
>

customized grouping

I have a tabular report with several groupings.
I want to customize one of the groups.
For example I have a field called country. I want to group it by
region, western and eastern. How would I do this?where does the regional information come from? you need to provide us with
more info about your fields and their data.
"OogleGoogle" <Yvonhong@.gmail.com> wrote in message
news:1183576344.729726.5950@.i38g2000prf.googlegroups.com...
>I have a tabular report with several groupings.
> I want to customize one of the groups.
> For example I have a field called country. I want to group it by
> region, western and eastern. How would I do this?
>

Customize where clause c# (RDL)

We have may reports that need to customize the where clause based on
parameters entered by the end user. Is there a way to modify the RDL on the
fly in order to achieve this? I am using VS2005 and SQLServer 2005.
Example:
if user selects run report by week ending date the following line needs to
be used
"and we_dt between ? and ?
if the user selects the run the report by export date then the line changes
to:
"and export_dt between ? and ?You can handle this via expressions in the command text of the dataset.
It is much easier than modifying the RDL on the fly.
For example, you can use VB expressions in the command text to
something like this:
="SELECT field1, field2 FROM tblName WHERE " &
iif(Parameter!Param1.Value = something, "do between stuff", "don't do
between stuff")
Andy Potter|||We'll look into this, but what if the entire WHERE cluase needs to be modified?
Are there any good examples of people doing this? Either through changing
the RDL or passing the entire where clause into the report?
Thanks
"Potter" wrote:
> You can handle this via expressions in the command text of the dataset.
> It is much easier than modifying the RDL on the fly.
> For example, you can use VB expressions in the command text to
> something like this:
> ="SELECT field1, field2 FROM tblName WHERE " &
> iif(Parameter!Param1.Value = something, "do between stuff", "don't do
> between stuff")
> Andy Potter
>|||Using expressions, your entire command text is available for
manipulation. Just do something like this:
="SELECT field1, field2 FROM tblName " & iif(Parameter!Param1.Value ="all", "", "WHERE field=" & Parameter!Param1.Value )
Personally, I prefer this kind of logic in a stored procedure. I find
large expressions to handle string manipulation to be a bit unwieldy.
The other option to handle large string manipulation is the custom code
section of the report, which give you a little more flexibility as far
writing your string manipulation code.
Andy Potter

Customize toolbar

I want to customize the toolbar (change color, button...).
Is it possible ? How ?It is possible in SP1. Check the SP1 readme for documentation on how to
supply a custom stylesheet.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Karine" <Karine@.discussions.microsoft.com> wrote in message
news:6D953609-51E1-4FDA-BDFF-67A2D01491E1@.microsoft.com...
> I want to customize the toolbar (change color, button...).
> Is it possible ? How ?

customize the table format

I don't want every row divided by a solid line,
how can I customize the table format so every third row
is divided by a solid line? is that even possible in reporting service? I
don't know what to do to make it happen."Britney" <britneychen_2001@.yahoo.com> wrote in message news:<#xmtlxnzEHA.824@.TK2MSFTNGP11.phx.gbl>...
> I don't want every row divided by a solid line,
> how can I customize the table format so every third row
> is divided by a solid line? is that even possible in reporting service? I
> don't know what to do to make it happen.
Hi Britney,
You can customize the table format in reporting services.
To have every third row divided by a solid line, the Borderstyle of
the textboxes inside the table have to be set based on the following
expression
=iif((RowNumber("DataSet1") mod 3=0),"Solid","None")
where DataSet1 is the dataset name you are going to use..
Hope this helps you.
Cheers,
Prathima.C|||YES, it worked partially,
the table looked pretty ugly now.
but I want the format with one line only. is that possible?
______________
1 3 4 5
1 4 5 5
2 4 5 6
______________
1 3 4 5
1 4 5 5
2 4 5 6
______________
.........
..........
"Prathima" <prathima.chandramouli@.gmail.com> wrote in message
news:f941b84.0411220300.5888d832@.posting.google.com...
> "Britney" <britneychen_2001@.yahoo.com> wrote in message
news:<#xmtlxnzEHA.824@.TK2MSFTNGP11.phx.gbl>...
> > I don't want every row divided by a solid line,
> > how can I customize the table format so every third row
> > is divided by a solid line? is that even possible in reporting service?
I
> > don't know what to do to make it happen.
> Hi Britney,
> You can customize the table format in reporting services.
> To have every third row divided by a solid line, the Borderstyle of
> the textboxes inside the table have to be set based on the following
> expression
> =iif((RowNumber("DataSet1") mod 3=0),"Solid","None")
> where DataSet1 is the dataset name you are going to use..
> Hope this helps you.
> Cheers,
> Prathima.C|||Can u please define the problem more clearly so that i can help u. I'm
not able to get your problem correctly.
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:<u8ELx2K0EHA.3976@.TK2MSFTNGP09.phx.gbl>...
> YES, it worked partially,
> the table looked pretty ugly now.
> but I want the format with one line only. is that possible?
>
> ______________
> 1 3 4 5
> 1 4 5 5
> 2 4 5 6
> ______________
> 1 3 4 5
> 1 4 5 5
> 2 4 5 6
> ______________
> .........
> ..........
>
> "Prathima" <prathima.chandramouli@.gmail.com> wrote in message
> news:f941b84.0411220300.5888d832@.posting.google.com...
> > "Britney" <britneychen_2001@.yahoo.com> wrote in message
> news:<#xmtlxnzEHA.824@.TK2MSFTNGP11.phx.gbl>...
> > > I don't want every row divided by a solid line,
> > > how can I customize the table format so every third row
> > > is divided by a solid line? is that even possible in reporting service?
> I
> > > don't know what to do to make it happen.
> >
> > Hi Britney,
> >
> > You can customize the table format in reporting services.
> > To have every third row divided by a solid line, the Borderstyle of
> > the textboxes inside the table have to be set based on the following
> > expression
> >
> > =iif((RowNumber("DataSet1") mod 3=0),"Solid","None")
> >
> > where DataSet1 is the dataset name you are going to use..
> > Hope this helps you.
> > Cheers,
> > Prathima.C|||never mind, I figured it out.
your logic is correct, I specified it in default input of border style, it
draw all the four lines (top, bottom, left ,right) as solid lines, but I
really should just specify it on "bottom" input box of border style.
thanks for your help
"Prathima" <prathima.chandramouli@.gmail.com> wrote in message
news:f941b84.0411232053.66adc74d@.posting.google.com...
> Can u please define the problem more clearly so that i can help u. I'm
> not able to get your problem correctly.
>
>
> "Britney" <britneychen_2001@.yahoo.com> wrote in message
news:<u8ELx2K0EHA.3976@.TK2MSFTNGP09.phx.gbl>...
> > YES, it worked partially,
> >
> > the table looked pretty ugly now.
> >
> > but I want the format with one line only. is that possible?
> >
> >
> >
> > ______________
> > 1 3 4 5
> > 1 4 5 5
> > 2 4 5 6
> > ______________
> > 1 3 4 5
> > 1 4 5 5
> > 2 4 5 6
> > ______________
> > .........
> > ..........
> >
> >
> >
> > "Prathima" <prathima.chandramouli@.gmail.com> wrote in message
> > news:f941b84.0411220300.5888d832@.posting.google.com...
> > > "Britney" <britneychen_2001@.yahoo.com> wrote in message
> > news:<#xmtlxnzEHA.824@.TK2MSFTNGP11.phx.gbl>...
> > > > I don't want every row divided by a solid line,
> > > > how can I customize the table format so every third row
> > > > is divided by a solid line? is that even possible in reporting
service?
> > I
> > > > don't know what to do to make it happen.
> > >
> > > Hi Britney,
> > >
> > > You can customize the table format in reporting services.
> > > To have every third row divided by a solid line, the Borderstyle of
> > > the textboxes inside the table have to be set based on the following
> > > expression
> > >
> > > =iif((RowNumber("DataSet1") mod 3=0),"Solid","None")
> > >
> > > where DataSet1 is the dataset name you are going to use..
> > > Hope this helps you.
> > > Cheers,
> > > Prathima.C

Customize the SQL Report

Hello
How to customize the mom report (SQL Report)? is there any guide available?
Thanx
Gopi
Gopi,
Take a look at:
Developing Custom MOM Reports v2.0
http://www.microsoft.com/downloads/d...displaylang=en
HTH
Jerry
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:%23UMVat70FHA.448@.TK2MSFTNGP09.phx.gbl...
> Hello
> How to customize the mom report (SQL Report)? is there any guide
> available?
> Thanx
> Gopi
>

Customize the SQL Report

Hello
How to customize the mom report (SQL Report)? is there any guide available?
Thanx
GopiGopi,
Take a look at:
Developing Custom MOM Reports v2.0
http://www.microsoft.com/downloads/...&displaylang=en
HTH
Jerry
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:%23UMVat70FHA.448@.TK2MSFTNGP09.phx.gbl...
> Hello
> How to customize the mom report (SQL Report)? is there any guide
> available?
> Thanx
> Gopi
>sql

Customize the SQL Report

Hello
How to customize the mom report (SQL Report)? is there any guide available?
Thanx
GopiGopi,
Take a look at:
Developing Custom MOM Reports v2.0
http://www.microsoft.com/downloads/details.aspx?FamilyId=97F6E49A-3834-49A2-B41D-3727C1011DBC&displaylang=en
HTH
Jerry
"Gopi" <gopigopi@.hotmail.com> wrote in message
news:%23UMVat70FHA.448@.TK2MSFTNGP09.phx.gbl...
> Hello
> How to customize the mom report (SQL Report)? is there any guide
> available?
> Thanx
> Gopi
>

Customize the reporting services interface display reports.

Hello:
We are using the reporting services interface to display reports. By using
the security we restricted some access and everything works fine.
Now we would like to change the way the parameters prompt works.
Is there any way of applying styles to the pages rendered by the reporting
server?
Thanks,
Daniel Bello.You can modify the RSReportServer.config file to specify a custom style
sheet for HTML Viewer. The <HTMLViewerStyleSheet> setting is not included in
the file by default. You must type it into the <Configuration> selection of
the RSReportServer.config file and then specify the style sheet you want to
use. Do not include the .css file extension when specifying the style sheet.
The following example provides an illustration of how to specify the style
sheet:
<Configuration>
...
<HTMLViewerStyleSheet>MyStyleSheet</HTMLViewerStyleSheet>
...Read the full article at:
http://msdn2.microsoft.com/en-us/library/ms345247.aspxThanks,Daniel Bello
Urizarri.

Customize the "Next topic" and "Previous topic"

Hi all,
By mistake I added the "Next topic" and "Previous topic" twice in the
toolbar and I don't know how to remove/delete one of them. To add the "Next
topic" in the toolbar by bring up the Customer window(right click on toolbar
and choose customize). Select "Help" in the categories and drap the command
from teh Commands list and drop the command on the target toolbar or menu.
Now I have the "Next topic" displayed twice in the toolbar but I don't know
how to remove one of them. Any help is greatly aggreciated.
JP
Jodie (Jodie@.discussions.microsoft.com) writes:
> By mistake I added the "Next topic" and "Previous topic" twice in the
> toolbar and I don't know how to remove/delete one of them. To add the
> "Next topic" in the toolbar by bring up the Customer window(right click
> on toolbar and choose customize). Select "Help" in the categories and
> drap the command from teh Commands list and drop the command on the
> target toolbar or menu. Now I have the "Next topic" displayed twice in
> the toolbar but I don't know how to remove one of them. Any help is
> greatly aggreciated.
You're talking about Books Online for SQL 2005, right?
Tools->Customize, and the right-click the button in the toolbar you want to
get rid of. Worked for me.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||It works. Thanks a lot Erland
"Erland Sommarskog" wrote:

> Jodie (Jodie@.discussions.microsoft.com) writes:
> You're talking about Books Online for SQL 2005, right?
> Tools->Customize, and the right-click the button in the toolbar you want to
> get rid of. Worked for me.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

customize template.ini to upgrade from msde to express edition?

I need to create the script to upgrade the current named instance of sql 2000 desktop engine to sql server 2005 express edition. I am having difficulty preparing the template.ini and would appreciate help.

[Options]
INSTANCENAME=MY_INSTANCE
SQLBROWSERACCOUNT=NT AUTHORITY\NETWORK SERVICE
SECURITYMODE=SQL
SAPWD=music
UPGRADE=SQL_Engine
SQLBROWSERAUTOSTART=1
RSCANINSTALLDEFAULT=0
RSCONFIGURATION=FilesOnly
RSSQLLOCAL=0

I get an error that this file is invalid..Any clues? I am trying to upgrade existing instance of msde 2k to sql express 2005 and uses sql authentication

http://www.microsoft.com/sql/editions/express/upgrade.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx

http://msdn2.microsoft.com/en-us/ms143491.aspx

|||

When a parameter includes space characters, you need quote with " or '. For example, the browser account should be specified as SQLBROWSERACCOUNT="NT AUTHORITY\NETWORK SERVICE " or SQLBROWSERACCOUNT='NT AUTHORITY\NETWORK SERVICE'

Note, this account is localized on some localized operating system. You need to use the localized version if required. In addition, MSDE already has its SP4. So please use MSDE SP4 directly.

The following are two command lines that may be useful to you.

1. Install MSDE SP4.

start /wait setup.exe /qb INSTANCENAME=msde4instance SAPWD="<password>" SECURITYMODE=SQL

2. Upgrade to SQL 2005 SP1.

start /wait setup.exe UPGRADE=SQL_Engine INSTANCENAME=msdesp4instance SAPWD=""<password>" SECURITYMODE=SQL

Customize SRS Home Page

I need to customize the SQL Reporting services home page with my company logo and some text. Is there a way of doing this. Thanks!SQL Server 2000 Reporting Services 2000 SP1 added the capability make some
modifications to Report Manager. The file you need to look at is
...\Microsoft SQL
Server\MSSQL\ReportingServices\ReportManager\Styles\ReportingServices.css.
If you want to change the reporting services site name displayed in Report
Manager you will need to modify that on Report Manager's site settings page.
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"CurtisK" <CurtisK@.discussions.microsoft.com> wrote in message
news:F82131F0-A29B-4F78-949A-8CA287D43816@.microsoft.com...
> I need to customize the SQL Reporting services home page with my company
logo and some text. Is there a way of doing this. Thanks!sql

Customize SQL Server Management Studio (or Express)?

Is there any way to customize the SSMS or Express? SSMS seems to have the same codebase as Visual Studio, so would the Visual Studio SDK work?

Curtis

I recently answered this question in another post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1530544&SiteID=1

Long story short: we don't support or recommend 3rd party extensions to Management Studio. We do use the Visual Studio shell, so you might technically be able to add menu items, but we are free to change our extensions in SPs and major releases and this could break your extensions.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

Customize SQL Server Management Studio (or Express)?

Is there any way to customize the SSMS or Express? SSMS seems to have the same codebase as Visual Studio, so would the Visual Studio SDK work?

Curtis

I recently answered this question in another post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1530544&SiteID=1

Long story short: we don't support or recommend 3rd party extensions to Management Studio. We do use the Visual Studio shell, so you might technically be able to add menu items, but we are free to change our extensions in SPs and major releases and this could break your extensions.

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

Customize ReportViewer Animation

Hello All,
I am developing an application that queries a database for a large
amount of data. The SQL server is not local so the time to query the
data can take some time.
Once I have the data locally, I send it to the ReportViewer to display.
The ReportViewer then shows the "Processing" animation, and displays
the results quickly so the animation is shown for a breif period. The
problem is that it takes a long time to query for the data, but the
ReportViewer animation is only shown for the time it processes the
DataSet.
I was wondering if anyone had experience customizing the ReportViewer
control to prematurely start the ReportViewer "Processing..."
animation. I would like to start the animation before I query the
database for the data so the user is aware that something is happening
during the data query.
I would rather implement my own "Processing..." form, or progress bar,
but if there is no way to control the ReportViewer control animation
that is my backup solution.
Thank you,
bigcoopsDoes anyone have any suggestions?
Thanks.
bigcoops@.hotmail.com wrote:
> Hello All,
> I am developing an application that queries a database for a large
> amount of data. The SQL server is not local so the time to query the
> data can take some time.
> Once I have the data locally, I send it to the ReportViewer to display.
> The ReportViewer then shows the "Processing" animation, and displays
> the results quickly so the animation is shown for a breif period. The
> problem is that it takes a long time to query for the data, but the
> ReportViewer animation is only shown for the time it processes the
> DataSet.
> I was wondering if anyone had experience customizing the ReportViewer
> control to prematurely start the ReportViewer "Processing..."
> animation. I would like to start the animation before I query the
> database for the data so the user is aware that something is happening
> during the data query.
> I would rather implement my own "Processing..." form, or progress bar,
> but if there is no way to control the ReportViewer control animation
> that is my backup solution.
> Thank you,
> bigcoops

Customize Reportserver interface

Hi,
Im currently developing various reports for my company. We have many
different clients and different reports for each client.
I want to develop a common website (just like reportserver) for all
the reports and through NT-logon redirect a client to his reports.
My question is: Is it possible to customize the reportserver interface
to do this? How ?Stefan wrote:
> Im currently developing various reports for my company. We have many
> different clients and different reports for each client.
> I want to develop a common website (just like reportserver) for all
> the reports and through NT-logon redirect a client to his reports.
> My question is: Is it possible to customize the reportserver interface
> to do this? How ?
Look at http://www.codeproject.com/useritems/SQLRSViewer.asp
You have to modify this solution but it works great.
regards
Frank
www.xax.de|||Thank you!
/Regards Stefan
"Frank Matthiesen" <fm@.xax.de> wrote in message news:<366uerF4klp8oU1@.individual.net>...
> Stefan wrote:
> > Im currently developing various reports for my company. We have many
> > different clients and different reports for each client.
> >
> > I want to develop a common website (just like reportserver) for all
> > the reports and through NT-logon redirect a client to his reports.
> >
> > My question is: Is it possible to customize the reportserver interface
> > to do this? How ?
> Look at http://www.codeproject.com/useritems/SQLRSViewer.asp
> You have to modify this solution but it works great.
> regards
> Frank
> www.xax.desql

Customize Report Parameter Properties

Is it possible to modify the XML code at runtime? I want to control the
report parameter properties multi-value setting of True/False during runtime
in the XML behind the RDL file. Set it to True if I want the parameters to be
multi-value or False for single-value. This is determined based on the value
selected in parameter one. Parameter one and two are City,State.
If City is selected in parameter one then I want Parameter two to be a
single-valued list, if State is chosen in Parameter One then I want the list
in Parameter two to be a multi-valued select list.
Any ideas or guidance would be appreciated.No, this is not possible.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"arulibaba" <arulibaba@.discussions.microsoft.com> wrote in message
news:939952BF-0FB7-42A8-AF1C-A9E4005BCAF5@.microsoft.com...
> Is it possible to modify the XML code at runtime? I want to control the
> report parameter properties multi-value setting of True/False during
> runtime
> in the XML behind the RDL file. Set it to True if I want the parameters to
> be
> multi-value or False for single-value. This is determined based on the
> value
> selected in parameter one. Parameter one and two are City,State.
> If City is selected in parameter one then I want Parameter two to be a
> single-valued list, if State is chosen in Parameter One then I want the
> list
> in Parameter two to be a multi-valued select list.
> Any ideas or guidance would be appreciated.
>|||Looking at my example, could you recommend an approach to tackle this issue?
"Bruce L-C [MVP]" wrote:
> No, this is not possible.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "arulibaba" <arulibaba@.discussions.microsoft.com> wrote in message
> news:939952BF-0FB7-42A8-AF1C-A9E4005BCAF5@.microsoft.com...
> > Is it possible to modify the XML code at runtime? I want to control the
> > report parameter properties multi-value setting of True/False during
> > runtime
> > in the XML behind the RDL file. Set it to True if I want the parameters to
> > be
> > multi-value or False for single-value. This is determined based on the
> > value
> > selected in parameter one. Parameter one and two are City,State.
> >
> > If City is selected in parameter one then I want Parameter two to be a
> > single-valued list, if State is chosen in Parameter One then I want the
> > list
> > in Parameter two to be a multi-valued select list.
> >
> > Any ideas or guidance would be appreciated.
> >
>
>|||It is a nice concept but this is not an area you have control over if you
are using the portal (report manager) that ships with Reporting Services. If
you want to create your own web page and then integrate with RS using either
web services or url integration this is certainly possible. RS 2005 ships
with a webform and a winform control for integrating RS reports into your
applications.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"arulibaba" <arulibaba@.discussions.microsoft.com> wrote in message
news:2E596365-10F4-45F0-A89C-AA99568E53DE@.microsoft.com...
> Looking at my example, could you recommend an approach to tackle this
> issue?
> "Bruce L-C [MVP]" wrote:
>> No, this is not possible.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "arulibaba" <arulibaba@.discussions.microsoft.com> wrote in message
>> news:939952BF-0FB7-42A8-AF1C-A9E4005BCAF5@.microsoft.com...
>> > Is it possible to modify the XML code at runtime? I want to control the
>> > report parameter properties multi-value setting of True/False during
>> > runtime
>> > in the XML behind the RDL file. Set it to True if I want the parameters
>> > to
>> > be
>> > multi-value or False for single-value. This is determined based on the
>> > value
>> > selected in parameter one. Parameter one and two are City,State.
>> >
>> > If City is selected in parameter one then I want Parameter two to be a
>> > single-valued list, if State is chosen in Parameter One then I want the
>> > list
>> > in Parameter two to be a multi-valued select list.
>> >
>> > Any ideas or guidance would be appreciated.
>> >
>>|||Thank you for your reply. So if I create a separate web page, can I reference
this page as a link from Report Manager going out and launching this custom
page/report? Would I find the winform/webform via Visual Studio?
"Bruce L-C [MVP]" wrote:
> It is a nice concept but this is not an area you have control over if you
> are using the portal (report manager) that ships with Reporting Services. If
> you want to create your own web page and then integrate with RS using either
> web services or url integration this is certainly possible. RS 2005 ships
> with a webform and a winform control for integrating RS reports into your
> applications.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "arulibaba" <arulibaba@.discussions.microsoft.com> wrote in message
> news:2E596365-10F4-45F0-A89C-AA99568E53DE@.microsoft.com...
> > Looking at my example, could you recommend an approach to tackle this
> > issue?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No, this is not possible.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "arulibaba" <arulibaba@.discussions.microsoft.com> wrote in message
> >> news:939952BF-0FB7-42A8-AF1C-A9E4005BCAF5@.microsoft.com...
> >> > Is it possible to modify the XML code at runtime? I want to control the
> >> > report parameter properties multi-value setting of True/False during
> >> > runtime
> >> > in the XML behind the RDL file. Set it to True if I want the parameters
> >> > to
> >> > be
> >> > multi-value or False for single-value. This is determined based on the
> >> > value
> >> > selected in parameter one. Parameter one and two are City,State.
> >> >
> >> > If City is selected in parameter one then I want Parameter two to be a
> >> > single-valued list, if State is chosen in Parameter One then I want the
> >> > list
> >> > in Parameter two to be a multi-valued select list.
> >> >
> >> > Any ideas or guidance would be appreciated.
> >> >
> >>
> >>
> >>
>
>|||Well, the only way you could do this is to have a report that just has
links. You would need to have your own website. Usually people either use
Report Manager or provide their own front end via their own application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"arulibaba" <arulibaba@.discussions.microsoft.com> wrote in message
news:EFC6D25C-E313-4398-92F6-1C5651FABFB9@.microsoft.com...
> Thank you for your reply. So if I create a separate web page, can I
> reference
> this page as a link from Report Manager going out and launching this
> custom
> page/report? Would I find the winform/webform via Visual Studio?
> "Bruce L-C [MVP]" wrote:
>> It is a nice concept but this is not an area you have control over if you
>> are using the portal (report manager) that ships with Reporting Services.
>> If
>> you want to create your own web page and then integrate with RS using
>> either
>> web services or url integration this is certainly possible. RS 2005 ships
>> with a webform and a winform control for integrating RS reports into your
>> applications.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "arulibaba" <arulibaba@.discussions.microsoft.com> wrote in message
>> news:2E596365-10F4-45F0-A89C-AA99568E53DE@.microsoft.com...
>> > Looking at my example, could you recommend an approach to tackle this
>> > issue?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> No, this is not possible.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "arulibaba" <arulibaba@.discussions.microsoft.com> wrote in message
>> >> news:939952BF-0FB7-42A8-AF1C-A9E4005BCAF5@.microsoft.com...
>> >> > Is it possible to modify the XML code at runtime? I want to control
>> >> > the
>> >> > report parameter properties multi-value setting of True/False during
>> >> > runtime
>> >> > in the XML behind the RDL file. Set it to True if I want the
>> >> > parameters
>> >> > to
>> >> > be
>> >> > multi-value or False for single-value. This is determined based on
>> >> > the
>> >> > value
>> >> > selected in parameter one. Parameter one and two are City,State.
>> >> >
>> >> > If City is selected in parameter one then I want Parameter two to be
>> >> > a
>> >> > single-valued list, if State is chosen in Parameter One then I want
>> >> > the
>> >> > list
>> >> > in Parameter two to be a multi-valued select list.
>> >> >
>> >> > Any ideas or guidance would be appreciated.
>> >> >
>> >>
>> >>
>> >>
>>

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
>
>
>

Customize Prompt Message for Stored Procudure

Hello all,
I have a stored procedure that prompts the user for beginning date and
ending date to run a monthly report. The prompt says
Enter_Beginning_Date and Enter_Ending_Date. I want the prompt to say
Enter Beginning Date (Example:1-1-2003) or something like that. Is
there a way to do this?

CREATE PROCEDURE dbo.MonthlyReport(@.Enter_Beginning_Date datetime,
@.Enter_Ending_Date datetime)
AS SELECT incident, @.Enter_Beginning_Date AS BeginningDate,
@.Enter_Ending_Date AS EndingDate, COUNT(*) AS Occurances
FROM dbo.Incident
WHERE (DateOccured BETWEEN @.Enter_Beginning_Date AND
@.Enter_Ending_Date)
GROUP BY incident
GO"ndn_24_7" <ndn_24_7@.yahoo.com> wrote in message
news:1105983132.532065.27990@.c13g2000cwb.googlegro ups.com...
> Hello all,
> I have a stored procedure that prompts the user for beginning date and
> ending date to run a monthly report. The prompt says
> Enter_Beginning_Date and Enter_Ending_Date. I want the prompt to say
> Enter Beginning Date (Example:1-1-2003) or something like that. Is
> there a way to do this?
> CREATE PROCEDURE dbo.MonthlyReport(@.Enter_Beginning_Date datetime,
> @.Enter_Ending_Date datetime)
> AS SELECT incident, @.Enter_Beginning_Date AS BeginningDate,
> @.Enter_Ending_Date AS EndingDate, COUNT(*) AS Occurances
> FROM dbo.Incident
> WHERE (DateOccured BETWEEN @.Enter_Beginning_Date AND
> @.Enter_Ending_Date)
> GROUP BY incident
> GO

MSSQL is purely a server, so it doesn't have any idea about GUIs or
prompts - if you want to present a more user-friendly description of the two
parameters, then you would have to do that in the front-end application
where the users select the dates.

One possible approach would be to add an extended property to the two
parameters which has the description in it, then retrieve that from the
front end when you display the input screen. See "Using Extended Properties
on Database Objects" in Books Online for more details. But I don't know if
that would be a suitable solution for your toolset and design.

Simon|||I'm sorry
I should have been more discriptive. My program has a Access 2000 front
end and a SQL 2000 server backend. I have a button that the user clicks
that brings up the prompt window for the stored proc. So would I do
this on the Access front end, Where would Icustomize this message?|||Not a clue how you are prompting the user thru Stored Procedure. May be
you missed out some valuable info on the post........!|||ndn_24_7 (ndn_24_7@.yahoo.com) writes:
> I should have been more discriptive. My program has a Access 2000 front
> end and a SQL 2000 server backend. I have a button that the user clicks
> that brings up the prompt window for the stored proc. So would I do
> this on the Access front end, Where would Icustomize this message?

Sounds like you should try an Access newsgroup. It is possible that
you can use extended properties for this, but I have no knowledge
what Access makes use of. So try comp.databases.ms-access where the
expertise for this question might hang out.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||As far I understood,

You have a stored procedure that accepts parameters and you have an
Access front end that accepts input parameters thru prompts and pass
them to the backend stored procedure... Am I correct?

If so, what you are doing is correct so far. You need to find out how
to call a stored procedure thru access and once you know, all you need
to do is, thru access, get those inputs (you may display anyway you
need - that is irrelevent to the backend procedure...) and pass them as
parameters to the backend stored proc.. May be an access guru can show
some light on how to accomplish this..!|||"ndn_24_7" <ndn_24_7@.yahoo.com> wrote in message
news:1105990021.951317.205140@.c13g2000cwb.googlegr oups.com...
> I'm sorry
> I should have been more discriptive. My program has a Access 2000 front
> end and a SQL 2000 server backend. I have a button that the user clicks
> that brings up the prompt window for the stored proc. So would I do
> this on the Access front end, Where would Icustomize this message?

I suggest you want a form that the user enters the dates in and then clicks
the button to run the stored proc.
I'll assume you know a little about VB code.
Otherwise, you got a steep learning curve ahead mate.

You probably want to validate the fields using isdate()

Access now uses ADO, so the code involves using an ado connection and
command.
I found pretty much the below code by using google to search the access
newsgroup.
Not tested it and I had to add the execute line, so this is just to get you
started.
BTW You'll want to get used to doing such searches if you are new to this
lark.
I suggest also take a look at each of the bits in turn and read up using
msdn so you get a better understanding what you're up to.
I have deliberately not changed the parameter type to date and input because
you'd learn stuff all if I just gave you the code.

There's a couple gotchas with datetime. Inside access some bits want this
delimited by # but not with ado. Remember also the time bit of a date is
likely there. Not such a problem with > or < but throw that to the back of
your mind for later.

Anyhow.
You run the thing by using the execute method of the command.
There's a parameter collection associated with a command you add the values
to:

'start untested snippet
Dim cmd As ADODB.Command
Dim prm As ADODB.Parameter

Set cmd = New ADODB.Command
cmd.ActiveConnection = CurrentProject.Connection
cmd.CommandText = "stored procedurename"
cmd.CommandType = adCmdStoredProc
Set prm = cmd.CreateParameter("@.CompanyID", adInteger, adParamOutput _
, , forms!yourformname!text1.Value)
cmd.Parameters.Append prm

cmd.execute

set prm = Nothing
Set cmd = Nothing

' end snippet

HTH

--
Regards,
Andy O'Neill