Hi,
I am invoking RS web services to render reports, using Apache Axis to generate stub classes from Reporting Service WSDL.
Please let me know if I can integrate Report Viewer control in the jsp where I am writing the report output. Else do I have to create my own custom tags simulating ReportViewer functionality.
Hello,
I'm trying to rertieve specific RS 2005 report by passing WebApp control value (this.VCtrlNo.Text) to "CV Report" - name of my report with the following scripts.
1) No Action - when clicked. AutoPostBack is set and properly initialized.
Page.Response.Write("<script>window.open('http://localhost/Reports/Pages/Reports.aspx? /Reports+Folder/CV+Report&vctrlno=" + this.VCtrlNo.Text + "','_blank');return false; </script>");
2) This just opened the default page instead of specific report.
<a href="http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReports+Folder%2fCV+Report&rc=Render&vctrlno=10-0000037", target="_blank">Open CV Report
</a>
Where "Reports" is the reportmanager, vctrlno is the parameter name (properly set) and obviously I want to open a new page.
I would be very thankful to anyone who can lead to make this work.
Thanks
Jj
Hi,
I need to implement SQL server 2005 reporting services in my current project, we will be having a report server for that, now i am really confused ho should I integrate reporting services with my asp.net 2.0 web application.
My requirement consists of using tables, charts and graphs, need to save reports as excel, xml and csv formats and most important thing is report columns are dynamic, user can select/deselect some columns in a particular report.
Can any one help whether i should go for reportviewer in remote processing mode(then how can i pass column information) or should i go for url access or use SOAP API.
URL access looks easy to implement and really bowled out by SOAP API option, and dont know whether reportviewer can fulfill my requirements or not.
Will really appreciate any kind of help....
We are using SSRS 2005.We designed one report.This report contains Table and chart controls .When Table is hidden,chart only is visible, this chart is going to show only on last page.There is a white space in top of the chart while hiding the table control.
Consider for an Example Report one tables and one chart . We want to show only chart,So we made Table's visible property is false.Total Number of pages is five and table has only four pages and chart has only one page that is in last page. Now the report showing Four pages are empty with header and footer and last page have a chart with header and footer.
Any suggestions how to avoid the empty pages?
I tried to Filter property to filter the table.Same empty page with header and footer is only visible
Thanks In Advance
Mugesh
I'm building a web app in c# that will consume sql rdl reports. These reports are hosted at MaxmimumASP and the physical location requires us to login with our one and only network account or to at least impersonate the authorized account in code. (Note that this all stored under SSL on a server different than our web app).
This is easy enough using the provided ReportService. However, we desire the functionality in ReportViewer that gives the toolbar and multiple export options.
So some serious work-arounds are in order.
Using ReportService, I can easily impersonate our MaximumASP account with:
ReportingService service = new ReportingService();
service.Credentials = new System.Net.NetworkCredential(user, pword, domain);
Using the ReportService leaves us with a stream of binary information. Under this set of conditions, direct rendering to PDF doesn't seem to work (or at least I can't get it to.).
Another problem is that embedded images either do not show up, require another challenge/response even though we did this in our cs page, or require us to stream them to the app's directory (see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_49f6.asp?frame=true)
The big question. Does anybody have a way to get ReportServices stream to display in ReportViewer without using temporary files?
Hi,
I€™ve an application Web which uses to reportviewer to show information. I want that all the users of the application accede to reports by means of he himself user and password. This user is a local user of report€™s server. The problem is that when attempt to show report always appear the following error:
The request failed with HTTP status 401: Unauthorized.
The code that use is the following one:
ReportViewer1.ServerReport.ReportServerCredentials = new ReportViewerCredentials("Usuario", "pwd", "servidor");
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Reporting.WebForms;
using System.Net;
using System.Security.Principal;
using System.Runtime.InteropServices;
/// <summary>
/// Summary description for ReportViewerCredentials
/// </summary>
public class ReportViewerCredentials : IReportServerCredentials
{
[DllImport("advapi32.dll", SetLastError = true)]
public extern static bool LogonUser(String lpszUsername, String lpszDomain, String lpszPassword, int dwLogonType, int dwLogonProvider, ref IntPtr phToken);
[DllImport("kernel32.dll", CharSet = CharSet.Auto)]
public extern static bool CloseHandle(IntPtr handle);
[DllImport("advapi32.dll", CharSet = CharSet.Auto, SetLastError = true)]
public extern static bool DuplicateToken(IntPtr ExistingTokenHandle,
int SECURITY_IMPERSONATION_LEVEL, ref IntPtr DuplicateTokenHandle);
public ReportViewerCredentials()
{
}
public ReportViewerCredentials(string username)
{
this.Username = username;
}
public ReportViewerCredentials(string username, string password)
{
this.Username = username;
this.Password = password;
}
public ReportViewerCredentials(string username, string password, string domain)
{
this.Username = username;
this.Password = password;
this.Domain = domain;
}
public string Username
{
get
{
return this.username;
}
set
{
string username = value;
if (username.Contains("\"))
{
this.domain = username.Substring(0, username.IndexOf("\"));
this.username = username.Substring(username.IndexOf("\") + 1);
}
else
{
this.username = username;
}
}
}
private string username;
public string Password
{
get
{
return this.password;
}
set
{
this.password = value;
}
}
private string password;
public string Domain
{
get
{
return this.domain;
}
set
{
this.domain = value;
}
}
private string domain;
#region IReportServerCredentials Members
public bool GetBasicCredentials(out string basicUser, out string basicPassword, out string basicDomain)
{
basicUser = username;
basicPassword = password;
basicDomain = domain;
return username != null && password != null && domain != null;
}
public bool GetFormsCredentials(out string formsUser, out string formsPassword, out string formsAuthority)
{
formsUser = username;
formsPassword = password;
formsAuthority = domain;
return username != null && password != null && domain != null;
}
public bool GetFormsCredentials(out Cookie authCookie,out string user, out string password, out string authority)
{
authCookie = null;
user = password = authority = null;
return false; // Not implemented
}
public WindowsIdentity ImpersonationUser
{
get
{
string[] args = new string[3] { this.Domain.ToString(), this.Username.ToString(), this.Password.ToString() };
IntPtr tokenHandle = new IntPtr(0);
IntPtr dupeTokenHandle = new IntPtr(0);
//const int LOGON32_PROVIDER_DEFAULT = 0;
////This parameter causes LogonUser to create a primary token.
//const int LOGON32_LOGON_INTERACTIVE = 2;
const int LOGON32_PROVIDER_DEFAULT = 3;
//This parameter causes LogonUser to create a primary token.
const int LOGON32_LOGON_INTERACTIVE = 9;
const int SecurityImpersonation = 2;
tokenHandle = IntPtr.Zero;
dupeTokenHandle = IntPtr.Zero;
try
{
// Call LogonUser to obtain an handle to an access token.
bool returnValue = LogonUser(args[1], args[0], args[2],
LOGON32_LOGON_INTERACTIVE, LOGON32_PROVIDER_DEFAULT,
ref tokenHandle);
if (false == returnValue)
{
Console.WriteLine("LogonUser failed with error code : {0}",Marshal.GetLastWin32Error());
return null;
}
// Check the identity.
System.Diagnostics.Trace.WriteLine("Before impersonation: "
+ WindowsIdentity.GetCurrent().Name);
bool retVal = DuplicateToken(tokenHandle, SecurityImpersonation, ref dupeTokenHandle);
if (false == retVal)
{
CloseHandle(tokenHandle);
Console.WriteLine("Exception in token duplication.");
return null;
}
// The token that is passed to the following constructor must
// be a primary token to impersonate.
WindowsIdentity newId = new WindowsIdentity(dupeTokenHandle);
WindowsImpersonationContext impersonatedUser = newId.Impersonate();
// Free the tokens.
if (tokenHandle != IntPtr.Zero)
CloseHandle(tokenHandle);
if (dupeTokenHandle != IntPtr.Zero)
CloseHandle(dupeTokenHandle);
// Check the identity.
System.Diagnostics.Trace.WriteLine("After impersonation: "
+ WindowsIdentity.GetCurrent().Name);
return newId;
}
catch (Exception ex)
{
Console.WriteLine("Exception occurred. " + ex.Message);
}
return null;
}
}
public ICredentials NetworkCredentials
{
get
{
return null; // Not using NetworkCredentials to authenticate.
}
}
#endregion
}
I tried to open a SQL Server 2005 Reporting Service report in ASP.Net 2.0 using ReportViewer. The following is my code.
Dim param(2) As Microsoft.Reporting.WebForms.ReportParameter
param(0) = New Microsoft.Reporting.WebForms.ReportParameter("ProjectID", Me.cboProject.SelectedValue)
param(1) = New Microsoft.Reporting.WebForms.ReportParameter("RunBy", Session("strEmployeeName"))
Me.ReportViewer1.ServerReport.SetParameters(param)
Me.ReportViewer1.ServerReport.ReportServerCredentials = New _
clsReportServerCredential(System.Configuration.ConfigurationManager.AppSettings("strReportViewUser"), _
System.Configuration.ConfigurationManager.AppSettings("strReportViewPassword")
Me.ReportViewer1.ServerReport.ReportServerUrl = New Uri(http://SQL2005/ReportServer/)
Me.ReportViewer1.ServerReport.ReportPath = "/nsPortalReports/rptIssuesByRole"
Me.ReportViewer1.ServerReport.Refresh()
I need help with passing multiple parameters. I got an erron on the second parameter (parm(1)). The error was
"Overload resolution failed because no accessible 'New' can be called without a narrowing conversion:
'Public Sub New(name As String, values() As String)': Argument matching parameter 'values' narrows from 'Object' to '1-dimensional array of String'.
'Public sub New(name As String, value As String)': Argument matching parameter 'value' narrow from 'Object' to 'String' "
How can I pass the parameters?
Thanks.
DanYeung
I am trying to use a reportviewer control (processing mode = remote) to view a rdl that is hosted on a server running MOSS, the reporting services are run in "sharepoint integrated mode". When i try to set the path to the RDL on the control like i usually do for an ASP.NET ReportViewer control, i get the error message posted below. I cant find anything on google, Please HELP
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <HTML dir="ltr"> <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title> Error </title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/> <script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=VhAxGc3rkK79RM90tibDzw%3D%3D"></script> <script type="text/javascript" language="javascript" src="/_layouts/1033/core.js?rev=F8pbQQxa4zefcW%2BW9E5g8w%3D%3D"></script> <meta name="Robots" content="NOINDEX " /> <meta name="SharePointError" content=""/> </HEAD> <BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();"> <form name="aspnetForm" method="post" action="../../_layouts/error.aspx" id="aspnetForm" onsubmit="return _spFormOnSubmitWrapper();"> <div> <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTU2NjkxODU3M2RkBsUItbjjuHbcaHeDmf91mLp59DY=" /> </div> <TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%" HEIGHT="100%"> <tr><td> <table CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%"> <tr> <td colspan=4 class="ms-globalbreadcrumb" align="right"> <a href="javascript:TopHelpButtonClick('NavBarHelpHome')" id="ctl00_PlaceHolderGlobalNavigation_TopHelpLink" AccessKey="6" title="Help (new window)"><img src="/_layouts/images/helpicon.gif" align="absmiddle" border="0" alt="Help (new window)" /></a> </td> </tr> </table> </td></tr> <tr> <td class="ms-globalTitleArea"> <table width=100% cellpadding=0 cellspacing=0 border=0> <tr> <td id="GlobalTitleAreaImage" class="ms-titleimagearea"><img id="onetidHeadbnnr0" src="/_layouts/images/titlegraphic.gif" alt="" /></td> <td class="ms-sitetitle" width=100%> </td> <td style="padding-top:8px;" valign=top> </td> </tr> </table> </td> </tr> <TR> <TD id="onetIdTopNavBarContainer" WIDTH=100% class="ms-bannerContainer"> </TD> </TR> <TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0" cellpadding="0"> <tr> <td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle" nowrap><div style="height:100%" class="ms-titleareaframe"></div></td> <td class="ms-titleareaframe" id="TitleAreaFrameClass"> <table cellpadding=0 height=100% width=100% cellspacing=0> <tr><td class="ms-areaseparatorleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr> </table> </td> <td valign=top id="onetidPageTitleAreaFrame" class='ms-areaseparator' nowrap width="100%"> <table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0 width=100% border="0"> <tr> <td valign="top" class="ms-titlearea"> <a href="http://xjthdqdwd03:8080/bi" id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to site</a> </td> </tr> <tr> <td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle"> <h2 class="ms-pagetitle"> Error </h2> </td> </tr> </table> </td> <td class="ms-titlearearight"> <div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div> </td> </tr> <TR> <TD class="ms-leftareacell" valign=top height=100% id="LeftNavigationAreaCell"> <table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0> <tr> <td> <TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0 border="0"> <tr valign="top"> <td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1 alt=""></td> <td valign="top" width="100%"> </td> </tr> <tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138 height=1 alt=""></td></tr> </TABLE> </td> <td></td> </tr> </table> </TD> <td> <div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div> </td> <td class='ms-formareaframe' valign="top"> <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="ms-propertysheet"> <TR valign="top" > <TD class="ms-descriptiontext" width="100%"> </TD> <TD ID=onetidYPadding width="10px"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD> </TR> <TR > <TD ID=onetidMainBodyPadding height="8px"><IMG SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD> </TR> <tr> <td valign="top" height="100%"> <A name="mainContent"></A> <table width=100% border=0 class="ms-titleareaframe" cellpadding=0> <TR> <TD valign=top width="100%" style="padding-top: 10px" class="ms-descriptiontext"> <span id="ctl00_PlaceHolderMain_LabelMessage">The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.</span> <P><span class="ms-descriptiontext"> <span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new window" HREF="javascript:HelpWindowKey('troubleshooting')">Troubleshoot issues with Windows SharePoint Services.</A></span> </span> </TD> </TR> </table> <script type="text/javascript" language="JavaScript"> var gearPage = document.getElementById('GearPage'); if(null != gearPage) { gearPage.parentNode.removeChild(gearPage); document.title = "Error"; } </script> </td> </tr> </table> </td> <td class="ms-rightareacell"> <div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div> </td> </TR> <tr> <td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> <td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> <td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> <td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> </tr> </TABLE></TD></TR> </TABLE> <input type="text" name="__spDummyText1" style="display:none;" size=1/> <input type="text" name="__spDummyText2" style="display:none;" size=1/> </form> </BODY> </HTML> --.
Hi
I had a problem accessing our report manager via the web front...
We deleted the virtual directories in IIS and then recreated them... this required us to make a change in the rsWebApplication.config file to include the URL in the ReportServerUrl tag before we could access the site again.
Now we have access to the site but when we attempt to view a report that we deployed to it - the report fails to render and returns a rsReportNotReady error, even though the report doesnt use a snapshot.
Furthermore, the strange thing is that the filters for the report don't display in their own collapsable bar as they used to before... they just display on the white part of the page. Neither does the reportviewer toolbar display properly. It appears as labels and textboxes going down the page and not in a toolbar as you might expect...
any help is appreciated... we suspect that it is some kind of configuration issue, but we have no clue where to begin...
I have a report (stored procedure) that I have set up in SQL 2005 Reporting Services. I've designed this report (using SQL server business intelligence studio), and several other reports, thinking that running totals or summing may be the issue, but it hasn't been. The latest iteration has been just a display of product info, about 100 records, no fields formatted or summed. Very very simple, straight-forward report. If I go to the Report server & upload the rdl file, it displays fine, performs as it should, paging & exporting - everything works fine. The issue comes up when in a web app, I put a Reportviewer control on the page, and call the report.
It works, sort of.
Originally, I had written the page using ASP.NET AJAX Enabled web project, and I had been using the Tab Container on the page. What happens is when I open it on that tab (I am using AJAX Tab panels, which had been working fine without this behavior prior to finally getting the reportviewer working), and the report displays, the "e" on Internet explorer at the top of the tab now flickers, like the page is reloading. It also runs the CPU up to 100% on the computer and although I can go from tab to tab in it (I am using AJAX tab panels in the page), it will take like up to a minute to go to the next tab. I'm not doing anything really data-intensive on those tabs, and they had been functioning fine prior to putting in the report viewer (i.e. they weren't flickering & clocking the CPU).
Thinking that the Tab Container may be the issue, I created just a plain AJAX Enabled web project and put the same reportviewer on it. Same performance. It'll display the report, and then take the system up to 100% and stay there until I kill the browser.
After that, I did just a plain old ASP.Net web project and put the report viewer control on it. Same result. The report will display, but as soon as it does, the "e" on Internet Explorer tab starts flickering and you see the CPU go to 100% and stay there. I've left it for 20-30 minutes with no change. It appears as if the page is constantly refreshing.
Thinking that the issue may be related to having the reportviewer report hard coded in the app, I put a button on the page, and assigned the button to put in the report. It displays, but it again runs the CPU up to 100% and stays there.
I thought that having Asynch = True (run the report asynchronously) might be the issue, but setting it to false made no difference.
I eventually have to kill the page to do anything, because it has the system up to 100%.
The code I am using on this page follows:
Here's the code in the codefile:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
Me.ReportViewer1.Visible = False
End If
ReportViewer1.ServerReport.ReportPath = ""
End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
ReportViewer1.Visible = True
ReportViewer1.ServerReport.ReportPath = "/BA10listing"
End Sub
The code in the aspx part of the page:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="Button1" runat="server" Text="Button" />
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="400px" ProcessingMode="Remote" Width="400px" AsyncRendering="False" ShowDocumentMapButton="False">
<ServerReport ReportPath="/BA10listing" ReportServerUrl="http://mycomputer/ReportServer$SQL2005/" />
</rsweb:ReportViewer>
</div>
</form>
</body>
</html>
.... so you can see there's a lot going on here. The report returns ~100 records or so, no calculations, no summation, no grand totals. Basically a "nothing" report, just listing product info data.
In SQL Reporting Services in the web browser, this report displays fine, no problems. It's only when I call it from the Reportviewer inside a web page that it hangs.
Any idea why reportviewer might make this act this way?
My system is running Windows XP, VS 2005, I have both SQL 2000 and SQL 2005 on this same box. I have a server that has both SQL 2000 & SQL 2005 on it as well, and the behavior is the same for both, whether I run the web page with the Reportviewer control on it with the report being on the local system, or the remote system.
Any help or advice would be very much appreciated.
Thanks!!!
SC
how should i hide pdf in export option in reportviewer
View 11 Replies View RelatedWe recently upgraded from ReportViewer 9.0 to 10.0 Control in our ASP.NET application, and face some strange issues after the upgrade. When we press the Back button to go to a page that was rendering a report with one or more single-select drop down lists, the selected index in the drop down is reduced by 1, and the report doesn't render until I press "View Report". I verified that exact same setup works well with ReportViewer 9.0.
View 2 Replies View RelatedI have designed plenty of reports in VS 2005 and have been deployed on the reporting server. I have been designed one web page which shows UI through which user can access which ever reports he/she wants. I have kept some buttons on UI. When button is clicked appropriate report accessed and displayed on the browser.
Â
Problem is that, report width is about 40 - 50 % of the screen and report viewer shows the report on the left align of the screen. I just want to show the report at the center of the screen. Also, any property I can use to set the report size in the proportion of screen in Percentage(%).
This is a subject that has been brought up before but I have not seen a definitive answer/solution.
We have implemented a custom authentication extension (forms authentication) for reporting services and it has been working just fine under "normal" conditions; "normal" being users logging in, viewing reports, and then moving on.
Recently some reports were created by our report group and they contain Dundas gauge controls for "dashboard" style reports. These reports are meant to be up all day and they post back every few seconds because the data they present is mission critical.
This of course exposed the inability of the reportviewer control to stay in the context of Report Manager when it comes to the cookie exchange and authentication thus resulting in the following error:
<html><head><title>Object moved</title></head><body>
<h2>Object
moved to <a
href="/ReportServer/logon.aspx?ReturnUrl=%2freportserver%2fReportExecution2005.asmx">here</a>.</h2>
</body></html>
I created a quick ASP.NET web application and added the reportviewer to it, implemented IReportServerCredentials and the report came up as expected but behaved the same way as it did in Report Manager. Same with a Windows Forms application.
Increasing the cookie timeout in the forms authentication tag is an option, but not an attractive one. Extending the reportviewer control is also an option, but I don't know if that is a good candidate right now because I don't see anything extensible yet.
Is this just the nature of RS with custom authentication or is there a viable solution out there right now?
Any and all answers are much appreciated and I thank you in advance.
I have a report that displays fine in VS 2005 (in the Preview tab), and if I hit it via a URL in IE as a deployed report. However, when I embed it in a ReportViewer control for display on a web site, I get no data back for the report. I am using an Oracle database for the data source. None of the the logs in reporting services show anything wrong, there are no events in the event viewer to indicate any problems, Oracle logs also show no problems and no errors are returned to the page when the "View Report" button is clicked.
Anyone out there have a clue? I certainly don't.
Mike
I am working with vs2013 and have developed ssrs report in ssdt that creates RDL files, I want to view this report in asp.net web page using vs 2013 Reportviewer control. How do I do that? What are the proper steps to configure reportviewer control.so I can view ssrs report through vs2013 ultimate edition.
View 2 Replies View RelatedWe are using SharePoint 2010 integrated with Reporting Services 2008 R2. We have successfully configured RS and we are able to create RDL reports using Report Builder from the SharePoint site.
However we are getting following error message when we host same RDL report using Report Viewer control in an application page i.e. ASPX page:
<ERROR>The request failed with HTTP status 401: Unauthorized</ERROR>
We can fix this issue by setting:
1) setting impersonation to false in web.config file:
<identity impersonate="false" />
2) Setting Report server URL to _vti_bin path:
rptViewer.ServerReport.ReportServerUrl = new Uri("http://sharepointserver:1000/_vti_bin/reportserver");
If we turn impersonation to true we get the same error. Other project module requires impersonation to be enabled. Hence we cannot proceed further with this work around/fix.
Hi
I have created a packages which pull and push the data to SAP server.
I want to create a report every day and send that report to the manager.
For the same i want to call reporting services in my SSIS package.
I know i can write a SQL script and export the report in excel but i want to use Reporting services.
Have any one call reporting services from ssis.
I have two ASP pages. Page 1 has a button that when pressed, it will display page 2. Page 2 has a button that will call the reporting service (by a URL) . The button on page 1 has the "method=post" to pass a value to page 2. Page 2 wlll use this value as variable to the reporting service.
It works fine for the first time calling the report. But after that, I go back to page 1. When press the button on page 1 and go to page 2, it cannot get the value. Is that something wrong with the reporting services.
I am trying to call oracle stored procedure from SRSS 2005. I am using the syntax { Call s_test_rcur()} . I am getting following error.An error occurred while retrieving the parameters in the query.ORA-00911: invalid characterORA-06512: at "SYS.DBMS_UTILITY", line 68ORA-06512: at line 1
ORA-00911: invalid characterORA-06512: at "SYS.DBMS_UTILITY", line 68ORA-06512: at line 1Â (System.Data.OracleClient)
Here is the Oracel stored proc.
TYPE rc_test IS REF CURSOR;
PROCEDURE s_test_rcur (po_test_rc OUT rc_test, -- returns a record setpo_error OUT INTEGER)ISBEGIN g_err_level := 1;OPEN po_test_rc FORSELECT a.ssn_id,TO_CHAR (a.acad_yr) || TO_CHAR (a.acad_yr + 1) acad_yr,RPAD (NVL (last_name, ' '), 30, ' ') last_name,RPAD (NVL (first_name, ' '), 30, ' ') first_name,NVL (middle_initial, ' ') middle_initialfrom test_tableorder by last_name;po_error := 0;EXCEPTIONWHEN OTHERSTHENpo_error := -1;g_error_code := SQLCODE;g_error_msg :='Err level :' ||TO_CHAR (g_err_level) ||' ' ||SUBSTR (SQLERRM, 1, 250);END;
Need some clarification on calling an SSIS package from SSRS. I have managed to get this to work, but only if I actually build the SSIS package on the report server machine.My SSIS package is very simple it. The control flow is a single data flow task. Within the data flow task is an ole db data source and a data reader destination. I verified that the package works in BIDS.
Â
If I build it and deploy it on the report server I can execute it just fine from integration services (using the dtexec UI panel) in SSMS, no validation errors and no execution errors.If I try to build a dataset (specifying SSIS as the data source type) then immediately on referencing the package I get a "Package failed to validate error". However, if I bring the whole project over to the report server and build it then I can reference it from my Report Services project.
Â
I'm using package deployment security of "Don't Save Sensitive" for the SSIS package with the 'sa' login. After the deployment package is built I edit the connection string to include the password.The remote execution account for the Report Server is set to the administrator of the box. I know these account permissions are overkill, but I'll iron all that out once I get the basic pieces in place and working.
Hello everyone I have a small application in asp.net now I’m trying to use the SQL reporting services. But as soon as I try to connect to the DB on the “connection properties� window I get this error.
Unable to open the physical file "C:myAppsmydb.mdf". Operating system error 32: "32(The file is in use by another process.)".
Thanks
Hi all,
I don't know if this is possible or not but what I want to do is include a few images on a report that will launch a little VB6 application when clicked. I've tried messing with the Navigation - URL properties of the image but am getting nowhere fast!
Anyone any ideas?
Cheers
Ninj
Hi
This is the code which I have written in code window.
Public Shared Function CalcLocalFactor(ByVal CalcLifeCode As Integer, ByVal CalcFiscalAge As Integer, ByVal CalcLifeYearsUsed As Double, ByVal CalcLocConvention As String, ByVal CalcSRate As Integer) As Double
Dim locCalcFiscalAge As Integer = 0
Dim locFactor As Double= 1.0
Dim locFactor1 As Double = 1.0
Dim REM1 As Integer = 1
Dim DEP As Double = 0
Dim YR As Integer
Dim HALF_YEAR As Double
Dim LINEAR As Double
Dim MACR As Double
If CalcFiscalAge > CalcLifeCode + 1 Then
locCalcFiscalAge = 0
locFactor = 1.0
End If
If (CalcLocConvention <> "HALF-YEAR" And CalcLifeYearsUsed < CalcLifeCode) Then
locFactor = Math.Round((CalcLifeYearsUsed / CalcLifeCode), 4)
End If
If (CalcLocConvention = "HALF-YEAR") Then
for YR = 1 to CalcFiscalAge step 1
If YR = CalcLifeCode + 1 Then
locFactor1 = 1
Exit For
End If
If (YR = 1 Or YR = CalcFiscalAge) Then
HALF_YEAR = 2
Else
HALF_YEAR = 1
End If
LINEAR = Math.Round(REM1 / (CalcLifeCode - YR + 1.5) / HALF_YEAR, 4)
MACR = Math.Round(REM1 / CalcLifeCode * CalcSRate / HALF_YEAR, 4)
If MACR >= LINEAR Then
DEP = MACR
Else
DEP = LINEAR
End If
locFactor1 = locFactor1 + DEP
REM1 = 1 - locFactor1
locFactor = locFactor1
Next
End If
Return locFactor
End Function
I'm calling this code in a Report Parameter like below:
=Code.CalcLocalFactor(Parameters!CalcLifeCode.Value,Parameters!CalcFiscalAge.Value,Parameters!CalcLifeYearsUsed.Value,Parameters!CalcLifeYearsUsed.Value, Parameters!CalcSRate.Value )
It is working fine for the first record where as for other records, the value is not getting changed. i.e. the first records value is coming repeatedly for all other records also.
How can I dynamically change the parameter values of the function?
Parameter is not accepting directly the field names, hence I used other parameter to initialize the field and used that parameter for this.
Ex. Parameter Name ; FieldPurchDate (internal) FieldName : PURCHDATE
Other parameter: FieldInDate (internal) FieldName : InDate
While initializing the new parameter CalcPurchDate,, I used an expression for this: Parameters!CalcFiscalAge.Value
=iif(Parameters!FieldPurchDate.Value is nothing, Parameters!FieldInDate.Value,Parameters!FieldPurchDate.Value)
and using this CalcPurchDate for processing of the parameter:
These are some of the things , I am doing ....
Please let me know how to fix this issue...
Thanks in advance
Regards,
Radhika
I have an existing vb6 application which used Crystal reports .dsr inside the vb application for the forms. Now I need to change to Reporting services reports. I haven't worked in VB before. I am looking for some guidelines as to how to hook up the Reporting Services reports to vb6 application.
Any ideas or links will be appreciated.
Thanks in advance
All of a sudden I am getting an error when connecting to reporting services, not sure how long it has been going on, but I know reporting services was working when we moved to WSS3.0.
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
And this is the error from the event log:
Failed to execute request because the App-Domain could not be created. Error: 0x80070005 Access is denied.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Has anyone seen this error come up before or know of a quick fix for it.
Recently we upgraded to TFS 2008 and WSS 3.0 but the reporting services was still working after that.
I have a SSRS 2012 report which references a custom c# assembly.  This report exists in multiple environments (alpha, beta and  production ) which are each associated with different data sources.
Is there a way for the assembly to determine the datasource used by the calling report so it can also connect to it?
Hi,
There is a .net application which has a screen with four options(text boxes)
Each of these should take to reports generated by SQL REp Services
This is the requirment
The School selected in the App should be passed on to the report
How should I pass the parameter in my report
so that when user selects a link or text box report for that particular school number is displayed
Thanks
sowree
I am new to Reporting Services, and I would like to serve up SQL 2005 Reporting Services reports via an ASP.NET web app (possibly using Report Viewer controls in Server mode). The web app will be running on an IIS server outside the firewall.
I would prefer to have the Reporting Services server be inaccessible outside the firewall, but it seems that the client browsers need direct URL access to the Reporting Services server. I guess this means either locating the Reporting Services server outside the firewall, or opening a hole in the firewall for access to the Reporting Services server.
Is there a Microsoft best-practice methodology/white-paper that addresses this scenario (especially as regards security concerns)?
Alternately, would it be possible, and would the same report presentation functionality be available (reports with expanding/collapsing sections, choice of export formats, etc), by calling the Reporting Services web service directly from the ASP.NET app, and manually populating the Response object?
Thanks. Any help would be appreciated.
Hi,
I installed Reporting Services Add-in for Sharepoint 2007, on my Server where i have both Sharepoint 2007 and SQL Server 2005 and report Server are installed, i already installed SQL Server SP2, but in SharePoint 3.0 Central Administration under Application Management Reporting Services section is not Showing.
Please let me know if anybody has the got the same issue and fix it.
Thanks
Ahsan
Hello Everyone
As part of UK compliance, we are going to start use an encrytption package (GNUPG), which will be running on a different Server to Reporting Services. A program has been written in C#, to handle requests (from mainframe and PC applications) to encrypt/decrypt credit card details. The encrypted card details are held in an NCR Teradata data warehouse, which Reporting Services can access. The encryption can be called using a http://server/folder/program?DATA=
In Reporting Services, a Data Source connection will be made, using an OLE DB .NET connection to the Teradata machine. SQL code will be included, which will link tables and retrieving the required fields for use in the report. I want to call the encryption program to decrypt the card number, so the actual card number can be printed in the body of the report.
There will probably be a requirement to write some parameter selection SQL as well, so a card nmuber can be entered as a report parameter field, which the SQL will have to either encrypt first, then process the SQL statement down the tables.
Has anybody use this technique before?
Thanks
Graham N.
I have an application that uses SQL Report Builder to edit templates. When I go to add a dataset to add a custom field to the report, I get a permissions error (screenshot Error). When I check the credentials for the shared datasource, they are all grayed out, so I can’t verify the credentials being used (screenshot Error 2). According to SQL Management Studio, the user credentials have the right permissions. The weird thing is, I can access the datasets and shared datasource embedded in the report just fine. I just get a permissions error whenever trying to create a new dataset.
View 2 Replies View RelatedI Installed SQL Reporting services 2012 service with sharepoint 2013 ... and started it with success..I followed the microsoft's procedure.. URL....After , I have not encountered any problems when I created the application <--- 3 databases created in my SQLSERVER instance//The problem occured when I tried to click on my ssrs application_name --> system settings...ERROR 500 Correlation ID: f6c5f49b-6ab0-4009-6f31-fd019ddc3ecc
This what I read in the log of sharepoint -->
01/14/2013 12:18:36.22    w3wp.exe (0x0BEC)                         0x05D8   SharePoint Foundation      Â
    Monitoring                      nasq   Medium     Entering monitored scope (Request
(GET:http://vwaisql201202:22628/_admin/ReportServer/ReportingServicesSystemSettings.aspx?ID=5abbbf0d-e8dd-4e8e-93d6-eddc77225a9f)). Parent No  Â
[code]....