I am writing a report using NL Rows (=NL("Rows","G/L Entry",,"Transaction Type","Actual","+Posting Date",$A$6,"Global Dimension 2 Code",$B$9,"G/L Account No.","*")) so that I use NF in the columns for the report (=NF($A9,"Document No.")).
The report will run just fine, but when I go back to design mode, the rows from report mode don't go away. (I hit report, and the report runs. I hit design, and the original formulas are there, but so are all the rows that ran from the last report.)
This has happened to me before, but I've always been able to find a solution. Am I doing something wrong? One strange thing is that this report consists of several worksheets with the same formulas - just the Global Dimension 2 Code is different on each sheet. One sheet works perfectly each time! The remaining sheets mess up each time.
I'll provide more detail if necessary … wondering if anyone else has had this issue and if there's something obvious that I'm overlooking.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
This is definitely not the expected behavior. For problems like this, it's probably best to create a ticket with Jet Reports Support. Then someone can look at your report and assess whether there's an issue with Jet that needs to be fixed, or whether the problem is in the report.
Regards,
Hughes -
Jet Reports Historic Posts OK, thanks!
I would up starting from scratch and now it works. Same formulas and everything. -
Jet Reports Historic Posts Hi,
I've had this a few times and I found I could only resolve by redoing on a new excel workbook.
If I copied the sheet from one workbook to another however the problem would persist - seems to be a problem in the excel sheet itself but can't tell you what.
Hope this helps in some small way
Regards
Tom
Please sign in to leave a comment.