Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
formatting and exporting of report from visual studio environment.
- Thread starter raghu55
- Start date
BobSuruncle
Technical User
Following is a checklist that I give my clients.
It's not 100 % foolproof (what is?), but it helps:
When exporting report to Excel, there are a few tricks that help create the output in a format that minimizes columns being unaligned and having extra rows created.
1. Keep Column Headings aligned perfectly with the data that they represent. (left align or right align) Guidelines are very helpful here.
2. Ensure that Column Headings are exactly the same width as the data that they represent.
3. Ensure that EVERY column in the report has a Colum Heading.
4. Ensure that you are using full font sizes. Don't use ½ sizes.
5. Use standard fonts like Arial or Time New Roman.
6. If you're using subreports to perform calculation and return values to the main report, but are not showing anything else from the subreport, use shared variables to retrieve the values from the subreport instead of showing the fields from the subreport. This will prevent a new row being created in the spreadsheet for the subreport value with just one item on the row.
7. Use the "Excel Data Only" format option.
8. Use either a specific size for the column widths, or base them on the section of the report that contains the bulk of the data being exported.
9. Use the "Simplify Page Headers" option.
10. Experiment with the "Maintain Column Alignment" option. It may work better with this option Off.
Bob Suruncle
It's not 100 % foolproof (what is?), but it helps:
When exporting report to Excel, there are a few tricks that help create the output in a format that minimizes columns being unaligned and having extra rows created.
1. Keep Column Headings aligned perfectly with the data that they represent. (left align or right align) Guidelines are very helpful here.
2. Ensure that Column Headings are exactly the same width as the data that they represent.
3. Ensure that EVERY column in the report has a Colum Heading.
4. Ensure that you are using full font sizes. Don't use ½ sizes.
5. Use standard fonts like Arial or Time New Roman.
6. If you're using subreports to perform calculation and return values to the main report, but are not showing anything else from the subreport, use shared variables to retrieve the values from the subreport instead of showing the fields from the subreport. This will prevent a new row being created in the spreadsheet for the subreport value with just one item on the row.
7. Use the "Excel Data Only" format option.
8. Use either a specific size for the column widths, or base them on the section of the report that contains the bulk of the data being exported.
9. Use the "Simplify Page Headers" option.
10. Experiment with the "Maintain Column Alignment" option. It may work better with this option Off.
Bob Suruncle
- Status
Similar threads
- Locked
- Question
- Locked
- Question