Link with parameters

Hi,
is it possible to start a Report via Link (from Desktop) with start
parameter like an
ASP-Script
For example:
...report.rdl?Year=2007&Month=6...
Thank you
HansThat's what URL access in RS is for.
Amarnath
"Hans" wrote:
> Hi,
> is it possible to start a Report via Link (from Desktop) with start
> parameter like an
> ASP-Script
> For example:
>
> ...report.rdl?Year=2007&Month=6...
>
> Thank you
> Hans
>|||That what I mean ist to start the report from Desktop inclusive
parameters.
Hans|||ok,
so this is a sample you can use to see how it works if you have implemented
the samples and hosted the reports on localserver. copy this url from
desktop.. also you can write asp.net to mask this url and give just a
hyperlink from the page.. see the parameters also passed.
http://server/reportserver?/Sales/Northwest/Employee Sales
Report&rs:Command=Render&EmployeeID=1234
Amarnath
"Hans" wrote:
> That what I mean ist to start the report from Desktop inclusive
> parameters.
> Hans
>|||I tried this, but it doesn=B4t work. The report opens, but there=B4s not
selected parameter value.
Thanks,
Hans|||Hans,
Have you pasted my sample link as a whole URL because it is wraped in the
post.
Incase you have done this pl ignore, you said there is no parameter value,
so I thought you have not pasted the whole URL.
Amarnath, MCTS
"Hans" wrote:
> I tried this, but it doesn´t work. The report opens, but there´s not
> selected parameter value.
>
> Thanks,
> Hans
>

Link two dataSet in the same report

Hi !
I use ms sql server 2005, and I have a problem
I have a dataBase where I have a lot of data, I have a webServices which calculate indicator for a time period and an id indicator. The time period must be specific and choose by the user, so I can't dto automatically by integrating the data from my webService in a dataBase (with IntegrationServices).
So I create a report with 2 dataset, one which recover the indicator value for each equipment (the webService send a list of {<idEquipment> and <value>}) , and I want to link the idEquipment with the IdEquipement in my dataBase, it would allow me to know other informations about the equipment :
equipement ID | Indicator value (from webServices) | equipment name | eq number | cumul of event duration for this eq....
All in the same grid...
Does it possible ?
If it is possible with the report designer, does it possible with report builder, as report builder need a model, how can i do to make a model from 2 dataSource...
thank you for your answer...

You may want to explore using SSIS as a data source or a custom object, or connect to the web service from SQL Server passing the parameters to it.

I was once able to use hash tables in custom code to store the data, with hidden fields for setting the values, but I'm not sure if that is feasable anymore as I could not replicate it.

cheers,

Andrew

|||Hi Andrew, and thank you for your answer.
As i explain, it is not possible to us to integrate our data with SSIS because our webService need parameter define by user, if we pass our own parameter, there will have too much data and user cannot change them after.
So I need to call my web Service methode in my report, because it is at this moment that the user can and have to choose his param. So I have already doing a dataSet which recover the data from the web Service.
Now I need to know if it possible to do like a 'inner join' between two dataSet (one from my web Service, and the other from my olap cube) ?
I already use BIRT (Java) and it is possible to do it, but I didn't see this 'option' in Reporting Services. Maybe there is an easy way or another way to do that... I hope so.

Thank you to read...
|||

Hi Alineo,

It's not possible to join two different datasets inside the report itself.

Hope you can find alternate means. You should be able to pass parameters to a web service by using SSIS or SQL Server.

cheers,

Andrew

|||excuse me, but I don't understand how, to do.
I need just this information when the user run the report... so it isn't possible to use integrating services, because (it is what I understand) the integration will generate automatically and before... So the user cannot give it param to it, just the developper can do it, and as I told you, the developper cannot do all the possibility in parameter.
The parameter in a time period (from ... to ...) so ....
Ok so it is not possible !!
thank you for your answer....
|||

Here's how to use a parameter from SSIS if you want to go down this road.

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

Integration services runs when the report runs.

cheers,

Andrew

link to picture

Hello,
I have to add a picture to a report. The picture changes sometimes and for that I want to make something like a link or replace the picture is this possible?
Regards
HansjrgYes, if you're using Crystal XI
Look up images, dynamic in the help.

