ReportViewer Control And Aggregate RDL Expressions

Jul 5, 2007

I've been successfully using the WinForm ReportViewer control to view reports from relational databases. I'm starting to investigate viewing reports based on Analysis Services 2005 multi-dimensional sources.



From my reading (including the following thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1432935&SiteID=1), it seems that the RDL Aggregate function is key to getting proper results in expressions.



The RDL spec indicates that the Aggregate function behaviour is tightly coupled with the Data Processing Extension (DPE). This is fine for web-based Reporting Services, but with the ReportViewer control, we do all data processing and provide a .NET DataTable object that the viewer consumes and evaluates expressions from.



How does the WinForm ReportViewer handle evaluating the Aggregate function when there is no DPE to talk to?



Thanks!

View 5 Replies


ADVERTISEMENT

Reporting Services :: Aggregate Functions Cannot Be Used In Group Expressions

Apr 21, 2015

I have report showing sales by Vendor. I need to list all the vendors with Monthly Total>5000 and combine the rest as "OTHER VENDORS"

Vendor is a Group in my report, so I tried to put an expression as a Group on:

=IIF(Sum(Fields!Mth_1_Sales.Value)>5000,Fields!Vendor_No.Value,"OTHER VENDORS")

I've got an error: "aggregate functions cannot be used in group expressions"

How do I get Vendors with Sales < 5000 into  "OTHER VENDORS" ?

View 4 Replies View Related

How To Use Reportviewer Control

Jun 15, 2007

Hi,



I have couple of reports designed and they are on the report server and those reports are driven using some strored procedures.



I am building a asp.net program and want to use the reportviewer control in it, and i was wondering if there is any way that i could reference the reports thats been created usiing BIDS and use them in report viewer, or do i have to build them from scratch.



Any ideas pls?



Regards

Karen

View 9 Replies View Related

Problems With The ReportViewer Control

Sep 1, 2006

The client side reportviewer control is used with a typed dataset in vs 2005. But I have noticed something that is really interesting, the turkish characters in the dataset are changed in the runtime enviroment when used with the reportviever control. such as.exec sp_executesql N'SELECT        CASES._ID, CASES._OWNERID, CASES._LASTMODIFYDATE, CASES._DELETIONSTATUS, CASES._SECURITYCODE, CASES._NAME, CASES._STATE,                          CASES._DESCRIPTION, CASES._CATEGORY, CASES._TYPE, CASES.PRIORITY, CASES.REASON, CASES.ORIGIN, CASES.FROMDATE, CASES.TODATE,                          CASES.COMMENT, CASES.WHATID, CASES.WHATTYPE, VIEW_WHONAME.WHONAME, ORGANIZATION._NAME AS ORGANIZATIONNAME,                          PERSON.HOMETEL, PERSON.EMAILFROM            CASES INNER JOIN                         VIEW_WHONAME ON CASES.WHOID = VIEW_WHONAME.WHOID INNER JOIN                         PERSON ON VIEW_WHONAME.WHOID = PERSON._ID INNER JOIN                         ORGANIZATION ON PERSON.WORKINGORGANIZATIONID = ORGANIZATION._IDWHERE        (CASES._OWNERID = @ownerID) AND (CASES._ID = @entityID) AND (VIEW_WHONAME.WHOTYPE = ''KÄ°Åžİ'')',N'@ownerID smallint,@entityID int',@ownerID=1,@entityID=30 ------------------------------------>>> the bold area should be 'KİŞİ'  which is a turkish string....What sholud I do?  Do I need to configure the sql server or do I need to configure asp.net runtime?

View 4 Replies View Related

Problem With ReportViewer Control And IE7

Jun 20, 2007

Hi,



We have a problem with our ASP.NET 2.0 app in one aspx page which contains reportviewer control.

The problem is in this: When this page is shown in IE6 the reportviewer control is working OK and the report is shown, but when this page is shown in IE7 reportviewer control starts to act strange. The report isn't shown until F5 or refresh button isn't clicked. Does anybody have problem like this one?



Thanks in advance



CypS

View 1 Replies View Related

