replacement for report manager

Hi!
I am evaluating how far i can go in implementing repoting features of SRS in
my program.
I want to be able to write a Windows form (in C#) that has a grid/list
containing all the reports that I have made. The list may have been
previously enterd into the database along with other information needed to
run the particular report.
I want to be able to select in the grid/list(e.g. using a check box) which
reports to run, and what format to render each individual report, as well as
other parameters.
Is the Report Manager that extensible? Is it possible to create this sort of
replacement for Report Manager from C#?
I am using VS2005 and SRS 2005.
Thanks in advance!It is absolutely possible... I have written a report for a customer which
searches the reporting services met data database and returns a list of
reports which match the search criteria the customer wants.. It creates a
report which displays the report name, directory and description... Each
report name is a hot link to run the report... This was done in a report!~
Using a programming language you can do anything you wish... There is a
ReportViewer control ( Search for ReportViewer in Books on line.) that you
can use..
There are sample programs in the SQL directory /90 subdirectory which will
help get you started...
Reporting Services is also just a DotNet Web service, with an entire API
which can you call from your program as well.. It is the same API that MS
uses in the Report Manager..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"PacMan" wrote:
> Hi!
> I am evaluating how far i can go in implementing repoting features of SRS in
> my program.
> I want to be able to write a Windows form (in C#) that has a grid/list
> containing all the reports that I have made. The list may have been
> previously enterd into the database along with other information needed to
> run the particular report.
> I want to be able to select in the grid/list(e.g. using a check box) which
> reports to run, and what format to render each individual report, as well as
> other parameters.
> Is the Report Manager that extensible? Is it possible to create this sort of
> replacement for Report Manager from C#?
> I am using VS2005 and SRS 2005.
> Thanks in advance!

Replacement for Enterprise Manager?

Hello,
I am just wondering if there is a replacement for EM which will have certain
improvements over MS's.
I am coming from an Oracle world, and there is a major issue in SSEM which i
find seriously lacking compared OEM.
In OEM, when you expand a schema (roughly equivalent to a database in SS)
there are a lot more treenodes. There are the basic ones like SSEM has...
Tables, Views, SProcs, Funcs etc...
However OEM also has seperate nodes for Indexes and Triggers, so you can see
and manage all the triggers and indexes in one place. It allows to do all
the relevant management stuff right there. Enable/Disable triggers, Rebuild
indexes, and such. This is a Major improvement, to be able to work directly
on these objects rather then going to a table, designing it, then getting
into the triggers window, selecting the one you want, and then being able to
manage it.
Is there a SSEM alternative which give you more direct and finely-grained
control over individual objects in a similar fashion?
Thanks in advance,
- Hitchhiker
Hi,

> I am just wondering if there is a replacement for EM which will have
certain
> improvements over MS's.
> I am coming from an Oracle world, and there is a major issue in SSEM which
i
> find seriously lacking compared OEM.
> In OEM, when you expand a schema (roughly equivalent to a database in SS)
> there are a lot more treenodes. There are the basic ones like SSEM has...
> Tables, Views, SProcs, Funcs etc...
> However OEM also has seperate nodes for Indexes and Triggers, so you can
see
> and manage all the triggers and indexes in one place. It allows to do all
> the relevant management stuff right there. Enable/Disable triggers,
Rebuild
> indexes, and such. This is a Major improvement, to be able to work
directly
> on these objects rather then going to a table, designing it, then getting
> into the triggers window, selecting the one you want, and then being able
to
> manage it.
> Is there a SSEM alternative which give you more direct and finely-grained
> control over individual objects in a similar fashion?
You might want to download a trial version of Database Workbench:
www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
|||You might try SQLExecMS from www.laplas-soft.com
"A Traveler" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:OskK3qzmEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I am just wondering if there is a replacement for EM which will have
certain
> improvements over MS's.
> I am coming from an Oracle world, and there is a major issue in SSEM which
i
> find seriously lacking compared OEM.
> In OEM, when you expand a schema (roughly equivalent to a database in SS)
> there are a lot more treenodes. There are the basic ones like SSEM has...
> Tables, Views, SProcs, Funcs etc...
> However OEM also has seperate nodes for Indexes and Triggers, so you can
see
> and manage all the triggers and indexes in one place. It allows to do all
> the relevant management stuff right there. Enable/Disable triggers,
Rebuild
> indexes, and such. This is a Major improvement, to be able to work
directly
> on these objects rather then going to a table, designing it, then getting
> into the triggers window, selecting the one you want, and then being able
to
> manage it.
> Is there a SSEM alternative which give you more direct and finely-grained
> control over individual objects in a similar fashion?
> Thanks in advance,
> - Hitchhiker
>
|||This one looks Really Good!. I will have to download it and give it a shot.
Thanks A Lot!!
CheerZ -
"John Smith" <wp456@.mail.ru> wrote in message
news:uw7Vo%234mEHA.2372@.TK2MSFTNGP10.phx.gbl...
> You might try SQLExecMS from www.laplas-soft.com
>
> "A Traveler" <hitchhikersguideto-news@.yahoo.com> wrote in message
> news:OskK3qzmEHA.1356@.TK2MSFTNGP09.phx.gbl...
> certain
> i
> see
> Rebuild
> directly
> to
>
|||If you're an Oracle person, you probably know TOAD pretty well. There's a
freeware version for SQL Server at www.toadss.com. You can also download a
freeware copy of Quest Central for SQL Server at
www.quest.com/quest_central/sql_server/freeware.
"A Traveler" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:OskK3qzmEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I am just wondering if there is a replacement for EM which will have
certain
> improvements over MS's.
> I am coming from an Oracle world, and there is a major issue in SSEM which
i
> find seriously lacking compared OEM.
> In OEM, when you expand a schema (roughly equivalent to a database in SS)
> there are a lot more treenodes. There are the basic ones like SSEM has...
> Tables, Views, SProcs, Funcs etc...
> However OEM also has seperate nodes for Indexes and Triggers, so you can
see
> and manage all the triggers and indexes in one place. It allows to do all
> the relevant management stuff right there. Enable/Disable triggers,
Rebuild
> indexes, and such. This is a Major improvement, to be able to work
directly
> on these objects rather then going to a table, designing it, then getting
> into the triggers window, selecting the one you want, and then being able
to
> manage it.
> Is there a SSEM alternative which give you more direct and finely-grained
> control over individual objects in a similar fashion?
> Thanks in advance,
> - Hitchhiker
>
|||I just installed Quest Central for SQL Server, and it is slower than
Enterprise Manager...
SQLExecMS is really fast, but it is $100+ for an individual license.
"Kevin Kline" <kevin.kline@.quest.com> wrote in message
news:eCg11eRoEHA.1160@.tk2msftngp13.phx.gbl...
> freeware version for SQL Server at www.toadss.com. You can also download
a
> freeware copy of Quest Central for SQL Server at
> www.quest.com/quest_central/sql_server/freeware.
>
|||Hmmm... It was slower to load the SEM in our testing, but it's operations
were the same or faster. I'll have to talk to our testers to see if we can
reproduce the problem. Thanks for the input.
-Kevin
SQL Server MVP
I support PASS, the Professional Association for SQL Server.
www.sqlpass.org
"Developer" <wanderer@.mapinfo.nope.com> wrote in message
news:%23K07jSupEHA.1152@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I just installed Quest Central for SQL Server, and it is slower than
> Enterprise Manager...
> SQLExecMS is really fast, but it is $100+ for an individual license.
> "Kevin Kline" <kevin.kline@.quest.com> wrote in message
> news:eCg11eRoEHA.1160@.tk2msftngp13.phx.gbl...
download
> a
>
sql

Repeated Rows in Matrix

Hi,

I am facing a problem with Matrix control. My requirement is similar to the below problem.

The report should display Manager, Leaders under him, Members under leaders. The data is the working hours of members grouped by Month.

Manager Leader Member Jan Feb Mar Apr .....

M1 L1 E1 170 160 150 180

E2 159 161 130 185

E3 150 180 159 161

L2 E5 159 161 170 160

E6 159 161 130 185

E1 160 150 150 180

M2 L3 E5 150 180 159 161

L1 E1 160 150 150 180

I took Manager, Leader and Member Name columns as Row groups and Month of Working day as Column group. Working hours sum in Data Section. Every thing is working fine but some rows for same Manager are dividing into to parts and displaying as entries for seperate managers as below.

Manager Leader Member Jan Feb Mar Apr .....

M1 L1 E1 140 150 100 120

E2 119 149 50 120

E3 150 180 159 161

L2 E5 159 161 170 160

E6 159 161 130 185

E1 160 150 150 190

M1 L1 E1 30 10 50 60

E2 40 11 80 65

Is this any bug of Matrix control or is there any thing wrong in my design ?( I just dragged respective columns to row, column and data groups, nothing much). Are there any things i need to ensure ?

This could be caused by Manager fields not being exactly the same. There could be extra white space or a different case used for a character or two.

Try using the following as the grouping expression.

"=Fields!FieldName.Value.Trim().ToLower()"

Ian|||It is working. Thank you very much.

Repairing 'The shared data source reference is no longer valid' is long winded in report m

Would be great to be able to multi select reports in report manager and set data sources etc. as tasks like that take a long time when done individually.

Yes, that would be a nice feature.

You might consider using RS.exe scripts if you have to do this for lots of reports, or for a few reports on a regular basis.