Report pagination w/in web browser

I have a report that is designed with 3 matrices in it --
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx
x
x x x
x Item Data
x x Aggregate x
x
x x Row Data x
x xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
x
x
x Aggregate Column Data x
x
x
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
My client would like all of the data from the report to be displayed on 1
page so the employee who uses this application does not have to navigate
between pages in order to see all of the data.
I've tried messing around with the page break settings in the Item Data
matrix and the Aggregate Column Data matrix to no avail. Is there any other
way I can get around this limitation of HTML rendering of the report.
TIA,
Bill YoungmanI have run some pretty wide matrices before and haven't seen this. If I had,
the first thing I would try is to place the matrix within a rectangle - this
will resolve to a "DIV" container surrounding the matrix and may prevent this
break you are seeing.
let me know if this solves it.
Steve Muise
Hitachi Consulting
smuise@.<nospam>hitachiconsulting.com
"Bill Youngman" wrote:
> I have a report that is designed with 3 matrices in it --
> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx
> x
> x x x
> x Item Data
> x x Aggregate x
> x
> x x Row Data x
> x xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxx
> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> x
> x
> x Aggregate Column Data x
> x
> x
> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> My client would like all of the data from the report to be displayed on 1
> page so the employee who uses this application does not have to navigate
> between pages in order to see all of the data.
> I've tried messing around with the page break settings in the Item Data
> matrix and the Aggregate Column Data matrix to no avail. Is there any other
> way I can get around this limitation of HTML rendering of the report.
> TIA,
> Bill Youngman
>
>

Report not rending via web service

I'm somewhat new to reporting services and have used a web service call to
render my reports in my asp.net applications in the past. All the reports
thus far have been Excel, and I've used the same method for calling these
reports from some sample code I found online. This has worked great up till
now.
I have a report I want to render in PDF. I've plugged in the correct values
in my code and the browser will try and download the PDF but returns a "File
is damaged and could not be displayed". I tried rending in Excel and I get
"This file is not in a recognizable format". I've compared my code to past
projects and everything looks good. The only difference with this report is
I used a list control with textboxes instead of a table which I've used on
all past reports. If anyone has a suggestion on what causes these error
message, please reply. Thanks.I figured it out. There was a <httpModules> tag in my web.config that was
causing this problem. I built another project to call my report with a
"clean" web.config and it works fine.
"jweesies" wrote:
> I'm somewhat new to reporting services and have used a web service call to
> render my reports in my asp.net applications in the past. All the reports
> thus far have been Excel, and I've used the same method for calling these
> reports from some sample code I found online. This has worked great up till
> now.
> I have a report I want to render in PDF. I've plugged in the correct values
> in my code and the browser will try and download the PDF but returns a "File
> is damaged and could not be displayed". I tried rending in Excel and I get
> "This file is not in a recognizable format". I've compared my code to past
> projects and everything looks good. The only difference with this report is
> I used a list control with textboxes instead of a table which I've used on
> all past reports. If anyone has a suggestion on what causes these error
> message, please reply. Thanks.

report model and it's datasource

hi everyone,

I created a report model and deployed it. When I open the rpt builder on web I get the following error.

'The selected data source does not have and content available'

Seemed like it would be a easy issue, but I cannot retrieve any data in the rpt model. The datasource I'm using does work for rpts not associated with the rpt model. Any suggestions? It seems like I've missed a step. Thanks, Lisa

If there is no primary key defined, you can build the model, but no contents. Do you have primary key defined?sql

Report Model & Data Source Views

