Web reporting tools Finereport common errors encountered in use and Solutions (iii)

here to write a point, I hope we can put their own problems and solutions to dry out, mark, the benefit of self-interest.

There is a problem first search the document there is no, then look at the degree Niang have no, then see the forum there is no. Have an error to read the log. The following is a brief list of common problems, most of which are mentioned in the document.

1, repeated column width is Largerthan paper width:

This should be a good understanding of this passage. For example, the template page width can only open 5 columns, the results of the 6 columns have been repeated and frozen, this logic is certainly not justified.

2, the template does not open, Access denied:

It is possible that the Win7 operating system has permissions on the file.

3. Unable to preview the report after installing the designer (404 error):

Add the servlet tag in Web. XML with the following code:

<servlet>

<servlet-name>ReportServer</servlet-name>

<servlet-class>com.fr.web.ReportServlet</servlet-class>

<load-on-startup>0</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>ReportServer</servlet-name>

<url-pattern>/ReportServer</url-pattern>

</servlet-mapping>

4. Object does not support this property or method, xxx is undefined:

Unified page encoding and JS encoding (in the report is the server code), such as the page encoding for Utf-8, and the server code is GBK, unified encoding method has three, let's look at a specific setting. Modify the management platform encoding to match the page encoding, open the FR management platform, under management System > System Management > General properties, modify the server-side code to UTF-8, such as:

5. The date comparison causes an error:

I tested it with my own sqlserver2005.2012/01/01. This format of the date and FR on the 2012-01-01 This format is not comparable, directly from the database read the date format is relatively long, not only the month and day, and can not read, do not know why, You can see it in the preview. And then I added a left in the conditional attribute (ToDate ($$$), 10) converted a bit to solve, todate transformed into a-connection, the first 10 is the month and day.

6. Rows that are expanded by one cell are inconsistent (fill in the preview):

However, there is no problem with page-break previews. Finally found because the data dictionary is set. A cell with a data dictionary set its true value one line does not show, it is changed, so it becomes wider. Is it the actual value that is used when calculating the space required for the calculation of the preview? Solution, pay attention to the point, pull the wide point is good.

7. Custom data dictionary Displays the equals sign problem:

Finereport like a custom data dictionary this place, with the cell also has the hint definition box must, if not the ' = ' sign begins as a string processing, ' = ' begins as a formula processing. So write an equal sign is blank. Use = "=" To display the equals sign

8, a cell content too much error:

Temporary workaround, merging multiple cells directly can increase the input content.

Web reporting tools Finereport common errors encountered in use and Solutions (iii)