0

2 User Data Fields - 1 Key [Resolved]

Jet Reports Historic Posts

February 16, 2016 21:19

None

Follow

I need to build a report for someone that pulls a set of data, but allows them to enter two columns of user data on each row.

When I try to do this, I get an error on the refresh:

Error loading user data for sheet 'PoD':

The user data cells $G$7 and $H$7 have been assigned duplicate keys. Each user data cell must contain a unique key. The offending key value is:

Key: Code
Value: SLH000001

User data will not be saved for this sheet.

Do I need to use a work around like putting my user data on two different rows and duplicating the key?

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts February 16, 2016 22:00

  Hello Jaycen,
  As indicated in the error message, it appears that there is an issue with the keys specified in your report.
  Please take a moment and review the below Knowledge Base articles for further assistance and clarification.
  http://kb.jetreports.com/article/AA-00538
  
  In case you have multiple keys setup and that might not be configured correctly, please see the below KB article:
  Advanced Stored User Data
  http://kb.jetreports.com/article/AA-00569/0/
  
  I have also attached a sample report that might give you a clearer picture on how these keys should be configured.
  
  I hope that helps.
  
  Cheers

  • example report.xlsx
• 0
  
  Jet Reports Historic Posts February 17, 2016 13:56

  Hi, Cynthia.
  
  The knowledge base articles don't cover my specific situation.
  
  In your example, there seems to be no correlation between the rows/columns where a key is located and where your user data is located. Is that correct? I guess I assumed the key had to be either in the same column or same row as your user data.

• 0
  
  Jet Reports Historic Posts February 17, 2016 15:04

  Okay, I see the issue now.
  
  The walk-through on the advanced page is hard to follow, but I think I understand the issue. The keyname, key data, and user data must all be in the same row/column, but it looks like you can basically build an array to get there. Maybe that's a clumsy way of explaining it.

• 0
  
  Jet Reports Historic Posts February 24, 2016 20:29

  I guess I answered my own question. I have a report that technically saves both cell's worth of data, but it has a tendency to crash when going back and forth from Design to Report mode. Of course, since it is a report on every single SO on every single shipment, the file is 4M, so maybe that's the real problem.
  
  Apparently, my real problem was that I was trying to duplicate the data in the key, thus I had chosen the wrong field to use as a "unique" key. I was trying to save our shipping carrier's invoice and our PO # to the same Sales Order (the only unique value in the system tied to both pieces of user data).
  
  I ended up concatenating &" - PO" to the end of our SO when I did my rows replicator, and then assigned each user data point to either the SO or the SO&" - PO" as my keys. Here's the final result:
  
  Shipping Invoice Log.xlsx
  
  Hopefully this helps other people.