drill down report with report viewer

Hi
I am using the new report viewer control that comes with Reporting services
2005. However, my reports were created in using Visual Studio 2003 and are
.rdl files. Previously I used jump to url to drill down in a report and
passed the report url along with the report parameters in the query string.
I tried my report using the new report viewer control but when I click on a
drill down link, the report opens in the report viewer but it takes over the
whole IE window. My report viewer is within a page which is within one of
many frames that make up my webb application.
How can I get the drill down to work without losing my other frames?
If this is not possible, what do I need to do to convert my .rdl files to
.rdlc. I understand if I do this that I will need to take the sql query out
of my .rdl report and load up a dataset in code using this query and then
set this as the datasource for the report. Is this correct?
Thanks
Lewis Holmes
eNateHi eNate,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: When you use the
jump to url to view a report in the report viewer control ( SQL Reporting
Services 2005 ), all the frames gones away. If I misundertstood your
concern, please feel free to point it out.
I have tested on my SPS site. But it works fine.
1. I create a Web Page Part, configurate the Report Viewer Control to view
the report. In the report I use jump to url to redirect to another report.
2. I access the Web Page, the report shows fine.
3. I click the link in the report, and it redirected, and the Report Viewer
is fine.
Have you install SPS Service Pack 2? If not , please install and try to
check the issue again.
You can download SP2 from the following site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=171DC9A7-B4BA-4759-
BD64-6B7D851A97EF&displaylang=en
As for the convert from .rdl file to .rdlc file, you may follow this
article:
Converting RDL and RDLC Files
http://msdn2.microsoft.com/en-us/library/ms252109.aspx
Hope this will be helpful
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
Basically when I click on the link in a report, the report opens in the same
window but the other frames I had are lost.
I have tried using
javascript:void(window.open('reportURLandParameters','_self'));
but this does not work. The closest I have got is to replace '_self' with
the name of the iframe that the report viewer control uses. This works but i
get the report along with the report toolbar are displayed again within the
original report viewer frame. I tried adding &rc:toolbar=false to remove the
toolbar and this works but then the refresh button on the toolbar crashes
with javascript error and print preview thinks the original report page is
still being displayed.
Has anybody got a jump to report URL drill down to open in the report viewer
correctly when using the report viewer within a frame?
I really do not want to have to change the reports at this stage of
development.
I am using .rdl reports and Visual Studio 2005 with ASP.net 2.0.
Thanks
Lewis Holmes
eNate
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:kVKTqgxUGHA.4716@.TK2MSFTNGXA01.phx.gbl...
> Hi eNate,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: When you use the
> jump to url to view a report in the report viewer control ( SQL Reporting
> Services 2005 ), all the frames gones away. If I misundertstood your
> concern, please feel free to point it out.
> I have tested on my SPS site. But it works fine.
> 1. I create a Web Page Part, configurate the Report Viewer Control to
> view
> the report. In the report I use jump to url to redirect to another report.
> 2. I access the Web Page, the report shows fine.
> 3. I click the link in the report, and it redirected, and the Report
> Viewer
> is fine.
> Have you install SPS Service Pack 2? If not , please install and try to
> check the issue again.
> You can download SP2 from the following site:
> http://www.microsoft.com/downloads/details.aspx?FamilyId=171DC9A7-B4BA-4759-
> BD64-6B7D851A97EF&displaylang=en
> As for the convert from .rdl file to .rdlc file, you may follow this
> article:
> Converting RDL and RDLC Files
> http://msdn2.microsoft.com/en-us/library/ms252109.aspx
> Hope this will be helpful
> 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.
>|||What happens if you use jump to report instead?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"l.holmes" <enate@.newsgroups.nospam> wrote in message
news:OczKizyUGHA.4976@.TK2MSFTNGP11.phx.gbl...
> Hi
> Basically when I click on the link in a report, the report opens in the
> same window but the other frames I had are lost.
> I have tried using
> javascript:void(window.open('reportURLandParameters','_self'));
> but this does not work. The closest I have got is to replace '_self' with
> the name of the iframe that the report viewer control uses. This works but
> i get the report along with the report toolbar are displayed again within
> the original report viewer frame. I tried adding &rc:toolbar=false to
> remove the toolbar and this works but then the refresh button on the
> toolbar crashes with javascript error and print preview thinks the
> original report page is still being displayed.
> Has anybody got a jump to report URL drill down to open in the report
> viewer correctly when using the report viewer within a frame?
> I really do not want to have to change the reports at this stage of
> development.
> I am using .rdl reports and Visual Studio 2005 with ASP.net 2.0.
> Thanks
> Lewis Holmes
> eNate
>
> "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
> news:kVKTqgxUGHA.4716@.TK2MSFTNGXA01.phx.gbl...
>> Hi eNate,
>> Welcome to use MSDN Managed Newsgroup Support.
>> From your description, my understanding of this issue is: When you use
>> the
>> jump to url to view a report in the report viewer control ( SQL Reporting
>> Services 2005 ), all the frames gones away. If I misundertstood your
>> concern, please feel free to point it out.
>> I have tested on my SPS site. But it works fine.
>> 1. I create a Web Page Part, configurate the Report Viewer Control to
>> view
>> the report. In the report I use jump to url to redirect to another
>> report.
>> 2. I access the Web Page, the report shows fine.
>> 3. I click the link in the report, and it redirected, and the Report
>> Viewer
>> is fine.
>> Have you install SPS Service Pack 2? If not , please install and try to
>> check the issue again.
>> You can download SP2 from the following site:
>> http://www.microsoft.com/downloads/details.aspx?FamilyId=171DC9A7-B4BA-4759-
>> BD64-6B7D851A97EF&displaylang=en
>> As for the convert from .rdl file to .rdlc file, you may follow this
>> article:
>> Converting RDL and RDLC Files
>> http://msdn2.microsoft.com/en-us/library/ms252109.aspx
>> Hope this will be helpful
>> 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.
>