Using Webservice In ReportViewer Control

Dec 26, 2006

HI

I want to use ReportViewer Control to show the data.
Can I render report using Sql Server 2005 Reporting web service call. I didn't get any sample which allow me to host report on reporting server but view them using ReportViewer Control using webservice call rather than using URL.

I need to hide Reporting server URL location. And If you show report using ReportViewer Control using URL mechanism, anybody can see the report server url.

View 3 Replies View Related

Problem With ReportViewer Control

Sep 13, 2006

I have an ASP.NET web site with form authentication.

When I use a ReportViewer control in a page (with a masterPage) and my report (ServerReport and Remote processingmode) has DateTime parameters I can't see that calendar gif in order to select a date. Same thing with a DropDownList bound to a dataset for another paramater (I can't see that arrow from the right side of DropDownList so I can't dropdown it).

When I want to see the report with a browser direct from my Reports site it works fine. Only in reportviewer has this simptoms.

IE has some errors in script

1. 'RSClientController' is undefined

2. 'ClientControllerctl00_contentPanel_ReportViewer1' is null or not an object.

3. 'DropDownParamClass' is undefined.

I found other posts with the same simptoms:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=327473&SiteID=1

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=358590&SiteID=1

but the solution found there doesn't apply to me.

Any suggestions ?

View 3 Replies View Related

Updating ReportViewer Control

Apr 23, 2007

I have a Gridview control and a ReportViewer control that use the same datasource (SqlDataSource1). The gridview displays rows and columns of data and the ReportViewer displays a chart of the same data. This works fine when the page is initially loaded.



I also have a couple textboxes where the user can select a start and end date and press a submit button.



When the submit button is selected the SelectCommand of SqlDataSource1 is modified to use the new dates (SqlDataSource1.SelectCommand = SQLString).



The Gridview correctly updates the data based on the user-selected dates but the chart in the ReportViewer control does not change. It is still displaying the data before the user selected a start and end date. Why does this happen when they are using the same SqlDataSource1??



Protected Sub button_submit_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles button_submit.Click



Dim SQLString As String



SQLString = "select tech_clients.client_name, SUM(tech_hours_worked.hours_worked) as hours_worked_per_client " & _
"from tech_hours_worked, tech_clients " & _
"where tech_hours_worked.hours_company_id = tech_clients.client_id And tech_hours_worked.hours_company_id <> 1 and tech_hours_worked.hours_worked_date >= '" & TextBox_start_date.Text.Trim & "' and tech_hours_worked.hours_worked_date <= '" & TextBox_end_date.Text.Trim & "'" & _
"group by tech_hours_worked.hours_company_id, tech_clients.client_name " & _
"order by hours_worked_per_client desc"



SqlDataSource1.SelectCommand = SQLString



End Sub

View 1 Replies View Related

Autosize Reportviewer Control

May 8, 2006

I want the reportviewer to display the report exactly over the entire screen. If I try to use "width=100%", the report viewer control expands beyond the screen area making us to scroll to view the "View Report" button. However, in the report manager, the same report gets displayed exactly occupying the screen size no matter what resolution the screen size is.

How is it done?


Thanks.

View 3 Replies View Related

Does VS 2003 Has A Reportviewer Control With It Framework 1.1

Sep 21, 2006

We have a project fully developed using framework 1.1 VS2003.

We are currently working on the reports, i see the reportviewer control but, there seems to be lot of problems.

Please does anyone know, is there a report viewer control developed by microsoft or somebody which works with VS2003 and pointing to SQL server RS 2005.

Please help thank you very much for the information.

View 1 Replies View Related

Troubleshooting Errors When Using The Reportviewer Control

Mar 29, 2007

Is there some way of troubleshooting errors when using the reportviewer control (with no reportserver).? Specifically, I am dynamically loading supreports and their ascociated datasets. I get an "Error: Subreport can not be shown." in the report viewer display panel at run time. In the past when I have gotten them it was a matter of randomly trying things until I hit on the problem. I can trace it to the point where I load the dataset for the subreport and all seems correct. There are no report parameters to be passed so I know its not that. I've double checked the subreportname,datasource and dataset names and they are all okay.



