Customer Top 10 or 20 list

Hushdontspamme
Hushdontspamme Member Posts: 56
edited 2006-03-13 in Navision e-Commerce
Hi

In Navision there is a report called Customer Top 10. Is there a way i can create a new Web Part Template to show Customers Top 10 in a report window on the EP system?

(p.s i am very new to navision)

Regards


James

Comments

  • Hushdontspamme
    Hushdontspamme Member Posts: 56
    Hi

    I have figured out how to add the reports to employee portal.

    I have created a caption called "Top 10 Customers" - for the CUSTOMERCARD i have added an action to showreport 111 on table 18 and configured it as a link.

    I have updated the CodeUint 6828


    REPORT::"Customer - Top 10 List":
    ReturnValue := CustomerTableBased (ReportID,TmpFileName,PrintRecordRef)

    The link for Top 10 Customer is on the Customer Card in Sharepoint, but when i click on it i get the Navision error (10500): cannot find file error.

    This is happening on the Order Summary report as well.

    I must be missing something - any advice?

    Regards

    James
  • kine
    kine Member Posts: 12,562
    Install the printer on the server where the NAS is running...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Hushdontspamme
    Hushdontspamme Member Posts: 56
    Hi

    Printers already installed. I am using Cronus Sample data - and in the employee portal the Product Design Item Card BOM reports work fine.

    Its when trying to use the Customer - Top 10 and Customer - Order SUmmary i get errors.

    I am now getting

    Navision error (10500): This message is for C/AL programmers: This Automation variable has not been instantiated. You can instantiate it by either creating or assigning it.

    I have updated CodeUnit 6828 to allow it to use the above reports.

    What am i missing?

    Spent all day trying to figure this out.

    Regards


    James
  • kine
    kine Member Posts: 12,562
    Somewhere in the code the Automation type of variable is used without CREATE command. You can run the debugger on the Navision application server. I do not know right now where it can be, may be on Monday...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Hushdontspamme
    Hushdontspamme Member Posts: 56
    Hi Any luck on looking into this?

    I have never used C/SIDE before. Not sure where to start.

    Regards


    James
  • kine
    kine Member Posts: 12,562
    1) The customer top 10 report is using dialog to show progress. This can be problem for NAS which has no GUI. You need to use condition 
    if GUIALLOWED then
  ...
    before you use Dialog variable somewhere in the code. For example in this report you need to modify:
    if GUIALLOWED then
  Window.OPEN(Text000);

...
if GUIALLOWED then
  Window.UPDATE(1,"No.");

...
if GUIALLOWED then
  Window.CLOSE;

    2) It seems that point 1 is not connected with your problem because it seems that you never get it to the point that the report was runned...
    3) Can you post your customization in CU 6828 (or PM me if it is not public)?
    4) Please, check the Event log on the server where NAS is running for some errors or warnings.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Hushdontspamme
    Hushdontspamme Member Posts: 56
    Hi

    Thanks for your help, i decided to use SQL Reporting services as this was much easier.

    I created the report and added a SQL Reporting Services Report Viewer web part to the employee portal page.

    Looks very nice as well.

    Many Thanks

    James

Categories