Navision Pivot Table v2

Administrator · 2005-05-11

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 · 2005-05-11

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 · 2005-05-11

Sorry, it only works with SQL

guidorobben · 2005-05-11

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 · 2005-05-11

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

ref · 2005-05-20

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 · 2005-05-21

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 · 2005-05-21

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 · 2005-05-24

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 · 2005-05-27

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 · 2005-05-27

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 · 2005-06-05

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 · 2005-06-17

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 · 2005-06-28

Hi there

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

Phenno · 2005-06-30

Is this for 3.7 or?

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

Phenno · 2005-06-30

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

andreof · 2005-06-30

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

Phenno · 2005-07-01

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 · 2005-07-01

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

Phenno · 2005-07-01

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 · 2005-07-01

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 · 2005-07-01

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.

Navision Pivot Table v2

Comments

Categories