jump to url option with _blank

I am trying to set up a link using the navigation/hyperlink action/jump to
url feature of reporting services(Right Click ->Advanced->Navigation->Jump To
Url).
When I click on the hyperlink, I would like the navigation target to be a
new form (_blank), NOT the existing one. I have tried the following code
with some success
="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
As you can see the actual url is contained in: " & Fields!feature_url.Value
& "
If I preview my report in Visual Studio, click on the hyperlink it will
launch a page that contains the entire line:
="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
in the browser's url field, it then launches a second page with the correct
url.
Unfortunately, it doesn't work at all from the report server...I just get a
page with the entire line and then nothing.
Does anyone know how to do this? Here's the html if that's of any use.
<Action>
<Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
& "','_blank'))"
</Hyperlink>
</Action>I create a test report and it works fine...I have SP2.
Check the post "Please Help"
Jeronimo Vogt
"beeyule" <beeyule@.discussions.microsoft.com> wrote in message
news:ED8D1700-FA0E-4E58-B8C4-CEC4AC367B6C@.microsoft.com...
> I am trying to set up a link using the navigation/hyperlink action/jump to
> url feature of reporting services(Right Click ->Advanced->Navigation->Jump
To
> Url).
> When I click on the hyperlink, I would like the navigation target to be a
> new form (_blank), NOT the existing one. I have tried the following code
> with some success
> ="javascript:void(window.open('" & Fields!feature_url.Value &
"','_blank'))"
> As you can see the actual url is contained in: " &
Fields!feature_url.Value
> & "
> If I preview my report in Visual Studio, click on the hyperlink it will
> launch a page that contains the entire line:
> ="javascript:void(window.open('" & Fields!feature_url.Value &
"','_blank'))"
> in the browser's url field, it then launches a second page with the
correct
> url.
> Unfortunately, it doesn't work at all from the report server...I just get
a
> page with the entire line and then nothing.
> Does anyone know how to do this? Here's the html if that's of any use.
> <Action>
> <Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
> & "','_blank'))"
> </Hyperlink>
> </Action>
>
>
>|||bee,
Please check the url of the first report
dont type in localhost/reorts - type <yourservername>/reports.
Hope this helps
"beeyule" wrote:
> I am trying to set up a link using the navigation/hyperlink action/jump to
> url feature of reporting services(Right Click ->Advanced->Navigation->Jump To
> Url).
> When I click on the hyperlink, I would like the navigation target to be a
> new form (_blank), NOT the existing one. I have tried the following code
> with some success
> ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> As you can see the actual url is contained in: " & Fields!feature_url.Value
> & "
> If I preview my report in Visual Studio, click on the hyperlink it will
> launch a page that contains the entire line:
> ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> in the browser's url field, it then launches a second page with the correct
> url.
> Unfortunately, it doesn't work at all from the report server...I just get a
> page with the entire line and then nothing.
> Does anyone know how to do this? Here's the html if that's of any use.
> <Action>
> <Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
> & "','_blank'))"
> </Hyperlink>
> </Action>
>
>
>|||"RP" wrote:
> bee,
> Please check the url of the first report
> dont type in localhost/reorts - type <yourservername>/reports.
> Hope this helps
> "beeyule" wrote:
> > I am trying to set up a link using the navigation/hyperlink action/jump to
> > url feature of reporting services(Right Click ->Advanced->Navigation->Jump To
> > Url).
> >
> > When I click on the hyperlink, I would like the navigation target to be a
> > new form (_blank), NOT the existing one. I have tried the following code
> > with some success
> >
> > ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> >
> > As you can see the actual url is contained in: " & Fields!feature_url.Value
> > & "
> >
> > If I preview my report in Visual Studio, click on the hyperlink it will
> > launch a page that contains the entire line:
> >
> > ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> >
> > in the browser's url field, it then launches a second page with the correct
> > url.
> >
> > Unfortunately, it doesn't work at all from the report server...I just get a
> > page with the entire line and then nothing.
> >
> > Does anyone know how to do this? Here's the html if that's of any use.
> >
> > <Action>
> > <Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
> > & "','_blank'))"
> > </Hyperlink>
> > </Action>
> >
> >
> >
> >
> >
> >
bee,
> Please check the url of the first report
> dont type in localhost/reorts - type <yourservername>/reports.
I have sp4...
I'm not typing in the localhost address. The url to the report server is
determined by the "Fields!feature_url.Value" field.
The report itself opens without incident. When I click on the hyperlink
located within the report column I get a directed to a web page with the url:
javascript:void(window.open('http://websiteaddress/app/Page.aspx?ID=1','_blank'))
the url contained within the code is correct, it just doesn't behave the way
I had anticipated.|||We are on SP1 and found the "LinkTarget" property does NOT work the way it is
supposed to on the report server (be careful when testing in the Visual
Studio designer - it opens a new page because you are running in VS.)
The Javascript code to open a new window does NOT work in SP1. SP2 is
supposed to have fixed this - I have not yet found out if that is actually
the case.
Tom
"beeyule" wrote:
>
> "RP" wrote:
> > bee,
> > Please check the url of the first report
> > dont type in localhost/reorts - type <yourservername>/reports.
> >
> > Hope this helps
> >
> > "beeyule" wrote:
> >
> > > I am trying to set up a link using the navigation/hyperlink action/jump to
> > > url feature of reporting services(Right Click ->Advanced->Navigation->Jump To
> > > Url).
> > >
> > > When I click on the hyperlink, I would like the navigation target to be a
> > > new form (_blank), NOT the existing one. I have tried the following code
> > > with some success
> > >
> > > ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> > >
> > > As you can see the actual url is contained in: " & Fields!feature_url.Value
> > > & "
> > >
> > > If I preview my report in Visual Studio, click on the hyperlink it will
> > > launch a page that contains the entire line:
> > >
> > > ="javascript:void(window.open('" & Fields!feature_url.Value & "','_blank'))"
> > >
> > > in the browser's url field, it then launches a second page with the correct
> > > url.
> > >
> > > Unfortunately, it doesn't work at all from the report server...I just get a
> > > page with the entire line and then nothing.
> > >
> > > Does anyone know how to do this? Here's the html if that's of any use.
> > >
> > > <Action>
> > > <Hyperlink>="javascript:void(window.open('" & Fields!feature_url.Value
> > > & "','_blank'))"
> > > </Hyperlink>
> > > </Action>
> > >
> > >
> > >
> > >
> > >
> > >
> bee,
> > Please check the url of the first report
> > dont type in localhost/reorts - type <yourservername>/reports.
>
> I have sp4...
> I'm not typing in the localhost address. The url to the report server is
> determined by the "Fields!feature_url.Value" field.
> The report itself opens without incident. When I click on the hyperlink
> located within the report column I get a directed to a web page with the url:
> javascript:void(window.open('http://websiteaddress/app/Page.aspx?ID=1','_blank'))
> the url contained within the code is correct, it just doesn't behave the way
> I had anticipated.
>
>|||Hmm, not sure why it isn't working correctly for you. I suspect something in
how you are creating the URL. Are you using jump to URL? I have had this
working in both SP1 and SP2 and I know others have as well. Here is a URL
that works for me (opening a new window). One thing to note, it does not
work from VS, you have to deploy it. Try copying and pasting the below into
the jump to URL and give it a try.
= "javascript:void(window.open('http://www.google.com','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ASP Yaboh" <ASPYaboh@.discussions.microsoft.com> wrote in message
news:8F5897A0-09D1-4565-8573-5ADCE6191360@.microsoft.com...
> We are on SP1 and found the "LinkTarget" property does NOT work the way it
> is
> supposed to on the report server (be careful when testing in the Visual
> Studio designer - it opens a new page because you are running in VS.)
> The Javascript code to open a new window does NOT work in SP1. SP2 is
> supposed to have fixed this - I have not yet found out if that is actually
> the case.
> Tom
> "beeyule" wrote:
>>
>> "RP" wrote:
>> > bee,
>> > Please check the url of the first report
>> > dont type in localhost/reorts - type <yourservername>/reports.
>> >
>> > Hope this helps
>> >
>> > "beeyule" wrote:
>> >
>> > > I am trying to set up a link using the navigation/hyperlink
>> > > action/jump to
>> > > url feature of reporting services(Right
>> > > Click ->Advanced->Navigation->Jump To
>> > > Url).
>> > >
>> > > When I click on the hyperlink, I would like the navigation target to
>> > > be a
>> > > new form (_blank), NOT the existing one. I have tried the following
>> > > code
>> > > with some success
>> > >
>> > > ="javascript:void(window.open('" & Fields!feature_url.Value &
>> > > "','_blank'))"
>> > >
>> > > As you can see the actual url is contained in: " &
>> > > Fields!feature_url.Value
>> > > & "
>> > >
>> > > If I preview my report in Visual Studio, click on the hyperlink it
>> > > will
>> > > launch a page that contains the entire line:
>> > >
>> > > ="javascript:void(window.open('" & Fields!feature_url.Value &
>> > > "','_blank'))"
>> > >
>> > > in the browser's url field, it then launches a second page with the
>> > > correct
>> > > url.
>> > >
>> > > Unfortunately, it doesn't work at all from the report server...I just
>> > > get a
>> > > page with the entire line and then nothing.
>> > >
>> > > Does anyone know how to do this? Here's the html if that's of any
>> > > use.
>> > >
>> > > <Action>
>> > > <Hyperlink>="javascript:void(window.open('" &
>> > > Fields!feature_url.Value
>> > > & "','_blank'))"
>> > > </Hyperlink>
>> > > </Action>
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> bee,
>> > Please check the url of the first report
>> > dont type in localhost/reorts - type <yourservername>/reports.
>>
>> I have sp4...
>> I'm not typing in the localhost address. The url to the report server is
>> determined by the "Fields!feature_url.Value" field.
>> The report itself opens without incident. When I click on the hyperlink
>> located within the report column I get a directed to a web page with the
>> url:
>> javascript:void(window.open('http://websiteaddress/app/Page.aspx?ID=1','_blank'))
>> the url contained within the code is correct, it just doesn't behave the
>> way
>> I had anticipated.
>>
>>|||I'm pretty certain we thoroughly flogged this issue, but I will deploy a test
report later today with that exact link just to be certain.
Thank you.
"Bruce L-C [MVP]" wrote:
> Hmm, not sure why it isn't working correctly for you. I suspect something in
> how you are creating the URL. Are you using jump to URL? I have had this
> working in both SP1 and SP2 and I know others have as well. Here is a URL
> that works for me (opening a new window). One thing to note, it does not
> work from VS, you have to deploy it. Try copying and pasting the below into
> the jump to URL and give it a try.
> = "javascript:void(window.open('http://www.google.com','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ASP Yaboh" <ASPYaboh@.discussions.microsoft.com> wrote in message
> news:8F5897A0-09D1-4565-8573-5ADCE6191360@.microsoft.com...
> > We are on SP1 and found the "LinkTarget" property does NOT work the way it
> > is
> > supposed to on the report server (be careful when testing in the Visual
> > Studio designer - it opens a new page because you are running in VS.)
> >
> > The Javascript code to open a new window does NOT work in SP1. SP2 is
> > supposed to have fixed this - I have not yet found out if that is actually
> > the case.
> >
> > Tom
> >
> > "beeyule" wrote:
> >
> >>
> >>
> >> "RP" wrote:
> >>
> >> > bee,
> >> > Please check the url of the first report
> >> > dont type in localhost/reorts - type <yourservername>/reports.
> >> >
> >> > Hope this helps
> >> >
> >> > "beeyule" wrote:
> >> >
> >> > > I am trying to set up a link using the navigation/hyperlink
> >> > > action/jump to
> >> > > url feature of reporting services(Right
> >> > > Click ->Advanced->Navigation->Jump To
> >> > > Url).
> >> > >
> >> > > When I click on the hyperlink, I would like the navigation target to
> >> > > be a
> >> > > new form (_blank), NOT the existing one. I have tried the following
> >> > > code
> >> > > with some success
> >> > >
> >> > > ="javascript:void(window.open('" & Fields!feature_url.Value &
> >> > > "','_blank'))"
> >> > >
> >> > > As you can see the actual url is contained in: " &
> >> > > Fields!feature_url.Value
> >> > > & "
> >> > >
> >> > > If I preview my report in Visual Studio, click on the hyperlink it
> >> > > will
> >> > > launch a page that contains the entire line:
> >> > >
> >> > > ="javascript:void(window.open('" & Fields!feature_url.Value &
> >> > > "','_blank'))"
> >> > >
> >> > > in the browser's url field, it then launches a second page with the
> >> > > correct
> >> > > url.
> >> > >
> >> > > Unfortunately, it doesn't work at all from the report server...I just
> >> > > get a
> >> > > page with the entire line and then nothing.
> >> > >
> >> > > Does anyone know how to do this? Here's the html if that's of any
> >> > > use.
> >> > >
> >> > > <Action>
> >> > > <Hyperlink>="javascript:void(window.open('" &
> >> > > Fields!feature_url.Value
> >> > > & "','_blank'))"
> >> > > </Hyperlink>
> >> > > </Action>
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >> > >
> >>
> >> bee,
> >> > Please check the url of the first report
> >> > dont type in localhost/reorts - type <yourservername>/reports.
> >>
> >>
> >> I have sp4...
> >>
> >> I'm not typing in the localhost address. The url to the report server is
> >> determined by the "Fields!feature_url.Value" field.
> >>
> >> The report itself opens without incident. When I click on the hyperlink
> >> located within the report column I get a directed to a web page with the
> >> url:
> >>
> >> javascript:void(window.open('http://websiteaddress/app/Page.aspx?ID=1','_blank'))
> >>
> >> the url contained within the code is correct, it just doesn't behave the
> >> way
> >> I had anticipated.
> >>
> >>
> >>
> >>
>
>

