Hello Developers,
Currently, I'm facing issues while creating and scheduling a report. I'm currently designing a report with a sub-report which contains 18 columns.
Specifications : Back-End : Oracle 11 g Stored Procedure ,Designer : Crystal Reports 2011 SP4, Server : SAP BO Enterprise 4.0
Issue-1: Explicit NULL Handling :- There are some Null values coming from the BE Oracle SP. This can be handled by checking "Convert Database Null values by default" so that if it is number it will be converted 0 or if it is string it will be "space". But the requirement is one of the Number field shouldn't be "0", It should display as blank .
Formula : if ISNULL({DBField.AmountField}) then " " else ToText({DBField.AmountField})
Kindly, don't suggest the formula above, it will change the number into string. Users want that field as number only in-order to perform sum and average operations when they exports into excel.
Issue-2: Blank Row at the Top :- Currently I'm using Crystal Reports 2011 SP 4. My report contains a sub-report whenever I'm exporting it into excel displays a single blank row on the first row of my excel sheet. I tried various methods like : Can Grow, Suppress if blank and also clean excel formatting but no use.
Issue-3 : Header in the pages of Excel : My SP is returning lots of data which results 5 tabs in the excel sheet when I export it into excel. There Header is displaying in the 1st tab and missing in the remaining tabs. The reason behind it is I'm using a Sub report which usually don't have a page header option. I know this can be achieved by using Groups (or) any other way and It would be very helpful if anyone explain it and share a formula to achieve it.
Issue-4: Long Running Report: This report contains a very huge data. When I schedule it in the BO Enterprise it taken almost taken 45mins to generate the excel report with 750mb size. The remaining reports are waiting till its get completed. Is there any way to increase the processing speed of this particular report (or) handle any other way. So that it shouldn't affect the remaining reports.
I apologize for asking so many queries . I'm running out of time. Anyone who answers my queries are very much appreciated.
Thanks,
Preethi.