I can't dissable a dimension level

SQL Server 2005 april CTP
Hi, I have an snowflake dimension with 2 levels which I used in a cube. But I need to link it to the top level.
In AS 2000, the only thing I used to do is to disable the next level from the linked level. Now i'm trying to do this with no success.
How can I do that?
For example:
Dimension: Warehouse
Level 1: Warehouse
Level 2: Rack
I have linked my cube to the level Warehouse and I want to disable level Rack but AS raises this error: Errors in the metadata manager. The attribute for the 'Rack' source attribute, of the 'Rack' source cube level, is disabled.
I need to disable this level because it isn't linked to the cube.
Any ideas?
Thanks in advance.It was my error. I have mystake definning the key of the dimension. I fixed the key. Then in dimension usage you only have to define the correct granularity of the dimension and that's all.

Hypertext link in a report.

hello :

On a hypertext link in a report, how to open the link in a new window IE. ?

Thank's.

user the following as your URL

javascript:window.open(.........

the full syntax and example of window.open can be found here http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/methods/open_0.asp

|||

Thank's for your answer ; but Where what is that I have to put that ?

I can't use the file .config ?

|||

Not too sure what you mean by referring to the .config file.

You would use this as you would with any other HTML hyperlink e.g.

normal link
<a href="test.htm">link text </a>

new window
<a href=window.open('test.htm')">link etxt </a>

When defining hyperlinks in a report you are essentially providing the contents of the href attribute in the above example.

How do you currently define your hyperlink?

|||

Thank's: but :

I I use the properties of a zone of text, and I put in anglet Navigation towards another report(relationship). Thus I do not know or I put your code.

|||

You'll need to use the "Jump to URL" option instead of the "Jump to report" option and construct the URL using an expression e.g.

="window.open('" & Globals!ReportServerUrl & "target report name" & "')"

|||

Thank you very mutch.

|||

hi,I am using SQL Reporting 2005 and javascript doesn't work on my report.Can you tell me how you made javascript working on Jump to URL|||

Hi,

JavaScript work only in browser.It will not work in the report designer.Try to run the report in browser.

Hope this helps

|||Thanks mate, I have deployed the report to the server and view it on the browser, the link disappeared I put ="java script:void(window.open('http://nww.risklog.surreyhis.nhs.uk/aspx/addrisk.aspx?fromSearch=true&riskid=" & Fields!Risk_ID.Value & "','_blank','toolbar=false'))"|||

Hi,

Think in the Report Server also you can't get that link.You can do one think in the Web application,Drag ReportViewr control and put the report in the ReportViewr.Run that web application.Then you can get the link.

Hope this helps

|||

Im trying this in my report that returns a field in the URL - I keep getting the URI scheme is not valid error. Can anyone help? My report has no globals listed, and this is confusing me since I have tried HTML as well as JAVA to get this report to jump to an open window with no luck (obviously!) - can anyone help a newbie?

Ever Gracious for your help

Gina

Hyperlinking to another report

Im trying to create a link to another report from one of my fields (Budget_Reporting_Group_Description) but i only want the hyperlink to be visible and clickable for one value (Actual), how would i write out the code and where would i put it in the properties box for navigation. The report i want to link to is called Details.

I have this so far:

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

whats wrong?

Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.

-Aayush

|||

Hello,

Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

Now, if the Id is "Actual", then you will see "Details" in the textbox and it will be clickable, which will take you to your Details report. If it's not "Actual", then the textbox will be blank, with no hyperlink.

Hope this helps.

Jarret

|||I have it in the jump to report Expression box. But its not showing a hyperlink when i roll the mouse of the field. Is there another expression, or something to link it to another report. I just want the report to show a hyperlink if the value in the field is "Forecast" if not, it should not have a link to the other report.
|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!

Hyperlinking to another report

Im trying to create a link to another report from one of my fields (Budget_Reporting_Group_Description) but i only want the hyperlink to be visible and clickable for one value (Actual), how would i write out the code and where would i put it in the properties box for navigation. The report i want to link to is called Details.

I have this so far:

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

whats wrong?

Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.

-Aayush

|||

Hello,

Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

Now, if the Id is "Actual", then you will see "Details" in the textbox and it will be clickable, which will take you to your Details report. If it's not "Actual", then the textbox will be blank, with no hyperlink.

Hope this helps.

Jarret

|||I have it in the jump to report Expression box. But its not showing a hyperlink when i roll the mouse of the field. Is there another expression, or something to link it to another report. I just want the report to show a hyperlink if the value in the field is "Forecast" if not, it should not have a link to the other report.
|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!

Hyperlinking to another report

Im trying to create a link to another report from one of my fields (Budget_Reporting_Group_Description) but i only want the hyperlink to be visible and clickable for one value (Actual), how would i write out the code and where would i put it in the properties box for navigation. The report i want to link to is called Details.

I have this so far:

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

whats wrong?

Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.

-Aayush

|||

Hello,

Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

Now, if the Id is "Actual", then you will see "Details" in the textbox and it will be clickable, which will take you to your Details report. If it's not "Actual", then the textbox will be blank, with no hyperlink.

Hope this helps.

Jarret

|||I have it in the jump to report Expression box. But its not showing a hyperlink when i roll the mouse of the field. Is there another expression, or something to link it to another report. I just want the report to show a hyperlink if the value in the field is "Forecast" if not, it should not have a link to the other report.
|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!

Hyperlink Target property in SharePoint 2007 Report Viewer Web Part

SharePoint 2007. I have the SSRS Web Part embedded in a page as part
of the dashboard. The SSRS Report displayed in the SSRS Web Part
contains a link (aka Jump To Report) to a second report. I want the
second report to open in the parent SharePoint page, not in the Web
Part.
The Web Part contains a property called "Hyperlink Target", which
should specify where hyperlinks are opened. Even if I set this
property to be "_blank", the second report opens inside of the web
part.
Had anyone been able to use the "Hyperlink Target" of the Sharepoint
2007 SSRS Web Part?Anyone?

hyperlink open new window

I have a link on my report which open new window. The code i have in advance properties of that field is :

="javascriptt:void(window.open('http://www.msn.com','_blank'))" (note: the extra "t" is intentionally added in the code, coz website block the keyword "java.....t")

It works great on testing server but it doesn't work on production server. Both testing and production servers run windows 2003 server and service pack 2 for reporting services.

Reports accessing form production server, when i click on report it opens up new window with address in address bar :

javascript:void(window.open('http://www.msn.com','_blank')) with "The page cannot be displayed" message. But if i open a new internet explorer window and copy past the same address in address bar then its open up www.msn.com. To test the production server behavior I created a test web page test.htm and added the java script to open new window, it works fine.

Any help would be much appreciated.

Ive had problems with this too!
I found it only works when you access the report via a URL such as
http://reportserver/reportserver?report
Rather than through the Report Manager:
http://reportserver/reports
Through the Report Manager I saw the same behaiviour "The page cannot be displayed" message but copying and pasting worked :S
Although Im not surew this is your problem as it works on your tst server, but not prod
Hope this helps
Al

Hyperlink

How can I put a friendly name or tool tip on a hyperlink? This is the
link I use in my graph, but I would like it to display the value when I
hover.
Thanks.
="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials="
& Fields!soldby.Value & "','popup','width=400,height=200'))"John Geddes wrote:
> How can I put a friendly name or tool tip on a hyperlink? This is the
> link I use in my graph, but I would like it to display the value when I
> hover.
>
> Thanks.
> ="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials="
> & Fields!soldby.Value & "','popup','width=400,height=200'))"
>
Use the Title="my tool tip" attribute in the a href
EG <a href="http://links.10026.com/?link=#" title="Link to something">Link</a>|||Hi Tony,
Can U please Explain me where I need to put this code'
This can be put directly in the expression for the TextBox'
Thanks in Advance,
Chandra.
"Tony G" wrote:
> <a
> href="http://links.10026.com/?link=javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
> & Fields!soldby.Value & "','popup','width=400,height=200'))" title="your
> text">link</a>
>
> John Geddes wrote:
> > I can put TITLE in the function?
> >
> > --
> >
> >
> >
> > John Geddes
> > jgeddes@.email.uophx.edu <mailto:jgeddes@.email.uophx.edu>
> > John.R.Geddes@.gmail.com <mailto:John.R.Geddes@.gmail.com>
> >
> >
> > "Tony G" <b6@.blueyonder.co.yuk> wrote in message news:b6@.blueyonder.co.yuk:
> > > John Geddes wrote:
> > > > How can I put a friendly name or tool tip on a hyperlink? This is the
> > > >
> > > > link I use in my graph, but I would like it to display the value when I
> > > >
> > > > hover.
> > > >
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > ="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
> > > > "
> > > > & Fields!soldby.Value & "','popup','width=400,height=200'))"
> > > >
> > >
> > >
> > > Use the Title="my tool tip" attribute in the a href
> > >
> > > EG <a href="http://links.10026.com/?link=#" title="Link to something">Link</a>
>|||Right mouse click on a textbox (or a field of a table control, etc),
properties, advanced, navigation tab, jump to URL.
(from memory so might be slightly different).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:7F7942F6-F094-4DB4-B6D9-8F556BCB2460@.microsoft.com...
> Hi Tony,
> Can U please Explain me where I need to put this code'
> This can be put directly in the expression for the TextBox'
> Thanks in Advance,
> Chandra.
> "Tony G" wrote:
>> <a
>> href="http://links.10026.com/?link=javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
>> & Fields!soldby.Value & "','popup','width=400,height=200'))" title="your
>> text">link</a>
>>
>> John Geddes wrote:
>> > I can put TITLE in the function?
>> >
>> > --
>> >
>> >
>> >
>> > John Geddes
>> > jgeddes@.email.uophx.edu <mailto:jgeddes@.email.uophx.edu>
>> > John.R.Geddes@.gmail.com <mailto:John.R.Geddes@.gmail.com>
>> >
>> >
>> > "Tony G" <b6@.blueyonder.co.yuk> wrote in message
>> > news:b6@.blueyonder.co.yuk:
>> > > John Geddes wrote:
>> > > > How can I put a friendly name or tool tip on a hyperlink? This is
>> > the
>> > > >
>> > > > link I use in my graph, but I would like it to display the value
>> > when I
>> > > >
>> > > > hover.
>> > > >
>> > > >
>> > > > Thanks.
>> > > >
>> > > >
>> > > >
>> > ="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
>> > > > "
>> > > > & Fields!soldby.Value & "','popup','width=400,height=200'))"
>> > > >
>> > >
>> > >
>> > > Use the Title="my tool tip" attribute in the a href
>> > >
>> > > EG <a href="http://links.10026.com/?link=#" title="Link to something">Link</a>|||I got the javascript to open up a window, however, I cannot pass paramaters
into the string. If the string is hard-coded then it works fine.
-tim
"Bruce L-C [MVP]" wrote:
> Right mouse click on a textbox (or a field of a table control, etc),
> properties, advanced, navigation tab, jump to URL.
> (from memory so might be slightly different).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:7F7942F6-F094-4DB4-B6D9-8F556BCB2460@.microsoft.com...
> > Hi Tony,
> > Can U please Explain me where I need to put this code'
> > This can be put directly in the expression for the TextBox'
> >
> > Thanks in Advance,
> > Chandra.
> >
> > "Tony G" wrote:
> >
> >> <a
> >> href="http://links.10026.com/?link=javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
> >> & Fields!soldby.Value & "','popup','width=400,height=200'))" title="your
> >> text">link</a>
> >>
> >>
> >> John Geddes wrote:
> >> > I can put TITLE in the function?
> >> >
> >> > --
> >> >
> >> >
> >> >
> >> > John Geddes
> >> > jgeddes@.email.uophx.edu <mailto:jgeddes@.email.uophx.edu>
> >> > John.R.Geddes@.gmail.com <mailto:John.R.Geddes@.gmail.com>
> >> >
> >> >
> >> > "Tony G" <b6@.blueyonder.co.yuk> wrote in message
> >> > news:b6@.blueyonder.co.yuk:
> >> > > John Geddes wrote:
> >> > > > How can I put a friendly name or tool tip on a hyperlink? This is
> >> > the
> >> > > >
> >> > > > link I use in my graph, but I would like it to display the value
> >> > when I
> >> > > >
> >> > > > hover.
> >> > > >
> >> > > >
> >> > > > Thanks.
> >> > > >
> >> > > >
> >> > > >
> >> > ="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
> >> > > > "
> >> > > > & Fields!soldby.Value & "','popup','width=400,height=200'))"
> >> > > >
> >> > >
> >> > >
> >> > > Use the Title="my tool tip" attribute in the a href
> >> > >
> >> > > EG <a href="http://links.10026.com/?link=#" title="Link to something">Link</a>
> >>
>
>