Showing posts with label html. Show all posts
Showing posts with label html. Show all posts

Wednesday, March 7, 2012

How To use Data Mining HTML Tree Viewer

Hi!

I try to use Data Mining HTML Tree Viewer, but has some problem. In the Connection property, i can't set a new connection to this property.

Help me!!!

The Connection property should be used in the code behind the web page. When the web application already initialized an OleDb connection pointing to an Analysis Services server, that connection can be reuased by the web controls.

An example (assuming a Tree viewer control on the page, named DMDecisionTreeViewer1)

System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection();

cn.ConnectionString = "Provider=MSOLAP.3;Data Source=localhost; Initial Catalog=MyCatalog";

DMDecisionTreeViewer1.Connection = cn;

DMDecisionTreeViewer1.Model = "MyModel";

DMDecisionTreeViewer1.Tree = "SomePredictableColumn";

If a connection is not available in the web application (the general case), then the Connection property should be ignored and, instead, the Server and Database properties of the controls should be populated. If, in the code above, the properties are set as below:

DMDecisionTreeViewer1.Server = "localhost";

DMDecisionTreeViewer1.Database= "MyCatalog";

then the result will be the same as using the connection created above (the control will create a connection by itself and use it in populating the tree content)

Hope this helps

Sunday, February 19, 2012

How to use "TARGET" in "Jump to URL"

Is it possible to include HTML element "Target" in "Jump to URL"?
If it's possible how to do? Can show me any example code?
Cause I want the new report is open on the other frame not a new window.
Thanks for any help!
AngiThis might do what you want:
This is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
You have to have SP1 or greater installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"angi" <angi@.news.microsoft.com> wrote in message
news:e1oVn0uTGHA.5264@.TK2MSFTNGP10.phx.gbl...
> Is it possible to include HTML element "Target" in "Jump to URL"?
> If it's possible how to do? Can show me any example code?
> Cause I want the new report is open on the other frame not a new window.
> Thanks for any help!
> Angi
>|||Thanks for Bruce!
I knew this function and work well.
But I don't want to open the data in a separate window,
I want it opens in another frame on Homepage.
This is my code:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/MOJBIS/MojBisLv2-Bu01Sc','_main'))"
'_main' is the frame's name.
The HTML Code as follow:
<frameset rows="64,*">
<frame name="Horizon" scrolling="no" noresize target="contents"
src="tframe.aspx">
<frameset cols="449,*">
<frame name="contents" target="main" src="http://pics.10026.com/?src=lframe.aspx">
<frame name="main" src="http://pics.10026.com/?src=rframe.aspx">
</frameset>
<noframes>
<body>
</body>
</noframes>
</frameset>
So, I want the report open on "rframe.aspx", and the frame name = "main".
Have any idea?
Thanks for help!
Angi
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:eHiQ1$1TGHA.3192@.TK2MSFTNGP09.phx.gbl...
> This might do what you want:
> This is an example of a Jump to URL link I use. This causes Excel to come
> up with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> You have to have SP1 or greater installed.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "angi" <angi@.news.microsoft.com> wrote in message
> news:e1oVn0uTGHA.5264@.TK2MSFTNGP10.phx.gbl...
>> Is it possible to include HTML element "Target" in "Jump to URL"?
>> If it's possible how to do? Can show me any example code?
>> Cause I want the new report is open on the other frame not a new window.
>> Thanks for any help!
>> Angi
>|||I haven't done this. My guess would have been to put the frame name instead
of _blank. You tried _main, how about putting the work main with no
underscore?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"angi" <angi@.news.microsoft.com> wrote in message
news:u8OGJqYUGHA.4864@.TK2MSFTNGP12.phx.gbl...
> Thanks for Bruce!
> I knew this function and work well.
> But I don't want to open the data in a separate window,
> I want it opens in another frame on Homepage.
> This is my code:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/MOJBIS/MojBisLv2-Bu01Sc','_main'))"
> '_main' is the frame's name.
> The HTML Code as follow:
> <frameset rows="64,*">
> <frame name="Horizon" scrolling="no" noresize target="contents"
> src="http://pics.10026.com/?src=tframe.aspx">
> <frameset cols="449,*">
> <frame name="contents" target="main" src="http://pics.10026.com/?src=lframe.aspx">
> <frame name="main" src="http://pics.10026.com/?src=rframe.aspx">
> </frameset>
> <noframes>
> <body>
> </body>
> </noframes>
> </frameset>
> So, I want the report open on "rframe.aspx", and the frame name = "main".
> Have any idea?
> Thanks for help!
> Angi
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com>
> ¼¶¼g©ó¶l¥ó·s»D:eHiQ1$1TGHA.3192@.TK2MSFTNGP09.phx.gbl...
>> This might do what you want:
>> This is an example of a Jump to URL link I use. This causes Excel to come
>> up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> You have to have SP1 or greater installed.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "angi" <angi@.news.microsoft.com> wrote in message
>> news:e1oVn0uTGHA.5264@.TK2MSFTNGP10.phx.gbl...
>> Is it possible to include HTML element "Target" in "Jump to URL"?
>> If it's possible how to do? Can show me any example code?
>> Cause I want the new report is open on the other frame not a new window.
>> Thanks for any help!
>> Angi
>>
>|||Hi, Bruce,
Thank you very much.
I've done this, the code as follow...
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/MOJBIS/MojBisLv2-Bu01Sc','main'))"
Using underscore will open the new window!
Last, for "window.open" function there is a reference:
http://www.w3schools.com/htmldom/met_win_open.asp
Thanks again!
Angi
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:%23CSU32aUGHA.776@.TK2MSFTNGP09.phx.gbl...
>I haven't done this. My guess would have been to put the frame name instead
>of _blank. You tried _main, how about putting the work main with no
>underscore?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "angi" <angi@.news.microsoft.com> wrote in message
> news:u8OGJqYUGHA.4864@.TK2MSFTNGP12.phx.gbl...
>> Thanks for Bruce!
>> I knew this function and work well.
>> But I don't want to open the data in a separate window,
>> I want it opens in another frame on Homepage.
>> This is my code:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/MOJBIS/MojBisLv2-Bu01Sc','_main'))"
>> '_main' is the frame's name.
>> The HTML Code as follow:
>> <frameset rows="64,*">
>> <frame name="Horizon" scrolling="no" noresize target="contents"
>> src="http://pics.10026.com/?src=tframe.aspx">
>> <frameset cols="449,*">
>> <frame name="contents" target="main" src="http://pics.10026.com/?src=lframe.aspx">
>> <frame name="main" src="http://pics.10026.com/?src=rframe.aspx">
>> </frameset>
>> <noframes>
>> <body>
>> </body>
>> </noframes>
>> </frameset>
>> So, I want the report open on "rframe.aspx", and the frame name = "main".
>> Have any idea?
>> Thanks for help!
>> Angi
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:eHiQ1$1TGHA.3192@.TK2MSFTNGP09.phx.gbl...
>> This might do what you want:
>> This is an example of a Jump to URL link I use. This causes Excel to
>> come up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> You have to have SP1 or greater installed.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "angi" <angi@.news.microsoft.com> wrote in message
>> news:e1oVn0uTGHA.5264@.TK2MSFTNGP10.phx.gbl...
>> Is it possible to include HTML element "Target" in "Jump to URL"?
>> If it's possible how to do? Can show me any example code?
>> Cause I want the new report is open on the other frame not a new
>> window.
>> Thanks for any help!
>> Angi
>>
>>
>