Wednesday, March 28, 2012
link target
to' links displays reports in new window and 'back to' links displays the
reports in same window. any idea?You can use javascript in the Jump to URL option of the Action property, so
you can include something like this:
= "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
to open a report in a new window. You can use similar stuff to navagate to
a report in the same window. Hope this helps.
David
"sun" wrote:
> I have some 'go to' links and 'back to' links in my report. I want the 'go
> to' links displays reports in new window and 'back to' links displays the
> reports in same window. any idea?|||Hi,
I have the same problem :(
I want the hyperlinks in my report to open in a new window. I tried doing
this:
in Advanced->Navigation->JumptoURL of the textbox displaying the hyperlink,
I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work - even
the javascript doesnt work :(
plz help
thanks.
"David Siebert" wrote:
> You can use javascript in the Jump to URL option of the Action property, so
> you can include something like this:
> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> to open a report in a new window. You can use similar stuff to navagate to
> a report in the same window. Hope this helps.
> David
> "sun" wrote:
> > I have some 'go to' links and 'back to' links in my report. I want the 'go
> > to' links displays reports in new window and 'back to' links displays the
> > reports in same window. any idea?|||Try a simple test ...
="javascript:void(window.open('http://www.google.com',
'_blank'))"
<Action>
<Hyperlink>="javascript:void(window.open('http://www.google.com',
'_blank'))"</Hyperlink>
</Action>
"Aravind" <Aravind@.discussions.microsoft.com> wrote in message
news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> Hi,
> I have the same problem :(
> I want the hyperlinks in my report to open in a new window. I tried doing
> this:
> in Advanced->Navigation->JumptoURL of the textbox displaying the
> hyperlink,
> I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> even
> the javascript doesnt work :(
> plz help
> thanks.
> "David Siebert" wrote:
>> You can use javascript in the Jump to URL option of the Action property,
>> so
>> you can include something like this:
>> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
>> to open a report in a new window. You can use similar stuff to navagate
>> to
>> a report in the same window. Hope this helps.
>> David
>> "sun" wrote:
>> > I have some 'go to' links and 'back to' links in my report. I want the
>> > 'go
>> > to' links displays reports in new window and 'back to' links displays
>> > the
>> > reports in same window. any idea?|||Thank you very much. This worked perfect
"steve kwon" wrote:
> Try a simple test ...
> ="javascript:void(window.open('http://www.google.com',
> '_blank'))"
>
> <Action>
> <Hyperlink>="javascript:void(window.open('http://www.google.com',
> '_blank'))"</Hyperlink>
> </Action>
>
> "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > Hi,
> > I have the same problem :(
> > I want the hyperlinks in my report to open in a new window. I tried doing
> > this:
> > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > hyperlink,
> > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > even
> > the javascript doesnt work :(
> > plz help
> > thanks.
> >
> > "David Siebert" wrote:
> >
> >> You can use javascript in the Jump to URL option of the Action property,
> >> so
> >> you can include something like this:
> >>
> >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> >>
> >> to open a report in a new window. You can use similar stuff to navagate
> >> to
> >> a report in the same window. Hope this helps.
> >>
> >> David
> >>
> >> "sun" wrote:
> >>
> >> > I have some 'go to' links and 'back to' links in my report. I want the
> >> > 'go
> >> > to' links displays reports in new window and 'back to' links displays
> >> > the
> >> > reports in same window. any idea?
>
>|||Hi steve,
I too have a similar requirement, where in when i click on the image in the
report,it should navigate to the url given in the expression.
I have given
="javascript:void(window.open('http://www.google.com','_blank'))" in the
expression.
But what happens is,a new window is opened with "Page cannot be diaplayed"
and the javascript is pasted on to the addres bar of the the browser.And once
we press the enter key, the page loads successfully.What could be the reason
for such an behaviour.Any settings that i have to explicitly make to get this
working.
I have tried looking almost everywhere and this is the solution that they
have suggested.But then it just doesnt work fime with me.
Any inputs on this would be of great help to me.
waiting for your reply,
Many Thanks,
Archana
"steve kwon" wrote:
> Try a simple test ...
> ="javascript:void(window.open('http://www.google.com',
> '_blank'))"
>
> <Action>
> <Hyperlink>="javascript:void(window.open('http://www.google.com',
> '_blank'))"</Hyperlink>
> </Action>
>
> "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > Hi,
> > I have the same problem :(
> > I want the hyperlinks in my report to open in a new window. I tried doing
> > this:
> > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > hyperlink,
> > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > even
> > the javascript doesnt work :(
> > plz help
> > thanks.
> >
> > "David Siebert" wrote:
> >
> >> You can use javascript in the Jump to URL option of the Action property,
> >> so
> >> you can include something like this:
> >>
> >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> >>
> >> to open a report in a new window. You can use similar stuff to navagate
> >> to
> >> a report in the same window. Hope this helps.
> >>
> >> David
> >>
> >> "sun" wrote:
> >>
> >> > I have some 'go to' links and 'back to' links in my report. I want the
> >> > 'go
> >> > to' links displays reports in new window and 'back to' links displays
> >> > the
> >> > reports in same window. any idea?
>
>|||Hi Steve,
Please also note that ,Javascript works fine in the report.That is when i
try opening the report using the report manager /reportserver it works
fine.When i click the link, the page ('google') gets loaded.
But when i include the same report in my sharepoint site ,using the page
viewer webpart and try accessing the link,it throws up an error saying "Page
cannot be displayed" and the javascript gets pasted on the address bar.
Any idea why this behaviour?
Many thanks inadvance,
Regards,
Archana
"Archana" wrote:
> Hi steve,
> I too have a similar requirement, where in when i click on the image in the
> report,it should navigate to the url given in the expression.
> I have given
> ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> expression.
> But what happens is,a new window is opened with "Page cannot be diaplayed"
> and the javascript is pasted on to the addres bar of the the browser.And once
> we press the enter key, the page loads successfully.What could be the reason
> for such an behaviour.Any settings that i have to explicitly make to get this
> working.
> I have tried looking almost everywhere and this is the solution that they
> have suggested.But then it just doesnt work fime with me.
> Any inputs on this would be of great help to me.
> waiting for your reply,
> Many Thanks,
> Archana
>
> "steve kwon" wrote:
> > Try a simple test ...
> >
> > ="javascript:void(window.open('http://www.google.com',
> > '_blank'))"
> >
> >
> > <Action>
> >
> > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > '_blank'))"</Hyperlink>
> >
> > </Action>
> >
> >
> > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > Hi,
> > > I have the same problem :(
> > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > this:
> > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > hyperlink,
> > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > even
> > > the javascript doesnt work :(
> > > plz help
> > > thanks.
> > >
> > > "David Siebert" wrote:
> > >
> > >> You can use javascript in the Jump to URL option of the Action property,
> > >> so
> > >> you can include something like this:
> > >>
> > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > >>
> > >> to open a report in a new window. You can use similar stuff to navagate
> > >> to
> > >> a report in the same window. Hope this helps.
> > >>
> > >> David
> > >>
> > >> "sun" wrote:
> > >>
> > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > >> > 'go
> > >> > to' links displays reports in new window and 'back to' links displays
> > >> > the
> > >> > reports in same window. any idea?
> >
> >
> >|||Hi steve,
My problem got solved.It works fine now.There was a problem with my
sharepoint page and not the script.
Thanks for all the help
Regards
Archana
"Archana" wrote:
> Hi Steve,
> Please also note that ,Javascript works fine in the report.That is when i
> try opening the report using the report manager /reportserver it works
> fine.When i click the link, the page ('google') gets loaded.
> But when i include the same report in my sharepoint site ,using the page
> viewer webpart and try accessing the link,it throws up an error saying "Page
> cannot be displayed" and the javascript gets pasted on the address bar.
> Any idea why this behaviour?
> Many thanks inadvance,
> Regards,
> Archana
> "Archana" wrote:
> >
> > Hi steve,
> >
> > I too have a similar requirement, where in when i click on the image in the
> > report,it should navigate to the url given in the expression.
> >
> > I have given
> > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > expression.
> >
> > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > and the javascript is pasted on to the addres bar of the the browser.And once
> > we press the enter key, the page loads successfully.What could be the reason
> > for such an behaviour.Any settings that i have to explicitly make to get this
> > working.
> >
> > I have tried looking almost everywhere and this is the solution that they
> > have suggested.But then it just doesnt work fime with me.
> >
> > Any inputs on this would be of great help to me.
> >
> > waiting for your reply,
> > Many Thanks,
> > Archana
> >
> >
> > "steve kwon" wrote:
> >
> > > Try a simple test ...
> > >
> > > ="javascript:void(window.open('http://www.google.com',
> > > '_blank'))"
> > >
> > >
> > > <Action>
> > >
> > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > '_blank'))"</Hyperlink>
> > >
> > > </Action>
> > >
> > >
> > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > Hi,
> > > > I have the same problem :(
> > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > this:
> > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > hyperlink,
> > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > even
> > > > the javascript doesnt work :(
> > > > plz help
> > > > thanks.
> > > >
> > > > "David Siebert" wrote:
> > > >
> > > >> You can use javascript in the Jump to URL option of the Action property,
> > > >> so
> > > >> you can include something like this:
> > > >>
> > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > >>
> > > >> to open a report in a new window. You can use similar stuff to navagate
> > > >> to
> > > >> a report in the same window. Hope this helps.
> > > >>
> > > >> David
> > > >>
> > > >> "sun" wrote:
> > > >>
> > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > >> > 'go
> > > >> > to' links displays reports in new window and 'back to' links displays
> > > >> > the
> > > >> > reports in same window. any idea?
> > >
> > >
> > >|||Hello, what was the problem with your sharepoint site exactly? I am just
using the reportserver with the javascript included, and was working just
fine, in many of my reports' action properties. Then one day they all just
stopped working. Perhaps there is a setting that has been changed by some
other install/update to the machine' thanks!
"Archana" wrote:
> Hi steve,
> My problem got solved.It works fine now.There was a problem with my
> sharepoint page and not the script.
> Thanks for all the help
> Regards
> Archana
>
> "Archana" wrote:
> > Hi Steve,
> > Please also note that ,Javascript works fine in the report.That is when i
> > try opening the report using the report manager /reportserver it works
> > fine.When i click the link, the page ('google') gets loaded.
> >
> > But when i include the same report in my sharepoint site ,using the page
> > viewer webpart and try accessing the link,it throws up an error saying "Page
> > cannot be displayed" and the javascript gets pasted on the address bar.
> >
> > Any idea why this behaviour?
> > Many thanks inadvance,
> > Regards,
> > Archana
> >
> > "Archana" wrote:
> >
> > >
> > > Hi steve,
> > >
> > > I too have a similar requirement, where in when i click on the image in the
> > > report,it should navigate to the url given in the expression.
> > >
> > > I have given
> > > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > > expression.
> > >
> > > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > > and the javascript is pasted on to the addres bar of the the browser.And once
> > > we press the enter key, the page loads successfully.What could be the reason
> > > for such an behaviour.Any settings that i have to explicitly make to get this
> > > working.
> > >
> > > I have tried looking almost everywhere and this is the solution that they
> > > have suggested.But then it just doesnt work fime with me.
> > >
> > > Any inputs on this would be of great help to me.
> > >
> > > waiting for your reply,
> > > Many Thanks,
> > > Archana
> > >
> > >
> > > "steve kwon" wrote:
> > >
> > > > Try a simple test ...
> > > >
> > > > ="javascript:void(window.open('http://www.google.com',
> > > > '_blank'))"
> > > >
> > > >
> > > > <Action>
> > > >
> > > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > > '_blank'))"</Hyperlink>
> > > >
> > > > </Action>
> > > >
> > > >
> > > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > > Hi,
> > > > > I have the same problem :(
> > > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > > this:
> > > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > > hyperlink,
> > > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > > even
> > > > > the javascript doesnt work :(
> > > > > plz help
> > > > > thanks.
> > > > >
> > > > > "David Siebert" wrote:
> > > > >
> > > > >> You can use javascript in the Jump to URL option of the Action property,
> > > > >> so
> > > > >> you can include something like this:
> > > > >>
> > > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > > >>
> > > > >> to open a report in a new window. You can use similar stuff to navagate
> > > > >> to
> > > > >> a report in the same window. Hope this helps.
> > > > >>
> > > > >> David
> > > > >>
> > > > >> "sun" wrote:
> > > > >>
> > > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > > >> > 'go
> > > > >> > to' links displays reports in new window and 'back to' links displays
> > > > >> > the
> > > > >> > reports in same window. any idea?
> > > >
> > > >
> > > >|||Hi,
The prerequisite to get the javascript working is you need to have SP1
installed.
And in my case i was trying to include the report in a page viewer web part.
There were 3 frames in my SP page and 2 webparts.I was just not setting the
src property for the web part correctly.But other wise
="javascript:void(window.open('http://www.google.com','_blank'))" javascript
just works fine.
Please make sure you have SP1 update installed on your s/m to get it working.
Thanks !
Archana
"dcray" wrote:
> Hello, what was the problem with your sharepoint site exactly? I am just
> using the reportserver with the javascript included, and was working just
> fine, in many of my reports' action properties. Then one day they all just
> stopped working. Perhaps there is a setting that has been changed by some
> other install/update to the machine' thanks!
> "Archana" wrote:
> > Hi steve,
> >
> > My problem got solved.It works fine now.There was a problem with my
> > sharepoint page and not the script.
> >
> > Thanks for all the help
> >
> > Regards
> > Archana
> >
> >
> > "Archana" wrote:
> >
> > > Hi Steve,
> > > Please also note that ,Javascript works fine in the report.That is when i
> > > try opening the report using the report manager /reportserver it works
> > > fine.When i click the link, the page ('google') gets loaded.
> > >
> > > But when i include the same report in my sharepoint site ,using the page
> > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > cannot be displayed" and the javascript gets pasted on the address bar.
> > >
> > > Any idea why this behaviour?
> > > Many thanks inadvance,
> > > Regards,
> > > Archana
> > >
> > > "Archana" wrote:
> > >
> > > >
> > > > Hi steve,
> > > >
> > > > I too have a similar requirement, where in when i click on the image in the
> > > > report,it should navigate to the url given in the expression.
> > > >
> > > > I have given
> > > > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > > > expression.
> > > >
> > > > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > > > and the javascript is pasted on to the addres bar of the the browser.And once
> > > > we press the enter key, the page loads successfully.What could be the reason
> > > > for such an behaviour.Any settings that i have to explicitly make to get this
> > > > working.
> > > >
> > > > I have tried looking almost everywhere and this is the solution that they
> > > > have suggested.But then it just doesnt work fime with me.
> > > >
> > > > Any inputs on this would be of great help to me.
> > > >
> > > > waiting for your reply,
> > > > Many Thanks,
> > > > Archana
> > > >
> > > >
> > > > "steve kwon" wrote:
> > > >
> > > > > Try a simple test ...
> > > > >
> > > > > ="javascript:void(window.open('http://www.google.com',
> > > > > '_blank'))"
> > > > >
> > > > >
> > > > > <Action>
> > > > >
> > > > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > > > '_blank'))"</Hyperlink>
> > > > >
> > > > > </Action>
> > > > >
> > > > >
> > > > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > > > Hi,
> > > > > > I have the same problem :(
> > > > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > > > this:
> > > > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > > > hyperlink,
> > > > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > > > even
> > > > > > the javascript doesnt work :(
> > > > > > plz help
> > > > > > thanks.
> > > > > >
> > > > > > "David Siebert" wrote:
> > > > > >
> > > > > >> You can use javascript in the Jump to URL option of the Action property,
> > > > > >> so
> > > > > >> you can include something like this:
> > > > > >>
> > > > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > > > >>
> > > > > >> to open a report in a new window. You can use similar stuff to navagate
> > > > > >> to
> > > > > >> a report in the same window. Hope this helps.
> > > > > >>
> > > > > >> David
> > > > > >>
> > > > > >> "sun" wrote:
> > > > > >>
> > > > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > > > >> > 'go
> > > > > >> > to' links displays reports in new window and 'back to' links displays
> > > > > >> > the
> > > > > >> > reports in same window. any idea?
> > > > >
> > > > >
> > > > >|||Thanks for the reply. Yes, I had to install SP1 in order to get it working
in the first place, which it was working just fine for awhile anyway.
"Archana" wrote:
> Hi,
> The prerequisite to get the javascript working is you need to have SP1
> installed.
> And in my case i was trying to include the report in a page viewer web part.
> There were 3 frames in my SP page and 2 webparts.I was just not setting the
> src property for the web part correctly.But other wise
> ="javascript:void(window.open('http://www.google.com','_blank'))" javascript
> just works fine.
> Please make sure you have SP1 update installed on your s/m to get it working.
> Thanks !
> Archana
>
>
> "dcray" wrote:
> >
> > Hello, what was the problem with your sharepoint site exactly? I am just
> > using the reportserver with the javascript included, and was working just
> > fine, in many of my reports' action properties. Then one day they all just
> > stopped working. Perhaps there is a setting that has been changed by some
> > other install/update to the machine' thanks!
> >
> > "Archana" wrote:
> >
> > > Hi steve,
> > >
> > > My problem got solved.It works fine now.There was a problem with my
> > > sharepoint page and not the script.
> > >
> > > Thanks for all the help
> > >
> > > Regards
> > > Archana
> > >
> > >
> > > "Archana" wrote:
> > >
> > > > Hi Steve,
> > > > Please also note that ,Javascript works fine in the report.That is when i
> > > > try opening the report using the report manager /reportserver it works
> > > > fine.When i click the link, the page ('google') gets loaded.
> > > >
> > > > But when i include the same report in my sharepoint site ,using the page
> > > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > > cannot be displayed" and the javascript gets pasted on the address bar.
> > > >
> > > > Any idea why this behaviour?
> > > > Many thanks inadvance,
> > > > Regards,
> > > > Archana
> > > >
> > > > "Archana" wrote:
> > > >
> > > > >
> > > > > Hi steve,
> > > > >
> > > > > I too have a similar requirement, where in when i click on the image in the
> > > > > report,it should navigate to the url given in the expression.
> > > > >
> > > > > I have given
> > > > > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > > > > expression.
> > > > >
> > > > > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > > > > and the javascript is pasted on to the addres bar of the the browser.And once
> > > > > we press the enter key, the page loads successfully.What could be the reason
> > > > > for such an behaviour.Any settings that i have to explicitly make to get this
> > > > > working.
> > > > >
> > > > > I have tried looking almost everywhere and this is the solution that they
> > > > > have suggested.But then it just doesnt work fime with me.
> > > > >
> > > > > Any inputs on this would be of great help to me.
> > > > >
> > > > > waiting for your reply,
> > > > > Many Thanks,
> > > > > Archana
> > > > >
> > > > >
> > > > > "steve kwon" wrote:
> > > > >
> > > > > > Try a simple test ...
> > > > > >
> > > > > > ="javascript:void(window.open('http://www.google.com',
> > > > > > '_blank'))"
> > > > > >
> > > > > >
> > > > > > <Action>
> > > > > >
> > > > > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > > > > '_blank'))"</Hyperlink>
> > > > > >
> > > > > > </Action>
> > > > > >
> > > > > >
> > > > > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > > > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > > > > Hi,
> > > > > > > I have the same problem :(
> > > > > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > > > > this:
> > > > > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > > > > hyperlink,
> > > > > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > > > > even
> > > > > > > the javascript doesnt work :(
> > > > > > > plz help
> > > > > > > thanks.
> > > > > > >
> > > > > > > "David Siebert" wrote:
> > > > > > >
> > > > > > >> You can use javascript in the Jump to URL option of the Action property,
> > > > > > >> so
> > > > > > >> you can include something like this:
> > > > > > >>
> > > > > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > > > > >>
> > > > > > >> to open a report in a new window. You can use similar stuff to navagate
> > > > > > >> to
> > > > > > >> a report in the same window. Hope this helps.
> > > > > > >>
> > > > > > >> David
> > > > > > >>
> > > > > > >> "sun" wrote:
> > > > > > >>
> > > > > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > > > > >> > 'go
> > > > > > >> > to' links displays reports in new window and 'back to' links displays
> > > > > > >> > the
> > > > > > >> > reports in same window. any idea?
> > > > > >
> > > > > >
> > > > > >|||thanks again for responding to my inquiry. turns out some urls to reports
that were getting passed around used an alias for the machine that wasn't set
up as one of the host headers
"dcray" wrote:
> Thanks for the reply. Yes, I had to install SP1 in order to get it working
> in the first place, which it was working just fine for awhile anyway.
> "Archana" wrote:
> > Hi,
> >
> > The prerequisite to get the javascript working is you need to have SP1
> > installed.
> > And in my case i was trying to include the report in a page viewer web part.
> > There were 3 frames in my SP page and 2 webparts.I was just not setting the
> > src property for the web part correctly.But other wise
> > ="javascript:void(window.open('http://www.google.com','_blank'))" javascript
> > just works fine.
> >
> > Please make sure you have SP1 update installed on your s/m to get it working.
> >
> > Thanks !
> > Archana
> >
> >
> >
> >
> > "dcray" wrote:
> >
> > >
> > > Hello, what was the problem with your sharepoint site exactly? I am just
> > > using the reportserver with the javascript included, and was working just
> > > fine, in many of my reports' action properties. Then one day they all just
> > > stopped working. Perhaps there is a setting that has been changed by some
> > > other install/update to the machine' thanks!
> > >
> > > "Archana" wrote:
> > >
> > > > Hi steve,
> > > >
> > > > My problem got solved.It works fine now.There was a problem with my
> > > > sharepoint page and not the script.
> > > >
> > > > Thanks for all the help
> > > >
> > > > Regards
> > > > Archana
> > > >
> > > >
> > > > "Archana" wrote:
> > > >
> > > > > Hi Steve,
> > > > > Please also note that ,Javascript works fine in the report.That is when i
> > > > > try opening the report using the report manager /reportserver it works
> > > > > fine.When i click the link, the page ('google') gets loaded.
> > > > >
> > > > > But when i include the same report in my sharepoint site ,using the page
> > > > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > > > cannot be displayed" and the javascript gets pasted on the address bar.
> > > > >
> > > > > Any idea why this behaviour?
> > > > > Many thanks inadvance,
> > > > > Regards,
> > > > > Archana
> > > > >
> > > > > "Archana" wrote:
> > > > >
> > > > > >
> > > > > > Hi steve,
> > > > > >
> > > > > > I too have a similar requirement, where in when i click on the image in the
> > > > > > report,it should navigate to the url given in the expression.
> > > > > >
> > > > > > I have given
> > > > > > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > > > > > expression.
> > > > > >
> > > > > > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > > > > > and the javascript is pasted on to the addres bar of the the browser.And once
> > > > > > we press the enter key, the page loads successfully.What could be the reason
> > > > > > for such an behaviour.Any settings that i have to explicitly make to get this
> > > > > > working.
> > > > > >
> > > > > > I have tried looking almost everywhere and this is the solution that they
> > > > > > have suggested.But then it just doesnt work fime with me.
> > > > > >
> > > > > > Any inputs on this would be of great help to me.
> > > > > >
> > > > > > waiting for your reply,
> > > > > > Many Thanks,
> > > > > > Archana
> > > > > >
> > > > > >
> > > > > > "steve kwon" wrote:
> > > > > >
> > > > > > > Try a simple test ...
> > > > > > >
> > > > > > > ="javascript:void(window.open('http://www.google.com',
> > > > > > > '_blank'))"
> > > > > > >
> > > > > > >
> > > > > > > <Action>
> > > > > > >
> > > > > > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > > > > > '_blank'))"</Hyperlink>
> > > > > > >
> > > > > > > </Action>
> > > > > > >
> > > > > > >
> > > > > > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > > > > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > > > > > Hi,
> > > > > > > > I have the same problem :(
> > > > > > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > > > > > this:
> > > > > > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > > > > > hyperlink,
> > > > > > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > > > > > even
> > > > > > > > the javascript doesnt work :(
> > > > > > > > plz help
> > > > > > > > thanks.
> > > > > > > >
> > > > > > > > "David Siebert" wrote:
> > > > > > > >
> > > > > > > >> You can use javascript in the Jump to URL option of the Action property,
> > > > > > > >> so
> > > > > > > >> you can include something like this:
> > > > > > > >>
> > > > > > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > > > > > >>
> > > > > > > >> to open a report in a new window. You can use similar stuff to navagate
> > > > > > > >> to
> > > > > > > >> a report in the same window. Hope this helps.
> > > > > > > >>
> > > > > > > >> David
> > > > > > > >>
> > > > > > > >> "sun" wrote:
> > > > > > > >>
> > > > > > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > > > > > >> > 'go
> > > > > > > >> > to' links displays reports in new window and 'back to' links displays
> > > > > > > >> > the
> > > > > > > >> > reports in same window. any idea?
> > > > > > >
> > > > > > >
> > > > > > >sql
Wednesday, March 21, 2012
Line/Point Chart
"hide" the line. Scatter chart does not appear to be the right choice for
this. Is there a way to create a line chart and then hide the line so that
only the data points themselves are visible?
JHIn RS 2000 SP1 or later, you can just set the border line width property on
the value to a value of 0.5 pt or lower.
In RS 2005, you can set the border line style to "None".
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:5A79CABA-6B4E-4579-9610-B06BF3136F71@.microsoft.com...
>I am trying to create a simple chart that displays just the data points and
> "hide" the line. Scatter chart does not appear to be the right choice for
> this. Is there a way to create a line chart and then hide the line so that
> only the data points themselves are visible?
> JH|||Have you tried setting the line color to the same as the background color?
--
Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:5A79CABA-6B4E-4579-9610-B06BF3136F71@.microsoft.com...
>I am trying to create a simple chart that displays just the data points and
> "hide" the line. Scatter chart does not appear to be the right choice for
> this. Is there a way to create a line chart and then hide the line so that
> only the data points themselves are visible?
> JH
Monday, March 19, 2012
Line feed formating
I have put a chr(10) line feed in a expression and it displays just fine in the preview in VS. When I deploy it to the web server it ignores it.
How do I get the line feed to continue to the web server?
="Displays Job's that do not have serial numbers assigned to them form the pervious 30 days." & Chr(10) &
"Products for: " & Parameters!ProdClass.Label & ", Reporting dates: " & Format(DateAdd("d", -30, Now), "d") & " - " & Today
Try this instead:
="Displays Job's that do not have serial numbers assigned to them form the pervious 30 days." & VbCrLf &
"Products for: " & Parameters!ProdClass.Label & ", Reporting dates: " & Format(DateAdd("d", -30, Now), "d") & " - " & Today
-- Robert
|||That worked great Thanks!Line Chart Color
Hello,
My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?
Michael
To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||Merin,
I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?
Michael
|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.
Michael
|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).
however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x
(refer to code snippet)
and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.
rev-boy
=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)
Line Chart Color
Hello,
My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this? Or is the only differentiation the markers?
Michael
To put different colors for lines in line chart, Please select chart properties-goto Data-under values goto Edit-Apperance-goto Series Style...-select Border and Line-Color. give suitable color here. (and i think line and marker will have the same color.)|||Merin,
I did see that option. But doing that changes the colors for ALL lines in my chart. I'd like my series to have different colors, if possible. Any ideas?
Michael
|||for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also|||Ugh, that sounds a lot messier than I thought, especially since my series are all dynamic. Can I reference the color pallete using an array? Or perhaps I'll wait to SRS 2008 with the Dundas charts.
Michael
|||What you mean by dynamic series?|||I mean I have multiple lines on the chart, one for each series value. All the lines are the same color.|||i am trying to do the same thing too.i was able to for a 100% stacked column chart, using multiple data values, and still specify a color for each value in the stacked column chart (3 of them in my case).
however for my current line chart with only 1 data value, the default colors are automatic according to a color scheme, but i want to be able to define the colors. i was thinking of the following methods using coding under the chart properties -? data -? values (double click the value item) -? edit chart value -? appearance -? series style -? border and line -? color -? ?x
(refer to code snippet)
and the color will be hardcoded to the value string of the data. alternative you can put it as a database column. these are just my ideas. would be great if someone out there has a better solution ... always open to learn.
rev-boy
=IIf(
Fields!DATA_COLUMN.Value = "Type 1", "Green",
IIf
(
Fields!DATA_COLUMN.Value = "Type 2", "Red",
IIf
(
Fields!DATA_COLUMN.Value = "Type 3", "Brown", "Black"
)
)
)
Friday, March 9, 2012
Limiting Amount of Text in a box
it displays in the report the textbox grow extensively. How can I limit the
amount that the text box grows, OR limit the amount of text that is
retrieved in my query, i.e., I only want to display 10-15 lines out of
potentially 80-100.
Thanks
DeanYou can try to show only the first N characters doing it in your SQL
sentence or in the Cell Expresion:
IN SQL:
SELECT substring(YourtextField, 1, N) as Comments, ... FROM YourTable
IN Your cell expresion:
= Mid(Fields!YourField.Value, 1, N)
Does it help?
"Dean" <deanl144@.hotmail.com.nospam> escribió en el mensaje
news:%23M8giJhIIHA.5764@.TK2MSFTNGP06.phx.gbl...
>I have Comments field in my db that can contain many lines of text and when
>it displays in the report the textbox grow extensively. How can I limit the
>amount that the text box grows, OR limit the amount of text that is
>retrieved in my query, i.e., I only want to display 10-15 lines out of
>potentially 80-100.
> Thanks
> Dean
>|||On Nov 8, 9:19 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> I have Comments field in my db that can contain many lines of text and when
> it displays in the report the textbox grow extensively. How can I limit the
> amount that the text box grows, OR limit the amount of text that is
> retrieved in my query, i.e., I only want to display 10-15 lines out of
> potentially 80-100.
> Thanks
> Dean
You could create a custom code that counts the carriage return
characters (vbCr, vbLf, vbCrLf depending on your encoding), and if
there are more than 10 in your input string, truncate it using the
Left function
Off the top of my head, it would look something like this:
Function TextTrimmer( txt As String ) As String
lineCount = 0
returnOffset = 1
While lineCount < 10 and returnOffset > 0
returnOffset = InStr( returnOffset+1, txt, vbCr)
lineCount = lineCount + 1
Wend
If returnOffset = 0 Then
' ran out of characters in the string before reaching 10 lines
return( txt )
Else
return( Left( txt, returnOffset-1 ) & "..." )
End If
End Function
Then in the textbox, use
=Code.TextTrimmer( Fields!ReallyLongText.Value )
-- Scott