Skip to main content
Question

23R1 issue with Exporting quick report via scheduled report


Forum|alt.badge.img+17

Hello,

(We are on 23R1.6 in our environments.) We have a quick report that pulls invoice data, we can export this data from the quick report page, completely fine. We encounter no issues and the excel formatting is perfect.

 

The issue we are encountering though, is when scheduling this report via scheduled reports, and having it emailed to our users, we notice that the method used to export the data onto an excel sheet adds an extra space and a new line character before the field values for all columns/rows. We cannot fix this on our end since these characters are added after the data is pulled from the quick report.

 

Has anyone else encountered this issue?

 

Thanks,
Bryan

13 replies

Forum|alt.badge.img+17
  • Author
  • Superhero (Customer)
  • 250 replies
  • April 12, 2024

Hello @ChanakaAmarasekara

I was told you would be the best person to ask about this. If you could provide any information regarding this issue, it would be very much appreciated.

I checked the application messages for the attached report and it also appears on that excel, so I’m assuming there is an issue with the formatting of data onto the excel sheet rather than an issue with the email.

We also notice that the conditions in the quick report are not being applied to the emailed report, but only the exported one when viewing it as an end user, for example if I pull all fields and say where invoice_id=1000, the quick report will only return invoice 1000, but when scheduling the report, it pulls all invoices, very odd!

Again, any and all input would be greatly appreciated.

Thanks,
Bryan


Forum|alt.badge.img
  • Do Gooder (Partner)
  • 1 reply
  • June 10, 2024

Hello, 

We are experiencing same issue with format of report when it is sent by mail.All columns are with one extra row before  field values for all columns/rows.

Is there any solution for this, it is not possible to fix this every time after mail is received.

IFS CLOUD version 23 R 2


Forum|alt.badge.img+5
  • Do Gooder (Employee)
  • 15 replies
  • November 19, 2024

I just encountered the same issue in 23R1 SU17.  Has anyone found a solution other than running the report manually instead of scheduling it?


ashen_malaka_ranasinghe
Hero (Employee)
Forum|alt.badge.img+11

Hi All,

We have encountered a few cases related to this issue, and some fixes have already been implemented. However, it appears that further investigation is needed in the latest environment. I will provide updates on this thread as more information becomes available.


Forum|alt.badge.img+5
  • Do Gooder (Employee)
  • 15 replies
  • November 20, 2024

Thanks, Ashen.  I did open a support case CS0316979 in the meantime.


Forum|alt.badge.img+3

Has there been any update on this issue?


Forum|alt.badge.img+5
  • Do Gooder (Employee)
  • 15 replies
  • December 18, 2024

It is expected to be addressed in 25R1. That is the information I received from R&D.


ashen_malaka_ranasinghe
Hero (Employee)
Forum|alt.badge.img+11

Hi ​@Hassan Shareef,

Is there a JIRA ticket for this? Could you please provide if any?


Forum|alt.badge.img+5
  • Do Gooder (Employee)
  • 15 replies
  • December 18, 2024

I did not see one.  I only received an email from R&D which came from my project sponsor.


Forum|alt.badge.img+6
  • Do Gooder (Customer)
  • 21 replies
  • January 6, 2025

I can confirm it’s still an issue in 24R2


ashen_malaka_ranasinghe
Hero (Employee)
Forum|alt.badge.img+11
TSPPRICH wrote:

I can confirm it’s still an issue in 24R2

Our R&D team is currently working on a fix for this issue. We will update here when we have more information about the fix!


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 6 replies
  • March 3, 2025

I’m having the same issue as well. When exporting directly from the Quick Report it’s fine however through the scheduled reports it will add two blank spaces then a new line in every cell.


ashen_malaka_ranasinghe
Hero (Employee)
Forum|alt.badge.img+11

Hi ​@RyanSleight,

A fix for this issue has been already provided by our RnD team and the fix has been included in the following versions.

• 23.1.22 - 23R1 SU22
• 23.2.15 - 23R2 SU15
• 24.1.9 - 24R1 SU9
• 24.2.3 - 24R2 SU3
• 25.1E.0 - 25R1 EA


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings