Customer Top 10 or 20 list

Hushdontspamme

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

Hushdontspamme

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

Install the printer on the server where the NAS is running...

Hushdontspamme

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

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...

Hushdontspamme

Hi Any luck on looking into this?

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

Regards


James

kine

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.

Hushdontspamme

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