Hi ,
I'm just getting started with Jet Report ,i connected jet report with navision database , i downloaded the pre-built reports i want to modify them but i have to know the source table of displayed data.
Can anyone help me please.
Date
Votes
4 comments
-
Jet Reports Historic Posts Hello Mehdi,
I am not quite sure that I understand your question.
If you are trying to find out what tables one of the sample reports is utilizing you can switch the report into Design Mode with the "Design" button in the Jet ribbon.
Once in Design Mode you can click on the NL(Table) and NL(Link) formulas to see the tables being queried.
Take for example the "NAV005 - Item Sales by Customer.xlsx" report.
This report queries the Value Entry table and links to the Item and Customer tables (see attached).
Best regards,
MWilson
-
Jet Reports Historic Posts Hello,
I believe OP is asking about Pivot Table Data Source.
For example, if I open one of the pre-built reports, such as "NAV017 - Accounts Receivable Summary", then select Pivot Table -> Analyze (Ribbon) -> Change Data Source, we can see that "Table/Range" says "Customer". I assumed that "Customer" is a Named Range, but after spending few hours on it, I couldn't figure out how "Customer" is linked to the report table. The report is enclosed.
Does anyone know? Thank you. -
Jet Reports Historic Posts Just found this!
It looks like this is what defines it "TableName=","Customer"
But when I copy the Pivot Table to another report and enter the Data Source as "Sales Invoice Header", which is the table name of the report on the second tab, I get "Reference is not valid".
Is it because I copy the Pivot Table from another report and only after try to enter Data Source? Thank you. -
Jet Reports Historic Posts Thank you MWilson , That is exactly what i'm asking for.
Please sign in to leave a comment.