Jump To URL not working

Hi,
I'm using Reporting Services 2000 with the latest SP. The javascript code in
Jump To URL is giving a Page Cannot be Displayed message.
Here is the code:
="javascript:void(window.open('" + Globals!ReportServerUrl + "?"+
Globals!ReportFolder + "/Detail&Country_Code=" +
Parameters!Country_Code.Value + "&ITEMID=" + Fields!Parent_Product_Code.Value
+ "&NavCat=" + STR(Parameters!NavCat.Value) + "&Language=" +
Parameters!Language.Value +
"&IsParent=Y&rs:Command=Render&rc:Parameters=false','','_blank,width = 580,height=750,top=200'))"
Can someone plz help?The links work fine if i access the report from localhost/ReportServer
but not when i access from ReportManager.
Is this a known issue?
"Gaurav" wrote:
> Hi,
> I'm using Reporting Services 2000 with the latest SP. The javascript code in
> Jump To URL is giving a Page Cannot be Displayed message.
> Here is the code:
> ="javascript:void(window.open('" + Globals!ReportServerUrl + "?"+
> Globals!ReportFolder + "/Detail&Country_Code=" +
> Parameters!Country_Code.Value + "&ITEMID=" + Fields!Parent_Product_Code.Value
> + "&NavCat=" + STR(Parameters!NavCat.Value) + "&Language=" +
> Parameters!Language.Value +
> "&IsParent=Y&rs:Command=Render&rc:Parameters=false','','_blank,width => 580,height=750,top=200'))"
> Can someone plz help?
>|||Get this complete link display on a text box (ofcourse without javascript
syntax) and see where you are going wrong.
Amarnath
"Gaurav" wrote:
> The links work fine if i access the report from localhost/ReportServer
> but not when i access from ReportManager.
> Is this a known issue?
>
> "Gaurav" wrote:
> > Hi,
> >
> > I'm using Reporting Services 2000 with the latest SP. The javascript code in
> > Jump To URL is giving a Page Cannot be Displayed message.
> >
> > Here is the code:
> > ="javascript:void(window.open('" + Globals!ReportServerUrl + "?"+
> > Globals!ReportFolder + "/Detail&Country_Code=" +
> > Parameters!Country_Code.Value + "&ITEMID=" + Fields!Parent_Product_Code.Value
> > + "&NavCat=" + STR(Parameters!NavCat.Value) + "&Language=" +
> > Parameters!Language.Value +
> > "&IsParent=Y&rs:Command=Render&rc:Parameters=false','','_blank,width => > 580,height=750,top=200'))"
> >
> > Can someone plz help?
> >|||I couldn't resolve this. Even if i put in a link to google.com it doesn't
work.
The following is not working:
="javascript:void(window.open('http://www.google.com','_blank'))"
Any other suggestions?
"Amarnath" wrote:
> Get this complete link display on a text box (ofcourse without javascript
> syntax) and see where you are going wrong.
> Amarnath
> "Gaurav" wrote:
> > The links work fine if i access the report from localhost/ReportServer
> > but not when i access from ReportManager.
> >
> > Is this a known issue?
> >
> >
> > "Gaurav" wrote:
> >
> > > Hi,
> > >
> > > I'm using Reporting Services 2000 with the latest SP. The javascript code in
> > > Jump To URL is giving a Page Cannot be Displayed message.
> > >
> > > Here is the code:
> > > ="javascript:void(window.open('" + Globals!ReportServerUrl + "?"+
> > > Globals!ReportFolder + "/Detail&Country_Code=" +
> > > Parameters!Country_Code.Value + "&ITEMID=" + Fields!Parent_Product_Code.Value
> > > + "&NavCat=" + STR(Parameters!NavCat.Value) + "&Language=" +
> > > Parameters!Language.Value +
> > > "&IsParent=Y&rs:Command=Render&rc:Parameters=false','','_blank,width => > > 580,height=750,top=200'))"
> > >
> > > Can someone plz help?
> > >|||This looks OK. What version are you one. The ability to do this was
introduced with SP1 of RS 2000. You need to be on SP1 or greater for RS 2000
and any version of RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gaurav" <Gaurav@.discussions.microsoft.com> wrote in message
news:E823758C-0A43-433F-B7C5-1EB1E9D98627@.microsoft.com...
>I couldn't resolve this. Even if i put in a link to google.com it doesn't
> work.
> The following is not working:
> ="javascript:void(window.open('http://www.google.com','_blank'))"
> Any other suggestions?
> "Amarnath" wrote:
>> Get this complete link display on a text box (ofcourse without javascript
>> syntax) and see where you are going wrong.
>> Amarnath
>> "Gaurav" wrote:
>> > The links work fine if i access the report from localhost/ReportServer
>> > but not when i access from ReportManager.
>> >
>> > Is this a known issue?
>> >
>> >
>> > "Gaurav" wrote:
>> >
>> > > Hi,
>> > >
>> > > I'm using Reporting Services 2000 with the latest SP. The javascript
>> > > code in
>> > > Jump To URL is giving a Page Cannot be Displayed message.
>> > >
>> > > Here is the code:
>> > > ="javascript:void(window.open('" + Globals!ReportServerUrl + "?"+
>> > > Globals!ReportFolder + "/Detail&Country_Code=" +
>> > > Parameters!Country_Code.Value + "&ITEMID=" +
>> > > Fields!Parent_Product_Code.Value
>> > > + "&NavCat=" + STR(Parameters!NavCat.Value) + "&Language=" +
>> > > Parameters!Language.Value +
>> > > "&IsParent=Y&rs:Command=Render&rc:Parameters=false','','_blank,width
>> > > =>> > > 580,height=750,top=200'))"
>> > >
>> > > Can someone plz help?
>> > >|||Thanks for the reply Bruce.
I am using Version 8.00.1038.00.
"Bruce L-C [MVP]" wrote:
> This looks OK. What version are you one. The ability to do this was
> introduced with SP1 of RS 2000. You need to be on SP1 or greater for RS 2000
> and any version of RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Gaurav" <Gaurav@.discussions.microsoft.com> wrote in message
> news:E823758C-0A43-433F-B7C5-1EB1E9D98627@.microsoft.com...
> >I couldn't resolve this. Even if i put in a link to google.com it doesn't
> > work.
> >
> > The following is not working:
> > ="javascript:void(window.open('http://www.google.com','_blank'))"
> >
> > Any other suggestions?
> >
> > "Amarnath" wrote:
> >
> >> Get this complete link display on a text box (ofcourse without javascript
> >> syntax) and see where you are going wrong.
> >>
> >> Amarnath
> >>
> >> "Gaurav" wrote:
> >>
> >> > The links work fine if i access the report from localhost/ReportServer
> >> > but not when i access from ReportManager.
> >> >
> >> > Is this a known issue?
> >> >
> >> >
> >> > "Gaurav" wrote:
> >> >
> >> > > Hi,
> >> > >
> >> > > I'm using Reporting Services 2000 with the latest SP. The javascript
> >> > > code in
> >> > > Jump To URL is giving a Page Cannot be Displayed message.
> >> > >
> >> > > Here is the code:
> >> > > ="javascript:void(window.open('" + Globals!ReportServerUrl + "?"+
> >> > > Globals!ReportFolder + "/Detail&Country_Code=" +
> >> > > Parameters!Country_Code.Value + "&ITEMID=" +
> >> > > Fields!Parent_Product_Code.Value
> >> > > + "&NavCat=" + STR(Parameters!NavCat.Value) + "&Language=" +
> >> > > Parameters!Language.Value +
> >> > > "&IsParent=Y&rs:Command=Render&rc:Parameters=false','','_blank,width
> >> > > => >> > > 580,height=750,top=200'))"
> >> > >
> >> > > Can someone plz help?
> >> > >
>
>|||That should be SP2. It should be working for you.
Copy and paste this in:
= "javascript:void(window.open('http://www.google.com','_blank'))"
Also, do you have popup blocker running?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gaurav" <Gaurav@.discussions.microsoft.com> wrote in message
news:DD368BFC-B8B5-4EC6-994D-F95E603FF9FD@.microsoft.com...
> Thanks for the reply Bruce.
> I am using Version 8.00.1038.00.
> "Bruce L-C [MVP]" wrote:
>> This looks OK. What version are you one. The ability to do this was
>> introduced with SP1 of RS 2000. You need to be on SP1 or greater for RS
>> 2000
>> and any version of RS 2005.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Gaurav" <Gaurav@.discussions.microsoft.com> wrote in message
>> news:E823758C-0A43-433F-B7C5-1EB1E9D98627@.microsoft.com...
>> >I couldn't resolve this. Even if i put in a link to google.com it
>> >doesn't
>> > work.
>> >
>> > The following is not working:
>> > ="javascript:void(window.open('http://www.google.com','_blank'))"
>> >
>> > Any other suggestions?
>> >
>> > "Amarnath" wrote:
>> >
>> >> Get this complete link display on a text box (ofcourse without
>> >> javascript
>> >> syntax) and see where you are going wrong.
>> >>
>> >> Amarnath
>> >>
>> >> "Gaurav" wrote:
>> >>
>> >> > The links work fine if i access the report from
>> >> > localhost/ReportServer
>> >> > but not when i access from ReportManager.
>> >> >
>> >> > Is this a known issue?
>> >> >
>> >> >
>> >> > "Gaurav" wrote:
>> >> >
>> >> > > Hi,
>> >> > >
>> >> > > I'm using Reporting Services 2000 with the latest SP. The
>> >> > > javascript
>> >> > > code in
>> >> > > Jump To URL is giving a Page Cannot be Displayed message.
>> >> > >
>> >> > > Here is the code:
>> >> > > ="javascript:void(window.open('" + Globals!ReportServerUrl + "?"+
>> >> > > Globals!ReportFolder + "/Detail&Country_Code=" +
>> >> > > Parameters!Country_Code.Value + "&ITEMID=" +
>> >> > > Fields!Parent_Product_Code.Value
>> >> > > + "&NavCat=" + STR(Parameters!NavCat.Value) + "&Language=" +
>> >> > > Parameters!Language.Value +
>> >> > > "&IsParent=Y&rs:Command=Render&rc:Parameters=false','','_blank,width
>> >> > > =>> >> > > 580,height=750,top=200'))"
>> >> > >
>> >> > > Can someone plz help?
>> >> > >
>>|||Even after disabling the popup bloker, its not running.
Any other thoughts?
"Bruce L-C [MVP]" wrote:
> That should be SP2. It should be working for you.
> Copy and paste this in:
> = "javascript:void(window.open('http://www.google.com','_blank'))"
> Also, do you have popup blocker running?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Gaurav" <Gaurav@.discussions.microsoft.com> wrote in message
> news:DD368BFC-B8B5-4EC6-994D-F95E603FF9FD@.microsoft.com...
> > Thanks for the reply Bruce.
> > I am using Version 8.00.1038.00.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> This looks OK. What version are you one. The ability to do this was
> >> introduced with SP1 of RS 2000. You need to be on SP1 or greater for RS
> >> 2000
> >> and any version of RS 2005.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Gaurav" <Gaurav@.discussions.microsoft.com> wrote in message
> >> news:E823758C-0A43-433F-B7C5-1EB1E9D98627@.microsoft.com...
> >> >I couldn't resolve this. Even if i put in a link to google.com it
> >> >doesn't
> >> > work.
> >> >
> >> > The following is not working:
> >> > ="javascript:void(window.open('http://www.google.com','_blank'))"
> >> >
> >> > Any other suggestions?
> >> >
> >> > "Amarnath" wrote:
> >> >
> >> >> Get this complete link display on a text box (ofcourse without
> >> >> javascript
> >> >> syntax) and see where you are going wrong.
> >> >>
> >> >> Amarnath
> >> >>
> >> >> "Gaurav" wrote:
> >> >>
> >> >> > The links work fine if i access the report from
> >> >> > localhost/ReportServer
> >> >> > but not when i access from ReportManager.
> >> >> >
> >> >> > Is this a known issue?
> >> >> >
> >> >> >
> >> >> > "Gaurav" wrote:
> >> >> >
> >> >> > > Hi,
> >> >> > >
> >> >> > > I'm using Reporting Services 2000 with the latest SP. The
> >> >> > > javascript
> >> >> > > code in
> >> >> > > Jump To URL is giving a Page Cannot be Displayed message.
> >> >> > >
> >> >> > > Here is the code:
> >> >> > > ="javascript:void(window.open('" + Globals!ReportServerUrl + "?"+
> >> >> > > Globals!ReportFolder + "/Detail&Country_Code=" +
> >> >> > > Parameters!Country_Code.Value + "&ITEMID=" +
> >> >> > > Fields!Parent_Product_Code.Value
> >> >> > > + "&NavCat=" + STR(Parameters!NavCat.Value) + "&Language=" +
> >> >> > > Parameters!Language.Value +
> >> >> > > "&IsParent=Y&rs:Command=Render&rc:Parameters=false','','_blank,width
> >> >> > > => >> >> > > 580,height=750,top=200'))"
> >> >> > >
> >> >> > > Can someone plz help?
> >> >> > >
> >>
> >>
> >>
>
>

