Problem With Page Borders When Rendering Report In Html
Dec 28, 2007
Hello,
I created a report with borders in the page header, the page body, and the page footer. When I preview the report in report viewer it is exactly how I want it and it also prints and exports to pdf perfectly. There's only a problem viewing it in report manager. The borders in the page header and footer show up right but the body of the report's borders don't show up at all. The body of the report also is no longer aligned with the page header and footer because it's borders seem to be unrecognized in the report manager view. Has anyone experienced this problem and/or figured out what to do to fix this? Please let me know.
We have a "Comment" field that is saved as a HTML string to the DB. This field needs to be pulled into a report as rendered HTML.
I know this has been hashed out before, but has anybody found a good solution in the past couple of months?
We are thinking about storing two versions of the Comment in the DB: one with HTML, one as simple text. Has anybody found this an acceptable solution? I know it flies in the face of good DB design, but it seems the quickest, easiest solution...
Any word if this will be fixed in the next major release of SSRS? Can we expect this release any time soon?
We are facing an issue where the report rendering for specific report parameters is failing with an exceptionÂ
Throwing Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: , Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.TablixContext.CalculateDetailCell(PageItem topItem, Int32 colIndex, Boolean collect, PageContext pageContext)
[code]....
The server is running in Native mode. We tried restarting the services and also verified the disk space. Neither of them worked. The ExecutionLog3 table in the "ReportServer" database shows a rrenderingError as the report execution status. Report rendering with Excel format works fine.We enabled verbose logs and they are shared here. URL....
my report dont fit on a A4 letter. thats not a problem at the report viewer but when i print or export the report. can i scale the report to fit to one page??
I have uploaded a html-page to the Report Manager, the html-page has a img-tag with a src="Picture1.png" in it. The image is then uploaded to the same folder as the html-page. When I browse the html-page the image is not found, red cross, does anyone know why this happens?
I need to create forms for my users containing boxes and lines. When I get the boxes/lines looking correctly for PDF printing, they look really whacked out in HTML view. I understand this is caused by overlapping objects (lines on top of boxes, etc.) I tried a test to see if I could use all lines. This is VERY difficult to get aligned correctly for HTML view. Once I got my test completed, the HTML looked ok -- not great, but the PDF rendering looked REALLY bad.
Is there a way to overlap objects and tell the package to 'group' all the objects as one (like in Word) for HTML rendering? I need to put a karge rectangular box with lines and textboxes on top of it.
I've got a simple gridview and detailsview set up so the details view shows the selected item in gridview. But one of the fields contains HTML code and it's being displayed instead of rendered. There must be some easy way to use a panel or some other control and tell it dynamically what HTML to render, right? I saw one other post where someone suggested using a third party html editor like fckeditor but that just seems ugly and I really don't care to spend the time installing and configuring someone else's control for such a simple thing. Maybe I can assign the field to a variable and then response.write it? But then I can't change it dynamically based on my gridview selection... Any ideas?
Our system is set up using SQL Server 2000 and Reporting Services for SQL Server 2000. Our web application is built with Visual Studio 2003, C# and .Net Framework 1.1 and is a 3-tier application. On both our localhost and development builds of the application, the images that get rendered do show up properly. On our live build, the images do not.
One difference that we found is that on the live build, users do not have file permission access to our middle tier that is running reporting services. After examining the URL of where the image is trying to point to, we see that it is trying to access the middle tier from the front presentation tier.
My question is, is there a way to send a certain parameter into the Render method to have the images stored somewhere else? Any help would be greatly appreaciated. Here is the code we currently have:
ReportingService rs = new ReportingService(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
reportParameters[0] = new ParameterValue(); reportParameters[0].Name = "par_userID"; reportParameters[0].Value = userID;
reportParameters[1] = new ParameterValue(); reportParameters[1].Name = "par_menuID"; reportParameters[1].Value = menuID;
reportParameters[2] = new ParameterValue(); reportParameters[2].Name = "par_URL"; reportParameters[2].Value = reportURL;
reportParameters[3] = new ParameterValue(); reportParameters[3].Name = "par_startPage"; reportParameters[3].Value = startPage;
reportParameters[4] = new ParameterValue(); reportParameters[4].Name = "par_endPage"; reportParameters[4].Value = endPage;
//Clean up old files RemoveFiles(ConfigurationSettings.AppSettings["tempFileLocation"]);
result = rs.Render(reportPath, format, historyID, devInfo, reportParameters, credentials, showHideToggle, out encoding, out mimeType, out reportHistoryParameters, out warnings, out streamIDs);
// // For each image stream returned by the call to render, // // render the stream and save it to the application root // byte[] image; // string optionalString = null; // string tempFilePath = ConfigurationSettings.AppSettings["tempFileLocation"].ToString(); // // foreach (string streamID in streamIDs) // { // image = rs.RenderStream(reportPath, // "HTML4.0", // streamID, // null, // null, // reportHistoryParameters, // out optionalString, // out optionalString); // // FileStream stream = File.OpenWrite(tempFilePath + streamID + ".png"); // stream.Write(image, 0, image.Length); // stream.Close(); // }
// Write the results to the current Web page string htmlout = Encoding.ASCII.GetString(result); htmlout = htmlout.Replace("<hr/>", "");
First of all, this is not in reference to using SRS (SQL Reporting Services) to render a report and then use one of the extensions to render the complete report as a pdf, tiff, excel etc. We have an opportunity to render a list of claims and then embed the supporting docs for each of the claims within the report. We don't have an issue referencing jpg and gif images via URLs and then rendering them within the report after the grid information. We do have an issue rendering tiff images within the report.
You can insert an image object into SRS at design time and have it render and you can convert a complete report to a tiff image but I cannot find a way to be able to render a tiff image when running the report. All you get is the red "x".
My question is has anyone encountered the same issue and, if so, what did you do to resolve the issue?
I am having a main report having two subreports, say M1,S1 and S2 respectively.
The issue is S2 normally tend to go beyond one page, for all pages except first page of the of the subreport I am getting the page header and footer blank,
Actually this is not loading the ReportItems that are used in main report but it shows text boxes containing strings for eg . "My Name" and date functions eg Today()
What we've found is that when you have two reports where one navigates to the other, if you click on the second page of the second report, it takes you to the second page of the original report. If you navigate over to the subreport again and click for the second page, it works appropriately. This is definitely a no-go for production code and this may delay our ship date because I would think this is definitely undesirable.
Conditions:
ASP.NET Report Viewer using Remote Reports Report that links to another report Both reports return more than one page Reporting Services installed Steps to Reproduce:
Download the source code here.
Follow the directions (near the bottom of the post) to get the project set up.
Run it and click on a link in the first report to go to the second report.
Click the arrow for page 2 of the second report.
Notice how it takes you back to page 2 of the first report (this doesn't happen when you are in preview mode in the Reporting Services project and I don't believe it does this in a smart client application).
Click on a link in the first report to go back to the second report.
Click the arrow for page 2.
Notice how it takes you to page 2 of the second report.
Here is a link with source code and a more detailed explanation: http://geekswithblogs.net/robz/archive/2007/11/21/Reporting-Services-2005-BUG-Report-Linking-and-Paging---ASP.NET.aspx
So what I am looking for is both a workaround for now and if this is determined to be a bug, to be fixed in the next service pack.
I am trying to display a price from a table I created in MySQL to a web page. I have created a php form to open and select the home. The data base is simple with a table called homes fields home - size and 4 price fields one being mobile which I am showing here. How to get the information to show up on my index.php page.
php for opening database and file. data2.php <?php require('mysqli_connect.php'); $q = "SELECT * FROM homes WHERE home='solera'"; $result = @mysqli_query ($dbcon, $q); echo '$result.$row['mobile']';
I'm having problems displaying images generated by aspx pages from a report. It works fine if I point the external value to a static image on the web. I can paste the url to the page into IE and it generates the image with no issues. What am I doing wrong? I used a textbox to verify that the correct url is being generated (= Parameters!MYPROJECT_URL.Value & Parameters!MYPROJECT_NO.Value).
Are there any issues with generating external images with reporting services?
I have installed SP1 for MS 2005...shouldn't I see some sort of visual confirmation in Management studio when I click the Help Menu->about? saying the version is MS SQL Server 2005? how do I verify that the upgrade was successful?
I am trying to find a way to implement a page refresh using an SQL Server procedure for an HTML Page. The user will indicate the time for refresh and this would be genereated using the stored procedure..any ideas?????
I am extracting RS reports through a WebService: report = execService.Render("EXCEL", null, out extension, out mimeType, out encoding, out warnings, out streamIds);
Some works fine but some are generating the following SoapException:
Error during processing of €˜ReportParameterTime€™ report parameter. ---> Error during processing of €˜ReportParameterTime€™ report parameter. ---> Error during processing of €˜ReportParameterTime€™ report parameter. I set required parameters to their default values. In this specific report I have two required parameters: 1: ReportParameterTime, String 2: ReportParameter1, String
I set them to their default values (ReportParameterTime to "[Czas].[Kalendarzowy].[Rok].&[2007]" - means Time Calendar Year 2007) but I am getting the exception above. I set parameters using this code:
Where parameterValues is a List<ReportExecution2005.ParameterValue>.
When I am using Microsoft.Reporting.WinForms.ReportViewer the report is generated without any problems. I can see one parameter to choose: "Kalendarzowy" (means adj. Calendar) and can select years, the default value is "2007".
What am I doing wrong and how can I fix this error ? Does anybody know ?
Hello, I'm using Reporting Services to render a text (stored in sql as varchar(max)). The text is all plain text, with some lines having trailing spaces.
Source text file i've imported to SQL via SSIS: CLIENT: 10055 STATEMENT 2007 DATE:1002993 THIS IS THE OTHER STATEMENT COLUMN1 COLUMN2 COLUMN 3 TRY THIS
*Note the trailing spaces on the line before 'STATEMENT 2007'.
I've designed a report using the Report Project in VS2005 to retrieve this text via a stored procedure. When I test the report using the 'Preview' tab in the IDE, it looks good CLIENT: 10055 STATEMENT 2007 DATE:1002993 THIS IS THE OTHER STATEMENT COLUMN1 COLUMN2 COLUMN 3 TRY THIS
But when I deploy the report and run it using URL Access:
CLIENT: 10055 STATEMENT 2007 DATE:1002993
THIS IS THE OTHER STATEMENT
COLUMN1 COLUMN2 COLUMN 3 TRY THIS
On all lines with trailing spaces, they (the trailing spaces) have been removed. This is affecting my formatting of some reports and statements. We really want to use the report viewer as it has built in paging, print and export capabilities.
Why does it look okay in VS2005 but different in Report Viewer via URL Access and Report Manager?
Note: When I export as PDF, it looks okay.
The stored procedure I use to return the data is a CLR Hosted assembly as below:
Code Snippet Partial Public Class StoredProcedures <Microsoft.SqlServer.Server.SqlProcedure()> _
Public Shared Sub GetPagedDocument(ByVal inText As SqlString) Dim dr As SqlDataReader Dim row As New SqlDataRecord(New SqlMetaData("RowText", SqlDbType.Text)) Dim cmd As New SqlCommand("select cast(doc as varchar(max)) as 'DOCTEXT' from testdoc WHERE id='" + inText + "'") Dim cn As New SqlConnection("context connection=true") cn.Open() cmd.Connection = cn SqlContext.Pipe.SendResultsStart(row) 'initialise the resultset to be returned dr = cmd.ExecuteReader 'If no records in result set, return. If Not dr.HasRows Then
row.SetString(0, "There is no document to display or you do not have permission to view the document.") SqlContext.Pipe.SendResultsRow(row) SqlContext.Pipe.SendResultsEnd() ' SqlContext.Pipe.Send("There is no document to display.") Return End If 'Read rows in the result set dr.Read()
'Get the entire text Dim docText As String = dr.Item("DOCTEXT") 'debug row.SetString(0, docText) SqlContext.Pipe.SendResultsRow(row) SqlContext.Pipe.SendResultsEnd() Return 'end debug
May I know how to connect a database writing a source code at html page, is it by using javascript?Because I need to use it for <ul> and <li> tag html to display the text from database. Can you please provide me same example by using this tag. Appreciate if anyone can help me to solve this, thanks
Hi Folks, i am trying to add a connection string value to my client side as follows. i am getting error. any ideas?? <asp:SqlDataSource ID="SqldsComments2" runat="server" ConnectionString='<% session("sqlConn") %>' SelectCommand="SELECT * FROM TicketComments Where TicketNo=@TicketNo "> <SelectParameters> <asp:Parameter Name="TicketNo" DefaultValue="0" Type="string" /> </SelectParameters> </asp:SqlDataSource>
I have a report with a single table, single grouping level, single data set and no sub-reports. It has 3 rows for a grouping header and 3 rows per dataset row of detail. The detail rows are initially hidden and can be expanded by clicking on the header +. Its a fairly standard master-detail report.
Regardless of data size, I get NO page breaks in HTML. I have the Interactive size set to 8.5x11, KeepTogether is set to False, and PageBreakAtEnd is set to False. I would like it to break based on the visible grouping rows.
As it is now, everytime you expand any section, it takes forever to reload for a larger recordset.
I know that "HTML renderer and Preview (which are soft page break renderers) will ignore page breaks of conditionally hidden items and their children.", but how do I get this report to page break?? I've seen a lot of posts on this, but none that seem to have an answer.
Is it possible to edit the pages generated by the web reporting services interface?
If I wanted to change the color of all the pages, or the folder ICON, or perhaps inside a given folder to display something differently?
Is any of that editable, or is the entire reporting services "site" predefined and it just generates folders and directory views as it needs them (meaning if I had two folders I couldn't have one have black background when opened and the other have orange, etc..)
I have several nested sub-total groups that are all coded to "page break at end". I don't know how to tell RS to suppress the page break if one sub-total immediately follows another. The initial HTML output seems to be smart enough to do this suppression on its own, but when I export to PDF, all the page breaks appear. This causes several pages at the end of the report with one line per page. Perhaps, if I could explicitly suppress these page breaks, the PDF would render properly. How can I do this?
I have been using the following code, (thanks to Shyam), to display address fields. This works great when using preview in BIDS, but the address shows on one continious line when the report is redered in Reporting Services.
Hi All, I have a report which gets data for around 5 different parameters for 5 servers. It needs to render different graph for each parameter, each server. It renders it properly (after running long though, which can be understandable) on the Visual Studio Preview. But when deployed on the Report Manager, it does not produce the graphs. It runs for long time and ends up with this error:
The following error was encountered: We can not connect to the server you have requested.
This means that: The server might be busy at this time.
The server is not reachable.
Please try later to see if you can go through.
Though I have configured the report execution NOT to time out. As such, subscriptions also do not work, It says, "Failure sending mail: An error has occurred during report processing."
So, has anyone faced similar problem and fixed it? If yes, can you please share the same?
As far as I know there are 2 ways to render the report in a Web page: 1. Using ReportViewer control and call its Render method 2. Using URL access
Which of the method is faster? As we are in the process of increasing the Performance of our Reporting Web Application. I appreciate any suggestions in this regard.
My report is currently rendering about 50,000 rows and can still be increased.I am using SSRS 2005.I am exporting my rdls into HTML,Excel and PDF.My problem is when i export all the rows in PDF it won't continue and an error was produced.It says "Too many results, please constrain your parameters or try the other format."But using the same parameter which brings out the 50,000 rows,it works fine in HTML and Excel.
Which of the 3 rendering extension is the fastest in performance?Could it be HTML?What could be the reason why it wont work on PDF?Can't it contain such bulk record?Or is there anything can be done to solve the problem? If anyone have encountered the same problem,we will be happy to hear from you.Any ideas and comments will be greatly appreciated..Thanks
we are using the sql server 2005 reporting tool and we are trying the render the data into the report. and we are getting this error.basically we are trying to render huge data.
The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)
I am designing a report that creates a letter to send to a named individual. To accomodate different address lengths, additional fields have been added to the db. Is there a method by which if an address filed is empty, it does not display in the redered report and the fields below it are moved up to close the gap?
Hi All, In my SSRS report. I have a report which has only one page. In preview it is showing as only 1 page but when I am printing the report. I am getting two printouts with the second page as a blank.. Please help me in printing the page that contains report. Intially I used a Page header, at that it used to print the blank page with a header only. Now as I removed the header it is printing the page without header i.e Blank Page.. So please help me in prinitng a single page that has the report. It is urgent,..
