ReportNet does not support the following for reports in Excel formats:
• background images in table cells
• Excel headers and footers
• text flow and justification
• floating text objects
• white space, normal, and wrap text formatting
• maximum characters
Some layouts do not show exactly in HTML and PDF due to Microsoft Excel limitations.
Formats Not Supported for Reports in Excel Format
ReportNet does not support the following for reports in Excel formats:
• background images in table cells
• Excel headers and footers
• text flow and justification
• floating text objects
• white space, normal, and wrap text formatting
• maximum characters
Some layouts do not show exactly in HTML and PDF due to Microsoft Excel limitations.
• background images in table cells
• Excel headers and footers
• text flow and justification
• floating text objects
• white space, normal, and wrap text formatting
• maximum characters
Some layouts do not show exactly in HTML and PDF due to Microsoft Excel limitations.
Table and Column Width
Microsoft Excel does not support using percentages to determine the width of tables. If the report contains only one table, the value of the width attribute for the Table element in the report specification determines the width of the table in the Excel worksheet. If the report contains more than one table, Excel determines the width of all the tables in the worksheet. If the tables are nested, the width specified for the outer table is used and, if necessary, the width is adjusted to accommodate data in the nested tables. The columns and rows around the table are merged to preserve the appearance of the nested table. When the workbook is saved, only a single table
is saved per worksheet.
is saved per worksheet.
Table and Column Width
Microsoft Excel does not support using percentages to determine the width of tables. If the report contains only one table, the value of the width attribute for the Table element in the report specification determines the width of the table in the Excel worksheet. If the report contains more than one table, Excel determines the width of all the tables in the worksheet. If the tables are nested, the width specified for the outer table is used and, if necessary, the width is adjusted to accommodate data in the nested tables. The columns and rows around the table are merged to preserve the appearance of the nested table. When the workbook is saved, only a single table
is saved per worksheet.
is saved per worksheet.
Reports With More Than 256 Columns
Microsoft Excel limits the size of a worksheet size to 65536 rows by 256 columns. If your report contains more than 65536 rows, it is split into multiple worksheets. The number of worksheets that your report can contain is limited by the physical memory of your computer. If your report contains more than 256 columns, the following error occurs: Reports with more than 256 columns cannot be rendered in Excel.
Reports With More Than 256 Columns
Microsoft Excel limits the size of a worksheet size to 65536 rows by 256 columns. If your report contains more than 65536 rows, it is split into multiple worksheets. The number of worksheets that your report can contain is limited by the physical memory of your computer. If your report contains more than 256 columns, the following error occurs: Reports with more than 256 columns cannot be rendered in Excel.
Running Total in Grouped Reports Gives Unexpected Results
You have a running total calculation in a grouped report that returns unexpected values. Because tabulation of the running total calculation depends on the order in which the grouping is executed, you must ensure that the grouped totals are tabulated before applying the running total.
To ensure that the grouping is executed in correct order, define a running total calculation as a free standing calculation outside of the query subject in Framework Manager, and make sure the Regular Aggregate property is set to Automatic.
This may also be an issue with other running, moving, and ranking aggregations.
To ensure that the grouping is executed in correct order, define a running total calculation as a free standing calculation outside of the query subject in Framework Manager, and make sure the Regular Aggregate property is set to Automatic.
This may also be an issue with other running, moving, and ranking aggregations.
Running Total in Grouped Reports Gives Unexpected Results
You have a running total calculation in a grouped report that returns unexpected values. Because tabulation of the running total calculation depends on the order in which the grouping is executed, you must ensure that the grouped totals are tabulated before applying the running total.
To ensure that the grouping is executed in correct order, define a running total calculation as a free standing calculation outside of the query subject in Framework Manager, and make sure the Regular Aggregate property is set to Automatic.
This may also be an issue with other running, moving, and ranking aggregations.
To ensure that the grouping is executed in correct order, define a running total calculation as a free standing calculation outside of the query subject in Framework Manager, and make sure the Regular Aggregate property is set to Automatic.
This may also be an issue with other running, moving, and ranking aggregations.
Printed Report is Unsatisfactory
Printing HTML may produce unsatisfactory results. For best results, use the View in PDF Format command, and then print the PDF. This alternative gives you more control over such things as pagination than the browser does.
Problem When Printing PDF
You print a document in PDF format, but the print job is incomplete. For example, the job stops printing when it reaches a particular graphic. This is an Adobe Acrobat Reader issue that can occur when printing some PDFs using some versions of Acrobat Reader and some printer models. The same PDF may print correctly under one or both of the following conditions:
• using a different version of Acrobat Reader
• using a different printer
If you print from an Acrobat 4.0 or later product, you can try the following solution.
Steps to Force a Page to Print as an Image
1. In Acrobat Reader, from the File menu, click Print.
2. In the Printer section, select the Print as image check box. Because files print more slowly using this option, make sure you specify only the nonprinting page.
3. In the Print Range section, click Pages from and Pages to, type only the page number of the nonprinting page, and then click OK. You can print the rest of the PDF by resending the job starting on the next page.
4. Clear the Print as image check box.
5. In the Print Range section, click Pages from and Pages to, type the page range for the remaining pages, and then click OK.
Although you can use the Print as image option to print the file, this setting does not resolve the original printing problem. For more information, see the Adobe Web site.
Problem When Printing PDF
You print a document in PDF format, but the print job is incomplete. For example, the job stops printing when it reaches a particular graphic. This is an Adobe Acrobat Reader issue that can occur when printing some PDFs using some versions of Acrobat Reader and some printer models. The same PDF may print correctly under one or both of the following conditions:
• using a different version of Acrobat Reader
• using a different printer
If you print from an Acrobat 4.0 or later product, you can try the following solution.
Steps to Force a Page to Print as an Image
1. In Acrobat Reader, from the File menu, click Print.
2. In the Printer section, select the Print as image check box. Because files print more slowly using this option, make sure you specify only the nonprinting page.
3. In the Print Range section, click Pages from and Pages to, type only the page number of the nonprinting page, and then click OK. You can print the rest of the PDF by resending the job starting on the next page.
4. Clear the Print as image check box.
5. In the Print Range section, click Pages from and Pages to, type the page range for the remaining pages, and then click OK.
Although you can use the Print as image option to print the file, this setting does not resolve the original printing problem. For more information, see the Adobe Web site.
Printed Report is Unsatisfactory
Printing HTML may produce unsatisfactory results. For best results, use the View in PDF Format command, and then print the PDF. This alternative gives you more control over such things as pagination than the browser does.
Problem When Printing PDF
You print a document in PDF format, but the print job is incomplete. For example, the job stops printing when it reaches a particular graphic. This is an Adobe Acrobat Reader issue that can occur when printing some PDFs using some versions of Acrobat Reader and some printer models. The same PDF may print correctly under one or both of the following conditions:
• using a different version of Acrobat Reader
• using a different printer
If you print from an Acrobat 4.0 or later product, you can try the following solution.
Steps to Force a Page to Print as an Image
1. In Acrobat Reader, from the File menu, click Print.
2. In the Printer section, select the Print as image check box. Because files print more slowly using this option, make sure you specify only the nonprinting page.
3. In the Print Range section, click Pages from and Pages to, type only the page number of the nonprinting page, and then click OK. You can print the rest of the PDF by resending the job starting on the next page.
4. Clear the Print as image check box.
5. In the Print Range section, click Pages from and Pages to, type the page range for the remaining pages, and then click OK.
Although you can use the Print as image option to print the file, this setting does not resolve the original printing problem. For more information, see the Adobe Web site.
Problem When Printing PDF
You print a document in PDF format, but the print job is incomplete. For example, the job stops printing when it reaches a particular graphic. This is an Adobe Acrobat Reader issue that can occur when printing some PDFs using some versions of Acrobat Reader and some printer models. The same PDF may print correctly under one or both of the following conditions:
• using a different version of Acrobat Reader
• using a different printer
If you print from an Acrobat 4.0 or later product, you can try the following solution.
Steps to Force a Page to Print as an Image
1. In Acrobat Reader, from the File menu, click Print.
2. In the Printer section, select the Print as image check box. Because files print more slowly using this option, make sure you specify only the nonprinting page.
3. In the Print Range section, click Pages from and Pages to, type only the page number of the nonprinting page, and then click OK. You can print the rest of the PDF by resending the job starting on the next page.
4. Clear the Print as image check box.
5. In the Print Range section, click Pages from and Pages to, type the page range for the remaining pages, and then click OK.
Although you can use the Print as image option to print the file, this setting does not resolve the original printing problem. For more information, see the Adobe Web site.
Subscribe to:
Posts (Atom)