Report not showing up in IE but works in VS.net

Hey guys,
Anyone know why my main report works but when i click on a link i've created
on the main report to link to another report, the other report doesn't show
up (IE just says 'done' and nothing is displayed)?
The reports link and load correctly when i'm using the preview tab within
VS.net though.
ACK!
Thanks guys,
AlI've run into this when my drillthrough (second) report takes
parameters based on the first, but is pointing to a different database,
thereby returning no results. Try to manually load the second report
using any valid parameter values from the first and see if you can
replicate this error.
Just be sure that both reports are going against the same database.
I've run into this when using key values which are different between
DEV and QA environments.
Mike

Report Navigation and jump url

Hi all,

I have got a report with external hyperlink.

When I put this link in TextBox properties >> Navigation >> Jump URL of my gridView : http://www.micheldegremont.com it works.

However, if I put "http://www.micheldegremont.com?id=" + Fields!ID.Value it doesn't work. I haven't not link in my report.

And if I put http://www.micheldegremont.com?id=Fields!ID.Value my report create a hyperlink to http://www.micheldegremont.com?id=Fields!ID.Value and no http://www.micheldegremont.com?id=1

Thanks for you help.

Degremont wrote:

However, if I put "http://www.micheldegremont.com?id=" + Fields!ID.Value it doesn't work. I haven't not link in my report.

Instead use "http://www.micheldegremont.com?id=" & Fields!ID.Value

HTH|||

Now it works with ="http://www.micheldegremont.com?id=" & Fields!ID.Value but only on 1 report.

Howerver, I have the same XML

