|
|
You're in the
sql server reporting services
group:drill down report with report viewer
sql server reporting services:
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 eNate
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.
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 [quoted text, click to view] "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 [quoted text, click to view] "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. >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |