HI!!
I have downloaded a file with views of Navision but I dont know how to import it in the Jetreport.
I am having huge problems in order to link headers with lines and I think with these views I will solve it.
Other problem I have is how to prepare the structure of a report of Sales. Depending on "item category code" (a field from the product card) I want to know all the quantity of a product (group by product) have sold a salesman (this one as a filter)
Thank you for your help.
Regards,
NACHO
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Nacho,
If you are talking about importing SQL views into the backend SQL Server, you have to make them show up in NAV itself in order for Jet to see them. There is a way to do this, but I believe it is a somewhat complicated operation in NAV itself. Your solution center may know or you may be able to find instructions somewhere like mibuso.com.
As far as your actual report goes, you can probably do what you want without using SQL views. I'm not super clear from your description exactly what you are trying to do. If you are trying to link the Sales Header and Sales Line table in the same function, you can do this using the Jet Link= functionality. If you provide more specifics such as functions, Excel file, etc. we may be able to help more.
Regards,
Hughes -
Jet Reports Historic Posts Hi again,
I am talking views you can download directly from the advanced report assistant. There is a link to this address: http://community.jetreports.com/viewforum.php?f=35&sid=52a820091cf1f46701ae4aabe5464e78
This is a jdc file extension and I dont know what to do with it.
Thks so much.
Rgds,
NACHO -
Jet Reports Historic Posts Nacho,
Looks like whoever uploaded the Spanish data views did not translate the instructions for importing them. If you look at the topic for the English data views there are actually instructions for how to import them here:
http://community.jetreports.com/viewtopic.php?f=35&t=961
These data views can only be used through the Report Builder tool.
Regards,
Hughes -
Jet Reports Historic Posts Thank you so much!
Please sign in to leave a comment.