jump to URL navigation feature

I am using the navigation/hyperlink action/jump to url feature of reporting services(Right Click ->Advanced->Navigation->Jump To Url).In my environment the url comes from the database so I use thefollowing code in the "jump to url" field: =Fields!feature_url.Value.
I want to open a new window(_blank) when I click on the link but am having difficulties. I found some code
"void(window.open('& =Fields!feature_url &','_blank'))"
but haven't yet gotten it to work. I am entering this code directly into the "jump to url" field.
Does anyone have any ideas?
I left out a bit of important info...
If I use this:
="javascript:void(window.open('http://www.google.com','_blank'))"
I will be properly directed to google, so it looks like this piece ofcode works. I'm having trouble replacing the google urlwith "=Fields!feature_url.Value"

|||Hi, I don't know how you manage to have that piece of javascript working... I copy/pasted the string you posted and it is taked as a URL literally ... so obviosly it doesn't work.
I want that the Report show itself in an IFRAME and not in a new window, but should be just changing the TARGET property in the windows.open, isn't it?
May be this is a problem with my OS... Win2003 Server.
If you could help me... I'll be grateful.
Thanks in advance,
Matías|||

To call up a javascript window link from the "Jump To URL" functionality in Reporting Services SP2 Hotfix 1 applied, use:
="javascript:void(window.open('" & Fields!feature_url &"','_blank'))"
If you want it to direct to an iframe, make your iframe on your page:
<iframe name="MyFrameName"></iframe>
and make your link:
="javascript:void(window.open('" & Fields!feature_url &"','MyFrameName'))"
This works in IE6, but I can't say for the other browsers.