Hi,
(Newbie at SSRS, 10 years experience with SQL-Server & Web/App programming)
I recently (about 1 week ago) introduced myself to the world of SSRS - but
it wasn't as straightforward as I first thought it should be. Try yourself by
searching for documentation about installing reporting services on another
machine than the same as the sql server (ie: at the webserver). As usual: -
you have to read several different webpages, scan through endless
documentation created by linquist-speciallists (discussing everything but the
subject) - a.k.a. 'quickstarts'. Whehehe..
Anyhow, I've now successfully setup Reporting Services and it really excells
at everything it does :)
However, I find it a little bit strange generating the Report Model from the
Data Source View. Shouldn't it be the otherway around? - First creating the
Model (a simple schema of the database - right?), and THEN creating the view
- 'building' upon that model. Could someone please expand on this subject?
Why?
Then there seems to be an issue when I try to include a SQL Server "SQL
View" a.k.a. "Indexed Views" into the Report Model, so this results in that
neither of my SQL View are accessible from the online Report Builder tool.
Shouldn't it be possible to include views in the Report Model?
Best Regards,
FredrikThis is how I solved it:
- In the Data Source View, be sure to set Logical Primary Keys for the SQL
Views that you want to use. Just select the unique columns (if more than
one), rightclick and create the key.
- In the Report Model, add the entities (SQL views) manually - name & bind
them to the SQL views. Rightclick on an empty & newly created entity and
select autogenerate, proceed through the wizard. Add the identifying column
manually on the the entity (using the properties tool-window).
- Build and combine the .DSV & .SMDL file into one (fairly easy to google),
then upload the resulting "model.smdl" to the Report Manager.
- Enjoy SQL views in Report Builder!
"Fredrik Johansson" wrote:
> Hi,
> (Newbie at SSRS, 10 years experience with SQL-Server & Web/App programming)
> I recently (about 1 week ago) introduced myself to the world of SSRS - but
> it wasn't as straightforward as I first thought it should be. Try yourself by
> searching for documentation about installing reporting services on another
> machine than the same as the sql server (ie: at the webserver). As usual: -
> you have to read several different webpages, scan through endless
> documentation created by linquist-speciallists (discussing everything but the
> subject) - a.k.a. 'quickstarts'. Whehehe..
> Anyhow, I've now successfully setup Reporting Services and it really excells
> at everything it does :)
> However, I find it a little bit strange generating the Report Model from the
> Data Source View. Shouldn't it be the otherway around? - First creating the
> Model (a simple schema of the database - right?), and THEN creating the view
> - 'building' upon that model. Could someone please expand on this subject?
> Why?
> Then there seems to be an issue when I try to include a SQL Server "SQL
> View" a.k.a. "Indexed Views" into the Report Model, so this results in that
> neither of my SQL View are accessible from the online Report Builder tool.
> Shouldn't it be possible to include views in the Report Model?
>
> Best Regards,
> Fredrik

Report Manager web site doesn't work in FireFox...

But with some simple changes to ReportingServices.js it does.
1: Replace all instances of "document.all" with "document.getElementById".
2: Add in this:
window.navigate = function(url)
{
window.location = url;
}
I don't know why the author didn't just use getElementById from the
get-go. Also, the second function is because the navigation depends on
"window.navigate", which doesn't exist--except in IE. If I find
anything else, I'll try to remember to post updates.
Granger<sigh> Nevermind. I forgot about the "event" object in IE. There's no
quick fix on that one. ...except if you disabled the Javascript
validation routines. Once again, the application disappoints.
Granger Godbold wrote:
> But with some simple changes to ReportingServices.js it does.
>
> 1: Replace all instances of "document.all" with "document.getElementById".
> 2: Add in this:
> window.navigate = function(url)
> {
> window.location = url;
> }
>
> I don't know why the author didn't just use getElementById from the
> get-go. Also, the second function is because the navigation depends on
> "window.navigate", which doesn't exist--except in IE. If I find
> anything else, I'll try to remember to post updates.
> Granger

Report Manager Web Client Security Error

I am attempting to access an Access database file located on one of our
servers on the network through Reporting Services Report Manager and am
receiving the error below. I have already setup our Report Server
Service account to a domain account that has full Access to the file. I
am able to run the report from Visual Studio.Net on my local machine. I
have setup and successfully deployed numerous SQL Server based reports
and am able to run an Access based report as long as it's located on my
report server. Any help anyone could provide is extremely appreciated.
============================================== Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
The Microsoft Jet database engine cannot open the file
'\\Server02\PhoneBook\PhoneBook.mdb'. It is already opened exclusively
by another user, or you need permission to view its data.
----
Microsoft Reporting Services
==============================================Have you tried running it with Vis Studio closed?
I have not done this with RS, but I did have many problems connecting
asp pages to access using a DSN.
I ended up using a DSN-Less connection and it worked. I am not sure if
that is an option in RS though.
"Leo" <leo_olden@.yahoo.com> wrote in message news:leo_olden@.yahoo.com:
> I am attempting to access an Access database file located on one of our
> servers on the network through Reporting Services Report Manager and am
> receiving the error below. I have already setup our Report Server
> Service account to a domain account that has full Access to the file. I
> am able to run the report from Visual Studio.Net on my local machine. I
> have setup and successfully deployed numerous SQL Server based reports
> and am able to run an Access based report as long as it's located on my
> report server. Any help anyone could provide is extremely appreciated.
> ==============================================> Reporting Services Error
> ----
> --
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'DataSource1'.
> (rsErrorOpeningConnection) Get Online Help
> The Microsoft Jet database engine cannot open the file
> '\\Server02\PhoneBook\PhoneBook.mdb'. It is already opened exclusively
> by another user, or you need permission to view its data.
> ----
> --
> Microsoft Reporting Services
> ==============================================|||Thanks for your reply John. I actually did some further research and
found that the problem I'm experiencing is a known problem with Access
and the Microsoft Jet database engine. My workaround was to create a
batch file on my report server that copies in the original Access
database file to the report server every hour. My datasource now
resides on my report server and is therefore accessible.

