Visual Studio Report Controls ForumDiscuss reporting functionality including the integrated report designer and viewer controls for adding rich data reports to Windows Forms and ASP.NET applications© 2009 Microsoft Corporation. All rights reserved.Wed, 25 Nov 2009 18:31:01 Z8ce383d7-fb2c-4e72-8840-072a806af2c8http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/c4380d44-26c8-443e-b276-cc690ab4ff77http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/c4380d44-26c8-443e-b276-cc690ab4ff77DerekAtTempWorkshttp://social.msdn.microsoft.com/Profile/en-US/?user=DerekAtTempWorks"An error occurred during this operation". when attempting to print on IE8<p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-size:small"><span style="font-family:Calibri">&quot;An error occurred during this operation&quot;. when attempting to print via asp.net report viewer control on IE8</span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-family:Calibri;font-size:small"> </span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-size:small"><span style="font-family:Calibri">SQL Server 2005 SP3 CU4 (<span style="color:#333333">9.00.4226.00) </span></span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="color:#333333"><span style="font-size:small"><span style="font-family:Calibri">report viewer redistributable 2005 SP1</span></span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-size:small"><span style="font-family:Calibri">any IE8 browser in &quot;protected mode&quot;</span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-size:small"><span style="font-family:Calibri">(issue also reproduced on SQL Server 2008 with latest SP/CU)</span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-family:Calibri;font-size:small"> </span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-size:small"><span style="font-family:Calibri">when clicking the print button we expect to get the print dialog window, instead we get a popup with the message &quot;An error occurred during this operation&quot;. not a very descriptive message but we found that it was caused by &quot;Protected Mode&quot; being enabled. <br/>having end users configure trusted site settings or modify their security settings is not an acceptable solution for our client base.</span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-size:small"><span style="font-family:Calibri"> </span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-size:small"><span style="font-family:Calibri">see also this thread for similar issue with IE7 that was reportedly resolved by SQL SP. </span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-size:small"><span style="font-family:Calibri">http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/baf60983-900a-49bf-8fe8-c7efcd55759a</span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-family:Calibri;font-size:small"> </span></p> <p class=MsoNormal style="margin:0in 0in 0pt"><span style="font-size:small"><span style="font-family:Calibri">Anyone else experiencing this or have any further information about this issue?</span></span></p><hr class="sig">-Derek @ TempWorks SoftwareThu, 22 Oct 2009 15:32:21 Z2009-11-25T18:31:01Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/b4787e75-1ee9-41c9-b892-b131a7284d50http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/b4787e75-1ee9-41c9-b892-b131a7284d50Mani Balrajhttp://social.msdn.microsoft.com/Profile/en-US/?user=Mani%20BalrajPrinting from RDLC report to Dot Matrix Printer using Generic/Text only printer driverHi,<br/><br/>I am trying to print a RDLC report to a dot matrix printer using Generic/Text only printer driver in windows xp. But the problem is that, I am not getting the proper output as I am able to see in the preview of the report. In the preview the report the output is perfect. But when I print to the printer, some of the fields are shrinked and not displayed completely. When I increase the width of the coloumn in the table, its printing only some columns as it does not fit. So I hope someone can help me to sort out this issue.Mon, 11 May 2009 08:53:28 Z2009-11-25T16:37:12Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/b1eba889-4ce0-4b91-8eb4-da4046ec0216http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/b1eba889-4ce0-4b91-8eb4-da4046ec0216kegerdalhttp://social.msdn.microsoft.com/Profile/en-US/?user=kegerdalReport does not always position correctly anymore caused by WindowsUpdateWe have an application where one of the functions is to print invoices on preformatted sheets of paper (size A4). This is done using a report (.rdlc file) in Visual Studio 2008. The report is formatted like this: a page header is printed on top of the page, then a fixed size section with company name and address and other information. Next comes a variable sized section with orderlines. The number of lines in this section is restricted to a maximum of 12 lines. Below this variable section is a fixed size section that maps the fields of the preprinted invoice form.<br/>This has worked well for several years (first with VS2005 and now with VS2008).<br/>A couple of months ago, a couple of our customers got a newly build of our application and started having trouble that the last (and fixed size) section of the invoice was placed too high or too low compared to the fields of the preprinted sheets. No changes was made to our application regarding invoice printing. Later several other of our customers have started experiencing the same problem - without having a new version of our application, that is, they are still using the &quot;old&quot; version.<br/>The only explanation I can find for the problem is updates implemented by Windows Update (probably updates to .NET Framework or Report Viewer/Writer).<br/>Can you tell me whether there are any updates that may have caused the problems? Are there anybody else experiencing this?<hr class="sig">ProgrammerMon, 16 Nov 2009 14:42:40 Z2009-11-25T15:05:13Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/523d0e4d-d627-47a6-b6f0-6249c8292aa5http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/523d0e4d-d627-47a6-b6f0-6249c8292aa5speaktobrijeshhttp://social.msdn.microsoft.com/Profile/en-US/?user=speaktobrijeshExcel rendering slow in local mode reportviewerHi,<br/><br/>anybody help regarding why Excel rendering slow in local mode reportviewer. if more than 10 k records.... plz help me.<br/><br/>Thanks<br/>BrijeshWed, 25 Nov 2009 11:44:33 Z2009-11-25T11:44:34Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/42ddf8db-8b2b-4e54-aaed-0debfea6b3c1http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/42ddf8db-8b2b-4e54-aaed-0debfea6b3c1JobaDinizhttp://social.msdn.microsoft.com/Profile/en-US/?user=JobaDinizReportViewer two records per pageIs there a way to display two records per page?<br/> <br/> Here is my <a title=report href="http://img692.imageshack.us/img692/2056/77357348.jpg" title=report>report</a> <br/> <br/> I duplicate the report, as you can see. Also, my report display one record per page (I set that way).<br/> I'd want that the duplicated part show the next record, like this:<br/> <br/> Page1:<br/> record1                 record2<br/> <br/> Page2:<br/> record3                 record4<br/> <br/> Is that somehow possible? <hr class=sig> Get a life. Go party!Fri, 20 Nov 2009 13:38:19 Z2009-11-25T10:48:42Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/7f72a098-beed-44b6-8793-c6f20bd0e879http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/7f72a098-beed-44b6-8793-c6f20bd0e879RoyMicrohttp://social.msdn.microsoft.com/Profile/en-US/?user=RoyMicroMaking a table report in 4 colums?I am new to visual Studio 2008<br/> I have created a dataSet as a class in my project.<br/> My table has three colums and 72 rows. Now the report is loaded in controls and a lengthy awkward looking report is generated.<br/> <br/> I need to split this 72 rows into 18 rows and 4 sets and show siode by side as in news paper colums.<br/> Hope I am clear.<br/> How to do it in report viewer?<br/> Thanks<br/>Tue, 24 Nov 2009 13:25:04 Z2009-11-25T10:38:01Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/ed11e5ac-5ad4-4ee0-a704-7b5d14877a09http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/ed11e5ac-5ad4-4ee0-a704-7b5d14877a09henrikxxhttp://social.msdn.microsoft.com/Profile/en-US/?user=henrikxxReportViewer (remote mode) in VS 2008 together with ReportingServices Server 2008 not supported ?I have SQL Server <strong>2008 </strong> and Visual Studio .NET <strong>2008  </strong> installed and I'm trying to access some  SSRS 2008 Reports by Webservice through the ReportViewer-Control 9.0 in an <strong>ASP.NET</strong> App in  VS 2008.  But I'm getting an error: <br/> <br/> <em>&quot;# The version of the report server web service definition (WSDL) is either not valid or unrecognized. The server is not a compatible version.<br/>  * System.Web.Services.Protocols.SoapException: Server did not recognize the value of HTTP Header 'SOAPAction': <br/>  http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/LoadReport...&quot;</em> <br/> <br/>  The report file .rdl contains the namespace:<br/>   xmlns=&quot;http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition&quot;<br/> <br/> <div style="color:Black;background-color:White"> <pre>ReportViewer1.ServerReport.ReportServerUrl = <span style="color:Blue">new</span> Uri(<span style="color:#a31515">&quot;http://localhost:8080/ReportServer/ReportService2005.asmx?wsdl&quot;</span> ); ReportViewer1.ServerReport.ReportPath = <span style="color:#a31515">@&quot;/AdventureWorks Sample Reports/Sales Order Detail&quot;</span> ; </pre> </div> <br/> Maybe the error is because the following issue ?:<br/> <br/> MSDN says about ReportViewer in VS 2008: <em>&quot;The ReportViewer controls require information that is only exposed through the<strong> SQL Server 2005</strong> SOAP execution endpoint.&quot;</em> <br/> And <a rel=nofollow href="http://www.gotreportviewer.com/">www.gotreportviewer.com</a> says about Report Viewer in VS 2008: &quot;<em>In remote mode the ReportViewer control can only view reports hosted on a SQL Server 2005 Report Server&quot;. </em> <br/> <br/> Is there no update for using ReportViewer in VS 2008 in <strong>remote mode</strong> together with Reporting Services Server 2008 ?<br/> <br/> Thanks, henrikWed, 25 Nov 2009 08:58:44 Z2009-11-25T08:58:45Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/64532304-a4e8-466e-b0ce-65ee723a84b7http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/64532304-a4e8-466e-b0ce-65ee723a84b7Looobhttp://social.msdn.microsoft.com/Profile/en-US/?user=LooobOne or more rows contain values violating non-null, unique, or foreign-key constraints<p>Hi. i was Trying To read report and i got this error through reportviewer</p> <p> </p> <p>I'm No sure of wats wrong. I tried Searching the net it seems to be the Dataset Prob. But im positive Dataset is working as im using VWD dataset to bind data. even had a preview Which get the data i want. So it means its working. Which then shows that its Reportviewer thats gibing me this error.</p> <p> </p> <p>Appreciate any help thx</p> <p> </p> <ul> <li style="display:inline;font-weight:normal;font-size:8pt;font-family:Verdana">&quot;An error has occurred during report processing. <ul> <li style="display:inline;font-weight:normal;font-size:8pt;font-family:Verdana">Exception has been thrown by the target of an invocation. <ul> <li style="display:inline;font-weight:normal;font-size:8pt;font-family:Verdana">Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. &quot;</li> <li style="display:inline;font-weight:normal;font-size:8pt;font-family:Verdana"></li> <li style="display:inline;font-weight:normal;font-size:8pt;font-family:Verdana"></li> <li style="display:inline;font-weight:normal;font-size:8pt;font-family:Verdana"></li> <li style="display:inline;font-weight:normal;font-size:8pt;font-family:Verdana"></li> <li style="display:inline;font-weight:normal;font-size:8pt;font-family:Verdana"></li></ul></li></ul></li></ul>Mon, 24 Apr 2006 07:18:03 Z2009-11-25T02:21:54Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/df958346-e19a-4ece-93d3-23e867eefc0chttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/df958346-e19a-4ece-93d3-23e867eefc0cCharlieGodsoehttp://social.msdn.microsoft.com/Profile/en-US/?user=CharlieGodsoeMicrosoft Report Parameter based on Database Query to be nullable..In generating a Microsoft Report I'm trying to define a series of Report Parameters, used to gather data.  <div>I want to be able to allow the user to enter 8 different &quot;tags&quot; that I can get a list of from a dataset, which is called &quot;ChillerTags&quot;.</div> <div><br/></div> <div>So, in the ReportParameters dialog I wan to set the &quot;Avaliable values:&quot; section to from query and set it to the ChillerTags dataset.</div> <div><br/></div> <div>Now here's my problem.. I set under the &quot;Properties&quot; section I've checked the &quot;Allow null value&quot;, but since this parameter's available values are based on a query it doesn't give me a null check box in the reports form, and forces the user to select a tag. </div> <div><br/></div> <div>I would like the user to be able to select 1-8 tags without being forced to select any more than one. Using the Multi-value option doesn't work for me because order and a future boolean value will be important for me.</div> <div><br/></div> <div><br/></div> <div>Any ideas, or did I just confuse anyone reading this..</div>Tue, 24 Nov 2009 23:54:57 Z2009-11-24T23:54:59Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/8817dc73-4e42-4a7d-8a0f-b2482f1b29c7http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/8817dc73-4e42-4a7d-8a0f-b2482f1b29c7H.HEMDAN ISMAILIA - EGYPThttp://social.msdn.microsoft.com/Profile/en-US/?user=H.HEMDAN%20%20%20%20%20%20%20%20ISMAILIA%20-%20EGYPTHow can i show up the Value Numbers on my ReportView Control in arabic language ?????i have a ReportView control that show me the values i want in english language how can i change that to be arabic languageWed, 18 Nov 2009 16:49:48 Z2009-11-24T10:52:03Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/8bd0b42c-d927-4247-9c3d-f475856f1f81http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/8bd0b42c-d927-4247-9c3d-f475856f1f81Carlos Lonehttp://social.msdn.microsoft.com/Profile/en-US/?user=Carlos%20Lonereturn values from print dialog I need to know how can I get the return values when showing the Print Dialog,<br>I have to disable print button if the user has send the report to the printer, otherwise<br>if the user press the cancel button  the print button will be enable.<br><br>I have manage to use a custom button adding the following attribute:<br><font size=2> <p>BtnPrint.Attributes.Add(</font><font color="#a31515" size=2>&quot;onclick&quot;</font><font size=2>, </font><font color="#a31515" size=2>&quot;document.getElementById('&quot;</font><font size=2> + ReportViewer1.ClientID + </font><font color="#a31515" size=2>&quot;').ClientController.LoadPrintControl();return true;&quot;</font><font size=2>)<br><br>I need to know wether the user clicked the ok or the cancel button.<br><br>Thanks for your help!</p></font>Fri, 25 Jul 2008 22:46:36 Z2009-11-23T15:13:14Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/3ccd5cac-a0cb-47e9-9c3e-8ccb541f1a06http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/3ccd5cac-a0cb-47e9-9c3e-8ccb541f1a06kurobenkohttp://social.msdn.microsoft.com/Profile/en-US/?user=kurobenkoHow to Edit Non-Query Report Parameter to include All Possibe ValuesHello, <br/> <br/> I'm building a report to show Account names that are located in certain US states, for example CA, NY, NE, etc. <br/> <br/> However when inputting Accounts into the database, our users have been very inconsistent. Sometimes they put in 'CA' or 'California' or 'Cali'. That gives me problems when creating the Non-Query Report Parameter. Please see the picture below:<br/> <a href="http://i170.photobucket.com/albums/u277/kuroneko1313/states.jpg"><br/> http://i170.photobucket.com/albums/u277/kuroneko1313/states.jpg</a> <br/> <br/> For parameter label &quot;CA&quot;, I tried to write Value expression =&quot;CA&quot; OR &quot;California&quot; OR &quot;Cali&quot;. However, when executing the report, the parameter States will be grayed out like the picture below:<br/> <br/> <a href="http://i170.photobucket.com/albums/u277/kuroneko1313/states1.jpg">http://i170.photobucket.com/albums/u277/kuroneko1313/states1.jpg</a> <br/> <br/> Second, I tried to write Value &quot;CA&quot; OR &quot;California&quot; OR &quot;Cali&quot; (without the expression), and of course it's not returning any value.<br/> <br/> Can anyone please help me in this problem? Is there a way to overcome this issue?<br/> <br/> Thanks very much in advanced for your help in this, greatly appreciate it!<br/> <br/> <br/> -Elizabeth K.<br/> <br/> <br/>Sat, 21 Nov 2009 01:18:38 Z2009-11-23T08:20:38Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/fe61dcc6-795b-48e0-9acf-3769d7f9b139http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/fe61dcc6-795b-48e0-9acf-3769d7f9b139Anil Mujagichttp://social.msdn.microsoft.com/Profile/en-US/?user=Anil%20MujagicReportViewer and Entity FrameworkHi, <div><br/></div> <div>I'm developing an application using Entity Framework and now I want to start making reports using ReportViewer component.</div> <div>What would be the best approach: </div> <div>1. To use existing entity model objects as an Object DataSource</div> <div>2. To create a separate DataSet and use it as a DataSource in the report</div> <div><br/></div> <div>What would be the recommended approach?</div>Sun, 22 Nov 2009 00:20:16 Z2009-11-22T22:44:44Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/70c8e64f-1315-40d9-baf5-0d5021ae332fhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/70c8e64f-1315-40d9-baf5-0d5021ae332fJoe Duerohttp://social.msdn.microsoft.com/Profile/en-US/?user=Joe%20DueroReportViewer -- Client-side Event Handling for Print/Export in Local ModeIs it possible to handle events such as Printing and Exporting on the client side when using local mode?  Essentially, I would like to determine (on the client side) whether or not a report has been printed or exported.  Thanks in advance.Fri, 13 Nov 2009 19:20:16 Z2009-11-23T12:29:01Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/10a1a1f3-882c-4748-bd39-76078f3a0ad9http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/10a1a1f3-882c-4748-bd39-76078f3a0ad9Mr_Listerhttp://social.msdn.microsoft.com/Profile/en-US/?user=Mr_ListerWindows Mobile toolbox is entirely greyed outHello,<br/><br/>I have tried all of the solutions on this post and NONE of them have worked ...<br/><br/>My toolbox is still greyed out.<br/><br/>Somebody from MS please contact me and help me out.<br/><br/>Sun, 22 Nov 2009 04:07:38 Z2009-11-22T04:07:38Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/542bca77-9942-4680-8552-af3b17cfe901http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/542bca77-9942-4680-8552-af3b17cfe901JeevesIndiahttp://social.msdn.microsoft.com/Profile/en-US/?user=JeevesIndiaControls Toolbox not showing in Visual Studio 2005<span> <p>Hi,</p> <p><font face="Times New Roman">Using Microsoft Visual Studio 2005 Version 8.0.50727.42<span>  </span>(RTM.050727-4200)</font></p> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman">Microsoft .NET Framework Version 2.0.50727</font></p> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman">Installed Edition: Professional</font></p> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman">Microsoft Visual C# 2005<span>   </span>77626-009-0000007-41642</font></p> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman">Microsoft Visual C# 2005</font></p> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman">Microsoft Visual Studio 2005 Tools for Applications<span>   </span>77626-009-0000007-41642</font></p> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman">Microsoft Visual Studio 2005 Tools for Applications</font></p> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman">Microsoft Visual Web Developer 2005<span>   </span>77626-009-0000007-41642</font></p> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman">Microsoft Visual Web Developer 2005</font><font face="Times New Roman"> </font></p> <p><span style="font-size:12pt;font-family:'Times New Roman'">Toolbox does not display most of the controls </span></p><span style="font-size:12pt;font-family:'Times New Roman'"> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman">This is even after &quot;Rest Toolbox&quot;, &quot;Reset all settings&quot;, and &quot;Import selected environment settings&quot;.<span>  </span>I have also uninstalled and reinstalled three times.</font><font face="Times New Roman"> </font></p> <p><span style="font-size:12pt;font-family:'Times New Roman'">The only way it all shows up is if I do a &quot;Show All&quot; </span></p><span style="font-size:12pt;font-family:'Times New Roman'"> <p class=MsoNormal style="margin:0in 0in 0pt"><font face="Times New Roman"><span> E</span>ven  then the controls that appear on a group are still greyed out and not selectable.<span>  </span>Interestingly enough, when you go to &quot;Choose Items&quot; a given control can show up in the list multiple times.<span> T</span>he Textbox control shows up multiple time and still doesn't show up in the list even though one was selected. </font></p></span></span> <p><span style="font-size:12pt;font-family:'Times New Roman'"></span>Regards.</p></span>Wed, 05 Apr 2006 08:00:32 Z2009-11-22T04:06:23Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/cf1954b2-f576-44ea-8806-a68245a03a8ehttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/cf1954b2-f576-44ea-8806-a68245a03a8egeminigentlehttp://social.msdn.microsoft.com/Profile/en-US/?user=geminigentleHow to Search SiteDear:<br/><br/>I'm developing sites using VB 2008, I'm not an advanced programmer and I want to be able to include search field for viewers to search the sites and get the results in a page with all links result or page. I don't know how to do it and I got coffee cup program that can do this programming job, but it only accept english input and I want arabic. Therefore, is this has to be done throuhgt SQL database or crystal report or what? What would be the easiest and best way to program this with VB 2008 and the steps for doing that.<br/><br/>I hope I'm asking the right way, and I realy appreicate the help and advice.<br/><br/>Best regrads,,,<br/><br/>GeminiGentleSat, 21 Nov 2009 21:01:33 Z2009-11-21T21:01:33Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/d07ae849-3290-4855-b910-b4ddb858d4b8http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/d07ae849-3290-4855-b910-b4ddb858d4b8Roman Benkohttp://social.msdn.microsoft.com/Profile/en-US/?user=Roman%20BenkoERROR: subreport could not be shownMy main report has a subreport that has a table in it with an associated dataset.&nbsp; When I run the report, the main data displays, but the area that is supposed to show the subreport shows "subreport could not be shown".&nbsp; If I remove the table and dataset from the subreport, the headings will display.&nbsp; But as soon as I add the table and dataset back I get the error.&nbsp; I am setting the dataset for the main report and subreport before running the report.&nbsp; Does anyone have any suggestions?&nbsp; Thanks.<br />Fri, 29 Jul 2005 21:24:52 Z2009-11-21T14:42:54Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/7963a35f-bdf5-44c2-b080-9bb57f7e95ddhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/7963a35f-bdf5-44c2-b080-9bb57f7e95ddVanSeanhttp://social.msdn.microsoft.com/Profile/en-US/?user=VanSean"Access is denied" ReportViewer frame name colliding with another site's window.open()<p>I'm showing an RDLC in a ReportViewer. As one of its child controls, the ReportViewer automatically creates a frame with the name &amp; id of &quot;report&quot;. <br/><br/>There is another site (not under my control) that opens a page using the javascript window.open('','report');<br/><br/>Whenever the report viewer is open, any attempts to use this other site (in another tab of the browser) fail with an &quot;Access is Denied&quot; javascript error.<br/><br/>I assume this is because that site is trying to open a window with a name that is already in use on the ReportViewer page.<br/><br/>My question is - how can I avoid this and allow the 2nd site to open a page even when someone is viewing a report in a ReportViewer control? I cannot find any place in the ReportViewer parameters where I can override this name to be something other than &quot;report&quot;.<br/></p>Fri, 20 Nov 2009 22:09:18 Z2009-11-20T22:09:19Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/c29e929d-573a-453e-8393-0f3e86065921http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/c29e929d-573a-453e-8393-0f3e86065921randywheelerhttp://social.msdn.microsoft.com/Profile/en-US/?user=randywheelerProgrammatically Set ReportViewer Page SizeAfter spending hours with the ReportViewer (VS Standard 2008) and the forums it seems that there is no way to programmatically change a report's default page size and margins.  Suppose the program will be used worldwide.  Is the only solution for the user to have to reselect the paper size, orientation and margins every time they want to print a report if those items differ from the default?  There has to be a way to do this.  I see some talk about a fix.  Has anything been done?  Alternatively, is there another option to ReportViewer besides writing a custom report?Tue, 10 Mar 2009 20:53:45 Z2009-11-20T17:15:26Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/6e61f1a1-53a6-46c9-abdb-5f4aef680fb6http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/6e61f1a1-53a6-46c9-abdb-5f4aef680fb6Spaceman1972http://social.msdn.microsoft.com/Profile/en-US/?user=Spaceman1972Null Value in Report Viewer<span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff"><font size=2 color="#0000ff"><font size=2 color="#0000ff"> <p>hi, <br/><br/>I am passing several parameters to my local report as shown below.<br/><br/>With</p> </font></font></span><font size=2 color="#0000ff"> <p> </p> </font></span> <p><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Me</span></span><span style="font-size:x-small">.ReportViewer1.LocalReport<font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> parameters(9) </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> ReportParameter<font size=2> <p>parameters(0) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;Customer&quot;</span></span><span style="font-size:x-small">, CustomerName)<font size=2> <p>parameters(1) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;Part&quot;</span></span><span style="font-size:x-small">, Part)<font size=2> <p>parameters(2) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;ErrorCategory&quot;</span></span><span style="font-size:x-small">, ErrorCategory)<font size=2> <p>parameters(3) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;Severity&quot;</span></span><span style="font-size:x-small">, Severity)<font size=2> <p>parameters(4) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;RaisedBy&quot;</span></span><span style="font-size:x-small">, RaisedBy)<font size=2> <p>parameters(5) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;DateRaisedFrom&quot;</span></span><span style="font-size:x-small">, DateFrom)<font size=2> <p>parameters(6) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;DateRaisedTo&quot;</span></span><span style="font-size:x-small">, DateTo)<font size=2> <p>parameters(7) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;CorrectiveResp&quot;</span></span><span style="font-size:x-small">, CorrectiveResp)<font size=2> <p>parameters(8) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;PreventiveResp&quot;</span></span><span style="font-size:x-small">, PreventiveResp)<font size=2> <p>parameters(9) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;SignResp&quot;</span></span><span style="font-size:x-small">, SignResp) <p>.SetParameters(parameters)</p> <font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">With<br/><br/>The issue I have is all the parameters are from combo boxes. <br/>The data is coming from an sql database.<br/>The user can select a value from a combo box, if the user wants all values to be displayed from a certain<br/>combo box they select &quot;All Values&quot; from the list. <br/>I then place a willcard as the parameter<br/><br/>For example the parameters passed for a user selecting a parameter of part only are:<br/><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff"><font size=2 color="#0000ff"><font size=2 color="#0000ff"> <p>With</p> </font></font></span><font size=2 color="#0000ff"> <p> </p> </font></span> <p><span style="font-size:x-small;color:#000000"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Me</span></span><span style="font-size:x-small"><span style="color:#000000">.ReportViewer1.LocalReport</span><font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#008000"><span style="font-size:x-small;color:#008000">'Set the parameters</span></span></p> <span style="font-size:x-small"><font size=2> <p> </p> </font></span> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">Dim</span></span><span style="font-size:x-small"> parameters(9) </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">As</span></span><span style="font-size:x-small"> ReportParameter<font size=2> <p>parameters(0) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;Customer&quot;</span></span><span style="font-size:x-small">, &quot;*&quot;)<font size=2> <p>parameters(1) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;Part&quot;</span></span><span style="font-size:x-small">, &quot;1233456789&quot;)<font size=2> <p>parameters(2) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;ErrorCategory&quot;</span></span><span style="font-size:x-small">, &quot;*&quot;)<font size=2> <p>parameters(3) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;Severity&quot;</span></span><span style="font-size:x-small">, &quot;*&quot;)<font size=2> <p>parameters(4) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;RaisedBy&quot;</span></span><span style="font-size:x-small">, &quot;*&quot;)<font size=2> <p>parameters(5) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;DateRaisedFrom&quot;</span></span><span style="font-size:x-small">, &quot;*&quot;)<font size=2> <p>parameters(6) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;DateRaisedTo&quot;</span></span><span style="font-size:x-small">, &quot;*&quot;)<font size=2> <p>parameters(7) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;CorrectiveResp&quot;</span></span><span style="font-size:x-small">, &quot;*&quot;)<font size=2> <p>parameters(8) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;PreventiveResp&quot;</span></span><span style="font-size:x-small">, &quot;*&quot;)<font size=2> <p>parameters(9) =</p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">New</span></span><span style="font-size:x-small"> ReportParameter(</span><span style="font-size:x-small;color:#a31515"><span style="font-size:x-small;color:#a31515">&quot;SignResp&quot;</span></span><span style="font-size:x-small">, &quot;*&quot;) <p>.SetParameters(parameters)</p> <font size=2> <p> </p> </font></span></p> <p><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">End</span></span><span style="font-size:x-small"> </span><span style="font-size:x-small;color:#0000ff"><span style="font-size:x-small;color:#0000ff">With<br/><br/>When the report is run I only get 10 records. There are 30 in the database. After analyising the data I found that <br/>fields in the database that have a null value are not being displayed. The wilcard character doesn't pick out null<br/>fields.<br/>Is there a way to do this?<br/><br/>regards<br/>Mark</span></span></p> </span></span></p>Fri, 20 Nov 2009 09:20:40 Z2009-11-20T09:20:40Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/1267815a-2c50-4abf-9b0b-9567a78c5f0fhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/1267815a-2c50-4abf-9b0b-9567a78c5f0fJ-Balhttp://social.msdn.microsoft.com/Profile/en-US/?user=J-Balout of memory error in displaying reportsI am getting an out of memory error when rendering a report using Report Viewer. The error is as follows:<br/><br/>An error occurred during local report processing<br/>An error occured during rendering of the report<br/>Out of memory<br/><br/>I am using VS 2008. There IS an image on the report. <br/><br/>Is there a setting I need to change or code I need to add to VS2008 to make this work? <br/><br/>Any help is appreciated.<br/><br/>thanks.  Thu, 19 Nov 2009 20:34:55 Z2009-11-19T20:34:56Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/28343c3c-814f-4e64-b7f4-6ebb0c5e3c16http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/28343c3c-814f-4e64-b7f4-6ebb0c5e3c16Junior_luizhttp://social.msdn.microsoft.com/Profile/en-US/?user=Junior_luizcompare fields between two objctdatasource in a report<span class="long_text"><span style="background-color:#fff" title="Tenho um report que tem dois objectdatasource o objectdatasource1 trás resultado de uma storage procedure no database sql2005, enquanto o objectdatasource2 trás o resultado de uma query no databse oracle.">I have a report that has two objectdatasource ObjectDataSource1 back the result of a storage procedure in sql2005 database, while objectdatasource2 back the result of a query in oracle database.<br/><br/></span><span style="background-color:#fff" title="Quero comparar o campo id_emp do objectdatasource1 com o campo ent_id do objectdatasource2.">I want to compare the field id_emp the ObjectDataSource1 with the field ent_id of objectdatasource2.<br/><br/></span><span style="background-color:#fff" title="Sendo que no campo do report em expressão clico em fields(objectdatasource1) e me mostra os campos do storage.">Since the field of the report click on words in fields (ObjectDataSource1) and shows me the fields of storage. </span><span style="background-color:#fff" title="mais para eu ter alguma referencia aos campos do objectdatasource2 tenho que clicar na opção dataset e ele trás os campos do objectdatasource2 mais com valores de agregação ou seja todos os campos como por exemplo : sum(int_id)">more for me to have some reference to the fields of objectdatasource2 have to click the option dataset and he brings the fields of objectdatasource2 more with aggregate values ie all fields such as: sum (int_id)<br/><br/></span><span style="background-color:#fff" title="Se deleto o sum dá erro.">If I delete the sum gives error.<br/><br/></span><span style="background-color:#fff" title="minha duvida é como posso comparar dois campos entre dois objectdatasource distintos">My doubt is how can I compare two fields from two different objectdatasource<br/><br/></span><span title="por favor ajudem-me">please help me</span></span><hr class="sig">JuniorThu, 19 Nov 2009 18:11:59 Z2009-11-19T18:11:59Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/e156b79d-0db2-472b-a2f5-ba2fd143f45dhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/e156b79d-0db2-472b-a2f5-ba2fd143f45dMichael Hesterhttp://social.msdn.microsoft.com/Profile/en-US/?user=Michael%20Hestercan't locate Microsoft.Reporting.WebForms<p>Hello,</p> <p> </p> <p>I have a licensed version of Visual Studio 2005 and SQL Server 2005. I'm new to C# but not necessarily new to object-oriented programming.  My first assignment is to use the ReportViewer to allow company users to run remote reports on our webserver.</p> <p> </p> <p>My C# code won't compile due to the problem of missing the Microsoft.Reporting.WebForms component.  Where is this component supposed to come from?</p> <p> </p> <p>I've been going round and round in the doc for several days now.  Any hints or suggestions would be appreciated.  This is very similar to a problem posted by &quot;Jonas&quot; and answered by Albert Yen on 15 Nov 2006.  Albert's answer *almost* made sense to me--except for the fact he asked if Jonas was building a: &quot;web site project or a web application project?&quot;  That's a distinction that evidently escapes me as well.  </p> <p> </p> <p>The ReportViewer was extracted and installed on our web server, so I believe that the problem is merely a missing module/assembly (whatever you call it) on my Windows XP machine.</p> <p> </p> <p>Sorry for the neophyte aspect of this.  Have been looking on forums, but haven't seen the answer yet.  My reference books make no mention of the ReportViewer whatsoever.</p> <p> </p> <p>Cheers,</p> <p>Michael Hester</p>Tue, 24 Apr 2007 15:24:58 Z2009-11-19T17:36:14Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/1b745b2b-b854-4244-8e73-756b078ffc2chttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/1b745b2b-b854-4244-8e73-756b078ffc2cJunior_luizhttp://social.msdn.microsoft.com/Profile/en-US/?user=Junior_luizbuy fields between two objectdatasource<span class="long_text"><span style="background-color:#fff" title="tenho um objectdatasource que é ligado a uma storage procedure no sql2000 e tenho outro objectdatasource que é ligado e uma query no oracle, preciso comparar um campo nos dois objectdatasource mais nao é permitido pois os campos do objetdatasource do oracle so sao mostrados com o sum e">I have a ObjectDataSource which is connected to a storage procedure in sql2000 objectdatasource and have another that is connected and a query in Oracle, one must compare the two field objectdatasource more is not permitted because the fields objetdatasource Oracle so are shown with the sum and </span><span style="background-color:#fff" title="não como field e quero comparar campos e não soma de campos.">not as a field and want to compare fields and not the sum of fields.<br/><br/><span style="background-color:#fff" title="so me é permitido fazer essa expressão :">so I may make this expression:<br/><br/><span style="font-size:x-small"><font size=2> <p>=iif(Sum(Fields!cdempr.Value,</p> </font></span> <p><span style="color:#a31515;font-size:x-small"><span style="color:#a31515;font-size:x-small">&quot;Report_Tb_CCen_AtendimentoEmpresa&quot;</span></span><span style="font-size:x-small">)=Sum(Fields!ENT_ID.Value, </span><span style="color:#a31515;font-size:x-small"><span style="color:#a31515;font-size:x-small">&quot;oracle_DataTable1&quot;</span></span><span style="font-size:x-small">),Sum(Fields!QTD.Value, </span><span style="color:#a31515;font-size:x-small"><span style="color:#a31515;font-size:x-small">&quot;oracle_DataTable1&quot;</span></span><span style="font-size:x-small">),0)</span></p> <span style="background-color:#fff" title="se retiro o sum dá erro">retreat to the sum gives error</span><br/></span><br/></span></span><hr class="sig">JuniorThu, 19 Nov 2009 12:51:33 Z2009-11-19T12:51:33Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/f91b93d1-20f5-4bee-a2e4-d7f64b897a3dhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/f91b93d1-20f5-4bee-a2e4-d7f64b897a3dGudni G. Sigurdssonhttp://social.msdn.microsoft.com/Profile/en-US/?user=Gudni%20G.%20SigurdssonShow/Hide parts of a reportHi.<br/>I have a client report (*.rdlc) showing data from a few tables in as many list controls.  This works OK.    I also have headings in my report (like: 'Data From Table A', ...), which I place outside the list controls.  If a certain table does not have any rows, the corresponding list control is not shown.  In this case, I also do not want to display the corresponding heading.  My question is: can I hide the heading?  Is there a report event that I can use for this and exactly how would I do this?<br/><hr class="sig">Gudni G. SigurdssonThu, 19 Nov 2009 09:41:46 Z2009-11-19T09:41:46Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/99357ade-75ac-47e2-8633-807bcabb8d67http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/99357ade-75ac-47e2-8633-807bcabb8d67rschmitzhttp://social.msdn.microsoft.com/Profile/en-US/?user=rschmitzsaved shared data source credentials lost after restartI recently installed Service Pack 3 for SQL Server 2005, and now my saved credentials for my shared data sources in my Reporting Services project are gone every time I restart my computer. I have to enter the specific User Name and Password into the Credentials tab every day for each shared data source. This problem never occurred before I installed SQL Server 2005 SP3, and now my co-workers are afraid to install it on their machines. The server already has SP3 installed. What do I need to do to fix this problem?Wed, 06 May 2009 18:33:00 Z2009-11-19T05:04:22Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/6438ba78-ac92-42e2-96d9-5c21b304f766http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/6438ba78-ac92-42e2-96d9-5c21b304f766Ramya1__http://social.msdn.microsoft.com/Profile/en-US/?user=Ramya1__Showing multiple reports with one report viewer control.<p align=left><font face=Arial size=2></font> </p> <p>Hi,</p> <p align=left>I am developing a windows application to display multiple reports based on the selected criteria. On my windows form, I have a report viewer control and a combo box to select criteria to show the reports. I designed two reports(.rdlc files). I added the report viewer control and from the report viewer tasks selected the first report. But at run time, when the user selects a different item in the combo box, i am writing the following code to redirect to a  different report.</p> <p align=left> </p> <p align=left><font size=2>I am using the same datasource for both the reports, with the below code, i get the error </font></p> <p align=left><font size=2>&quot;A data source instance has not been supplied for the datasource DealRatesDS_T_PER_UNIT_RBT_DLRS.&quot;</p></font> <p align=left> </p><font size=2> <p>Microsoft.Reporting.WinForms.</font><font color="#008080" size=2>ReportDataSource</font><font size=2> reportDataSource = </font><font color="#0000ff" size=2>new</font><font size=2> Microsoft.Reporting.WinForms.</font><font color="#008080" size=2>ReportDataSource</font><font size=2>();</font></p> <p align=left><font size=2> </p></font><font size=2><font color="#0000ff" size=2> <p>if</font><font size=2> (ultraComboEditor1.Value.ToString() == </font><font color="#800000" size=2>&quot;PSR&quot;</font><font size=2>)</p> <p>{</p> <p>reportViewer1.Reset();</p> <p></font><font color="#0000ff" size=2>this</font><font size=2>.reportViewer1.LocalReport.ReportEmbeddedResource = </font><font color="#800000" size=2>&quot;DEALSUI.Report1.rdlc&quot;</font><font size=2>;</p> <p>reportDataSource.Name = </font><font color="#800000" size=2>&quot;T_PER_UNIT_RBT_DLRSBindingSource&quot;</font><font size=2>;</p> <p>reportDataSource.Value = </font><font color="#0000ff" size=2>this</font><font size=2>.T_PER_UNIT_RBT_DLRSBindingSource;</p> <p>reportViewer1.LocalReport.DataSources.Add(reportDataSource);</p> <p>}</p> <p></font><font color="#0000ff" size=2>else</p></font><font size=2> <p>{</p> <p>reportViewer1.Reset();</p> <p></font><font color="#0000ff" size=2>this</font><font size=2>.reportViewer1.LocalReport.ReportEmbeddedResource = </font><font color="#800000" size=2>&quot;DEALSUI.Report2.rdlc&quot;</font><font size=2>;</p> <p>reportDataSource.Name = </font><font color="#800000" size=2>&quot;T_PER_UNIT_RBT_DLRSBindingSource&quot;</font><font size=2>;</p> <p>reportDataSource.Value = </font><font color="#0000ff" size=2>this</font><font size=2>.T_PER_UNIT_RBT_DLRSBindingSource;</p> <p>reportViewer1.LocalReport.DataSources.Add(reportDataSource);</p> <p>}</p> <p></font><font color="#0000ff" size=2>this</font><font size=2>.reportViewer1.RefreshReport();</font></p> <p align=left> </p> <p align=left>Please help me out with this problem. Thanks in advance....</p> <p align=left><font size=2></font> </p><font size=2></font></font>Fri, 04 Apr 2008 16:48:49 Z2009-11-18T22:01:41Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/bce244c4-f8fe-4b60-a98a-92cb60cd2223http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/bce244c4-f8fe-4b60-a98a-92cb60cd2223Christopher Kellerhttp://social.msdn.microsoft.com/Profile/en-US/?user=Christopher%20KellerImage and UNC pathI am having an issue with showing an image in an RDLC report in my Windows VB.Net 2008 application.<br><br>I reviewed this post:  http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/f28ec1db-0cd4-4b24-8c3b-1c75fec03167/, but this does not solve my problem (or so I think).<br><br>I have the full path to the photo stored in my database table (ie. \\server\sharename\image1.jpg).  The path is using a UNC path.  When I run my report on various test systems, the report displays the images perfectly.<br><br>When my application is installed at my clients office, the reports all show a red X in place of the image.  All users have access to the UNC share.  They are able to read, write, modify, and delete files from this share through my application but the reports will not show the image.  There is no report server, and all reports are RDLC reports.  I have .LocalReport.EnableExternalImages = True.  <br><br>I do not understand why the Report will not show the images at my client's office when everything works fine in my office.  <br><br>Does report viewer store a cache anywhere on the local system and is unable to read from the cache due to security permissions?  Is there another account that is invoked when using the ReportViewer Control that would need access to this share?  I am at a loss as to why this does not work. <br><br>Any help would very much be appreciated.<br>Tue, 17 Mar 2009 16:49:27 Z2009-11-18T19:48:55Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/bd5ff593-bd31-45cd-b500-947997884eb3http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/bd5ff593-bd31-45cd-b500-947997884eb3TheKevDoghttp://social.msdn.microsoft.com/Profile/en-US/?user=TheKevDogRunning RDLC Results in "Operation May Destabilize the Runtime"This is the sum total of the message that is displayed when attempting to generate a report: <div><br/></div> <div> <ul> <li style="font-family:Verdana;font-size:8pt;font-weight:normal">Failed to load expression host assembly. Details: Operation could destabilize the runtime.</li> </ul> <span style="font-family:Verdana">I have no idea which assembly it is referring to, nor where it goes. It might not even be a RDLC error. There doesn't seem to be any unambiguous guidance on what causes this error.</span></div> <div><br/></div> <div><span style="font-family:Verdana">I wish I had more to go on here. Anybody have anything? </span></div>Wed, 18 Nov 2009 18:39:09 Z2009-11-18T18:39:10Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/99bdef68-6c98-4295-9cbf-a157a4bc32aahttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/99bdef68-6c98-4295-9cbf-a157a4bc32aaTheKevDoghttp://social.msdn.microsoft.com/Profile/en-US/?user=TheKevDogRDLC Won't Render in Internet Explorer, But Does in Other Browsers<p>Developing in VS2008, with .Net 3.5, C#, WebApplicationProject.<br/><br/>To Reproduce:<br/><br/>1. When calling a RDLC using Internet Explorer 8 (either in or out of compatibility mode), the report shell is present, but there is no data visible within the frame. Also, there are no page numbers that would imply that data is being received by the report.<br/><br/>2. When calling the same RDLC using Chrome, Firefox, and Safari. I get the proper data.<br/><br/>3. When in IE, if I select to export (either to Excel or to PDF), I get the proper data.<br/><br/>Steps:<br/><br/>I've tried to eliminate any kind of CSS problem by putting the control on a completely blank page.<br/>All required dll's are present on the server in question.<br/><br/><strong>Update: </strong>This seems to be related to a security problem. Outside of the local domain, the RDLC renders properly. This is a very old app that we are modifying that is using forms authentication. Don't know how to solve the problem yet, but I know where to start looking.</p>Wed, 18 Nov 2009 16:13:17 Z2009-11-18T16:13:18Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/7e936927-3cd4-4bbd-bf70-92339091ef15http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/7e936927-3cd4-4bbd-bf70-92339091ef15Swaykidhttp://social.msdn.microsoft.com/Profile/en-US/?user=SwaykidRDL/RDLC Programatically insert image at runtime. Image shows in design but not in report viewerHi, <br/><br/>My requirements are to create a dynamic header image that is generated at the moment of running the report. <br/><br/>I have managed to do this with a comination of XMLDocument, creating images converting the images to base64, inserting them in the XML.<br/><br/>Everything works to a point. In the rdlc file that I generate with the embedded image, if I view this in VS2008, I can see the new image. The XML renders fine. <br/><br/>In the report viewer however I get a blank image. The header adjusts to the correct size, and everything appears to work. Except for the image.<br/><br/>Enable external images is true just for testing. Makes no difference. I have also tried using an external image but to no avail. Same behaviour.<br/><br/>Any ideas?<br/><br/>PageHeader Tag from RDLC with Image<br/><br/>  &lt;PageHeader&gt;<br/>    &lt;PrintOnFirstPage&gt;true&lt;/PrintOnFirstPage&gt;<br/>    &lt;ReportItems&gt;<br/>      &lt;Textbox Name=&quot;textbox12&quot;&gt;<br/>        &lt;rd:DefaultName&gt;textbox12&lt;/rd:DefaultName&gt;<br/>        &lt;Style&gt;<br/>          &lt;FontSize&gt;7pt&lt;/FontSize&gt;<br/>          &lt;TextAlign&gt;Left&lt;/TextAlign&gt;<br/>          &lt;PaddingLeft&gt;2pt&lt;/PaddingLeft&gt;<br/>          &lt;PaddingRight&gt;2pt&lt;/PaddingRight&gt;<br/>          &lt;PaddingTop&gt;2pt&lt;/PaddingTop&gt;<br/>          &lt;PaddingBottom&gt;2pt&lt;/PaddingBottom&gt;<br/>        &lt;/Style&gt;<br/>        &lt;ZIndex&gt;1&lt;/ZIndex&gt;<br/>        &lt;CanGrow&gt;true&lt;/CanGrow&gt;<br/>        &lt;Left&gt;16cm&lt;/Left&gt;<br/>        &lt;Height&gt;0.5cm&lt;/Height&gt;<br/>        &lt;Value&gt;= &quot;Fecha: &quot; &amp;amp; Day(Globals!ExecutionTime)&amp;amp; &quot;/&quot; &amp;amp; Month(Globals!ExecutionTime)&amp;amp; &quot;/&quot; &amp;amp; Year(Globals!ExecutionTime)&lt;/Value&gt;<br/>      &lt;/Textbox&gt;<br/>      &lt;Textbox Name=&quot;textbox15&quot;&gt;<br/>        &lt;Top&gt;4.75cm&lt;/Top&gt;<br/>        &lt;Style&gt;<br/>          &lt;Color&gt;RoyalBlue&lt;/Color&gt;<br/>          &lt;BackgroundColor&gt;Ivory&lt;/BackgroundColor&gt;<br/>          &lt;BorderColor&gt;<br/>            &lt;Default&gt;Blue&lt;/Default&gt;<br/>          &lt;/BorderColor&gt;<br/>          &lt;BorderStyle&gt;<br/>            &lt;Bottom&gt;Solid&lt;/Bottom&gt;<br/>          &lt;/BorderStyle&gt;<br/>          &lt;BorderWidth&gt;<br/>            &lt;Default&gt;2pt&lt;/Default&gt;<br/>          &lt;/BorderWidth&gt;<br/>          &lt;FontWeight&gt;700&lt;/FontWeight&gt;<br/>          &lt;TextAlign&gt;Left&lt;/TextAlign&gt;<br/>          &lt;PaddingLeft&gt;2pt&lt;/PaddingLeft&gt;<br/>          &lt;PaddingRight&gt;2pt&lt;/PaddingRight&gt;<br/>          &lt;PaddingTop&gt;2pt&lt;/PaddingTop&gt;<br/>          &lt;PaddingBottom&gt;2pt&lt;/PaddingBottom&gt;<br/>        &lt;/Style&gt;<br/>        &lt;CanGrow&gt;true&lt;/CanGrow&gt;<br/>        &lt;Value&gt;FICHA DATOS DE EMPRESA&lt;/Value&gt;<br/>      &lt;/Textbox&gt;<br/>      &lt;Image Name=&quot;imganagrama&quot; xmlns=&quot;&quot;&gt;<br/>&lt;Sizing&gt;FitProportional&lt;/Sizing&gt;&lt;Top&gt;0cm&lt;/Top&gt;<br/>&lt;Width&gt;21cm&lt;/Width&gt;<br/>&lt;MIMEType&gt;image/jpeg&lt;/MIMEType&gt;<br/>&lt;Source&gt;Embedded&lt;/Source&gt;<br/>&lt;Style /&gt;<br/>&lt;ZIndex&gt;1&lt;/ZIndex&gt;<br/>&lt;Left&gt;0cm&lt;/Left&gt;<br/>&lt;Height&gt;4.0cm&lt;/Height&gt;<br/>&lt;Value&gt;anagrama&lt;/Value&gt;<br/>&lt;/Image&gt;<br/>&lt;/ReportItems&gt;<br/>    &lt;Height&gt;5.38492cm&lt;/Height&gt;<br/>    &lt;PrintOnLastPage&gt;true&lt;/PrintOnLastPage&gt;<br/>  &lt;/PageHeader&gt;<br/><br/><br/>EMBEDDED IMAGE TAG<br/>  &lt;EmbeddedImages xmlns=&quot;&quot;&gt;<br/>&lt;EmbeddedImage Name=&quot;anagrama&quot;&gt;<br/>&lt;MIMEType&gt;image/jpeg&lt;/MIMEType&gt;<br/>&lt;ImageData&gt;base64data&lt;/ImageData&gt;<br/>&lt;/EmbeddedImage&gt;<br/>&lt;/EmbeddedImages&gt;<br/><br/><br/><br/>Tue, 17 Nov 2009 16:24:06 Z2009-11-18T09:21:11Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/138682c5-f13b-45ab-874f-36599982c9f2http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/138682c5-f13b-45ab-874f-36599982c9f2Barry Gilberthttp://social.msdn.microsoft.com/Profile/en-US/?user=Barry%20GilbertRDLC Data Sources crashes VSI have a bunch of rdlc reports that were originally created in VS 2005. When I try to design them in VS 2008 and click on Reports&gt; Data Sources, the IDE thinks for a few seconds and then crashes. I've tried reinstalling Visual Studio. No luck. I've tried manually editing the data sources in the xml, but it never seems to work correctly. I'm using VS2008, SP1.Tue, 04 Aug 2009 19:10:13 Z2009-11-18T07:05:45Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/03e35e4b-0495-4b95-b278-de5c4ce054b4http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/03e35e4b-0495-4b95-b278-de5c4ce054b4Adam St. Pierrehttp://social.msdn.microsoft.com/Profile/en-US/?user=Adam%20St.%20PierreSend Report directly to a printer from Report Viewer WITHOUT Print Dialog<p align=left><font face=Arial size=2></font> </p> <p align=left>Hello, everyone!<br><br>I'm attempting to find a way to automatically generate SRS reports in VB .NET and then send those generated reports directly to the printer.<br><br>Now I can call ReportViewer and generate reports, site unseen. I can even save those as a PDF if I want.<br><br>What I CAN NOT do is send them to a network printer. Does anyone know how this can be done?<br><br>Thanks!</p>Wed, 01 Aug 2007 17:11:25 Z2009-11-17T21:32:01Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/fc5d86c9-f9b0-4fd6-8c90-019c357329a3http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/fc5d86c9-f9b0-4fd6-8c90-019c357329a3N11689http://social.msdn.microsoft.com/Profile/en-US/?user=N11689ReportViewer Export - Is there a way to enable the user to Open, Save or Cancel vs. just Save?We are using the ReportViewer in our VB.NET 2005 app to generate an SSRS report.<br/><br/>In SSRS Report Manager.  when Export is selected, a window pops up prompting to Open, Save or Cancel.<br/>If they open, the report is open in the format selected.  The user then has the ability to Email from the<br/>format option (Excel, PDF, etc.).<br/><br/>In ReportViewer, when exporting, the only option is to save.  Is there a way to have the ReportViewer<br/>prompt to Open the file in the the app of this selected format and the user can then email from within<br/>that app?<br/>Tue, 17 Nov 2009 20:26:05 Z2009-11-17T21:12:04Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/2873dbf0-9612-483c-bc77-1b77edd118b3http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/2873dbf0-9612-483c-bc77-1b77edd118b3Alizee Hayekhttp://social.msdn.microsoft.com/Profile/en-US/?user=Alizee%20HayekRun time report designing by end user.Hello Experts,<br/>                          I am looking for any runtime report designer which supports right to left text. Recently i used XtraReport by devexpress but its not working with arabic language (rtl). If anybody familiar with any other runtime end user report designer plz share that. I am using VS2008 + sqlserver 2005/2008 + visiual basic.<br/> Thanx In advance.<br/> <br/> Alizee Hayek.<br/>Tue, 17 Nov 2009 19:37:21 Z2009-11-20T08:11:37Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/896fc72b-1350-4d4b-86f2-66f77a3abe90http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/896fc72b-1350-4d4b-86f2-66f77a3abe90upnorthflyerhttp://social.msdn.microsoft.com/Profile/en-US/?user=upnorthflyerReport Viewer control missing smart tagI have a WinForms application with several report viewers that are functioning. I am creating a new form and adding a report. I created the Windows Form, basic report (.rdlc), and added the data adapters. To verify data binding, I added a grid view on the form to make sure the data is loading. I then drag the Report Control from the toolbox onto the form. However, there is no smart tag on the ReportViewer control!!! I looked at the other forms and they also are missing smart tags only on the ReportViewer control - they are present on all the data adapters. What is wrong with my developer? How do I configure the ReportViewer without the smart tag? I have looked at the 'designer' code from the other viewer forms and could attempt to duplicate but would rather not. I am using VS 2008, SP1, vers 3.5Tue, 17 Nov 2009 19:28:21 Z2009-11-17T19:28:23Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/8be5bafc-b0ef-4efa-a0a1-5766c4acd8e0http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/8be5bafc-b0ef-4efa-a0a1-5766c4acd8e02000MPHhttp://social.msdn.microsoft.com/Profile/en-US/?user=2000MPHLocalReport.Render PDF unexpected mailto link issueHi All<br/> <br/> I have som code that renders a RDLC report as PDF file and its working great except for one issue. One section of text I have in the report contains an @ symbol but not within an email address it's used to show value rate like 150@10.00p/unit <br/> <br/> However when I generate the PDF and open it up in Adobe Reader and hover over that section of text I get a mailto link (mailto:150@10.00p/unit) that when clicked opens an outlook new e-mail window.<br/> <br/> I'm not positive if this is a problem with how the report is rendered or is an issue with how Adobe Reader is displaying the file, but I have searched online and found nothing about a similar problem with either, so any help from anyone in here would be very welcome. <br/> <br/> Thanks, <br/> <br/> MPH.<br/> <br/>Tue, 17 Nov 2009 16:20:23 Z2009-11-17T16:20:23Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/c2e0b2ed-7b47-4964-8737-5b67f230871bhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/c2e0b2ed-7b47-4964-8737-5b67f230871bI am a new guyhttp://social.msdn.microsoft.com/Profile/en-US/?user=I%20am%20a%20new%20guyCan we show all the records in a single page in Microsft report Viewer instead of using page navigationHi I need to show all the records no matter how large data it is, in a single page, instead of showing it in different pages of Microsoft Report Viewer. Please help me if it is possible to do<br/> <br/> ThanksTue, 17 Nov 2009 06:09:29 Z2009-11-18T06:31:43Zhttp://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/cd33b21a-7231-4686-bf1b-06d24e9f68c4http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/cd33b21a-7231-4686-bf1b-06d24e9f68c4purtmanhttp://social.msdn.microsoft.com/Profile/en-US/?user=purtmanNeed to remove blank space on pages where Header should not printI am writing a report for a Fax process.  There is a cover page with the total number of pages and then subsequent pages with a table that produces the details from a table.  However, I've set up the cover page to be part of the header.  It's the only way I know of to capture the GlobalVariable &quot;Total Pages&quot;.  I only want the cover page to print once.  The problem is that the blank space left by where the header is appears on every page.  How do I eliminate this extra space on all of the detail pages.  I can't change the height of the header because that doesn't work.<br/> How do we eliminate this white space on the extra pages?  Trying to capture the Total Pages in a variable doesn't work either.<br/> Thanks!<br/>  <hr class="sig">Matthew PurtillWed, 11 Nov 2009 16:08:47 Z2009-11-17T03:24:45Z