|||

The reportviewer control has an attribute named "HyperlinkTarget"

so Yo can have somthing like:

<rsweb:ReportViewerID="reportViewer"runat="server"Font-Names="Verdana"Font-Size="8pt"

Width="100%"Height="800px"HyperlinkTarget="_blank">

</rsweb:ReportViewer>

Jump to URL mangling

I am using "Jump to URL" in a few reports to jump to other reports on the
same reporting services instance. The problem I'm having is that when RS
renders the report, it changes the URL to include a prefix of
"http://reportingserver.domain.com/Reports/Pages/Report.aspx?ServerUrl=".
This is then followed by the actual URL I want to jump to. However, I don't
want this prefix to be applied. It seems to only happen when the
destination of the jump is the reporting server - if I jump to another of
our web servers, the prefix isn't applied.
I am running RS 2000 SP2 on Windows 2000 Advanced Server SP4. Also, the
URLRoot element in RSReportServer.config is set to
"http://reportingserver.domain.com/ReportServer" (DNS name of the server as
opposed to NetBIOS name). Is there a way to prevent this prefix from being
applied?
Thanks,
Sean CarpenterHello Sean,
How about use the full server url in the "Jump to URL" ?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||I am using the full URL in the Jump to URL expression. For example, a Jump
to URL of:
http://reportingserver.domain.com/ReportServer/?/ReportDirectory/AnotherReport&rs:Command=Render&rs:format=HTML4.0&rc:Parameters=False&rc:ToolBar=True&Year=2006&Month=12&rc:LinkTarget=_main
Gets changed to:
http://reportingserver.domain.com/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2freportingserver.domain.com%2fReportServer%3f%2fReportDirectory%2fAnotherReport%26rs%3aCommand%3dRender%26rs%3aformat%3dHTML4.0%26rc%3aParameters%3dFalse%26rc%3aToolBar%3dTrue%26Year%3d2006%26Month%3d12%26rc%3aLinkTarget%3d_main%26rc%253aReplacementRoot%3dhttp%253a%252f%252freportingserver.domain.com%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d
It looks like the problem only occurs when the destination URL has the same
machine name as the URLRoot element of the RSReportServer.config file. Is
there any way to prevent this from happening?
Sean Carpenter
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:xNZMu4uMHHA.4020@.TK2MSFTNGHUB02.phx.gbl...
> Hello Sean,
> How about use the full server url in the "Jump to URL" ?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Do the following. I think not only does it get around your problem but it
allows you to not hard code any server names:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
This does csv in ascii format but you can change how you want.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sean Carpenter" <stcarpenter2005@.community.nospam> wrote in message
news:%23qoKwwzMHHA.1252@.TK2MSFTNGP02.phx.gbl...
>I am using the full URL in the Jump to URL expression. For example, a Jump
>to URL of:
> http://reportingserver.domain.com/ReportServer/?/ReportDirectory/AnotherReport&rs:Command=Render&rs:format=HTML4.0&rc:Parameters=False&rc:ToolBar=True&Year=2006&Month=12&rc:LinkTarget=_main
> Gets changed to:
> http://reportingserver.domain.com/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2freportingserver.domain.com%2fReportServer%3f%2fReportDirectory%2fAnotherReport%26rs%3aCommand%3dRender%26rs%3aformat%3dHTML4.0%26rc%3aParameters%3dFalse%26rc%3aToolBar%3dTrue%26Year%3d2006%26Month%3d12%26rc%3aLinkTarget%3d_main%26rc%253aReplacementRoot%3dhttp%253a%252f%252freportingserver.domain.com%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d
> It looks like the problem only occurs when the destination URL has the
> same machine name as the URLRoot element of the RSReportServer.config
> file. Is there any way to prevent this from happening?
> Sean Carpenter
>
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
> news:xNZMu4uMHHA.4020@.TK2MSFTNGHUB02.phx.gbl...
>> Hello Sean,
>> How about use the full server url in the "Jump to URL" ?
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>> Note: The MSDN Managed Newsgroup support offering is for non-urgent
>> issues
>> where an initial response from the community or a Microsoft Support
>> Engineer within 1 business day is acceptable. Please note that each
>> follow
>> up response may take approximately 2 business days as the support
>> professional working with you may need further investigation to reach the
>> most efficient resolution. The offering is not appropriate for situations
>> that require urgent, real-time or phone-based interactions or complex
>> project analysis and dump analysis issues. Issues of this nature are best
>> handled working with a dedicated Microsoft Support Engineer by contacting
>> Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>> ==================================================>> (This posting is provided "AS IS", with no warranties, and confers no
>> rights.)
>|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Jump to report