Any help would be greatly appreciated.

View 4 Replies View Related

Using ReportViewer Web-control From Linux Client

May 5, 2007

I'm about to create a web-page that will display RS-reports using the ReportViewer.

What is the client demands for being able to use the ReportViewer web control?

Can a linux-client using let's say Firefox use the ReportViewer?



Regards Andreas

View 1 Replies View Related

ReportViewer Control And SOAP Version

Dec 19, 2006

We have just upgraded from an embedded browser hosted RS2000 system to the Microsoft.ReportViewer.Winforms control for RS2005 in our applications, and have encountered a SOAP / firewall problem again.

We were using an embedded browser to display the reports, as some of our client sites block or strip the SOAP wrapper from SOAP 1.1 commands that the old RS2000 control tried to use when the data passes through their firewall. We have no control over, or visability of their firewall configuration, as this is part of their own site security.

Is RS2005 still using the same older version of SOAP, or has it been moved up to version 1.2, which I believe does not trigger as many alarm bells in some firewall systems.

We have no problems makeing web service calls to our own applications through the firewall, so its only the report viewer control that gives us these problems.

I have not been able to explicitly clarify this down to the SOAP version, but it looks too close the our previous firewall problem to be anything else - comments invited !!!!!

As an aside, is there any way to trace the inbound request through IIS to ReportServer so I can see what hits the report server ? The IIS logs alone show a request has been made, but no qualifying data, and the report server logs only seem to show processing once the request has been accepted. What I want to to is see the inbound request, and then the outbound error message being returned so I can confirm my suspicions.

I have posted a similar thread on google groups for reporting services.





View 1 Replies View Related

Localization Web ReportViewer Control In VS2005

Jan 17, 2008

Hi everyone,I followed the steps below to localize the report viewer control accoring to http://msdn2.microsoft.com/en-us/library/ms251723(VS.80).aspx"
Deploying Localized Versions of ReportViewer ControlsThe ReportViewer control includes language packs for eight languages: Chinese-Simplified, Chinese-Traditional, French, German, Italian, Japanese, Korean, and Spanish. To use a localized version of the control, you must do the following:1. Run ReportViewer.exe.2. Navigate to the folder that contains the language pack you want to use. Language pack folders are located at <drive>:Program FilesMicrosoft Visual Studio 8SDKv2.0BootStrapperPackagesReportViewer<lang>.3. Run ReportViewerLP.exe."
But I could not find the ReportViewerLP.exe in the step 3. Could anyone please tell me why?Thanks a lot.Danny

View 1 Replies View Related

Web User Control Inherited From ReportViewer

Feb 5, 2008

Hi,
Is it possible to create a web user control inheriting from Microsoft.Reporting.WebForms.ReportViewer? When I do this it gives me an error during compile saying



Code SnippetMake sure that the class defined in this code file matches the 'inherits' attribute, and that it extends the correct base class (e.g. Page or UserControl).




But the class definition of ReportViewer doesn't say it's sealed or non-inheritable. What is it that I am missing?

Thanks.

View 2 Replies View Related

ReportViewer (web Control) - Parameter Change Refresh

May 13, 2007

I have created an ASP.NET website with a ReportViewer on. The report renders fine, but when I change one of the parameters (manually), the report seems to invalidate itself and a blank while area is drawn. I would like the same behaviour as in the WinForms variant, where rhe rendered report remains the same until the 'View Report' button is pressed.



Is this possible?



Regards Andreas

View 1 Replies View Related

ReportViewer Control - Page Navigation Not Refreshing

Jan 17, 2008

I am using a ReportViewer Control inside of a Windows Form and ran into an issue with the page navigation failing to update upon refresh (the report itself does refresh - the page navigation does not). If the initial report has one page and the subsequent refresh produces five pages, the page navigation window only shows one page. If you manually type in page two or three, nothing happens.

Here is a code snippet:


private void adpTaxServicesForm_Load(object sender, EventArgs e)

{

this.reportViewer.RefreshReport();

}



