I've finally got the Jetreport working the way I want with the Stored Viewer Data, except with the conditional hide+?. I have actual data being pulled in one column, and then the other columns are for viewers to potentially enter data in the "full" option. If there is no data in either column it is supposed to hide during the next "detail" run, but if they entered data that row should remain.
The issue is that I run the report in "full" to enter data in some rows. The next time I run the report for "detail" to just keep the rows with "new data" the conditional hide hides that row regardless. It seems that the conditional hide reverts back to the way the design mode was done, and then it runs the Viewer data after the conditional hides are already done and therefore the new viewer data is not shown. If that makes sense please let me know if someone knows how to get around that? Thanks
Date
Votes
2 comments
-
Jet Reports Historic Posts It does makes sense, but I think it'll just regenerate the "columns" and "rows" functions every time.
Have you tried working with a seperate worksheet and link them through a "vlookup"?
Because, as you enter data in a row, and it "regenerates" the row, it doesn't see the data as part of the record.
If you would find another way in another worksheet, you could link it to the "generated" sheet by using a vlookup there. -
Jet Reports Historic Posts Thanks Jan, Went thru a consultant we occasionally use at work and she threw it up to Jetreports themselves. They basically said that I couldn't do what I was trying. First the conditional hides run, and then the viewer data is reloaded after. I'll have to figure something else out…maybe something like you suggested.
Thanks
Mopar30
Please sign in to leave a comment.