Hopefully someone can help me out…
Simply put, I've got a report that goes into the database and extracts the info. (Included in this report are a couple of columns where the end user is to insert comments.) [all of this is done in the designer mode] Now I press the 'report button' and save the report. Then I disbute the report for input, have it sent back to me, press the 'report button' and then all the comments that the end users disappear.
What am I doing wrong. (I've gone the 'data' route in row 1, but then I get errors stating something about a key error.)
Any feedback or advice would be helpful!!!
Date
Votes
11 comments
-
Jet Reports Historic Posts Hi Pete,
You should take a look at the topic in the Jet Reports Help called "Introducing Stored Viewer Data in Reports". You are on the right track with the "Data" tag, but unfortunately it's not quite that simple. When a report is run, all auto-generated rows are deleted, then reinserted back into the report based on the data retrieved. This is why the end-user's comments are being removed. The Stored Viewer Data feature (aka "User Data") will store user-entered data based on a key, then restore it after the report has been run. In order for this to work, each piece of data (i.e. end-user comment) must be identified by a unique key. Here is how the necessary elements are defined:
- A piece of data to be stored is defined by the intersection of a "Data" row and "Data" column.
- A key name is defined by the intersection of a "KeyName" row or column and a "Key" row or column.
- A key is defined by the intersection of a "Key" row or column and a "Data" row or column.
Each key must have a name, and each piece of data must be uniquely defined by that key. This can be really confusing at first, but I think once you work through the example you'll get the hang of it. Hope this helps! -
Jet Reports Historic Posts I have been toying with this, but as far as I can see, this is limited to 1 column of user data per key.
I would like to give the user the ability to edit 3 columns of user data per key.
I can't find a combination of the keywords that allows that.
Do I want to much?
rmw -
Jet Reports Historic Posts Do you recognize that?
Once you post your question, a solution pops to mind… :roll:
To determine the 3 different colums, you have to use KeyName and Key for columns as well.
Pretty nice!
rmw -
Jet Reports Historic Posts I have a report setup with the end user comment feature in it. Works great, accept for one report. If i Run i the end user comments dissapear, i run i t again and the comments are back.
As a test i entered in the empty version the word "test" in one line. I run it ones the version with "test" in it appears, i run it again and the other version of the comments appear.
Some how there are twe versioen of the comments saved. But i dont know how to get rid of one version.
Can anyone help me out? -
Jet Reports Historic Posts Hi Mark,
I think this might just be related to some version of the data getting saved while you were creating the report before you finished creating it. Click the Jet -> User Data -> Purge then report button which will delete all stored data and run the report. Now type the word "test" and re-run the report and see if it sticks around.
Regards,
Hughes -
Jet Reports Historic Posts I find that when building a report with Stored Viewer Data, after changing, running and saving the report a number of times, this data may get confused. Stored Viewer Data is kept in a Very Hidden Sheet, which may be made visible by going clicking on the Developer tab (or hitting Shift-F11) and then changing the property "Visible" of this sheet.
After being made visible, this sheet can be deleted (sometimes there are a couple of them!). This clears things up a lot more thoroughly than Data->Purge. Running the report again will of course happily re-create the Very Hidden Sheet (though you will have lost your viewer data, obviously) -
Jet Reports Historic Posts Hi Hans,
It is true that the Stored Viewer Data is stored on a very hidden sheet when the report is in design mode. Using User Data -> Purge should delete the very hidden user data sheets just like you say. If you want to try and do it manually, make sure you are in design mode. There are many more very hidden sheets created in report mode which hold the Jet functions and if you delete those very hidden sheets then you will never be able to re-run the report (all Jet functions will be gone), so it is a somewhat dangerous thing to do.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes
You are certainly right about only trying this in design mode.
Of course my solution is crude and brute-force, but I managed to mess up my stored viewer data in away where Purge Data didn't help anymore (also, I cannot get the hidden sheet to disappear using the Purge menu)
Though I got my stored viewer data (multiple coumns of them) working I found the documentation in the Jet Help not very clear (and only presented by way of examples). Knowing how this feature works behind the scenes would probably have helped my understanding.
I now also tend to finish the report first and then, only at the very end, add the "data", "key" and "keyname" labels. -
Jet Reports Historic Posts Hans,
I should point out that when I say Purge, what I mean is Jet -> User Data -> Purge then Report (or Purge then Design or Purge then Refresh). There is also a "Purge Cache" button on the Jet ribbon and this does not affect stored viewer data at all.
I agree that the Stored Viewer Data feature is very confusing. I actually wish it had not been implemented the way it was implemented, but that is how it was implemented a long time ago and now we must continue to support it.
Usually problems with Stored Viewer Data do happen because of adding the Key, Data, and Keyname tags early in creating the report (and sometimes because they are initially added incorrectly). This is why it's important when trying to get Stored Viewer Data to work to make sure and use the User Data -> Purge then Report and Purge then Design options often to clear out the bad user data sheets.
Regards,
Hughes -
Jet Reports Historic Posts I am also struggling with storing viewer data in JetReports.
I understand the concept of the single viewer data using Key/Keydata and data for 1 cell that stores information, but what when I want to store data in 3 separate cells, preferably in the same column? Is it absolutely necessary to identify the cells with viewer data in separate columns?
Can I put KeyName and Data in the same cell? The Key value (Job No.) is in the same column as the cells I want to store the data in…..
Thanks in advance,
Willem -
Jet Reports Historic Posts Hi,
did you read this ?
http://kb.jetreports.com/article/AA-00569
Please sign in to leave a comment.