Embedding plug-ins in Reports

Hi,
I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>
I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
Thank you.
Anton Bagayev,
TransForm Pharmaceuticals, Inc.
29 Hartwell Avenue
Lexington, MA 02421Or even simpler, is it possible to embed an HTML in a report.
That would be an exiting idea.
Thanks in advance.
Anton.
"Anton" wrote:
> Hi,
> I am trying to figure out the way to embed a plug-in (Chime for Windows)
> into my report, so that I can display a certain object from a database, that
> is stored there as a string. This Chime plug-in would read the input string
> and convert it to video display.
> This embedding is easily done in simple HTML:
> <embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
> hlabels2d='terminalhetero' structure= [encrypted string from the database
> follows]>
> I am wondering is there a way to do such embedding straight into my report
> by using the report designer features or by modifying an RDL file for my
> report?
> Thank you.
> Anton Bagayev,
> TransForm Pharmaceuticals, Inc.
> 29 Hartwell Avenue
> Lexington, MA 02421sql

Embedding an object into report

Hi,

I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>

I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
If I am able to place my <embed...> string somewhere in my report and when the report is rendered as HTML this string is interpreted as an HTML tag, this would be awesome! So far I experimented with displaying <embed...> string in one of my textboxes, but HTML renderer for report obviously interprets my string as a text not as a tag, so instead of seeing plug-in in action I just see the text of my string.

Probably another approach would be to embed an HTML in a report.
That would also be an exiting idea.
I would appreciate any help on this.
Thanks in advance!
Anton.Reporting Services does not support embedded HTML or object tags. The only way you could do this is to post-process the resulting output.|||

Hello,

Can you detail the approach to be taken, please?

Thanks

Embedding an object into report

Hi,

I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>

I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
If I am able to place my <embed...> string somewhere in my report and when the report is rendered as HTML this string is interpreted as an HTML tag, this would be awesome! So far I experimented with displaying <embed...> string in one of my textboxes, but HTML renderer for report obviously interprets my string as a text not as a tag, so instead of seeing plug-in in action I just see the text of my string.

Probably another approach would be to embed an HTML in a report.
That would also be an exiting idea.
I would appreciate any help on this.
Thanks in advance!
Anton.Reporting Services does not support embedded HTML or object tags. The only way you could do this is to post-process the resulting output.|||

Hello,

Can you detail the approach to be taken, please?

Thanks

EM snap in

Hi
I'm not sure if this is possible but does anyone know if there is a way to
create a MMC snap in for EM and only have certain features of EM showing in
that snap in e.g. not let the user see DTS jobs etc.
I know you can restrict access so the user won't have the rights to run
certain things but is it possible to set up so they don't even see certain
things when opening the snap in. I have had a look and can't see how this can
be done so any suggestions would be welcome.
Thanks
Jonjo
You would have to do that on your own, quering the sql server via SQLDMO.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"jonjo" <jonjo@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5EAB76B4-016A-41F9-84D5-C2A405220C62@.microsoft.com...
> Hi
> I'm not sure if this is possible but does anyone know if there is a way to
> create a MMC snap in for EM and only have certain features of EM showing
> in
> that snap in e.g. not let the user see DTS jobs etc.
> I know you can restrict access so the user won't have the rights to run
> certain things but is it possible to set up so they don't even see certain
> things when opening the snap in. I have had a look and can't see how this
> can
> be done so any suggestions would be welcome.
> Thanks
> Jonjo
|||... or also using the SQL.NS API (should save some work compared to only using DMO)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in message
news:uVJC6oJXFHA.3348@.TK2MSFTNGP14.phx.gbl...
> You would have to do that on your own, quering the sql server via SQLDMO.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "jonjo" <jonjo@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5EAB76B4-016A-41F9-84D5-C2A405220C62@.microsoft.com...
>

EM snap in

Hi
I'm not sure if this is possible but does anyone know if there is a way to
create a MMC snap in for EM and only have certain features of EM showing in
that snap in e.g. not let the user see DTS jobs etc.
I know you can restrict access so the user won't have the rights to run
certain things but is it possible to set up so they don't even see certain
things when opening the snap in. I have had a look and can't see how this can
be done so any suggestions would be welcome.
Thanks
JonjoYou would have to do that on your own, quering the sql server via SQLDMO.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"jonjo" <jonjo@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5EAB76B4-016A-41F9-84D5-C2A405220C62@.microsoft.com...
> Hi
> I'm not sure if this is possible but does anyone know if there is a way to
> create a MMC snap in for EM and only have certain features of EM showing
> in
> that snap in e.g. not let the user see DTS jobs etc.
> I know you can restrict access so the user won't have the rights to run
> certain things but is it possible to set up so they don't even see certain
> things when opening the snap in. I have had a look and can't see how this
> can
> be done so any suggestions would be welcome.
> Thanks
> Jonjo|||... or also using the SQL.NS API (should save some work compared to only using DMO)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in message
news:uVJC6oJXFHA.3348@.TK2MSFTNGP14.phx.gbl...
> You would have to do that on your own, quering the sql server via SQLDMO.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "jonjo" <jonjo@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5EAB76B4-016A-41F9-84D5-C2A405220C62@.microsoft.com...
>> Hi
>> I'm not sure if this is possible but does anyone know if there is a way to
>> create a MMC snap in for EM and only have certain features of EM showing in
>> that snap in e.g. not let the user see DTS jobs etc.
>> I know you can restrict access so the user won't have the rights to run
>> certain things but is it possible to set up so they don't even see certain
>> things when opening the snap in. I have had a look and can't see how this can
>> be done so any suggestions would be welcome.
>> Thanks
>> Jonjo
>

