Link to a table

There is a way to create a link from a SQL Server database to a table located on a MSAccess database? I mean like creating links from MSAccess to other databases. The requested table is updated many times/day, and I dont want to import the table each time an update happens.

Thanks,

Richard

Sure. You can use linked servers, which is easy to configure in Enterprise Manager. You can take a look at this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp

|||Thanks!

link target

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?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

Link Tables in SQL Server

Can I create Link Table in SQL Sever that links to a MS Access Table?You create a "Linked Server" to the Access database.

See Books OnLine under Linked Servers.|||You can use the OLEDB provider for Jet for MS Access database.

Link Tables in SQL Server

Can I create Link Table in SQL Sever that links to a MS Access Table?You create a "Linked Server" to the Access database.

See Books OnLine under Linked Servers.|||You can use the OLEDB provider for Jet for MS Access database.

Link tables in SQL databse

How to create links to other tables within SQL database?Can you define more clearly, Alan?
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:4BDE1092-1974-4958-990B-2FF2B8485DE2@.microsoft.com...
> How to create links to other tables within SQL database?|||If you want to query a table in another database, but on the same server, as
long as your login is a mapped user in the other database, all you need to do
is qualify the table in your FROM clause:
SELECT ...
FROM <database_name>.<owner>.<table_name|view_name>
WHERE ...
Now, if you want to query a database hosted by another server, you have
several optons:
OPENDATASOURCE
OPENRESULTSET
OPENQUERY
LINKED SERVER
Remember that these are not limited to just remote SQL Servers but any OLEDB
or ODBC compliant source where the drivers have been properly loaded on the
server in question.
Sincerely,
Anthony Thomas
"Alan" wrote:
> How to create links to other tables within SQL database?sql

Link tables in SQL databse

How to create links to other tables within SQL database?
Can you define more clearly, Alan?
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:4BDE1092-1974-4958-990B-2FF2B8485DE2@.microsoft.com...
> How to create links to other tables within SQL database?
|||If you want to query a table in another database, but on the same server, as
long as your login is a mapped user in the other database, all you need to do
is qualify the table in your FROM clause:
SELECT ...
FROM <database_name>.<owner>.<table_name|view_name>
WHERE ...
Now, if you want to query a database hosted by another server, you have
several optons:
OPENDATASOURCE
OPENRESULTSET
OPENQUERY
LINKED SERVER
Remember that these are not limited to just remote SQL Servers but any OLEDB
or ODBC compliant source where the drivers have been properly loaded on the
server in question.
Sincerely,
Anthony Thomas
"Alan" wrote:

> How to create links to other tables within SQL database?

Link tables in SQL databse

How to create links to other tables within SQL database?Can you define more clearly, Alan?
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:4BDE1092-1974-4958-990B-2FF2B8485DE2@.microsoft.com...
> How to create links to other tables within SQL database?|||If you want to query a table in another database, but on the same server, as
long as your login is a mapped user in the other database, all you need to d
o
is qualify the table in your FROM clause:
SELECT ...
FROM <database_name>.<owner>.<table_name|view_name>
WHERE ...
Now, if you want to query a database hosted by another server, you have
several optons:
OPENDATASOURCE
OPENRESULTSET
OPENQUERY
LINKED SERVER
Remember that these are not limited to just remote SQL Servers but any OLEDB
or ODBC compliant source where the drivers have been properly loaded on the
server in question.
Sincerely,
Anthony Thomas
"Alan" wrote:

> How to create links to other tables within SQL database?

Link opens a new window...How To?