Report manager problem

I am getting the following error when trying to access the Report Manager:

The report server configuration file specifies localhost for the Web server name. The report server requires that the computer name be specified instead.

I have tried:

http://<computername>/reports

http://localhost/reports

I have gone into the report server configuration and tried to change the directory there, but with no affect. Is there something further that I need to be looking at?

Thanks for the information.

In the RSWebApplication.config file you should change the ReportServerUrl to not use localhost.

Report Manager Port Question

Is it possible to run Report Manager from a different port. I know that local host is set to port 80 by default. My default Web Site is set to Port 81 and I can not get Report Manager to run. An example is http://localhost:81/Reports.You need to set the ReportServerUrl property in RSWebApplication.config to point to the port where the report server is installed.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks for the reply Brian. I tried that and it did not work. I have not rebooted the computer since the change so I will try a reboot this evening.

Gerry

Report Manager in Web Site?

In short, how can i get www.roadhouse.com.au/ReportManager deliver reports?
Description:
I developed reports managed to get them work on localhost/ReportManager and
through ASP.NET pages. I want to deploy on to a Web Server which hosts
several websites. I see that i can access reports through
//DevServerBox/ReportManager
but not
www.roadhouse.com.au/ReportManager (Our websites should be able to render
reports to public not just local)Hello,
Have you set Directory Security in your web application properties ?
Is your users needs to be authenticated ?
You have to consider WebApplication ReportServer and Reports.
Jerome Berthaud (MCSD)
http://www.winsight.fr
"AbiBaby" <AbiBaby@.discussions.microsoft.com> wrote in message
news:1BD712F8-A735-4134-8D63-28FBE3A8B1D4@.microsoft.com...
> In short, how can i get www.roadhouse.com.au/ReportManager deliver
reports?
> Description:
> I developed reports managed to get them work on localhost/ReportManager
and
> through ASP.NET pages. I want to deploy on to a Web Server which hosts
> several websites. I see that i can access reports through
> //DevServerBox/ReportManager
> but not
> www.roadhouse.com.au/ReportManager (Our websites should be able to render
> reports to public not just local)
>

Report Manager default open to sub folder

Hello, when I log onto Report Manager web server using Windows Authentication, I need this user to be directed to a default sub folder.

For example: if I have folder A and sub folder 1 and 2. I need to be able to log in and be directed to sub folder 1. I was able to set up view role and access folder A. But then I need to click on folder 1 to view / create my reports.

You can specify the folder path on the URL, so if you want someone to start in Folder1, have them use this URL:

http://localhost/Reports/Pages/Folder.aspx?ItemPath=%2fFolder1

Regards.

Report Manager buttons not working