Report 1 (it's work)

<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="AddressID">
<rd:DefaultName>AddressID</rd:DefaultName>
<ZIndex>1</ZIndex>
<Action>
<Hyperlink>="http://www.micheldegremont.com?id=" &amp; Fields!ID.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!AddressID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>

But on report 2 , it doesn't work

<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="noteFraisID">
<rd:DefaultName>noteFraisID</rd:DefaultName>
<ZIndex>7</ZIndex>
<Action>
<Hyperlink>="http://www.micheldegremont.com?id=" &amp; Fields!ID.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!noteFraisID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
....

sql

Report Manager help URL set to http, not https

We have an SSL cert in place on our production platform and for some reason
the help link in report manager is calling the help page through http, not
https and subsequently the call fails.
Does anyone know if it is possible to change the link to https somewhere in
the config files?
All other links work OK.
Thanks
DarrenHi Darren,
I have the same problem...
Did you manage to find a resolution?
Cant seem to find one on the newsgroups.
Many Thanks
Alex Young
"Darren" wrote:
> We have an SSL cert in place on our production platform and for some reason
> the help link in report manager is calling the help page through http, not
> https and subsequently the call fails.
> Does anyone know if it is possible to change the link to https somewhere in
> the config files?
> All other links work OK.
> Thanks
> Darren|||This is a known issue in RS. There is unfortunately no work around.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alex Young" <Alex Young@.discussions.microsoft.com> wrote in message
news:86358E44-48A6-4549-B059-1EE867CD647B@.microsoft.com...
> Hi Darren,
> I have the same problem...
> Did you manage to find a resolution?
> Cant seem to find one on the newsgroups.
> Many Thanks
> Alex Young
> "Darren" wrote:
>> We have an SSL cert in place on our production platform and for some
>> reason
>> the help link in report manager is calling the help page through http,
>> not
>> https and subsequently the call fails.
>> Does anyone know if it is possible to change the link to https somewhere
>> in
>> the config files?
>> All other links work OK.
>> Thanks
>> Darren|||Thanks for this. In the end I got the firewall config changed to allow http
as well as https.
Darren
"Daniel Reib [MSFT]" wrote:
> This is a known issue in RS. There is unfortunately no work around.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Alex Young" <Alex Young@.discussions.microsoft.com> wrote in message
> news:86358E44-48A6-4549-B059-1EE867CD647B@.microsoft.com...
> > Hi Darren,
> >
> > I have the same problem...
> >
> > Did you manage to find a resolution?
> >
> > Cant seem to find one on the newsgroups.
> >
> > Many Thanks
> >
> > Alex Young
> >
> > "Darren" wrote:
> >
> >> We have an SSL cert in place on our production platform and for some
> >> reason
> >> the help link in report manager is calling the help page through http,
> >> not
> >> https and subsequently the call fails.
> >>
> >> Does anyone know if it is possible to change the link to https somewhere
> >> in
> >> the config files?
> >> All other links work OK.
> >>
> >> Thanks
> >> Darren
>
>|||Is this a known issue only with the "Help" link OR also with links such as
"Home", "My Subscriptions" etc in Report Manager?
"Daniel Reib [MSFT]" wrote:
> This is a known issue in RS. There is unfortunately no work around.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Alex Young" <Alex Young@.discussions.microsoft.com> wrote in message
> news:86358E44-48A6-4549-B059-1EE867CD647B@.microsoft.com...
> > Hi Darren,
> >
> > I have the same problem...
> >
> > Did you manage to find a resolution?
> >
> > Cant seem to find one on the newsgroups.
> >
> > Many Thanks
> >
> > Alex Young
> >
> > "Darren" wrote:
> >
> >> We have an SSL cert in place on our production platform and for some
> >> reason
> >> the help link in report manager is calling the help page through http,
> >> not
> >> https and subsequently the call fails.
> >>
> >> Does anyone know if it is possible to change the link to https somewhere
> >> in
> >> the config files?
> >> All other links work OK.
> >>
> >> Thanks
> >> Darren
>
>|||Just with the help link.
-Mo|||Alex and Darren,
Sorry to disagree with Daniel Reib. There is a work around.
1) Access the IIS Manager
2) Go to the Default Web Site. Find the 'Reports' virtual directory and
expand
3) Locate the folders that have a sub folder â'helpâ'.
4) Right click and select properties
5) Go to the Directory Security tab, click the â'Editâ' button under Secure
communications
6) Uncheck the checkbox for â'Require secure channel (SSL)â'.
7) All the sub folders with that contain a help file donâ't require
SSL â'deâ', â'enâ', â'esâ', â'frâ', â'itâ', â'jaâ', â'koâ'.
Your Help link should work. The Help files really don't require SSL anyway.
Cheers!

Report Manager - Data Source question

I have a report on the Reporting Server Manager where in the Data Sources
link it shows two data sources. I have removed the report in question and
redeployed the report. The two data sources reappear. Does anyone know
where the second data source is coming from in the Report Manager.
Thanks.In the project do you have 2 datasources? For some reason when you
deploy a report it deploys all of the datasources in the project. If
you have 2 datasources in the project then you will get 2 datasources
in the folder that you deploy to. I haven't found a way around this
yet...if you find a way post it so that I can do the same. I find
myself just deleting any datasource as I have folder of shared
datasources. I have 130+ reports and only 3 datasources.|||I looked in the project and I did not see the second data source. I cannot
locate the second data source in the Report Manager.
"Luke" wrote:
> In the project do you have 2 datasources? For some reason when you
> deploy a report it deploys all of the datasources in the project. If
> you have 2 datasources in the project then you will get 2 datasources
> in the folder that you deploy to. I haven't found a way around this
> yet...if you find a way post it so that I can do the same. I find
> myself just deleting any datasource as I have folder of shared
> datasources. I have 130+ reports and only 3 datasources.
>

Report Hyperlink Opening New Window

