Navision Pivot Table v2

Administrator

Navision Pivot Table
Here's a new control you can use in a Navision form: a Pivot Table.
This example is very simple to use and doesn´t have restrictions, so you can link the pivot table to any Navision table.

http://www.mibuso.com/dlinfo.asp?FileID=484

Discuss this download here.

guidorobben

Having an problem to get it to work. The contol is show perfectly. But i'm getting the text. Could not process query.

this is my connection

DLL4.CreateConnection(NomeComputador,'D:\guido.fdb','Object Manager','Employee');

NomeComputador = "". I changed this to my pcname and to localhost, but had no effect.

- Object Manager is company Name
- Employee is tablename.

What goes wrong?

andreof

Sorry, it only works with SQL

guidorobben

It's me again. Trying with SQL server this time

DLL4.CreateConnection('SBS02','susa','SUSA','Country');

SBS02 = SQL server
susa = DBName
SUSA = Company

Finally got it to work. But now my field list keeps disapearing after I D&D one field.

Guido

andreof

i don't know why, here doesn't disapear

ref

I also face some problems, this is my code:

NomeComputador := ENVIRON('COMPUTERNAME');

// you have to use the SQL name of the table
//DLL4.CreateConnection(NomeComputador,'Navision Demo Database','CRONUS Portugal SA','Cust_Ledger Entry');
DLL4.CreateConnection(NomeComputador,'370','CRONUS Danmark A/S','Cust_Ledger Entry');
DLL4.Andre;

370 = Databasename in SQL

When I open the form I get the following error:

The query could not be processed:
o "Command contained one or more errors."

/René

dakyn

Hi, I don't have a problem with Connection but when I need set field for my pivot table I Can't see the view list of fields. Why?

andreof

I have sended a new improved version of the pivot table to mibuso, I think your connection problems will be over.

The field list problems I dont understand :-k but I will try to research

mrQQ

I get error "The Name "Entry No." contains invalid characters."

But that's how the database is setup, and that cannot be changed! So it's kinda useless..

ref

It seems that the new objects are not distributed, or at least I can’t find them. Is it possible that you can mail them directly to me?

andreof

I have them in my company computer, have to wait till monday. But i think next week the Mibuso administrator will put the new objects online (i hope )

Administrator

Navision Pivot Table v2
Here's a new control you can use in a Navision form: a Pivot Table.
This example is very simple to use and doesn´t have restrictions, so you can link the pivot table to any Navision table.

New:
- You have 2 ways to make a connection
- You can change de connection string (user, password, etc)
- You can define the select in navision, joining tables, etc

http://www.mibuso.com/dlinfo.asp?FileID=484

Discuss this download here.

aenriquezh

Hi, I allreade are connected, but each time I try to open a table it send me the folowing error :

The Name "Entry No." contains invalid characters."

But those names are navision names, it's something I can do ?


:shock:

elias_k

Hi there

Try using brackets on field names like
[Entry No.]

Phenno

Is this for 3.7 or?

On my 3.6 client, it crashes client when it comes to dll4.Andre...

Phenno

I tested, it crashes on Navision 4.0 beta, too...

andreof

Maybe you dont have OWC10 (Office Web Components :-k ) installed.

Phenno

My automation objects for office are 9.0


MS Office 2000 SR-1 Proffesional


You say, i should have installed MS Office Xp at least?

andreof

Look in your registry for OWC10. If you find it, i dont know the reason for the crashes

Phenno

File Version: 9.0.0.3821 :roll:

You could make a version checker

Another feature... I tried at friends comp (with OWC 10) and made a connection.

But, if I try to open Field menu popup, it just blinks once and disappear... :shock:
That happens with all controls in upper menu. I can't put fields on the pivot table.

If I export to excel, it all works fine there...

andreof

When i first tried the pivot table, 1 year ago, it also happened to me. I think it's a problem with the navision version, or OWC10 version, because now, with the some dll, it works fine (in my computer). But If you resize the form and move it in the screen you should be able to add the fields.

Phenno

don't know... haven't managed to get field list nor anything else... it' also blink whenever, wherever i click on control and it always blinks 2 same popups, field list and command & options.