Tips to achieve the same report structure when you export into Excel:
Following points will help to avoid the unwanted cell spaces and formatting issue while exporting .rpt file to Excel files.
- For example I have condition to display two fields i.e. Grade A and Grade B based on revenue value.
- If revenue is more than 60000 then we need to display Grade A field else Grade B. This condition we need to give at 2 objects suppression formula.
- In this case the .rpt file will display only one field object at report. But when you export to excel it will take 2 cells for both field objects. To avoid that just create 2 different sections for example you just create detail 1 for Grade A and Detail 2 for Grade B with above suppression logic.
5. We can't export lines and tables when you are export to Excel data only.
6. After you drag & drop fields into your designer, don't resize or overlap them. Make sure that you have selected options snap to grid.
7. Select the Can Grow option for all the fields in the report by default. This will avoid the overlapping.
These are main point’s needs to be remember, when you are exporting the .rpt file to .xls file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |