You are viewing limited content. For full access, please sign in.

Question

Question

Form Reporting and multiple values

asked on September 14, 2020

So starting to put together a report for a process and notice an immediate issue that the client is going to question.  The process is an invoice form where they have the vendor and other info folllowed by a table with line item information.

When running the report I would expect multiple lines for those values just like in the Form and how it was entered.  If the table had 4 rows on submit, the report should also have 4 rows.  

However, the report shows just one row with the values separated by bars 

The team is looking for line item info so they can run up and tally info.  Is there any configuration for this?

0 0

Replies

replied on September 14, 2020

Hi Chris, are you exporting the report by CSV? If you export the report by XLSX, you should get what you need, feel free to let me know if this is not sufficient.

0 0
replied on September 14, 2020 Show version history

Great, this worked.  Sorry I didnt have Excel on the client server so was just doing csv.

Is there a special type for generating reports in WebAccess.  If I run a search and then generate a metadata report it seems to do the multi values with semicolon separators 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.