I'm integrating SSRS reports(developed in VS 2008 vs. 9.0 ), and when I load it into the browser with Chrome, I get this:
There's no date-icon!
In Opera it shows, but doesn't work:
How do I figure out how to 1.) get it to work correct . 2) Make it visible in Chrome
I found a site talking about it( here ) , but it only hhas a dead-link ( http://www.rajbandi.net/ )
Is it just me or is this a complex issue to fix? Any tips appreciated
However, they were running into issues when using Google Chrome with SSRS reports. The first issue was that they were receiving a log in prompt to the SSRS server when browsing to it. The second issue was the infamous Kerberos Double-Hop issue.
Their company has standardized on using Google Chrome for the browser. However, they were running into issues when using Google Chrome with SSRS reports. The first issue was that they were receiving a log in prompt to the SSRS server when browsing to it. The second issue was the infamous Kerberos Double-Hop issue.
In SSRS, the Kerberos Double-Hop issue is seen by receiving the following message when running a report: Kerberos Double-Hop issue in SSRS This message indicates that somewhere along the line, the Kerberos ticket wasn’t used. The system has started using the generic “NT AUTHORITYANONYMOUS LOGIN” account for trying to connect to other computers.
The system has started using the generic “NT AUTHORITYANONYMOUS LOGIN” account for trying to connect to other computers. In this case, the SSRS report is using a data source that connects to a different computer. Showing SSRS errors remotely By default, SSRS does not display these error messages remotely.
Maybe this post will be helpful for you? http://www.codeproject.com/Articles/504567/Print-button-Date-picker-in-SSRS-Reports-for-Non-I
The supposedly dead link (rajbandi.net) was accessible at the time of writing this post; I'm putting its contents here for use if the link is down again:
Fixing SSRS Report Viewer control date picker in Google chrome
Author: Raj Bandi
April 3, 2012
https://rajbandi.net/2012/04/03/fixing-ssrs-report-viewer-control-date-picker-in-google-chrome/
SSRS Report Viewer control works well in IE6+ but has some known compatibility issues with other major browsers(Firefox, Chrome etc.) around date picker and print button.
For more information read this
http://msdn.microsoft.com/en-us/library/ms251673.aspx
I am presenting a simple solution to fix date picker issue in Chrome with a combination of some server side code and Client side JQuery script.
Server Side Code
1) Add the below code in the page/control file in which the reportviewer control resides
<asp:HiddenField ID="DatePickers" runat="server" />
2) Add the below code in the code behind file of page/control in which the reportviewer control resides(.Net 2.0 version)
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
DatePickers.Value = string.Join(",",(new List(GetDateParameters()).ToArray()));
}
private IEnumerable GetDateParameters()
{
// I'm assuming report view control id as reportViewer
foreach (ReportParameterInfo info in reportViewer.ServerReport.GetParameters())
{
if (info.DataType == ParameterDataType.DateTime)
{
yield return string.Format("[{0}]",info.Prompt);
}
}
}
Client Side Code
1) Add the below script in the html head section
$(document).ready(function(){
if ($.browser.webkit)
{
$($(":hidden[id*='DatePickers']").val().split(",")).each(function(i, item) {
var h = $("table[id*='ParametersGrid'] span").filter(function(i) {
var v = "[" + $(this).text() + "]";
return (v != null && v.indexOf(item) >= 0);
})
.parent("td").next("td").find("input")
.datepicker({
showOn: "button",
buttonImage: '/Reserved.ReportViewerWebControl.axd?OpType=Resource&Name=Microsoft.Reporting.WebForms.calendar.gif',
buttonImageOnly: true,
dateFormat: 'dd/mm/yy',
changeMonth: true,
changeYear: true
});
});
}
});
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With