Hi,
I got a problem with one of my reports.
I want to create a Report based on the table "Contact Profile Answers" (Dynamics NAV 5 SP 1) with JetReports to
evaluate them later with Data Mining Tools.
But somehow I can't get the right results when I use columns instead of rows.
This is what I thought would be the right way:
=NL("Columns";"Contact Profile Answer";"Line No.";"Contact No.";Q11;"Profile Questionnaire Code";"Debitor"), quite simple
For Each line of Customers i get from my Database all Answers should be displayed (A total of eight, displayed are the Line Numbers connected to the answers).
For the first Customer This works fine, but somehow all Customers get the same results. Additionally I can't use drilldown except for the First result of the First Column for
this Customer
When I use rows the results are correct.
Does anyone know why this won't work?
Thanks for your answers
Date
Votes
1 comment
-
Jet Reports Historic Posts Can you attach the file you are working on? The formula you wrote should give you a listing of the line numbers but if this NL(Columns) formula is on the same row as an NL(Rows) formula, it can cause some problems.
Also, you can only drilldown on a cell that has a Jet Reports function in it. So, if you have a formula listing out values, you will only be able to drilldown on the first one - but it will give you the complete list of values displayed in the report.
Does this help?
Please sign in to leave a comment.