Question about ReportViewer for ASP.NET Pages

hello masters and gurus,
anyone using the reportviewer control provided for integration with asp.net
webform? what should i do to keep the drilldown report to transfer to the
next report but just on the report viewer control? because when i try to
click one..it opens up on the whole page...which is not what i need..
thanks in advance guys...use the rc:replacementroot parameter to inform your reportviewer to open a
linked report in a specific ASPX web page.
The usage is like this
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
(encode the Replacementroot value with the server.urlencode function)
RS will add the report name at the end of this value, so the "ReportName"
parameter is the parameter passed to the URL filled by RS.
So, when the page "page.aspx" is called, read the ReportName query string
(request("ReportName")) to retrieve the drilled report and all the
associated parameters.
"dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> hello masters and gurus,
> anyone using the reportviewer control provided for integration with
asp.net
> webform? what should i do to keep the drilldown report to transfer to the
> next report but just on the report viewer control? because when i try to
> click one..it opens up on the whole page...which is not what i need..
> thanks in advance guys...
>|||It still didn't solve my problem..sorry i wasn't able to mention this..my
page has a frames..wherein the left pane displays the list of reports that
can be used...the right pane therefore is where my report viewer is
located...when i click the drilldown report on that report..it opens it in
the whole page and not just on that frame and on that specific report viewer
control..
hope you can help me with this problem...thanks in advance..
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OnjkSeuVEHA.1152@.TK2MSFTNGP09.phx.gbl...
> use the rc:replacementroot parameter to inform your reportviewer to open a
> linked report in a specific ASPX web page.
> The usage is like this
>
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> (encode the Replacementroot value with the server.urlencode function)
> RS will add the report name at the end of this value, so the "ReportName"
> parameter is the parameter passed to the URL filled by RS.
> So, when the page "page.aspx" is called, read the ReportName query string
> (request("ReportName")) to retrieve the drilled report and all the
> associated parameters.
>
> "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > hello masters and gurus,
> >
> > anyone using the reportviewer control provided for integration with
> asp.net
> > webform? what should i do to keep the drilldown report to transfer to
the
> > next report but just on the report viewer control? because when i try to
> > click one..it opens up on the whole page...which is not what i need..
> >
> > thanks in advance guys...
> >
> >
>|||Jéjé,
How did you find the "rc:ReplacementRoot=" URL access command? It is not in the SQL RS documentation that I can find. Did you dig around in the assemblies with Reflector, or did one of the MSFT guys post it here? Are there any other useful undocumented commands? Thanks,
-Josh
"Jéjé" wrote:
> use the rc:replacementroot parameter to inform your reportviewer to open a
> linked report in a specific ASPX web page.
> The usage is like this
> http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> (encode the Replacementroot value with the server.urlencode function)
> RS will add the report name at the end of this value, so the "ReportName"
> parameter is the parameter passed to the URL filled by RS.
> So, when the page "page.aspx" is called, read the ReportName query string
> (request("ReportName")) to retrieve the drilled report and all the
> associated parameters.
>
> "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > hello masters and gurus,
> >
> > anyone using the reportviewer control provided for integration with
> asp.net
> > webform? what should i do to keep the drilldown report to transfer to the
> > next report but just on the report viewer control? because when i try to
> > click one..it opens up on the whole page...which is not what i need..
> >
> > thanks in advance guys...
> >
> >
>
>|||You want rc:LinkTarget. Set the value of this HTML device command to the
window name of your main frame when a report is called. Any drill through
links in the report will open in the specified frame.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"dotnetprogram" <smalleville@.lycos.com> wrote in message
news:uz1YCl2VEHA.1652@.TK2MSFTNGP09.phx.gbl...
> It still didn't solve my problem..sorry i wasn't able to mention this..my
> page has a frames..wherein the left pane displays the list of reports that
> can be used...the right pane therefore is where my report viewer is
> located...when i click the drilldown report on that report..it opens it in
> the whole page and not just on that frame and on that specific report
viewer
> control..
> hope you can help me with this problem...thanks in advance..
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OnjkSeuVEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > use the rc:replacementroot parameter to inform your reportviewer to open
a
> > linked report in a specific ASPX web page.
> > The usage is like this
> >
>
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > (encode the Replacementroot value with the server.urlencode function)
> >
> > RS will add the report name at the end of this value, so the
"ReportName"
> > parameter is the parameter passed to the URL filled by RS.
> > So, when the page "page.aspx" is called, read the ReportName query
string
> > (request("ReportName")) to retrieve the drilled report and all the
> > associated parameters.
> >
> >
> > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > hello masters and gurus,
> > >
> > > anyone using the reportviewer control provided for integration with
> > asp.net
> > > webform? what should i do to keep the drilldown report to transfer to
> the
> > > next report but just on the report viewer control? because when i try
to
> > > click one..it opens up on the whole page...which is not what i need..
> > >
> > > thanks in advance guys...
> > >
> > >
> >
> >
>|||That was unintentionally undocumented. Actually it is a command that we use
for Report Manager and we didn't consider that developers would want to use
it for their own projects, so it didn't get as much attention as the others.
We try very hard to document all available commands.
There will be three new commands in SP1 and those will be documented in the
readme.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Josh Robinson" <Josh Robinson@.discussions.microsoft.com> wrote in message
news:57522785-22AA-4985-A921-D96A0EC66A5B@.microsoft.com...
> Jéjé,
> How did you find the "rc:ReplacementRoot=" URL access command? It is
not in the SQL RS documentation that I can find. Did you dig around in the
assemblies with Reflector, or did one of the MSFT guys post it here? Are
there any other useful undocumented commands? Thanks,
> -Josh
>
> "Jéjé" wrote:
> > use the rc:replacementroot parameter to inform your reportviewer to open
a
> > linked report in a specific ASPX web page.
> > The usage is like this
> >
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > (encode the Replacementroot value with the server.urlencode function)
> >
> > RS will add the report name at the end of this value, so the
"ReportName"
> > parameter is the parameter passed to the URL filled by RS.
> > So, when the page "page.aspx" is called, read the ReportName query
string
> > (request("ReportName")) to retrieve the drilled report and all the
> > associated parameters.
> >
> >
> > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > hello masters and gurus,
> > >
> > > anyone using the reportviewer control provided for integration with
> > asp.net
> > > webform? what should i do to keep the drilldown report to transfer to
the
> > > next report but just on the report viewer control? because when i try
to
> > > click one..it opens up on the whole page...which is not what i need..
> > >
> > > thanks in advance guys...
> > >
> > >
> >
> >
> >|||The current linktarget URL option works only for the first drilled report,
after RS lost this value and use a target = _Top (so the whole page)
RS keep the replacementroot value during each call.
In my usage, I'm using frames, in my ASPX page, I simply send the ReportName
value to the frame like this:
<frame id=Left src="http://pics.10026.com/?src=myleftmenu.aspx">
<frame id=right src='<%= Request("ReportName") %>
When I call a report, I open it like this URL:
http://myserver/mysite/myframedpage.aspx?ReportName=<http://myserver/reportserver/folder/report
name?rc:ReplacementRoot=http://myserver/mysite/myframedpage.aspx?ReportName>
the content in the < > is URLEncoded
You can create a more complex URL, for example, if you want to keep a state
of your left frame:
http://myserver/mysite/myframedpage.aspx?ReportName=<http://myserver/reportserver/folder/report
name?rc:ReplacementRoot=http://myserver/mysite/myframedpage.aspx?LeftOption=
Menu1&ReportName>
myframedpage.aspx =<frame id=Left src='myleftmenu.aspx?LeftOption=<%=Request("LeftOption")%>'>
<frame id=right src='<%= Request("ReportName") %>
good luck ! :)
I hope the SP1 provides more option to simplify the drill action.
"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> a écrit dans le message
de news:u9jSSP$VEHA.2696@.TK2MSFTNGP09.phx.gbl...
> You want rc:LinkTarget. Set the value of this HTML device command to the
> window name of your main frame when a report is called. Any drill through
> links in the report will open in the specified frame.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "dotnetprogram" <smalleville@.lycos.com> wrote in message
> news:uz1YCl2VEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > It still didn't solve my problem..sorry i wasn't able to mention
this..my
> > page has a frames..wherein the left pane displays the list of reports
that
> > can be used...the right pane therefore is where my report viewer is
> > located...when i click the drilldown report on that report..it opens it
in
> > the whole page and not just on that frame and on that specific report
> viewer
> > control..
> >
> > hope you can help me with this problem...thanks in advance..
> >
> > "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> > news:OnjkSeuVEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > > use the rc:replacementroot parameter to inform your reportviewer to
open
> a
> > > linked report in a specific ASPX web page.
> > > The usage is like this
> > >
> >
>
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > > (encode the Replacementroot value with the server.urlencode function)
> > >
> > > RS will add the report name at the end of this value, so the
> "ReportName"
> > > parameter is the parameter passed to the URL filled by RS.
> > > So, when the page "page.aspx" is called, read the ReportName query
> string
> > > (request("ReportName")) to retrieve the drilled report and all the
> > > associated parameters.
> > >
> > >
> > > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > hello masters and gurus,
> > > >
> > > > anyone using the reportviewer control provided for integration with
> > > asp.net
> > > > webform? what should i do to keep the drilldown report to transfer
to
> > the
> > > > next report but just on the report viewer control? because when i
try
> to
> > > > click one..it opens up on the whole page...which is not what i
need..
> > > >
> > > > thanks in advance guys...
> > > >
> > > >
> > >
> > >
> >
> >
>|||Yes, your drill throughs will have to support the LinkTarget attribute as
well. What type of action are you using, Jump to Report or Jump to URL? You
may have to convert your reports to Jump to URL. You can still pass
parameters and such if you build your URL as an expression ="http://..."
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OZmS10$VEHA.4064@.TK2MSFTNGP11.phx.gbl...
> The current linktarget URL option works only for the first drilled report,
> after RS lost this value and use a target = _Top (so the whole page)
> RS keep the replacementroot value during each call.
> In my usage, I'm using frames, in my ASPX page, I simply send the
ReportName
> value to the frame like this:
> <frame id=Left src="http://pics.10026.com/?src=myleftmenu.aspx">
> <frame id=right src='<%= Request("ReportName") %>
> When I call a report, I open it like this URL:
>
http://myserver/mysite/myframedpage.aspx?ReportName=<http://myserver/reportserver/folder/report
>
name?rc:ReplacementRoot=http://myserver/mysite/myframedpage.aspx?ReportName>
> the content in the < > is URLEncoded
> You can create a more complex URL, for example, if you want to keep a
state
> of your left frame:
>
http://myserver/mysite/myframedpage.aspx?ReportName=<http://myserver/reportserver/folder/report
>
name?rc:ReplacementRoot=http://myserver/mysite/myframedpage.aspx?LeftOption=
> Menu1&ReportName>
> myframedpage.aspx => <frame id=Left
src='myleftmenu.aspx?LeftOption=<%=Request("LeftOption")%>'>
> <frame id=right src='<%= Request("ReportName") %>
> good luck ! :)
> I hope the SP1 provides more option to simplify the drill action.
> "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> a écrit dans le
message
> de news:u9jSSP$VEHA.2696@.TK2MSFTNGP09.phx.gbl...
> > You want rc:LinkTarget. Set the value of this HTML device command to the
> > window name of your main frame when a report is called. Any drill
through
> > links in the report will open in the specified frame.
> >
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "dotnetprogram" <smalleville@.lycos.com> wrote in message
> > news:uz1YCl2VEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > > It still didn't solve my problem..sorry i wasn't able to mention
> this..my
> > > page has a frames..wherein the left pane displays the list of reports
> that
> > > can be used...the right pane therefore is where my report viewer is
> > > located...when i click the drilldown report on that report..it opens
it
> in
> > > the whole page and not just on that frame and on that specific report
> > viewer
> > > control..
> > >
> > > hope you can help me with this problem...thanks in advance..
> > >
> > > "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> > > news:OnjkSeuVEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > > > use the rc:replacementroot parameter to inform your reportviewer to
> open
> > a
> > > > linked report in a specific ASPX web page.
> > > > The usage is like this
> > > >
> > >
> >
>
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > > > (encode the Replacementroot value with the server.urlencode
function)
> > > >
> > > > RS will add the report name at the end of this value, so the
> > "ReportName"
> > > > parameter is the parameter passed to the URL filled by RS.
> > > > So, when the page "page.aspx" is called, read the ReportName query
> > string
> > > > (request("ReportName")) to retrieve the drilled report and all the
> > > > associated parameters.
> > > >
> > > >
> > > > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > > > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > > hello masters and gurus,
> > > > >
> > > > > anyone using the reportviewer control provided for integration
with
> > > > asp.net
> > > > > webform? what should i do to keep the drilldown report to transfer
> to
> > > the
> > > > > next report but just on the report viewer control? because when i
> try
> > to
> > > > > click one..it opens up on the whole page...which is not what i
> need..
> > > > >
> > > > > thanks in advance guys...
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I understand - I had noticed that some MSFT developer replies in this newsgroup said to "use the ReplacementRoot command" in the past. I didn't realize it was part of SQL RS and I have been using .NET Framework for something like 3 years now and hadn't seen it there either. Glad to know that it is part of Reporting Services and is usable by developers.
"Bryan Keller [MSFT]" wrote:
> That was unintentionally undocumented. Actually it is a command that we use
> for Report Manager and we didn't consider that developers would want to use
> it for their own projects, so it didn't get as much attention as the others.
> We try very hard to document all available commands.
> There will be three new commands in SP1 and those will be documented in the
> readme.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Josh Robinson" <Josh Robinson@.discussions.microsoft.com> wrote in message
> news:57522785-22AA-4985-A921-D96A0EC66A5B@.microsoft.com...
> > Jéjé,
> > How did you find the "rc:ReplacementRoot=" URL access command? It is
> not in the SQL RS documentation that I can find. Did you dig around in the
> assemblies with Reflector, or did one of the MSFT guys post it here? Are
> there any other useful undocumented commands? Thanks,
> >
> > -Josh
> >
> >
> > "Jéjé" wrote:
> >
> > > use the rc:replacementroot parameter to inform your reportviewer to open
> a
> > > linked report in a specific ASPX web page.
> > > The usage is like this
> > >
> http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > > (encode the Replacementroot value with the server.urlencode function)
> > >
> > > RS will add the report name at the end of this value, so the
> "ReportName"
> > > parameter is the parameter passed to the URL filled by RS.
> > > So, when the page "page.aspx" is called, read the ReportName query
> string
> > > (request("ReportName")) to retrieve the drilled report and all the
> > > associated parameters.
> > >
> > >
> > > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > hello masters and gurus,
> > > >
> > > > anyone using the reportviewer control provided for integration with
> > > asp.net
> > > > webform? what should i do to keep the drilldown report to transfer to
> the
> > > > next report but just on the report viewer control? because when i try
> to
> > > > click one..it opens up on the whole page...which is not what i need..
> > > >
> > > > thanks in advance guys...
> > > >
> > > >
> > >
> > >
> > >
>
>