.net - Chart Control Inside SSRS ReportViewer Is Viewable From Localhost But Not Internet?
Feb 24, 2010
A project I own was just moved from an older server to a new one, and in the process of moving the web folder, re-deploying the SSRS reports, restoring the database, configuring IIS, etc... I have lost the ability to view the Microsoft Chart Controls that are embedded in the SSRS reports, that are then displayed by a Microsoft.ReportViewer.
I could view them both locally and remotely (via the internet) on the old server. I can view them if I preview the SSRS report in Visual Studio. The report displays fine, only missing all the embedded charts. I can still view them locally through the web browser, just not from the internet.
I tried giving permissions to the ChartImageHandler temp storage folder, but it didn't work.
I'm getting the Javascript error: Error: ClientReport380ec8ca0c294a809e9986c1bef9db1c is undefined
View 4 Replies
Similar Messages:
Jan 13, 2011
I am getting "ASP.NET Session Expired" error when viewing SQL Server 2008 reports using the Microsoft ReportViewer web control. I found this article http://balanagaraj.wordpress.com/2009/09/25/session-has-expired-in-asp-net/ which suggests to use one worker process in IIS application pool, but that may affect performance, is there any other solution for this? I tried setting "AsyncRendering" to false already and that didn't work.
View 2 Replies
Oct 31, 2010
How to access report services from localhost on my mahcine? Is there any web interface provided for SQL Server Reporting Services 2008? If so how can i do that and what is the URL?
View 2 Replies
Mar 27, 2011
I have installed teampulse http://www.telerik.com/team-productivity-tools.aspx community. I add in bindings my domain name with port 9898 like it is with localhost. I can connect through localhost but not throuh the domain
View 1 Replies
Apr 15, 2010
iam using c#,asp.net and iis, i want to simulate slow internet connection on my pc for testing my app. is it possible i can control bandwidth of iis. System.Threading.Thread.Sleep(someDuration); in c# file.
View 3 Replies
Dec 29, 2010
I have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.
1) Set up new user? What permissions are required?
2) Configure SSRS to for external connections?
3) Firewall?
View 2 Replies
Mar 26, 2010
Starting to look into an web app thet uses the ReportViewer to display SSRS reports. This is for SSRS 2008. What would be the best way to go about the follwoing: The reports are sales reports so only ceratin people will get to see certain reports.
1: If a user opens a report which they can see and that report has a subreport which they can't, will the subreport still be viewable?
2: If the webapp will be used by many different people internally and eventually by outside people, what is the best security startegy to use, just plain ServerReportCredentials passing, or something else?
View 1 Replies
Jan 21, 2010
I have an SSRS report that has a Comments field where there's enough text to span multiple rows per record. It renders fine in the ASP.Net ReportViewer control, but when it's exported the formatting can be different. Exporting to Word it looks fantastic. But exporting to Excel and PDF, the row height for each record is never increased beyond the default, so the text just gets truncated. In Excel I can go in and double-click on individual or multiple row heights to fix them, but this is an extra step we don't want.
View 2 Replies
Nov 15, 2010
I am having an issue with my reportviewer where nothing is visible, not even the control. If I add other content, it shows, but the reportviewer is not. I am using the 9.0.0.0 version of the control with SSRS 2005 inside an MVC 2.0 application. I have built and deployed the report to the server. I have confirmed by looking on the report server and running it there.
My app is MVC 2.0
I have added a regular webforms page into the root of the website. I put it in a form, runat=server, and enabled viewstate. I have added the .aspx routing exception My code behind is set up similarly to every example I can find. My webconfig is configured (maybe that is where my issue is) I set up a manual test by forcing the correct values in and I get the same blank page. I have a reference to the 9.0.0.0 versions of Microsoft.ReportViewer.WebForms and Microsoft.ReportViewer.Common and as you can see my web.config matches my references.
The page appears white - no control is visible. No errors are thrown. As I remembered it, there should at least be a blank Reportviewer control on the page, however there isn't anything there at all.
A few other oddities - If I remove the parameter setting, no error occurrs. I also added code to send in credentials, but that did not work, even when sending in the credentials for the administrator account.
Report.aspx
<%@ Page Language="C#" AutoEventWireup="true" ViewStateMode="Enabled" CodeBehind="Report.aspx.cs" Inherits="MySite.Web.Report" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<html>
<body>
<form id="form1" runat="server">
<rsweb:ReportViewer ID="reportViewer" EnableViewState="True" runat="server" />
</form>
</body>
</html>
Routing Exceptions
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.IgnoreRoute("{resource}.aspx/{*pathInfo}");
Code Behind
protected void Page_Load(object sender, EventArgs e)
{
var qs = ReportQueryString.Parse(Request.QueryString["R"]);
reportViewer.ServerReport.ReportServerUrl = ConfigurationHelper.Reports.ReportServerUrl;
reportViewer.ServerReport.ReportPath = String.Format(ConfigurationHelper.Reports.ReportPath, qs.ReportName);
var result = from p in qs.Parameters
select new ReportParameter(p.Key, p.Value);
reportViewer.ServerReport.SetParameters(result);
reportViewer.ServerReport.Refresh();
}
Web.config
<compilation debug="true" targetFramework="4.0">
<assemblies>
<add assembly="System.Web.Abstractions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Web.Routing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
<add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
</assemblies>
<buildProviders>
<add type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" extension=".rdl" />
</buildProviders>
</compilation>
<pages>
<namespaces>
<add namespace="Microsoft.Web.Mvc" />
<add namespace="System.Web.Mvc" />
<add namespace="System.Web.Mvc.Ajax" />
<add namespace="System.Web.Mvc.Html" />
<add namespace="System.Web.Routing" />
<add namespace="System.Drawing" />
</namespaces>
</pages>
<httpHandlers>
<add type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" path="Reserved.ReportViewerWebControl.axd" verb="*" />
</httpHandlers>
EDIT:
As requested, here is the page source. On a side note, I am using Chrome, but I did try IE with the same result.
<html>
<body>
<form method="post" action="Report.aspx?R=rYeJ28xc7emx1PJPgiRkOi1lXjmmNE6pF7aJrEJ443w*" id="form1">
<div class="aspNetHidden">
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTE0NzMwNTUwMTgPZBYCAgEPZBYCAgEPFCsABA8WAh4OUmVuZGVyaW5nU3RhdGULKZUBTWljcm9zb2Z0LlJlcG9ydGluZy5XZWJGb3Jtcy5SZXBvcnRSZW5kZXJpbmdTdGF0ZSwgTWljcm9zb2Z0LlJlcG9ydFZpZXdlci5XZWJGb3JtcywgVmVyc2lvbj05LjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWIwM2Y1ZjdmMTFkNTBhM2ECZCgpWFN5c3RlbS5HdWlkLCBtc2NvcmxpYiwgVmVyc2lvbj00LjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWI3N2E1YzU2MTkzNGUwODkkOTQ5NWQxOTEtMmVmMy00OTJlLTk1ZTgtMzRhZDBkYWI4ZGM4AgEUKwABFCsAAgIBZBYKZg8PFgIeB1Zpc2libGVoZGQCAQ8PFgIfAWhkFgICCA8PFgIfAWhkZAIGDxYCHgVWYWx1ZQUBMGQCBw8WAh8CBQVmYWxzZWQCCA8WAh8CBQVmYWxzZWRkvlE8tEXOwYRIWVLykp+GFwUxbrW+MAtpUdojqbM994U=" />
</div>
<script src="/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=9.0.30729.4402&Name=Microsoft.Reporting.WebForms.Scripts.ReportViewer.js" type="text/javascript"></script>
<div class="aspNetHidden">
<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" />
<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" />
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="/wEWBgLgrv+UCwL8sqiiBgL8sqyiBgL8srCiBgL8srSiBgL8stiiBkbkdSlUJxfVD65mS2OQpfO01z367cPQhXOdmZguuzmc" />
</div>
<div id="reportViewer" style="display:inline-block;height:400px;width:100%;">
<Script language="javascript"><!--
if (document.getElementById('reportViewer') != null)
{
document.getElementById('reportViewer').ClientController = new RSClientController("reportViewer_ctl03", "ReportFramereportViewer", "/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=b003c2a678b44c71b949617a693d4f8c&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=DocMapArea&Controller=reportViewer&RootLabel=&BackColor=%23ECE9D8&Border=1px+Black+Solid&Font=font-family%3aVerdana%3bfont-size%3a8pt%3b", "25%", false, "/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=2558c6ccaa09444ea46bd3062bc553dd&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=ReportArea&Controller=reportViewer&LinkTarget=_top", true, true, true, true, true, true, "reportViewer_ctl06", false, "/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=66fb690f271c48d59bc881cd0f07421d&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=Export&FileName=&ContentDisposition=OnlyHtmlInline&Format=", "PrintFramereportViewer", "/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=c1c1698c78c7476b8a04e03424d3a36c&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=PrintHtml", "reportViewer_ctl07", "reportViewer_ctl00", "reportViewer_ctl08");
document.getElementById('reportViewer').ClientController.PostBackAction =
function(actionType, actionParam)
{
document.getElementById("reportViewer_ctl04").value = actionType;
document.getElementById("reportViewer_ctl05").value = actionParam;
doPostBack('reportViewer','');
};
}
--></Script><input type="hidden" name="reportViewer$ctl04" id="reportViewer_ctl04" /><input type="hidden" name="reportViewer$ctl05" id="reportViewer_ctl05" /><input type="hidden" name="reportViewer$ctl06" id="reportViewer_ctl06" value="0" /><input type="hidden" name="reportViewer$ctl07" id="reportViewer_ctl07" value="false" /><input type="hidden" name="reportViewer$ctl08" id="reportViewer_ctl08" value="false" /><noscript>
Your browser does not support scripts or has been configured not to allow scripts.
</noscript><Script language="javascript"><!--
document.getElementById('reportViewer').ClientController.CustomOnReportLoaded = function() {};
document.getElementById('reportViewer').ClientController.CustomOnAsyncPageChange = function() {};
document.getElementById('reportViewer').ClientController.CustomOnDocMapVisibilityChange = function() {};
document.getElementById('reportViewer').ClientController.CustomOnPromptAreaVisibilityChange = function() {};
document.getElementById('reportViewer').ClientController.CustomOnReloadDocMap = function() {};
--></Script>
</div><iframe name="reportViewerTouchSession0" id="reportViewerTouchSession0" onload="if (frames['reportViewerTouchSession0'].location != 'javascript:''') frames['reportViewerTouchSession0'].location.replace('javascript:''');" src="javascript:''" style="position:absolute;width:0;height:0;border-width:0;visibility:hidden;">
</iframe><script type="text/javascript">
setTimeout("frames['reportViewerTouchSession0'].location.replace('\/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=dd0df78cbe0d4c119d2af4e5a13a33b7&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodreportViewerTouchSession0&CacheSeed=' + encodeURIComponent(Date()));", 0);function KeepAliveMethodreportViewerTouchSession0() {setTimeout("frames['reportViewerTouchSession0'].location.replace('\/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=dd0df78cbe0d4c119d2af4e5a13a33b7&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodreportViewerTouchSession0&CacheSeed=' + encodeURIComponent(Date()));", 1140000);}
</script><Script language="javascript"><!--
document.getElementById('reportViewer').ClientController.ShowInitialWaitFrame();
--></Script>
<script type="text/javascript">
//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>
</script>
</form>
</body>
</html>
View 1 Replies
Nov 18, 2010
Any C# Code or any setting in Reportviewer to call SSRS Subreport from ReportViewerThe SSRS Subreport executes properly from report manager.
View 1 Replies
May 21, 2010
Can you test your connection from localhost to internet host Sqlserver Database
View 4 Replies
Jan 3, 2011
We have a requirement of using SSRS for rendering the reports using ReportViewer control. We are aware of the fact that SSRS requires Windows Authentication, but my requirement is to provide access to all the users stored in a database table who provide valid credentials to access the SSRS report via web page and report viewer cotrol.
We are following the below steps.
1) Create a dummy windows level user say "dummy".
2) Provide "Browser" permissions to the "dummy" user.
3) Set Impersonation = true for the "dummy" user in the web.config file of the custom website that uses the ReportViewer control.
4) Follow all the required steps to configure the reportviewer control for accessign the SSRS report
After following all the above steps we are successfully able to access the SSRS report on the internet facing website without any Windows authentication popup.
P.S. We dont want to implement a Custom extension for implementing forms authentication.
View 1 Replies
Jan 13, 2010
Is it possible to show the chart like the image in my attachement in Column Chart and in 100% Stacked Column Chart of SSRS 2008.
I like to show two series in same chart. Is it possible in SSRS 2008?
I provided the sample data to test it.
Select 'Fruits' as Category, 'Apple' as Item, 20 as Sales UNION
Select 'Fruits' as Category, 'Orange' as Item, 20 as Sales UNION
Select 'Snacks' as Category, 'Biscuits' as Item, 10 as Sales UNION
Select 'Snacks' as Category, 'Chips' as Item, 10 as Sales UNION
Select 'Snacks' as Category, 'Cakes' as Item, 40 as Sales
View 3 Replies
Jan 7, 2011
I am creating a column and line chart in the same chart using reportviewer 2008.
The chart got two y series 'Number of product order' as column chart and label on left side of chart (unit number count) and total value of orders as line chart with label on right side of chart (unit $ value). Month is on x axis. I am wondering whether it can be done in reportviewer.
View 5 Replies
Dec 6, 2010
Explaination in detail I have a tree view control on left of my page and AjaxToolkit:TabContainer on the right,consisting of 9 tabs in it (I have developed individual controls and added to the tab panels). On selecting a value from the tree view control the I am refreshing the values inside all the tab panels. There is a method reload written on all the controls which are called on tree view click which sets the value of the selected tree item in properties in all the controls and also refreshs them. Its a big performance issue for sure which i need to improve on but that would come later.
My problem
1. In the Main tab (ascx control) consists of asp:chart control which I am populating and it also consists of 2 buttons in which ModalPopupExtender would open up another 2 controls on button click within this control. Now on the tree view click I am calling
the reload of Main Tab which internally called the reload function of these 2 controls also
On Tree view click
Maintab.reload
{
ModalPopupExtender1.reload
ModalPopupExtender2.reload
}
Secondtab.reload
Thirdtab.reload
If I populate the asp.chartcontrol without reloading the ModalPopupExtender1.reload ModalPopupExtender2.reload it works great but when I call both ModalPopupExtender1.reload
ModalPopupExtender2.reload it shows up and goes away.
Any thing i am missing on ? How to make chart control stay on the page and not vanish. I tried making it visible again. The main page contains a chart control which comes and goes away and does not stay only if i comment out the reloading of these usercontrols it stays visible with values on the main page else goes away.
2.Performance problem- I am not sure how to lazy load the content inside the tab panels so that controls should have the selected item for tree view click and can populate thereon.
3. This is how I call my user controls to reload on the treeview click from within the main page.
PEGeneralInfoPortfolioProfiler1.PortfolioCode = strPortfolioCode;
PEGeneralInfoPortfolioProfiler1.ReloadControl(1);
View 2 Replies
May 7, 2015
How to bind chart in datalist dynamically in asp.net c#.
View 1 Replies
Jul 23, 2012
I need to generate a report by comparing two values in rdlc in c#.net
I am having a product with the price Rs 150 in 2010.
In 2011, the product price rises to Rs 200
In 2012, it decrease to Rs. 100
I need to show this in chart.
It should display as Waves.
View 1 Replies
Jul 9, 2010
I have an issue in using dot net chart control. In chart last column is not completely shown which give bad appearance and on right side of chart it looks like TickMark are enabled. I set MajorTickMark of AxisY2 disabled but still tick marks on right side.
View 2 Replies
Feb 24, 2010
how to freeze the x axis of the chart control in ms chart? need to use because data displayed at large amount that is scrollable.
View 1 Replies
Apr 28, 2010
Am I going mad/blind? Probably a combination of the two.
How does one go about removing the data labels from a pie chart with the new chart control in .net 4?
I can get these to display as tooltips absolutely fine, but ultiamtely I'd like the labels not to be present as it looks rather busy.
I've searched previous answers and seen code behind resolutions but surely there must be some sort of code infront option to turn these labels off?
View 2 Replies
Aug 12, 2010
I am using MS Chart control (3.5), and have a requirement where I need to display 2 pie charts. The datapoints for the pie charts is set programatically. My doubts are as follows:
1. Can I display both the pie charts in a single chart control and area, or do I have to use two controls? (Currently I am using two controls)
2. How can I maintain the same size for both the pie charts? This is my main concern, since the pie sizes keep changing, depending on the number of datapoints. I tried using custom properties like "MinimumRelativePieSize", but it's not working.
View 1 Replies
Nov 17, 2010
i'm trying to create a stacked bar chart on a vb web form using vs2010.My data source returns:
Error in Functionality Awaiting on Supplier
1IMT IssuesmActive6
IMT Issues,Awaiting on Supplier
2,IMT Issues,Awaiting on User 4
IMT Issues Closed 120
Login / Password Active
But I can't get this into a stacked chart. I know I must have to do quite a bit of work declaring what the series are and soforth, or having a different dataset but can't find any documentation on it.A link to some documentation or an example of a stacked chart from an sql datasource would be much appreciated.
View 1 Replies
May 21, 2010
I started using the awesome chart controls with my asp.net apps recently and so far they've been nothing short of breath taking. Right now I have a weird problem, on the first load of my page, the chart control appears correctly and the tooltip is correct, however, when I update it with new data, the chart displays correctly, but the tooltips are for the previous set of data.
I hope this makes sense. The first time I load the chart, the pie chart segments and tooltips are correct, after a partial postback (to get the new data), the pie chart segments are correct but the tooltips are for the previous data set.
Basically once the tooltips are set the first time, they can't be updated after that without a full page postback.
Here's how I set the tooltip:
[Code]....
Anyone else noticed this behaviour and have a work around?
Currently my only workaround is to check for a partial postback and not render the tooltip, which I'd rather not do as the tooltip display actual statistical data as opposed to the pie itself (which uses percentages).
View 2 Replies
Jul 19, 2010
I have X and Y data columns coming from database.
I have to show scatter plot chart with Linear, Exponential, Log, power using asp.net chart control.
How to do that?
View 2 Replies
Jun 7, 2010
im trying to create simple pie chart using the MS Chart controls. When my pie chart gets rendered in the browser i get padding around the pie chart that i cant get rid of. i would like the pie chart to sit up against the edge of the image with no padding or margin. in my code below the padding is highlighted in blue. i.e Chart1.BackColor = System.Drawing.Color.Blue;
<script type="text/C#" runat="server">
protected void Page_Load(object sender, EventArgs e)
{
//Set the chart type
Chart1.Series["Series1"].ChartType = SeriesChartType.Pie;
//add points
Chart1.Series["Series1"].Points.AddY(12);
Chart1.Series["Series1"].Points.AddY(45);
Chart1.Series["Series1"].Points.AddY(67);
//set back color of chart object
Chart1.BackColor = System.Drawing.Color.Blue;
//set back color of chart area
Chart1.ChartAreas["ChartArea1"].BackColor = System.Drawing.Color.Green;
}
</script>
<asp:Chart ID="Chart1" runat="server">
<Series>
<asp:Series Name="Series1" ChartType="Pie">
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea1">
</asp:ChartArea>
</ChartAreas>
</asp:Chart>
View 1 Replies