EM snap in

Hi
I'm not sure if this is possible but does anyone know if there is a way to
create a MMC snap in for EM and only have certain features of EM showing in
that snap in e.g. not let the user see DTS jobs etc.
I know you can restrict access so the user won't have the rights to run
certain things but is it possible to set up so they don't even see certain
things when opening the snap in. I have had a look and can't see how this ca
n
be done so any suggestions would be welcome.
Thanks
JonjoYou would have to do that on your own, quering the sql server via SQLDMO.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"jonjo" <jonjo@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5EAB76B4-016A-41F9-84D5-C2A405220C62@.microsoft.com...
> Hi
> I'm not sure if this is possible but does anyone know if there is a way to
> create a MMC snap in for EM and only have certain features of EM showing
> in
> that snap in e.g. not let the user see DTS jobs etc.
> I know you can restrict access so the user won't have the rights to run
> certain things but is it possible to set up so they don't even see certain
> things when opening the snap in. I have had a look and can't see how this
> can
> be done so any suggestions would be welcome.
> Thanks
> Jonjo|||... or also using the SQL.NS API (should save some work compared to only us
ing DMO)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message
news:uVJC6oJXFHA.3348@.TK2MSFTNGP14.phx.gbl...
> You would have to do that on your own, quering the sql server via SQLDMO.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "jonjo" <jonjo@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5EAB76B4-016A-41F9-84D5-C2A405220C62@.microsoft.com...
>

EM locks up

On certain occasions, when I'm running a long-running query in Query
Analyzer, I can't get in to Enterprise Manager. What happens is the list of
tables can't be enumerated until the long-running query finishes. What's
odd to me is that the query only affects 1 or 2 tables. So why can't I get
into EM until this job finishes?
Thanks, Andre
Hi,
This might be because your ISQLW.EXE in client machine will be using the
CPU and Memory fully. If you have better processor PIII or higher +
512 MB ram you should have such issues.
Check your virtual memory definition in your client machine. Always try to
run the long running queries in text result mode.
Thanks
Hari
MCDBA
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:#O07UKgLEHA.1556@.TK2MSFTNGP10.phx.gbl...
> On certain occasions, when I'm running a long-running query in Query
> Analyzer, I can't get in to Enterprise Manager. What happens is the list
of
> tables can't be enumerated until the long-running query finishes. What's
> odd to me is that the query only affects 1 or 2 tables. So why can't I
get
> into EM until this job finishes?
> Thanks, Andre
>
|||Actually, the long-running query is running on a different box. For
example, if you and I were in the same office, and I was running the query,
you might not be able to get into EM.
Andre
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23udrVlgLEHA.1032@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> This might be because your ISQLW.EXE in client machine will be using the
> CPU and Memory fully. If you have better processor PIII or higher +
> 512 MB ram you should have such issues.
> Check your virtual memory definition in your client machine. Always try to
> run the long running queries in text result mode.
> Thanks
> Hari
> MCDBA
>
>
> "Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
> news:#O07UKgLEHA.1556@.TK2MSFTNGP10.phx.gbl...
list[vbcol=seagreen]
> of
What's
> get
>
|||Hi,
Means , you will be able to open the enterprise manager, but while expanding
your SQL Server it just hangs..
Can you check the SQLSERVR.exe CPU usage in server. If it is 100% then the
performance will be slow and cause a time out. The CPU usage in the log
running query can be minimized by tuning the query by effect sql statement
and adding proper indexes.
Did you installed SP3 in SQL server machine. If not install SP3.
Thanks
Hari
MCDBA
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:ep0$dzgLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Actually, the long-running query is running on a different box. For
> example, if you and I were in the same office, and I was running the
query,[vbcol=seagreen]
> you might not be able to get into EM.
> Andre
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23udrVlgLEHA.1032@.tk2msftngp13.phx.gbl...
the[vbcol=seagreen]
to[vbcol=seagreen]
> list
> What's
I
>
|||sp3a was installed shortly after it was released. Yes, I (or other users)
can launch EM, can expand the server, but can't get a list of tables when
trying to expand the tables folder. Query analyzer works just fine. CPU
usage on the server is typically low when this is happening. sp_who2 shows
that the long running query is blocking the EM process. I just can't figure
out why a query that "might" have a lock on a table would prevent the list
of tables from being displayed in EM.
Andre
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:ODjXezpLEHA.3052@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Means , you will be able to open the enterprise manager, but while
expanding[vbcol=seagreen]
> your SQL Server it just hangs..
> Can you check the SQLSERVR.exe CPU usage in server. If it is 100% then the
> performance will be slow and cause a time out. The CPU usage in the log
> running query can be minimized by tuning the query by effect sql statement
> and adding proper indexes.
> Did you installed SP3 in SQL server machine. If not install SP3.
> Thanks
> Hari
> MCDBA
> "Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
> news:ep0$dzgLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> query,
> the
try[vbcol=seagreen]
> to
can't
> I
>
|||Hi,
Do you have the problem yet? I am having a similar problem. I have 2 machines:
1 .- SQL server 2000 + SP3, without problems
2 .- SQL Server 2000 + SP3a, with performance problems
I am reinstalling Sql server + SP3 and I am testing machine 1. I am sending you information.
Lina
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...