I have report that I have to render in PDF (invoice type report). The report itself has 4 tables.My last table should always fit on one page. I have checked the checkbox under the table propeties to say "Fit table on one page if ossible"...but it never works. My last table always splits between two pages.My table is not static, it will grow depends on it's data.
View 3 RepliesI am truying to work in my PC with reporting services 2008, but I got this message:
The report server can not decrypt the symmetric key used to access sensitive or encrypted data in a database server reports. You must restore a key from a backup or delete the encrypted content.(RsReportServerDisabled) .
I would like to design master page header to show report title and date. For Master footer page, I want to show address and page number. Thus, all report no need to design more page header and footer.
View 5 RepliesI am new to Sql Server Reporting .How to customize sql server reporting services home page?
Means, how to put some background picture, how to change shapes of Tabs, how to Insert Header Picutre at the top and so on.
I run SQL Reporting Service 2000 with his service pack, our application is under VS 2003. When we generate a report the print icon does not work, so we hace to export to PDF format in order to print it. How to solve this problem?
View 1 Replies I have a web application that contains some reports using Microsoft ReportViewer (Version 8.0). They have been working fine on my local machine with Visual Studio 2005 installed.
But in my hosting the export option does not work neither print button (the show print button is true). Also the page next and previous page options not work.
I'm generating the rdlc at runtime and I'm using LoadReportDefinition(memorystream) to provide the definition to report viewer. It works fine but when I export it to pdf or excel, the file extension comes in as .xls[1] or .pdf[1].
I have tried giving the DisplayName property but it doesn't work.
i am on a report in which i need to show the Total of Current Page in page footer then i want to carry forward this total to Next page's Page Header. How can i do it?
View 6 RepliesIn my ASP.Net web application, I have a base page that implements functionality that spans all pages of the web application and my web pages derive from this base page. Since there is a single master page for the entire website, I don't want to attach the master page in each of the web pages. So I attached the Master page via the basepage's OnPreInit method as follows:
protected override void OnPreInit(EventArgs e)
{
this.MasterPageFile = "~/Site.master";
base.OnPreInit(e);
}
However, when I switch to Designer view, I get the "Master Page Error"; The page has controls that require a Master Page reference, but noe is specified. Correct the problem in Code View.When I run the application, the webpage shows up correctly.What should be done so that the designer shows up correctly without having to go and set the master page explicitly in each of the web pages?
BTW, I am on Visual Studio 2010 and .Net 4.0
I have very simple validation on the aspx page (highlighting not valid textbox), and it works perfectly. But when I try to work with this page using MasterPage, I've got an error - "Object reference not set to an instance of an object." (with reference to the line "aControl.BackColor=Drawing.Color.White" - underlined).
Here is the code of the content page.
<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" CodeFile="testValid.aspx.vb" Inherits="testValid" %>
[Code].....
just a quick question -i cant get my class in App_Code to work in my code behind page for simple .net page, some light what doing wrong?
[Code]....
I have question is it possible to install Report Manager (IIS Service) on different server than Reporting Services is installed? I would like have IIS service (Report Manager) on one server and Reporting Services mechanism on the second one. Do you think this solution is possible?
View 2 Repliesi want to show my footer in rdlc report only in last page ?how do i do it?
View 2 RepliesI am working on a report using local mode ReportViewer. The report layout is 2-column newspaper style. When I run the report, only one column is filled in on the first page but both columns are filled in correctly on subsequent pages.
How do I get it to fill in both columns on the first page? visual Studio 2008, VB, .net
Using SSRS 2000 (SP2) - I have several reports that come up fine when displaying the first page. However, upon hitting the arrow in the ReportViewer to move to page 2 (or the last page, doesn't matter) , I get a "Reporting Services Error":
An unexpected error occurred in Report Processing. (rsInternalError)
Specified cast is not valid.I'm going to include below the point in the log at which the error shows up - something to do with GetChunkPointerAndLength... does anyone know what can cause this, and what the workaround or solution might be?
Here's the log info:
w3wp!chunks!3d4!08/12/2010-15:50:53:: e ERROR: GetChunkPointerAndLength: System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
w3wp!library!3d4!08/12/2010-15:50:53:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, String& mimeType)
at Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.Library.SessionReportItem.GetImage(String imageId)
at Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
at Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
at Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest session, CatalogItemContext itemContext)
--- End of inner exception stack trace ---
w3wp!webserver!3d4!08/12/2010-15:50:58:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.InvalidCastException: Specified cast is not valid.
w3wp!library!3d4!08/12/2010-15:51:06:: i INFO: Call to RenderNext( '/MasterReconciliationByType/WillCallwCC' )
w3wp!chunks!3d4!08/12/2010-15:51:06:: e ERROR: GetChunkPointerAndLength: System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
w3wp!processing!3d4!08/12/2010-15:51:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, String& mimeType)
at Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
--- End of inner exception stack trace ---
w3wp!webserver!3d4!08/12/2010-15:51:11:: e ERROR: Reporting Services error Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.InvalidCastException: Specified cast is not valid.
w3wp!library!c3c!08/12/2010-15:51:51:: i INFO: Call to RenderNext( '/MasterReconciliationByType/WillCallwCC' )
w3wp!chunks!c3c!08/12/2010-15:51:51:: e ERROR: GetChunkPointerAndLength: System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
w3wp!processing!c3c!08/12/2010-15:51:51:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, String& mimeType)
at Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
--- End of inner exception stack trace ---
w3wp!webserver!c3c!08/12/2010-15:51:56:: e ERROR: Reporting Services error Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.InvalidCastException: Specified cast is not valid.
w3wp!session!c3c!08/12/2010-15:52:06:: i INFO: LoadSnapshot: Item with session: vrfg4l451fvetg55mqr3zp45, reportPath: /MasterReconciliationByType/WillCallwCC, userName: MASTER
sexec not found in the database
w3wp!library!c3c!08/12/2010-15:52:06:: i INFO: Call to RenderFirst( '/MasterReconciliationByType/WillCallwCC' )
w3wp!library!c3c!08/12/2010-15:52:11:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!c3c!08/12/2010-15:52:11:: i INFO: Processed report. Report='/MasterReconciliationByType/WillCallwCC', Stream=''
w3wp!chunks!c3c!08/12/2010-15:52:11:: e ERROR: GetChunkPointerAndLength: System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
w3wp!library!c3c!08/12/2010-15:52:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, String& mimeType)
at Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.Library.SessionReportItem.GetImage(String imageId)
at Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
at Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
at Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest session, CatalogItemContext itemContext)
--- End of inner exception stack trace ---
w3wp!webserver!c3c!08/12/2010-15:52:16:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.InvalidCastException:
Specified cast is not valid.
w3wp!library!1e50!08/12/2010-15:52:23:: i INFO: Call to RenderNext( '/MasterReconciliationByType/WillCallwCC' )
w3wp!chunks!1e50!08/12/2010-15:52:23:: e ERROR: GetChunkPointerAndLength: System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
w3wp!processing!1e50!08/12/2010-15:52:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, String& mimeType)
at Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
--- End of inner exception stack trace ---
w3wp!webserver!1e50!08/12/2010-15:52:28:: e ERROR: Reporting Services error Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.InvalidCastException: Specified cast is not valid.
w3wp!session!3d4!08/12/2010-15:56:51:: i INFO: LoadSnapshot: Item with session: gavqaq55mhxzux45xiaulrfe, reportPath: /MasterReconciliationByType/WillCallwCC, userName: MASTER
sexec not found in the database
w3wp!library!3d4!08/12/2010-15:56:51:: i INFO: Call to RenderFirst( '/MasterReconciliationByType/WillCallwCC' )
w3wp!library!3d4!08/12/2010-15:56:54:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!3d4!08/12/2010-15:56:54:: i INFO: Processed report. Report='/MasterReconciliationByType/WillCallwCC', Stream=''
w3wp!chunks!3d4!08/12/2010-15:56:54:: e ERROR: GetChunkPointerAndLength: System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
w3wp!library!3d4!08/12/2010-15:56:54:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, String& mimeType)
at Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String name, ReportChunkTypes type, String& mimeType)
at Microsoft.ReportingServices.Library.SessionReportItem.GetImage(String imageId)
at Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
at Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
at Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest session, CatalogItemContext itemContext)
--- End of inner exception stack trace ---
w3wp!webserver!3d4!08/12/2010-15:56:59:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.InvalidCastException: Specified cast is not valid.
w3wp!library!3d4!08/12/2010-15:59:39:: i INFO: Call to RenderFirst( '/MasterReconciliationByType/SalesDetailAll' )
w3wp!chunks!3d4!08/12/2010-15:59:41:: e ERROR: GetChunkPointerAndLength: System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
w3wp!reportrendering!3d4!08/12/2010-15:59:41:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown., ; Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. ---> System.InvalidCastException: Specified cast is not valid.
at System.Data.SqlClient.SqlDataReader.GetSqlByte(Int32 i)
at System.Data.SqlClient.SqlDataReader.GetByte(Int32 i)
at Microsoft.ReportingServices.Library.ChunkStorage.GetChunkPointerAndLength(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, Object& chunkPointer, Int64& chunkLength, String& mimeType, ChunkFlags& chunkFlags)
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream.OpenReadStream()
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SqlChunkReadStream..ctor(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType)
at Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32 chunkType, String& mimeType)
at Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String name, ReportChunkTypes type, String& mimeType)
If exports the report as Excel format, how can I set the page margin in excel as 0.5cm ?
View 3 RepliesI have a rectange that has some printable elements. I want everying in the rectangle to print on one page. I don't want a new page ALWAYS before the rectange prints, I only want a new page if the entire rectange wont print on the current page
View 1 RepliesI have a print button on my site, and when I click it I would like it to print everything EXCEPT the Master Page. I don't care to waste the space and ink on all of the menu and header stuff. Does anybody know how to do that? I'm running Visual Studio 2008.
View 1 RepliesMy data is spreads to few pages. Is it possible to display all of them on one page?
I tried increasing the report Height, height of the reportviewer control I am using, but they don't work.
In my report i want the headers to appear on each page when i go
to view the report.
Here are the actions i have done:
1) Insert > Table > Insert New Table on to the report
2) I have then dragged the fields from the dataset on to the report.
3) I have clicked on the Header of the column, then clicked Tablix Properties
I have clicked in the tick box: Repeat header rows on each page.
4) I have also clicked Keep header visible while scrolling.
5) I have clicked ok.
When i go to run the report, i can see all the page headers on Page1. If i go
to page 2 and so on, I am unable to see the headers.
I have a report which displays some textbox and a table. In "PDF" format, if table not fit in the page it start in text page. bu i want to display some row of the tabe in a main page (that if how many rows is possibel to show) and other in text page (that rest of others rows) but it is display to all row to next page
View 2 RepliesMy main report is about half of a page long, subreport contains a table and its length depends on how many rows the table has. But even when a single row, subreport jumps to second page. How to prevent it?
View 5 RepliesI am creating an Invoice. Where company address must come at the bottom of the page. But I cannot use any fields in header and footer. How can I serve this requirement?
View 1 RepliesHow to set report parameter value from the UI page to My Report.
I can able to launch the report list in my ui page. I can open the reports which are there in my report server. I am generating Report by clicking the button am storing report server URl in string & Redirecting that URL by clicking button in below way,
strcompleteUrl = "My ReportServer Name" + Server.UrlEncode(strFolder) +"/"+ "Availble+files" + "&" + strcompleteUrl + "rs:Format=PDF" ;
Response.Redirect(strcompleteUrl);
When I am launching the report from UI page I need to pass report parameter value .. I am generating my report based on Fileyear.
How to pass the fileyear to my report url. ??
My report parameter values are coming from my stored proc. How to assign that stored proc value to my CompleteURL.
I am calling a report from my ASP web app and was working perfectly, but now for some reason the report is coming up as blank and only shows the header section where it shows export, page numbers etc...The report works 100% direclty from reports and reportsmanager but not from my application - there are no errors to even guide me to solving it.At first i had reporting services 2005 and was having this problem and then i installed Reporting services 2008 and hosted the report on there but i am still getting the same problem.....very frustrating!!Does anyone have any idea what could be causing this??
This might be a clue: this app is on my clients pc and i installed VS2010 on the pc so i can try troubleshoot this but when i open the app VS2010 tells me it is setup to use framework 2.0, strange cause before this problem i opened it in vs2010 and was in framwework 4.0 - but now ifi go to the build dropdown it does not give me the option to select framework 4.0 - just goes up to 3.5??the app was originally created in VS2005 then I upgraded it to vs2010.........it could be possible that there is aconflict with the report viewer on the webpage conflicting somewhere???the app still works 100%(except for reporting) on IIS using framework 4.0 so it is still on the PC..please help - my client is unable to use the app without the printing and i am getting desperate!!Here are the hardware and software details:
-Windows 7 Pro
-IIS 7
-framework 2, 3.5 and 4
-ASP.net 4 Web app developed in VS2010
-DB on SQL 2005 exp adv
-also have SQL2008 exp adv installed