Hi, I am trying to get a link out of a report to open another web browser
with the HTML
rs:target=_blank as part of the string parameter that is passed in...but it
still opens the link in the same window.
?How does one open a link out of a report so that it will open a new window?
THANKS!!!There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> Hi, I am trying to get a link out of a report to open another web browser
> with the HTML
> rs:target=_blank as part of the string parameter that is passed in...but
> it still opens the link in the same window.
> ?How does one open a link out of a report so that it will open a new
> window?
> THANKS!!!
>|||ok, so I tried this and it didn't work...or maybe I didn't understand it...
I'm in a text box in a table under
properties>>advanced>>navigation>>Jump to URL
and I enter
="http://kingofthegreens.com&rc:LinkTarget=_blank"
results in it still opening in the same window'
"Robert Bruckner [MSFT]" wrote:
> There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
> See also:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
> news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> > Hi, I am trying to get a link out of a report to open another web browser
> > with the HTML
> > rs:target=_blank as part of the string parameter that is passed in...but
> > it still opens the link in the same window.
> >
> > ?How does one open a link out of a report so that it will open a new
> > window?
> >
> > THANKS!!!
> >
>
>|||I am having a similar issue, I can't find the syntax for adding
rc:LinkTarget. I am trying to add a url with one query string parameter and
open in a new window.
Thanks!
"Ben Sullins" wrote:
> ok, so I tried this and it didn't work...or maybe I didn't understand it...
> I'm in a text box in a table under
> properties>>advanced>>navigation>>Jump to URL
> and I enter
> ="http://kingofthegreens.com&rc:LinkTarget=_blank"
> results in it still opening in the same window'
>
> "Robert Bruckner [MSFT]" wrote:
> > There is no rs:target parameter. I suppose you mean rc:LinkTarget=_blank
> > See also:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
> > news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
> > > Hi, I am trying to get a link out of a report to open another web browser
> > > with the HTML
> > > rs:target=_blank as part of the string parameter that is passed in...but
> > > it still opens the link in the same window.
> > >
> > > ?How does one open a link out of a report so that it will open a new
> > > window?
> > >
> > > THANKS!!!
> > >
> >
> >
> >|||Here is a response of mine about exporting to CSV that covers your
situation. Note that you need to have SP1 or SP2 installed to be able to use
this:
>>>>>>
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager it puts CSV data in unicode which Excel puts all in one column. If
you export in ASCII then Excel does just as you want. To prevent a problem
with cells (Excel will object to sorting the data) you need to remove any
textboxes you have (for instance with a title, showing the parameters run
etc) and instead add additional header rows, merge the cells and put your
text in there instead. I add a link at the top of the report that says
Export Data. With RS 2005 you will be able to configure it to use ASCII
instead of Unicode.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Very nice and very fast.
>>>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter Rogers" <Peter Rogers@.discussions.microsoft.com> wrote in message
news:F4C1AC98-3B0D-443D-B18A-0E7896435958@.microsoft.com...
>I am having a similar issue, I can't find the syntax for adding
> rc:LinkTarget. I am trying to add a url with one query string parameter
> and
> open in a new window.
> Thanks!
> "Ben Sullins" wrote:
>> ok, so I tried this and it didn't work...or maybe I didn't understand
>> it...
>> I'm in a text box in a table under
>> properties>>advanced>>navigation>>Jump to URL
>> and I enter
>> ="http://kingofthegreens.com&rc:LinkTarget=_blank"
>> results in it still opening in the same window'
>>
>> "Robert Bruckner [MSFT]" wrote:
>> > There is no rs:target parameter. I suppose you mean
>> > rc:LinkTarget=_blank
>> > See also:
>> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp
>> >
>> > -- Robert
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> > "G. Ray Giacalone" <rgiacalone@.virtual.com> wrote in message
>> > news:O9F1lJRxFHA.3720@.TK2MSFTNGP14.phx.gbl...
>> > > Hi, I am trying to get a link out of a report to open another web
>> > > browser
>> > > with the HTML
>> > > rs:target=_blank as part of the string parameter that is passed
>> > > in...but
>> > > it still opens the link in the same window.
>> > >
>> > > ?How does one open a link out of a report so that it will open a new
>> > > window?
>> > >
>> > > THANKS!!!
>> > >
>> >
>> >
>> >