0

Preserving Manually Entered Data

Dave Ashton

October 09, 2017 09:01

None

Follow

Hi

I am using the "Data" command in columns and rows to preserve data need to add manually into a report.

Currently, it seems that I can only have on cell per row/column defined i.e. put Data into D1 and A7 reserves cell D7 for manually entered data. This has the desired effect in that data i manually update into that cell is retained when I refresh the report.

I now have a requirement to enter manual data into multiple cells across a single row. I've tried adding the Data command into multiple columns but the report now throws an error - 

 

Error loading user data for sheet 'Sheet4':

The user data cells $D$4 and $P$4 have been assigned duplicate keys. Each user data cell must contain a unique key. The offending key value is:

Key: Name
Value: Bob Jones

User data will not be saved for this sheet.

 

Anyone know of a way to fix this or if there is a Knowledgebase article that covers it?

Thanks

Dave

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Heather Rowe October 09, 2017 13:27

  I've not used this technique myself, but this article may help get you in the right direction.

  https://jetsupport.jetreports.com/hc/en-us/articles/219403127

   

• 0
  
  Dave Ashton October 09, 2017 13:30

  Hi Heather

  Thanks for this link. This is where I got up to. What it assumes is that there is only one column per row that will receive manual data. I need to add a couple of columns per row. Its at this point my report fails.

• 0
  
  Harry Lewis October 09, 2017 14:14

  Hello Dave -

  Stored User Data requires that every piece of manually-entered data have a unique key associated with it.  When there is only one such piece of data per row, this is fairly easy.

  However, when you have more than one per row, you must create a unique key for each piece.

  Oftentimes, this is accomplished by concatenating the original unique key (which you used for saving one piece of data per row) with the column heading for the additional pieces. 

• 0
  
  Erwin Staal February 28, 2022 10:49

  A few years late, but this is how you are able to enter multiple manual columns:

  You need to create a key per column.

  

  Enter the Keyname defined in E6 and E7 above the manual columns in the corresponding rows
  So E6 matches U6 and E7 matches T7

  

  Dave Ashton Harry Lewis

  Edited by Erwin Staal February 28, 2022 10:58