[development-axapta] PLEASE HELP: CRYSTAL REPORTS 2008 AND AX2009

2009-03-18 Thread tavocol2002
Hello to everybody. Currently we are implementing a Customer that allready have Crystal Reports 2008. They have 1540 reports and they want to use the same formats and only change the DataSets, the customer developers has been working with the AX reporter but the conclusion was that AX Reporter

[development-axapta] HELP: Problems Executing a Stored Procedure AX 4.0

2009-02-26 Thread tavocol2002
Hello to everybody. Currently I'm trying to execute a SP but AX return an error that says something like this: Can not select a record at ( ) The SQL Data Base has thrown an error. This is the code that i'm trying to execute. I have to say that i allready try to use an ODBC connection

[development-axapta] FORCE USER AUTO LOGOFF

2008-12-08 Thread tavocol2002
Hello to everybody. Currently our customer are using Microsoft Dynamics AX 4.0 with a limited number of licences (15). The problem is that the number of users are increasing but the general manager doesn't want to buy new licenses. So, based on the CEO decisions, we are managing the automatic

[development-axapta] Re: datediff equivalent in X++

2008-12-08 Thread tavocol2002
Hello Larry. Let me see if i understand you. I have Transdate1 = 31\10\2008 And Transdate2= 01\08\2008 You want to know how many days are between the dates??? If the answer is yes, and you want the difference. The only thing that you have to do is declare a Int variable. And assing the

[development-axapta] Re: Views in AX

2008-10-28 Thread tavocol2002
Hello Aman. Ok. Let me understand, the thing that you want is to group on the new View. Let's say that today you have: COMPANY1,BUSREL1 COMPANY1,BUSREL1 COMPANY2,BUSREL1 COMPANY2,BUSREL2 COMPANY2,BUSREL2 The result that you want is: COMPANY1,BUSREL1 COMPANY2,BUSREL1 COMPANY2,BUSREL2 Right???

[development-axapta] READ A CUSTOM XML

2008-07-16 Thread tavocol2002
Hello to everybody. Right now i have to read a XML generated by a server. The problem is that i have writed many codes to create a XML but not for read a XML file. This is a code example of the XML that i have to read. Thank you very much to the people that reads this post. ?xml version=1.0

[development-axapta] OPEN CASH MACHINE HELP

2008-06-23 Thread tavocol2002
Hi Folks. I have an EPSON TM-U220PD and my customer wants to implement a P.O.S. I have this case scenario: An AX Server - Terminal Server - Final user logging trough Terminal Server to work with AX - Cash Machine on Local PC. The question is How can i open the Cash Machine that is connected to

[development-axapta] Re: XML XSLT Formating in Excel 2007

2008-02-12 Thread tavocol2002
://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=146 I hope your file will look more beautiful :) Regards, Aji Sarosa tavocol2002 wrote: Hi. A few weeks ago i started to use XML to generate massive data, because the use of COM Excel was too slow. Now i'm generating the same data result 10

[development-axapta] XML XSLT Formating in Excel 2007

2008-02-08 Thread tavocol2002
Hi. A few weeks ago i started to use XML to generate massive data, because the use of COM Excel was too slow. Now i'm generating the same data result 10 times faster than COM Excel. The Question :D I'm generating an XML file trough AX, i have the XSD and XSLT to visualize the file in a beauty

[development-axapta] Re: restore sql server, user bmssa problem

2005-01-05 Thread tavocol2002
Hi Hilda!! Ok, on SQL Corporative Manager go to the SysUser table and delete de bmssa user. Then refresh SQL Corporative Manager and go to the security folder and asign to the user bmssa the database. I hope that everything functions well!!! Spanish: Hola Hilda!! Nosotros hemos

[development-axapta] HOW TO SET TO MANDATORY A FIELD ON A FORM. WITHOUT TOUCHING THE TABLE????????

2005-01-05 Thread tavocol2002
Hello to everybody!!! I wanna set to mandatory a field in a form. I used InventTable_ds.object(FieldNum(InventTable,ItemId).Mandatory(true); The problem is that the property is false, it has the red indicator of mandatory field, but if i jump to another record it doesn´t do anything.

[development-axapta] EXECUTE A STRING VARIABLE CONTENT - EJECUTAR CONTENIDO DE VARIABLE STRING

2005-01-03 Thread tavocol2002
ENGLISH: Hello!!! I'm trying to execute the content of a string variable. By Example: I have the variable str execode = InventTable.ItemId = 'Item1' exists one way to execute the str variable? THANKS! SPANISH: Hola!!! Estoy tratando de ejecutar el contenido de una variable

[development-axapta] Extract the Field Properties

2004-12-30 Thread tavocol2002
Hello!!! This is my little doubt. I want to extract all the field properties located on a table. Lets see an example. I have the Table InventTable and the ItemGroupId Field. I want to extract the ItemGroupId properties, principally its ExtendedDataType. I want to do this from the