private void button1_Click(object sender, EventArgs e)

{

this.reportViewer.SuspendLayout();



this.reportViewer1.RefreshReport();

this.reportViewer.ResumeLayout();
}


Any help would be greatly appreciated...

Thanks,

-Fernando

View 1 Replies View Related

Help! Jump To Report: Error With Web Reportviewer Control

Jan 14, 2008

Hello everyone,
I have a report that has a "Jump to report:" link in it and in the report it jumps to there is another "Jump to report:" link. When I click on this link I get the following error.

The path of the item '(null)' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)


I have tried moving the link from the header to the body of the report with the same results.

This is only happening in the web reportviewer control as our windows app works flawlessly.

We are running SQL SERVER 2005 SP2.


Does anyone have a fix, workaround or idea how to resolve this issue?

Thanks in advance

-JW

View 13 Replies View Related

Error On Reporting Server - But Only Through The ReportViewer Control

Apr 11, 2006

We are using the webviewer control.

We get the following error when we try to export to EXCEL.



InternetExploer cannot download ...n=OnlyHtmlInline&Format=EXCEL from app.webcobra.com.

Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.



This error comes up almost immediatly after it starts trying to download the file. It is a large dataset but it isn't "overly large". There are basically 44 records.

The other wierd thing is that it works fine on our BETA servers but not on our Production servers. We figure this is a setting somewhere that we have missed.

And now I found out that if it just leave it sitting there it eventually asks me if I want to open the file and it opened fine.

So what was the above error all about????

Does anyone have any ideas that I can look into?

Thanks!

View 6 Replies View Related

ReportViewer Control And MOSS Reporting Services

Mar 10, 2008



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> --.

View 16 Replies View Related

Remove Export Options From ReportViewer Control

Feb 26, 2008

I found this method that will remove export options from a server report when called through ReportViewer. I like this one because you dont need to have a web reference to the SQL server to loop though each rendering extension. How do you call this method if for example, if wanted to remove the XML format from a particular report? I have tried ReflectivelySetVisibilityFalse("XML"), but no luck. Any clues?


private void ReflectivelySetVisibilityFalse(RenderingExtension extension)
{
FieldInfo info = extension.GetType().GetField(€œm_serverExtension€?,
BindingFlags.NonPublic | BindingFlags.Instance);
if (info != null)
{
object actualExtension = info.GetValue(extension);
if (actualExtension != null)
{
PropertyInfo propInfo = actualExtension.GetType().GetProperty(€œVisible€?);
if (propInfo != null && propInfo.CanWrite)
{
propInfo.SetValue(actualExtension, false, null);
}
}
}
}

View 9 Replies View Related

Binding Render Output To ReportViewer Control?

Jul 13, 2006

I'm trying to take the output of the Render method and bind it to the ReportViewer control. First of all, is this possible? If so, what is the best way to render the report (format: XML,CSV, NULL, etc), and then how to I 'bind' the result to the control?

I'm proving some code to demonstrate how I'm rendering the report:
...
string format = "XML";
string devInfo = @"<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
ReportExecutionService rs = new ReportExecutionService();
ExecutionInfo execInfo = new ExecutionInfo();
ExecutionHeader execHeader = new ExecutionHeader();
byte[] result= null;

rs.ExecutionHeaderValue = execHeader;
execInfo = rs.LoadReport(path, null);
string SessionId = rs.ExecutionHeaderValue.ExecutionID;
result = rs.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);


Thanks, any help would be greatly appreciated.
Peter

View 2 Replies View Related

ReportViewer Control Remove Scroll Bar Keep Document Map

Nov 7, 2007

I am accessing remote reports via the Web ReportViewer control. I need to keep the document map on the report but I want to get rid of the extra set of scroll bars. Setting AsyncRendering to false removes the scroll bars and the document map. Is there a way to get rid of the scroll bars and keep the document map?

View 2 Replies View Related

Save Parameters To The Database Using Reportviewer Control.

Mar 11, 2008

I have reportviewer control into the aspx page and i want to save the parameters informations to the database. but i also want to stick with reportviewer parameter UI instead of my own UI.