I have a reporting contain link to report (Jump to report)

I would like to jump to report locate in other folder in the folder tree.

now I'm getting error in the link that the report down't exist in the folder.

what is the option to jump to report in other folders

Thanks

YOu have to use the URL jump to, building the path the report you want to display.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

The problem is that we are using the ReportViewer control.

So we need to open a new windows in winform ReportViewer control

|||

The problem is that we are using the ReportViewer control.

So we need to open a new windows in winform ReportViewer control

|||

You have to handle the drillthrough event in your code - then you have full control over what should happen. Please take a look at the "Drillthrough Report" sample on www.gotreportviewer.com.

-- Robert

|||

I'm using RDL and not RDLC.

I check it but didn't understand how to create this.

can you help me ?

Jump To Relative URL

We have a series of relative URLs in a Crystal Report Specification that we
are converting to Reporting Services. In Crystal, the relative address to
the PDF is merely the filename.pdf. In Reporting Services, this mangles the
URL when rendered to an Acrobat File causing it to reference the Report
Server. Can a relative URL be Jumped to? If so, how?Kevin,
I'v used a period at the beginning of the file path to reference the
relative path of the document (.pdf) when using the "jump to report" feature
of textbox properties. For example, my relative path is "/report
specs/report 1" (i have a folder that holds the specs in .pdf format out of
view of the client). I put a period at the beginning of that string in
studio and when published, it references the .pdf perfectly in reporting
services. Hope this helps.
"Kevin" wrote:
> We have a series of relative URLs in a Crystal Report Specification that we
> are converting to Reporting Services. In Crystal, the relative address to
> the PDF is merely the filename.pdf. In Reporting Services, this mangles the
> URL when rendered to an Acrobat File causing it to reference the Report
> Server. Can a relative URL be Jumped to? If so, how?

