Few formatting Issues in BO4.0

[Former Member]

Dear All,

Have few queries in formatting stuff of BO4.0. Any help (partly/fully ) would be highly appreciated:

1. We have some report headers in our report. When the user scrolls down, it goes off (i mean he will not be able to see header once scrolls down the reports)

But the user wants to see the headers to be fixed. Is it possible ? Can this be achieved?

2. Excel to pdf conversion

When downloading the report as excel & trying to convert to pdf to take print out. But since report has too many columns (around 25), the format is not that good. Is there anyway we can show all columns in single page using any other option with better formatting?

3. User prompt fot date

There is a User prompt in which user selects the date. The date format is getting displayed as mm/dd/yyyy hh:mm:ss a.

This need to be displayed in dd/mm/yyyy format. Tried using many formulas using ToDate & FormatDate functions. Though the formula doesn't give any syntax error, the result displays as "Error"

4. A button to clear all selected filters

Is there anyway we can clear all selected filters at one shot? Is there any function available for this.

say we have selected some 4 filters. Now if we want to clear all filters at one shot instead of clearing each filters one by one manually.

5. Hierarchy to be maintained when export to excel

In the report we are able to see the hierarchy. But when doing the export to excel, the hierarchy is not shown.

Is there anyway hierarchy can be maintained as similar to that in the report.

Many Thanks,

Pavan Raj

[Former Member]

Hi Pavan,

Let me see if I can be of some help with your questions.

1. I'm afraid that I don't understand this issue. In A-OLAP the Column headers are fixed and will not be affected by scrolling. Are you referring to an exported report?
2. Once again, I could use some clarification. You're exporting to Excel and then converting to pdf and the width of the data is an issue? I'm afraid with pdf, your Column headers will be truncated when you try and fit 25 columns on one page. Is that acceptable?
3. If this is against BW, you can specify the date format using the SU01 transaction on the backend. A-OLAP will respect that.
4. There is a button that will clear all options (undo all) but not a button to clear only filters.
5. What's different about the hierarchy? When I export, I'm seeing the indenting.

As an overall comment, It would be helpful if you included some screenshots, as that will clarify your questions.

Regards,

Philip