Is that possible using ReportViewer?

Thanks in Advance

Rohit

View 1 Replies View Related

Incomplete Print Output From ReportViewer Control

Dec 29, 2006

We are experiencing a problem where a server report is rendered in the
ReportViewer control successfully but when the user chooses to print the
content, the print output is incomplete (ex. only 18 of 23 pages are printed,
etc.).

This is happening consistently and has been reproduced for multiple
different reports. It does not happen if the same report is printed via the
Report Manager web interface.

I have also found that if I switch to Print Layout mode and then initiate
the print from the ReportViewer that the problem does not occur. This is our
current workaround, but it would be nice to know what is causing this and
have it fixed.

Has anybody else seen this? Is this a known issue with my current version
(SQLRS 2005 with SP1 applied).

Thanx in advance.

View 3 Replies View Related

Print From ReportViewer Control Causes Blue Screen

Nov 30, 2007

Hi,

I have a MS Reporting Services Report which I display in a ASPX page inside a iFrame (i.e. an other ASPX page displayed inside the main ASPX page).
The report is rendered to the screen using the normal ReportViewer control.

Everything works fine, except when I click on the Print Button on the ReportViewer control, I get a Blue Screen of Death (BSOD) and my computer restarts.
This is something that happens every single time I click on that Print button

Has this happenend to anyone else?

Regards,
Thysie

View 4 Replies View Related

ReportViewer Control Fails With Forms Authentication

Mar 23, 2006

I am using forms authentication with reporting services. When I use ReportViewer control calls like:

ReportViewer1.ServerReport.ReportServerUrl = new Uri(http://localhost/reportserver);

ReportViewer1.ServerReport.ReportPath = "/Reports/report1";

ReportViewer1.ServerReport.Refresh();

in a web app

I get 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>

Anyone knows how to resolve this issue?

View 3 Replies View Related

Display Home Page In The ReportViewer Control

Jan 17, 2008

Is it posible to display the reporting services home page in the ReportViewer control?

I can display any of the published reports by setting the path e.g.,


serverReport.ReportPath = "/My Folder/My Report"

Is there a way of using the same command to show the home page?

I have tried a combination of "", "/" and "/Home" but none of them seem to work.

View 7 Replies View Related

Is It Possible To Set Parameters For The Reportviewer Control By Remote Mode

Jun 20, 2007

Hi.

Is it possible to set Parameters for the reportViwer control in remote mode.



I tried doing this

ReportViewer1.ServerReport.SetParameters(Session("ClientId")) and got this error


Unable to cast object of type 'System.Int32' to type 'System.Collections.Generic.IEnumerable`1[Microsoft.Reporting.WebForms.ReportParameter]'.

View 3 Replies View Related

Multiple Rdlc Files In One Winforms ReportViewer Control

Aug 14, 2007


How can I add multiple rdlc report definitions to a single Winforms ReportViewer control? I would like to start with the first rdlc and concatenate subsequent rdlc files after that. I want the user to be able to scroll through several different rdlc report definitions as if they were all just one report.

View 4 Replies View Related

Localize Web ReportViewer Control In VS2005 / SSRS 2005 / ASP.net 2.0???

Apr 24, 2006

Is it possible to translate the web report viewer control to another language (german, french...)? I need to integrate the control in a multilingula website.

I need also to change the messages from the report during the rendering "Report is being created".

And is it possible to change the little green animated icon during the process of creating a report?

Thanks,
Dirk

View 7 Replies View Related

Not Able To Display Images Of PNG Type When Placed In ReportViewer Control During Runtime

Jan 27, 2006

Hi,



I have placed a Image Control in ReportViewer , and in design mode the image(.png) is displayed properly and when it is deployed , i am not able to see the image.

whereas there is no problem of images of gif or jpg or bmp or jpeg type. only problem is image of png type.

View 4 Replies View Related

Reportviewer Control (from VS 2005, In Conjunction With SQL Reporting Services)

Aug 2, 2007

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>
&nbsp;

</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

View 23 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved