Question

Forms report content is out of order

Forms Version 10

Updated March 18, 2019

asked on March 18, 2019

I produced a report from a form that had multiple tables for items purchased. One table for beef, pork, chicken, fish. When I look at the completed form in the repository, it shows the order as the user entered the information (Exec form1.) When I produce the report from LF forms, it shows the item order flipped (bottom to top) but the total selected remain in the original order (Exec Form 2 & 3.) Obviously this makes the order incorrect and I would like to be able to correct this.

Is this something that was corrected after 10.2? Or is there something that I'm not getting right in my report setup?

Exec form 1.png (69.86 KB)

| Download

Exec form 2.png (24.77 KB)

| Download

Exec form 3.png (5.74 KB)

| Download

0 0

Replies

replied on March 18, 2019

I don't recall seeing this issue before, but it seems like it might be a bug. I haven't been able to reproduce this issue on our side though... Do you have any more details about how you were able to produce this specific dataset? It seems like some of the data may have been saved in the wrong order somehow.

Also might be helpful to know: when you export this data to Excel, is the order incorrect as well?

0 0

replied on March 18, 2019

Sean, we created the table by loading the item desc, price, and unit via a SQL table. The user had to enter the quantity. When exporting to Excel the order is also incorrect, see attached

Exec Screens.docx (502.38 KB)

| Download

Executive_Selections_2_28_2019.xlsx (14.45 KB)

| Download

0 0

replied on March 18, 2019

Thanks for the additional info; it doesn't sound like you've done anything wrong from a configuration stand-point. I would encourage you to contact support with this issue.

0 0

replied on March 18, 2019

I was able to set this up in our environment on 10.3.1 and was not able to recreate the issue. I added similar data into SQL and ran the Form as you guys would and my report comes out in the same order as entered in the Form (see attached). This seems like it may be a bug.

Custom_Report_Exec_Meat_Bonus-Test_3_18_2019.xlsx (8.89 KB)

| Download

1 0

You are not allowed to follow up in this post.

Question

Question

Forms report content is out of order

Replies

Sign in to reply to this post.