HI there,
we just installed reporting services 2000 on our web server, and some
of the buttons like New Folder, etc do not work. When you press on
them nothing happens.
Does anyone know what would cause this?
Regards,
TomMy guess is you have enable anonymous for the website (check in IIS). If so,
then because the user is anonymous you don't have any rights to do anything,
even if you are an admin because it does not know who your are, you are
anonymous.
Hope that makes sense.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<OTSolutions@.shaw.ca> wrote in message
news:1164995767.663955.160290@.l12g2000cwl.googlegroups.com...
> HI there,
> we just installed reporting services 2000 on our web server, and some
> of the buttons like New Folder, etc do not work. When you press on
> them nothing happens.
> Does anyone know what would cause this?
> Regards,
> Tom
>|||Hi Bruce, we did not have enable anonymous for the website checked.
I also have re-registered asp .net just to be safe, any other
suggestions?
PS Thanks for the quick response.
Regards,
Tom
Bruce L-C [MVP] wrote:
> My guess is you have enable anonymous for the website (check in IIS). If so,
> then because the user is anonymous you don't have any rights to do anything,
> even if you are an admin because it does not know who your are, you are
> anonymous.
> Hope that makes sense.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <OTSolutions@.shaw.ca> wrote in message
> news:1164995767.663955.160290@.l12g2000cwl.googlegroups.com...
> > HI there,
> >
> > we just installed reporting services 2000 on our web server, and some
> > of the buttons like New Folder, etc do not work. When you press on
> > them nothing happens.
> >
> > Does anyone know what would cause this?
> >
> > Regards,
> > Tom
> >|||My next guess is that no-one has setup roles in RS. Are you an administrator
on the server that is running RS. If not, then you need to get someone who
is or get your account added to the local administrator account on the
server. By default, local administrator group accounts have admin rights on
RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<OTSolutions@.shaw.ca> wrote in message
news:1165074992.191408.136430@.f1g2000cwa.googlegroups.com...
> Hi Bruce, we did not have enable anonymous for the website checked.
> I also have re-registered asp .net just to be safe, any other
> suggestions?
> PS Thanks for the quick response.
> Regards,
> Tom
> Bruce L-C [MVP] wrote:
>> My guess is you have enable anonymous for the website (check in IIS). If
>> so,
>> then because the user is anonymous you don't have any rights to do
>> anything,
>> even if you are an admin because it does not know who your are, you are
>> anonymous.
>> Hope that makes sense.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <OTSolutions@.shaw.ca> wrote in message
>> news:1164995767.663955.160290@.l12g2000cwl.googlegroups.com...
>> > HI there,
>> >
>> > we just installed reporting services 2000 on our web server, and some
>> > of the buttons like New Folder, etc do not work. When you press on
>> > them nothing happens.
>> >
>> > Does anyone know what would cause this?
>> >
>> > Regards,
>> > Tom
>> >
>

Report looks different in email

Hey all,

I have an issue with my report looking different in email than it does in the preview page or on the web in the online Report Manager. I've inserted a few pictures and resized them to fit inside cells on a table. They are the right size in preview, the right size on Report Manager, and the right size when exported to excel, however, when I set up a subscription and email it out they are full size as opposed to the size that they were resized to. Any ideas?

I appreciate the help,

Keith

Hi Keith,

What type of email subscription are you using? Are you sending the hyperlink to the report? Or if you're sending the report either embedded or attached, what type of rendering extension are you using (HTML, Excel, etc)?

Thanks for the info,

Jessica

|||

Hi Jessica,

The report is embedded as an email. The format is web archive.

Thank you,

Keith

'Report Is Being Generated' Message and Graphic not Displaying

Hello,
I am using ReportViewer in a Web Page with a Server Report and
Asyncrendering is turned on. The report displays correctly; however, the
'Report Is Being Generated' message and graphic do not display when the
report is loading.
It works fine in Report Manager. It is a big problem because the user can
not tell when a report is loading and they keep pressing the 'View Report'
button.
Any suggestions?
Thanks.Hello,
Have you tried this on other develop machine to develop a new report for
test?
Have you use the impersonate in your ASP.NET web application?
If so, what's the permission you have on the report server?
Also, please add your report server to the trust site in the IE and try to
set the security level to low to have a try.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||> Have you tried this on other develop machine to develop a new report for
> test?
No.
> Have you use the impersonate in your ASP.NET web application?
No.
>Also, please add your report server to the trust site in the IE and try to
> set the security level to low to have a try.
I tried this and it didn't work
What do you suggest based on these answers?
Thank
"Wei Lu [MSFT]" wrote:
> Hello,
> Have you tried this on other develop machine to develop a new report for
> test?
> Have you use the impersonate in your ASP.NET web application?
> If so, what's the permission you have on the report server?
> Also, please add your report server to the trust site in the IE and try to
> set the security level to low to have a try.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello,
I suggest you to check the develop this report on another machine to check
whether this issue appeared or not.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
Did you use any User Control to hold the ReportViewer? If you put your
ReportViewer to a single aspx page, does this issue appeared?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello
I find some user got the similar issue as you but I did not find any
solution since I could not reproduce this issue on my side.
Could you try to generate a simple sample which could reproduce your issue
and send it to me?
To reach me, please remove the ONLINE in my email address.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

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