Juggling Parameters

I am reporting off a star-schema data warehouse. I have three datasets that I
use to populate parameters, and one master dataset that uses the values from
all three to populate the report. The way I have set up the master dataset
is:
SELECT *
FROM t_policy_info
WHERE month_key = @.month_key AND
paper_desc = @.paper_desc AND
unit_desc = @.unit_desc
Matching on non-key values is very time-consuming. For the @.paper_desc and
@.unit_desc datasets, I'm only pulling back the descriptions so that they
appear in the dropdowns at the top of the report.
How should I configure the datasets so that the master query matches
WHERE month_key = @.month_key AND
paper_key= @.paper_key AND
unit_key = @.unit_key ?
Should the paper and unit datasets also contain the key fields so that they
can be matched in the master dataset? How do I prevent the user from being
prompted for the keys (which they shouldn't)?
This is really a performance issue, and while I could make it work with
straight SQL, I'm not sure how to implement it with Reporting Services.
Thanks,
MikeHave you looked at the parametere Label Field/ Value Field inputs , one of
them is what is displayed to the user and other is what is passed to the
query.?
When you create your query for the main dataset along with the month also
pass the paper_key and unit_key parameters, as input by the user.
HTH
"Bassist695" <Bassist695@.discussions.microsoft.com> wrote in message
news:8549E9F8-0F83-40A6-9737-864C4C302045@.microsoft.com...
>I am reporting off a star-schema data warehouse. I have three datasets that
>I
> use to populate parameters, and one master dataset that uses the values
> from
> all three to populate the report. The way I have set up the master dataset
> is:
> SELECT *
> FROM t_policy_info
> WHERE month_key = @.month_key AND
> paper_desc = @.paper_desc AND
> unit_desc = @.unit_desc
> Matching on non-key values is very time-consuming. For the @.paper_desc and
> @.unit_desc datasets, I'm only pulling back the descriptions so that they
> appear in the dropdowns at the top of the report.
> How should I configure the datasets so that the master query matches
> WHERE month_key = @.month_key AND
> paper_key= @.paper_key AND
> unit_key = @.unit_key ?
> Should the paper and unit datasets also contain the key fields so that
> they
> can be matched in the master dataset? How do I prevent the user from being
> prompted for the keys (which they shouldn't)?
> This is really a performance issue, and while I could make it work with
> straight SQL, I'm not sure how to implement it with Reporting Services.
> Thanks,
> Mike

JSP + Reporting 2005

Hi,
whats the best way to implement a Java Servelet/JSP to use reporting
services 2005?
I dont want to use the anonymous access,
is there a way to do this?a kind of proxy like this...
http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html
but with RS 2005
greetings
MauroMauro,
Check out this lab: Implementing SQL Server Reporting Services with a Java
EE Application-Building a Reporting Services Solution Virtual Lab
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032315323&EventCategory=3&culture=en-US&CountryCode=US
Reeves
"Mauro SB." wrote:
> Hi,
> whats the best way to implement a Java Servelet/JSP to use reporting
> services 2005?
> I dont want to use the anonymous access,
> is there a way to do this?a kind of proxy like this...
> http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html
> but with RS 2005
> greetings
> Mauro
>
>|||tnks veeeery much!
gretings
Mauro
"Reeves Smith" <ReevesSmith@.discussions.microsoft.com> escribió en el
mensaje news:E7113029-9686-474C-BF7E-8F37A01D4ABE@.microsoft.com...
> Mauro,
> Check out this lab: Implementing SQL Server Reporting Services with a Java
> EE Application-Building a Reporting Services Solution Virtual Lab
> http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032315323&EventCategory=3&culture=en-US&CountryCode=US
> Reeves
> "Mauro SB." wrote:
>> Hi,
>> whats the best way to implement a Java Servelet/JSP to use reporting
>> services 2005?
>> I dont want to use the anonymous access,
>> is there a way to do this?a kind of proxy like this...
>> http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html
>> but with RS 2005
>> greetings
>> Mauro
>>

Joining two reporting services datasets

Hi All,
It is possibile to create a dataset that is a join of two other datasets
(the two datasets are of diverse origin: the first is OLAP the second is
relational)?
Example:
I have dataset 1 and 2 I want to create the third that is a join of the 1
and the 2.
Can anyone help me?
Thank you.if it's just a SQL command you could create a 3rd dataset?
"gdaquila" wrote:
> Hi All,
> It is possibile to create a dataset that is a join of two other datasets
> (the two datasets are of diverse origin: the first is OLAP the second is
> relational)?
> Example:
> I have dataset 1 and 2 I want to create the third that is a join of the 1
> and the 2.
> Can anyone help me?
> Thank you.
>
>|||You can not do this within RS. You either need to have a stored procedure
doing this (can use linked databases) or you need to use subreports.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gdaquila" <gdaquila@.nospam.it> wrote in message
news:2vhku5F2lqt1fU1@.uni-berlin.de...
> Hi All,
> It is possibile to create a dataset that is a join of two other datasets
> (the two datasets are of diverse origin: the first is OLAP the second is
> relational)?
> Example:
> I have dataset 1 and 2 I want to create the third that is a join of the 1
> and the 2.
> Can anyone help me?
> Thank you.
>|||Hi,
Ok,
I will try with a linked server.
You think that I can follow the sample published by microsoft at
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
In this samples I have one regarding the use of linked server.
The last my question is: in this approach, the multidimensional data must be
retrieved via SQL Query not via MDX query it is correct?
Thank you!
G
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ha scritto nel messaggio
news:eiHEqHDyEHA.3976@.TK2MSFTNGP09.phx.gbl...
> You can not do this within RS. You either need to have a stored procedure
> doing this (can use linked databases) or you need to use subreports.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "gdaquila" <gdaquila@.nospam.it> wrote in message
> news:2vhku5F2lqt1fU1@.uni-berlin.de...
>> Hi All,
>> It is possibile to create a dataset that is a join of two other datasets
>> (the two datasets are of diverse origin: the first is OLAP the second is
>> relational)?
>> Example:
>> I have dataset 1 and 2 I want to create the third that is a join of the 1
>> and the 2.
>> Can anyone help me?
>> Thank you.
>>
>|||Sorry, I don't have any experience with MDX queries.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gdaquila" <gdaquila@.nospam.it> wrote in message
news:2vjgbgF2lorcjU1@.uni-berlin.de...
> Hi,
> Ok,
> I will try with a linked server.
> You think that I can follow the sample published by microsoft at
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
> In this samples I have one regarding the use of linked server.
> The last my question is: in this approach, the multidimensional data must
be
> retrieved via SQL Query not via MDX query it is correct?
> Thank you!
> G
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ha scritto nel messaggio
> news:eiHEqHDyEHA.3976@.TK2MSFTNGP09.phx.gbl...
> > You can not do this within RS. You either need to have a stored
procedure
> > doing this (can use linked databases) or you need to use subreports.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "gdaquila" <gdaquila@.nospam.it> wrote in message
> > news:2vhku5F2lqt1fU1@.uni-berlin.de...
> >> Hi All,
> >> It is possibile to create a dataset that is a join of two other
datasets
> >> (the two datasets are of diverse origin: the first is OLAP the second
is
> >> relational)?
> >> Example:
> >> I have dataset 1 and 2 I want to create the third that is a join of the
1
> >> and the 2.
> >> Can anyone help me?
> >> Thank you.
> >>
> >>
> >
> >
>

Joining Two Datasets in Reporting Services.

I am using SQL Reporting Services 2000.

Is there some way I can connect two datasets? Main issue is that I have to connect two tables from different databases and then display them in a report. Since these tables reside in different databases therefore I have one dataset for each table. While displaying the report I need to join both these datasets and display a report with data from both the tables.

Use linked server concept to join two databases.

Joining two DataSets

How do you join two datasets in reporting services... one from sql and another from oracle?

Thanks

Currently, datasets cannot be joined on the report. Some options you can explore:

1. Join the datasets at the database level by using the SQL Server linked servers feature.

2. Use a subreport for one of the datasets which can be synchronized with the master with parameters.

3. Use a SQL Server 2005 CLR stored procedure to fetch and join the ADO.NET datasets.

4. Write a custom data extension. This is the most intensive option which I will suggest as a last resort.

|||

Also, read about using the SSIS engine to create your combined dataset.

SSIS has easy and very powerful Transform options which may present you with a better option than writing the code yourself.

Have a look at the article here:

http://blogs.msdn.com/bimusings/archive/2006/07/19/using-a-parameterized-ssis-package-as-a-data-source-for-sql-reporting-services.aspx

Thank you,

LH

Joining Tables Across Multiple Datasets

I am trying to join two tables from two different datasets in SQL
Server 2005 Reporting Services. How would one go about doing this?
Since there are technically two spots to have SQL queries (one for
each dataset), how does one go about doing SQL? Is joining across
multiple datasets even possible? If so, are there clever workarounds?You cannot join datasets in RS. You either need to do this in a stored
procedure OR you should think about subreports. Usually what you need to do
can be accomplished with subreports. For a 1:1 or 1:M relationship
subreports will work for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<rdracer58@.gmail.com> wrote in message
news:1183746250.948449.38960@.o61g2000hsh.googlegroups.com...
>I am trying to join two tables from two different datasets in SQL
> Server 2005 Reporting Services. How would one go about doing this?
> Since there are technically two spots to have SQL queries (one for
> each dataset), how does one go about doing SQL? Is joining across
> multiple datasets even possible? If so, are there clever workarounds?
>sql

Join tables from different Db's

Hi,
I want to use a table from one db and do an inner join on a table which is
present in the other Db. Is it possible to do this in reporting Services? And
if yes, then how?
Thanks
--
pmuddoes a query like this doesn't works?:
select * from tableA inner join DatabaseB.dbo.TableB on ....
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:CE7B6ED2-9668-4B3D-BB9A-A40D3C422C57@.microsoft.com...
> Hi,
> I want to use a table from one db and do an inner join on a table which is
> present in the other Db. Is it possible to do this in reporting Services?
> And
> if yes, then how?
> Thanks
> --
> pmud

Join query not working

howz yew all
Iam in a middle of a project and iam stuck at reporting ill cut the
details it is so that i have three tables one is
"tbl_Transactions" (containing columns "Transaction_DetailID,
Transaction_Amount, Transaction_Type, Account_ID, Transaction_ID")
Transaction_Type contains CR for credit and DR for debit.
and other is
"tbl_TransactionDetails" (containing columns "Transaction_ID,
Transaction_Date")
and the third table is
"tbl_Account" (containing columns "Account_ID, Account_DateOfCreation,
Account_ParentID, Account_Name, Account_Description)
Now what iam not been able to do is that
i want to select Transaction_ID, Transaction_Date, Account_Name(for
Transaction_Type debit), Account_Name(for Transaction_Type Credit),
one debit and multiple credit entries and vice versa, iam trying to
join all tables but i dont know how to work :s can sum 1 plz help me
thnx in advance
take care
bye
Hi
> i want to select Transaction_ID, Transaction_Date, Account_Name(for
> Transaction_Type debit), Account_Name(for Transaction_Type Credit),
> one debit and multiple credit entries and vice versa, iam trying to
> join all tables but i dont know how to work :s can sum 1 plz help me
>
select * from tbl_Transactions t join tbl_TransactionDetails td on
t.Transaction_ID=td.Transaction_ID join tbl_Account ta
on ta.Account_ID=t.Account_ID
<umairsyed19@.gmail.com> wrote in message
news:c28a6557-2dfc-4efb-ad9f-c46aea287c12@.v3g2000hsc.googlegroups.com...
> howz yew all
> Iam in a middle of a project and iam stuck at reporting ill cut the
> details it is so that i have three tables one is
> "tbl_Transactions" (containing columns "Transaction_DetailID,
> Transaction_Amount, Transaction_Type, Account_ID, Transaction_ID")
> Transaction_Type contains CR for credit and DR for debit.
> and other is
> "tbl_TransactionDetails" (containing columns "Transaction_ID,
> Transaction_Date")
> and the third table is
> "tbl_Account" (containing columns "Account_ID, Account_DateOfCreation,
> Account_ParentID, Account_Name, Account_Description)
> Now what iam not been able to do is that
> i want to select Transaction_ID, Transaction_Date, Account_Name(for
> Transaction_Type debit), Account_Name(for Transaction_Type Credit),
> one debit and multiple credit entries and vice versa, iam trying to
> join all tables but i dont know how to work :s can sum 1 plz help me
> thnx in advance
> take care
> bye

Join query not working

howz yew all
Iam in a middle of a project and iam stuck at reporting ill cut the
details it is so that i have three tables one is
"tbl_Transactions" (containing columns "Transaction_DetailID,
Transaction_Amount, Transaction_Type, Account_ID, Transaction_ID")
Transaction_Type contains CR for credit and DR for debit.
and other is
"tbl_TransactionDetails" (containing columns "Transaction_ID,
Transaction_Date")
and the third table is
"tbl_Account" (containing columns "Account_ID, Account_DateOfCreation,
Account_ParentID, Account_Name, Account_Description)
Now what iam not been able to do is that
i want to select Transaction_ID, Transaction_Date, Account_Name(for
Transaction_Type debit), Account_Name(for Transaction_Type Credit),
one debit and multiple credit entries and vice versa, iam trying to
join all tables but i dont know how to work :s can sum 1 plz help me
thnx in advance
take care
byeHi
> i want to select Transaction_ID, Transaction_Date, Account_Name(for
> Transaction_Type debit), Account_Name(for Transaction_Type Credit),
> one debit and multiple credit entries and vice versa, iam trying to
> join all tables but i dont know how to work :s can sum 1 plz help me
>
select * from tbl_Transactions t join tbl_TransactionDetails td on
t.Transaction_ID=td.Transaction_ID join tbl_Account ta
on ta.Account_ID=t.Account_ID
<umairsyed19@.gmail.com> wrote in message
news:c28a6557-2dfc-4efb-ad9f-c46aea287c12@.v3g2000hsc.googlegroups.com...
> howz yew all
> Iam in a middle of a project and iam stuck at reporting ill cut the
> details it is so that i have three tables one is
> "tbl_Transactions" (containing columns "Transaction_DetailID,
> Transaction_Amount, Transaction_Type, Account_ID, Transaction_ID")
> Transaction_Type contains CR for credit and DR for debit.
> and other is
> "tbl_TransactionDetails" (containing columns "Transaction_ID,
> Transaction_Date")
> and the third table is
> "tbl_Account" (containing columns "Account_ID, Account_DateOfCreation,
> Account_ParentID, Account_Name, Account_Description)
> Now what iam not been able to do is that
> i want to select Transaction_ID, Transaction_Date, Account_Name(for
> Transaction_Type debit), Account_Name(for Transaction_Type Credit),
> one debit and multiple credit entries and vice versa, iam trying to
> join all tables but i dont know how to work :s can sum 1 plz help me
> thnx in advance
> take care
> bye