We have a report that links to another report. The A report is a posting on
our intranet and we'd like to have it so when a user clicks on the link for
the other report it will open another window for them. Any ideas on how this
may be done?You can try putting someting like this
= "javascript:void(window.open('<insert url here>','_blank'))"
in the Jump to URL section of the action property.
David Siebert
"Marty" wrote:
> We have a report that links to another report. The A report is a posting on
> our intranet and we'd like to have it so when a user clicks on the link for
> the other report it will open another window for them. Any ideas on how this
> may be done?|||The better way of doing this is in the parent reports url place the following
as part of the url rc:LinkTarget=_Self
this will make all report links in the report open up where the parent
report is.
"David Siebert" wrote:
> You can try putting someting like this
> = "javascript:void(window.open('<insert url here>','_blank'))"
> in the Jump to URL section of the action property.
> David Siebert
> "Marty" wrote:
> > We have a report that links to another report. The A report is a posting on
> > our intranet and we'd like to have it so when a user clicks on the link for
> > the other report it will open another window for them. Any ideas on how this
> > may be done?|||David,
I have tried using the javascript code below on a report of mine and it does
not work. I put the following in the "Jump to URL" on a field as a test to
make sure the code works:-
="javascript:void(window.open('http://www.google.com','_blank'))"
I deployed the report and ran it (we are just using the standard report
manager web site), but when I click on the field to invoke the jump to all I
get is a "page cannot be displayed" message and this message is in the same
window as the report.
If I shift and click the field to force the link into a new window then I
get the same "page cannot be displayed" error, but as soon as this window
opens I do get a new window with google in it. So, the code seems to be
working directly from IE but does not work from within RS.
Any ideas why this is not working?
Thanks
Dave
"David Siebert" wrote:
> You can try putting someting like this
> = "javascript:void(window.open('<insert url here>','_blank'))"
> in the Jump to URL section of the action property.
> David Siebert
> "Marty" wrote:
> > We have a report that links to another report. The A report is a posting on
> > our intranet and we'd like to have it so when a user clicks on the link for
> > the other report it will open another window for them. Any ideas on how this
> > may be done?|||got the same problem, tried this but it doesn't work :( Looking at the
rendered page, it is putting 'TARGET='_top' into the a tag :/ ) They need to
add a 'target' property to the 'jump to url', bit of an oversight tbh :(
"David Siebert" <DavidSiebert@.discussions.microsoft.com> wrote in message
news:1306182F-57EF-48BF-93C4-596B53F79B78@.microsoft.com...
> You can try putting someting like this
> = "javascript:void(window.open('<insert url here>','_blank'))"
> in the Jump to URL section of the action property.
> David Siebert
> "Marty" wrote:
> > We have a report that links to another report. The A report is a posting
on
> > our intranet and we'd like to have it so when a user clicks on the link
for
> > the other report it will open another window for them. Any ideas on how
this
> > may be done?|||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.
"Anonymous Poster" wrote:
> got the same problem, tried this but it doesn't work :( Looking at the
> rendered page, it is putting 'TARGET='_top' into the a tag :/ ) They need to
> add a 'target' property to the 'jump to url', bit of an oversight tbh :(
> "David Siebert" <DavidSiebert@.discussions.microsoft.com> wrote in message
> news:1306182F-57EF-48BF-93C4-596B53F79B78@.microsoft.com...
> > You can try putting someting like this
> >
> > = "javascript:void(window.open('<insert url here>','_blank'))"
> >
> > in the Jump to URL section of the action property.
> >
> > David Siebert
> >
> > "Marty" wrote:
> >
> > > We have a report that links to another report. The A report is a posting
> on
> > > our intranet and we'd like to have it so when a user clicks on the link
> for
> > > the other report it will open another window for them. Any ideas on how
> this
> > > may be done?
>
>|||When you tried the javascript link, did you deploy it to the server and try
it, or just from visual studio?
My first attempt at this gave me an error regarding the link's schema type
and said it was invalid. But after deploying to the report server it worked
fine.
"Aravind" wrote:
> 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.
> "Anonymous Poster" wrote:
> > got the same problem, tried this but it doesn't work :( Looking at the
> > rendered page, it is putting 'TARGET='_top' into the a tag :/ ) They need to
> > add a 'target' property to the 'jump to url', bit of an oversight tbh :(
> >
> > "David Siebert" <DavidSiebert@.discussions.microsoft.com> wrote in message
> > news:1306182F-57EF-48BF-93C4-596B53F79B78@.microsoft.com...
> > > You can try putting someting like this
> > >
> > > = "javascript:void(window.open('<insert url here>','_blank'))"
> > >
> > > in the Jump to URL section of the action property.
> > >
> > > David Siebert
> > >
> > > "Marty" wrote:
> > >
> > > > We have a report that links to another report. The A report is a posting
> > on
> > > > our intranet and we'd like to have it so when a user clicks on the link
> > for
> > > > the other report it will open another window for them. Any ideas on how
> > this
> > > > may be done?
> >
> >
> >|||David
Did you get this to work, I am getting the problem where it only works if I
use the shift key when pressing the mouse button.
Was it a server change or report as the same is happening on all reports?
Darren
"DaveW" wrote:
> David,
> I have tried using the javascript code below on a report of mine and it does
> not work. I put the following in the "Jump to URL" on a field as a test to
> make sure the code works:-
> ="javascript:void(window.open('http://www.google.com','_blank'))"
> I deployed the report and ran it (we are just using the standard report
> manager web site), but when I click on the field to invoke the jump to all I
> get is a "page cannot be displayed" message and this message is in the same
> window as the report.
> If I shift and click the field to force the link into a new window then I
> get the same "page cannot be displayed" error, but as soon as this window
> opens I do get a new window with google in it. So, the code seems to be
> working directly from IE but does not work from within RS.
> Any ideas why this is not working?
> Thanks
> Dave
> "David Siebert" wrote:
> > You can try putting someting like this
> >
> > = "javascript:void(window.open('<insert url here>','_blank'))"
> >
> > in the Jump to URL section of the action property.
> >
> > David Siebert
> >
> > "Marty" wrote:
> >
> > > We have a report that links to another report. The A report is a posting on
> > > our intranet and we'd like to have it so when a user clicks on the link for
> > > the other report it will open another window for them. Any ideas on how this
> > > may be done?|||Since there are many who cannot get "LinkTarget" to work I want to share my
mistake.
Remember that it is the url to the "master"-report that will need the
parameter "LinkTarget", it is not the action-links to the "Detail"-report
that will need the parameter.
Url 1: http://localhost/rerportMaster&rc:LinkTarget=_blank
Url 2 (Action In report 2): Anything (renders with target=_blank)
I struggled with this for a long time before I realized my mistake.
Regards Maran
"Marty" wrote:
> We have a report that links to another report. The A report is a posting on
> our intranet and we'd like to have it so when a user clicks on the link for
> the other report it will open another window for them. Any ideas on how this
> may be done?