Otherwise I think the picture needs to be in the database.|||Thank you for your help. I use Crystal Reports 10 :-((

Regards
Hansjrgsql

Link to Bring up email

I have a column on a report listing a contact. I want to click on the
contact and bring up my email program. I entered ="mailto:" & email variable
in the Jump to URL field. I get an error Invalid URI: the hostname could not
be parsed. Although it does work if I hard code the address like
=mailto:me@.microsoft.com
Thank you for any help.i tried to repro it..but couldnt replicate it.
i created a parameter as email id..it works fine.
can u specify the repro steps?
"SSVette@.Hotmail.com" <ssvette@.hotmail.com> wrote in message
news:e8qOXtFnEHA.2680@.TK2MSFTNGP15.phx.gbl...
>I have a column on a report listing a contact. I want to click on the
> contact and bring up my email program. I entered ="mailto:" & email
> variable
> in the Jump to URL field. I get an error Invalid URI: the hostname could
> not
> be parsed. Although it does work if I hard code the address like
> =mailto:me@.microsoft.com
> Thank you for any help.
>|||I have a data set that returns a contact name (contactname) and the contact
email address (email). The report displays the contact name and the
navigation is assigned a Jump to URL field as
="mailto:" & email
I get the message Invalid URI: the hostname could not be parsed.
If I assign the Jump to URL Field with a hardcoded email address it works
fine
=mailto:me@.microsoft.com
thank you
"avnrao" <avn@.newsgroups.com> wrote in message
news:%23jNzEAInEHA.3908@.TK2MSFTNGP09.phx.gbl...
> i tried to repro it..but couldnt replicate it.
> i created a parameter as email id..it works fine.
> can u specify the repro steps?
> "SSVette@.Hotmail.com" <ssvette@.hotmail.com> wrote in message
> news:e8qOXtFnEHA.2680@.TK2MSFTNGP15.phx.gbl...
> >I have a column on a report listing a contact. I want to click on the
> > contact and bring up my email program. I entered ="mailto:" & email
> > variable
> > in the Jump to URL field. I get an error Invalid URI: the hostname could
> > not
> > be parsed. Although it does work if I hard code the address like
> > =mailto:me@.microsoft.com
> >
> > Thank you for any help.
> >
> >
>sql

Link to another report on point labels in Pie Chart

Hello. I am new to SQL Server Reporting Services. The short explanation of what I want to do: In a pie chart, I have turned on point labels. I want each of the point labels to be a link. When you click on the link, you are taken to another report (in table format) that is more information about the data in that wedge of the pie.
If that is unclear, maybe it will help if I explain what I'm trying to do. The pie chart is a chart showing the status of developer issues in an issue tracking database. (Open, In-Progress, Awaiting Verification, Closed, Rejected, etc.) Each wedge of the pie has a point label that shows the number of issues that fall into the category (8 issues opened, 12 issues IP, etc.) When I click on the label that shows the number, I want to be taken to a table that shows what the issues in that category are.
Is this possible with SQL Server Reporting Services? Thanks in advance.Yes. Check out Chart Properties Dialog -> Values -> Edit -> Edit Chart Value
dialog box -> Action tab. You can choose Jump To Report option here and
specify the target report. You can also pass parameters to the target report
from this location.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Justin30519" <Justin30519@.discussions.microsoft.com> wrote in message
news:BC5B49B6-2B72-4D9C-A4B0-0CA3356E8114@.microsoft.com...
> Hello. I am new to SQL Server Reporting Services. The short explanation of
what I want to do: In a pie chart, I have turned on point labels. I want
each of the point labels to be a link. When you click on the link, you are
taken to another report (in table format) that is more information about the
data in that wedge of the pie.
> If that is unclear, maybe it will help if I explain what I'm trying to do.
The pie chart is a chart showing the status of developer issues in an issue
tracking database. (Open, In-Progress, Awaiting Verification, Closed,
Rejected, etc.) Each wedge of the pie has a point label that shows the
number of issues that fall into the category (8 issues opened, 12 issues IP,
etc.) When I click on the label that shows the number, I want to be taken to
a table that shows what the issues in that category are.
> Is this possible with SQL Server Reporting Services? Thanks in advance.|||Thank you very much for your reply. It was very helpful. My report works now.
Justin

Link to a report with parameters

I need to create a report with some parameters for filtering data.
This report must be called by URL link on an Html page.
This link must contains the values of these parameters; I don' want
specify the values when I see the report by clicking on View report button.
Is it possible? How?
What is the format of link for passing parameters to filter data?
Many thanks1. Try leaving the parameter Prompt blank... This should prevent the
parameter from displaying, (but you must provide a default value...)
2. Search for URL Access in Books on line and you will get an entire list
of all of the things you can do via URL in reporting services.
Hope this helps..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Pasquale" wrote:
> I need to create a report with some parameters for filtering data.
> This report must be called by URL link on an Html page.
> This link must contains the values of these parameters; I don' want
> specify the values when I see the report by clicking on View report button.
> Is it possible? How?
> What is the format of link for passing parameters to filter data?
> Many thanks|||I tried passing parameters in URL address successfully,
but I see some parameters that the user hasn't change!
Moreover, if I change the parameter property "User request"
by setting to false value, the call of report dumps!
The issue is partially solved! I need to pass a parameter by Url
and these parameters cannot change by a user.
Can I solve this problem URGENTLY?
Many thanks
"Wayne Snyder" wrote:
> 1. Try leaving the parameter Prompt blank... This should prevent the
> parameter from displaying, (but you must provide a default value...)
> 2. Search for URL Access in Books on line and you will get an entire list
> of all of the things you can do via URL in reporting services.
> Hope this helps..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Pasquale" wrote:
> > I need to create a report with some parameters for filtering data.
> > This report must be called by URL link on an Html page.
> > This link must contains the values of these parameters; I don' want
> > specify the values when I see the report by clicking on View report button.
> > Is it possible? How?
> > What is the format of link for passing parameters to filter data?
> >
> > Many thanks|||Read the rest of Wayne's post. He is telling you how to hide a parameter so
the user doesn't see it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>I tried passing parameters in URL address successfully,
> but I see some parameters that the user hasn't change!
> Moreover, if I change the parameter property "User request"
> by setting to false value, the call of report dumps!
> The issue is partially solved! I need to pass a parameter by Url
> and these parameters cannot change by a user.
> Can I solve this problem URGENTLY?
> Many thanks
>
> "Wayne Snyder" wrote:
>> 1. Try leaving the parameter Prompt blank... This should prevent the
>> parameter from displaying, (but you must provide a default value...)
>> 2. Search for URL Access in Books on line and you will get an entire
>> list
>> of all of the things you can do via URL in reporting services.
>> Hope this helps..
>> --
>> Wayne Snyder MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> I support the Professional Association for SQL Server ( PASS) and it''s
>> community of SQL Professionals.
>>
>> "Pasquale" wrote:
>> > I need to create a report with some parameters for filtering data.
>> > This report must be called by URL link on an Html page.
>> > This link must contains the values of these parameters; I don' want
>> > specify the values when I see the report by clicking on View report
>> > button.
>> > Is it possible? How?
>> > What is the format of link for passing parameters to filter data?
>> >
>> > Many thanks|||I have executed several tries modifying the parameter settings.
I have followed your suggests, but the solution isn't complete:
or I see the parameter or I cannot modify the parameter
that I pass via URL (an error occurs!!!)!
Many thanks
"Bruce L-C [MVP]" wrote:
> Read the rest of Wayne's post. He is telling you how to hide a parameter so
> the user doesn't see it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >I tried passing parameters in URL address successfully,
> > but I see some parameters that the user hasn't change!
> > Moreover, if I change the parameter property "User request"
> > by setting to false value, the call of report dumps!
> >
> > The issue is partially solved! I need to pass a parameter by Url
> > and these parameters cannot change by a user.
> >
> > Can I solve this problem URGENTLY?
> >
> > Many thanks
> >
> >
> > "Wayne Snyder" wrote:
> >
> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> parameter from displaying, (but you must provide a default value...)
> >>
> >> 2. Search for URL Access in Books on line and you will get an entire
> >> list
> >> of all of the things you can do via URL in reporting services.
> >>
> >> Hope this helps..
> >> --
> >> Wayne Snyder MCDBA, SQL Server MVP
> >> Mariner, Charlotte, NC
> >>
> >> I support the Professional Association for SQL Server ( PASS) and it''s
> >> community of SQL Professionals.
> >>
> >>
> >> "Pasquale" wrote:
> >>
> >> > I need to create a report with some parameters for filtering data.
> >> > This report must be called by URL link on an Html page.
> >> > This link must contains the values of these parameters; I don' want
> >> > specify the values when I see the report by clicking on View report
> >> > button.
> >> > Is it possible? How?
> >> > What is the format of link for passing parameters to filter data?
> >> >
> >> > Many thanks
>
>|||Two different things. First is getting the parameters to work. Then making
them hidden. Do you have them working properly so you know your URL is
correct. Be sure that your parameter is with the correct case since RS is
case sensitive with parameters. Once you know your URL is correct because
your report works properly then you can deal with hidding the parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>I have executed several tries modifying the parameter settings.
> I have followed your suggests, but the solution isn't complete:
> or I see the parameter or I cannot modify the parameter
> that I pass via URL (an error occurs!!!)!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Read the rest of Wayne's post. He is telling you how to hide a parameter
>> so
>> the user doesn't see it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >I tried passing parameters in URL address successfully,
>> > but I see some parameters that the user hasn't change!
>> > Moreover, if I change the parameter property "User request"
>> > by setting to false value, the call of report dumps!
>> >
>> > The issue is partially solved! I need to pass a parameter by Url
>> > and these parameters cannot change by a user.
>> >
>> > Can I solve this problem URGENTLY?
>> >
>> > Many thanks
>> >
>> >
>> > "Wayne Snyder" wrote:
>> >
>> >> 1. Try leaving the parameter Prompt blank... This should prevent the
>> >> parameter from displaying, (but you must provide a default value...)
>> >>
>> >> 2. Search for URL Access in Books on line and you will get an entire
>> >> list
>> >> of all of the things you can do via URL in reporting services.
>> >>
>> >> Hope this helps..
>> >> --
>> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> Mariner, Charlotte, NC
>> >>
>> >> I support the Professional Association for SQL Server ( PASS) and
>> >> it''s
>> >> community of SQL Professionals.
>> >>
>> >>
>> >> "Pasquale" wrote:
>> >>
>> >> > I need to create a report with some parameters for filtering data.
>> >> > This report must be called by URL link on an Html page.
>> >> > This link must contains the values of these parameters; I don' want
>> >> > specify the values when I see the report by clicking on View report
>> >> > button.
>> >> > Is it possible? How?
>> >> > What is the format of link for passing parameters to filter data?
>> >> >
>> >> > Many thanks
>>|||My issue has two aspects:
1. passing a parameter via URL to call my report filtering data by the
parameter;
2. hide or protect parameter inside report manager to avoid any user's
changes.
The first step is solved. The report is called correctly and I see the
correct value
of parameter (the same written in the URL). I have written correctly the
name of parameter.
Now, when I set user request for the parameter, inside report manager, to
false
in order to hide the parameter, this message error occurs:
"sReadOnlyReportParameter" and I cannot the value of parameter by the value
in the URL.
This strange behaviour represents a limit of RS!
Moreover, I have specified a default value of parameter with a particular
value.
Now, is it really possible to solve completely this issue?
Do I have a particular SP (SP1, SP2, ...)?
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||I have controlled all settings of the report; then I try to set to blank
the user request string inside report manager (maintaning a default
value for the parameter): so, I can modify the parameter by passing it
via URL and simultaneously hide it in order to avoid any user's changes.
Finally, the issue is solved!!!
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||Making parameters hidden is much more straight forward in RS 2005. I don't
hide parameters so I have not had that issue.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:8DE20C29-CBB1-4020-93BD-6D8C71361AD2@.microsoft.com...
>I have controlled all settings of the report; then I try to set to blank
> the user request string inside report manager (maintaning a default
> value for the parameter): so, I can modify the parameter by passing it
> via URL and simultaneously hide it in order to avoid any user's changes.
> Finally, the issue is solved!!!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Two different things. First is getting the parameters to work. Then
>> making
>> them hidden. Do you have them working properly so you know your URL is
>> correct. Be sure that your parameter is with the correct case since RS is
>> case sensitive with parameters. Once you know your URL is correct because
>> your report works properly then you can deal with hidding the parameters.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>> >I have executed several tries modifying the parameter settings.
>> > I have followed your suggests, but the solution isn't complete:
>> > or I see the parameter or I cannot modify the parameter
>> > that I pass via URL (an error occurs!!!)!
>> >
>> > Many thanks
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Read the rest of Wayne's post. He is telling you how to hide a
>> >> parameter
>> >> so
>> >> the user doesn't see it.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >> >I tried passing parameters in URL address successfully,
>> >> > but I see some parameters that the user hasn't change!
>> >> > Moreover, if I change the parameter property "User request"
>> >> > by setting to false value, the call of report dumps!
>> >> >
>> >> > The issue is partially solved! I need to pass a parameter by Url
>> >> > and these parameters cannot change by a user.
>> >> >
>> >> > Can I solve this problem URGENTLY?
>> >> >
>> >> > Many thanks
>> >> >
>> >> >
>> >> > "Wayne Snyder" wrote:
>> >> >
>> >> >> 1. Try leaving the parameter Prompt blank... This should prevent
>> >> >> the
>> >> >> parameter from displaying, (but you must provide a default
>> >> >> value...)
>> >> >>
>> >> >> 2. Search for URL Access in Books on line and you will get an
>> >> >> entire
>> >> >> list
>> >> >> of all of the things you can do via URL in reporting services.
>> >> >>
>> >> >> Hope this helps..
>> >> >> --
>> >> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> >> Mariner, Charlotte, NC
>> >> >>
>> >> >> I support the Professional Association for SQL Server ( PASS) and
>> >> >> it''s
>> >> >> community of SQL Professionals.
>> >> >>
>> >> >>
>> >> >> "Pasquale" wrote:
>> >> >>
>> >> >> > I need to create a report with some parameters for filtering
>> >> >> > data.
>> >> >> > This report must be called by URL link on an Html page.
>> >> >> > This link must contains the values of these parameters; I don'
>> >> >> > want
>> >> >> > specify the values when I see the report by clicking on View
>> >> >> > report
>> >> >> > button.
>> >> >> > Is it possible? How?
>> >> >> > What is the format of link for passing parameters to filter data?
>> >> >> >
>> >> >> > Many thanks
>> >>
>> >>
>> >>
>>sql

Link to a report directory

I know how to link to Reporting Services, and how to link to a specific
report; is there any way to link to a specific directory? I'd like to send
my CRM users to a specific directory for CRM reports.
When I try http://RSSRV/ReportServer, I get to the general Report Server
directory; however, when I try http://RSSRV/ReportServer/CRM%20Reports/, I
get an error.
Thanks in advance!Put a ? in there:
http://RSSRV/ReportServer?/CRM%20Reports/
The path is actually a parameter.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Paul McBride" <pmcbride@.comcast.net> wrote in message
news:O%23jNhoF3EHA.480@.TK2MSFTNGP10.phx.gbl...
>I know how to link to Reporting Services, and how to link to a specific
> report; is there any way to link to a specific directory? I'd like to send
> my CRM users to a specific directory for CRM reports.
> When I try http://RSSRV/ReportServer, I get to the general Report Server
> directory; however, when I try http://RSSRV/ReportServer/CRM%20Reports/, I
> get an error.
> Thanks in advance!
>

Link to a record in CRM from SSRS report

Hi All, I have develped a simple report in SSRS, I would like to link to the record in CRM from SSRS.

Example:

Report looks like

Id Name

-

001 ABS Co.

If I click on ABS Co. it should take me the record details of ABS Co. in CRM.

Please help

Hi,

you′ve to add the AccountId to your reportdataset. Using the field AccountId you can build up the following link for the action property (Jump to URL) of the field:

="http://CRMSERVER/sfa/accts/edit.aspx?id={" & Fields!AccountId.Value.ToString() & "}"

Best regards

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 Reports to System.Data.DataSets?

The mechanism to link a Crystal Report to data is by giving it a
System.Data.DataSet, I was wondering if this same option is possible in
Reporting Services.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!Today you have to create a data processing extension. In the future
(Widbey/Yukon) there will be a webform control and winform control that
would allow this. If you don't want to create a data processing extension
then the dataset needs to be generated from RS (either embed the SQL or call
a stored procedure). I suggest first looking at using RS without a data
processing extension and make sure you understand RS capabilities then if
you decide you have to do it with a data processing extension.
Remember, RS is a different architecture than Crystal so there will be
plenty of places where you need to approach things differently.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> The mechanism to link a Crystal Report to data is by giving it a
> System.Data.DataSet, I was wondering if this same option is possible in
> Reporting Services.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
>|||Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can be rendered from data tha only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||uhh... I meant:
Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can't be rendered from data that only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||Well, you can do it, it is just more complex, version 2 this will be much
simplier.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OPn72Nn0EHA.2192@.TK2MSFTNGP14.phx.gbl...
> uhh... I meant:
> Thank you. The point is that not allowing to generate the reports from a
> system.data.DataSet mean that reports can't be rendered from data that
only
> exists in memory and this is something that Crystal allows and that one of
> my customers supposedly needs.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing
extension
> > then the dataset needs to be generated from RS (either embed the SQL or
> call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then
if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible
in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > Medellín, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
>|||Hi
I am not sure that I fully understand your suggestions. I have an ASP.NET
application that uses a web form to update an XML dataset. I would like to be
able to produce a report from the dataset and ideally I would like to
serialize it and pass it as a data source to an RS web service but RS does
not seem to support this. I could serialise and persist to SQL Server as a
single ntext field that could then be queried to return a complete XML
document. Again RS does not seem to handle this. I do not wish to create a
full set of SQL Server tables to persist the dataset at the field level just
to produce the report (there are rather a lot of items).
You indicated that a "data processing extension" might help with this. Could
you possibly expand a little more or point me in the right direction?
Thanks
"Bruce L-C [MVP]" wrote:
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>
>|||I have had some further thoughts and I would be interested to know if the
following approach might work:
1. Create a web-service report that accepts a string parameter and uses a
stored procedure as a data source to which it passess the parameter.
2. Write the stored procedure to accept a parameter of type ntext which it
passes to sp_xml_preparedocument and then generates the required output using
OPENXML().
3. From the asp.net application, serialise the xml from the dataset as a
string and pass as a parameter to the web-service report.
Thanks
"njr" wrote:
> Hi
> I am not sure that I fully understand your suggestions. I have an ASP.NET
> application that uses a web form to update an XML dataset. I would like to be
> able to produce a report from the dataset and ideally I would like to
> serialize it and pass it as a data source to an RS web service but RS does
> not seem to support this. I could serialise and persist to SQL Server as a
> single ntext field that could then be queried to return a complete XML
> document. Again RS does not seem to handle this. I do not wish to create a
> full set of SQL Server tables to persist the dataset at the field level just
> to produce the report (there are rather a lot of items).
> You indicated that a "data processing extension" might help with this. Could
> you possibly expand a little more or point me in the right direction?
> Thanks
> "Bruce L-C [MVP]" wrote:
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing extension
> > then the dataset needs to be generated from RS (either embed the SQL or call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > Medellín, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
> >

Link Report Problems

I have established a set of base reports which are then linked to a variety of department specific folders. Moreover, many of the reports have the capability to "Drill Through". The problem occurs when clicking on a Drill Through field in one of the department specfic folder -- it directs the drill through to a report in the Base folder instead of the department specific folder. Pleaseeeeee help!The behavior you are seeing is the expected behavior for linked reports. Relative paths are resolved based on the location of the source report, and not the linked report.|||Hopefully in a future release there could be an option to select either base or linked folder(s).

Link Report Builder with Visual Studio C#

How call a method of Visual Studio after close Report Builder?

Then in this method I must obtain the path and the name of created report with Report Builder.

Thanks for help me.

This is not supported. Interesting idea, though.

Link Report

I have a report A under FolderA , I created a link report for reportA under Folder B.

I am trying to access the names of the reports under FolderB through ASP.Net web application.

But when I do this the link report name is not being displayed since it has the path \FolderA\ReportA.

But the report is visible in the report manager under folder B. Is there a work around to display the name of the link report.please let me know.

Thanks!!

SqlNew

The link report name "does" appear !! it was problem with refresh.

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?