[development-axapta] Re: Reports with group by and count

2009-02-05 Thread karinasaenzs 
Thanks all,

It worked, actually it was kind of complicated and I had to change 
some things but it worked fine. 

I tried using the element.send(_tipos) but it gave me an error, so 
instead I used the .executeSection() and it worked, then also I had 
to change to Generated Design instead of AutoDesignSpecs, so that I 
could have Group Sections.

So even I made it kind of dynamic, cause I had a lot of Subtotales 
and only used one Footer.

Thanks,

Karina

--- In development-axapta@yahoogroups.com, Ahmet Tütüncüler 
 wrote:
>
> Hi,
> 
> No you don't have to use a temporary table.
> 
> Try to write element.send(_tipos); after your query.
> 
> Ahmet
> 
> On Tue, Jan 20, 2009 at 5:37 PM, karinasaenzs 
wrote:
> 
> >   Hi,
> >
> > I am new to Axapta and am working on a report that has totals and
> > subtotals sections.
> >
> > In this sections I am working with queries that look like this:
> >
> > select count(recid), ep_id_etapa, in_id_descripcion
> > from _tipos group by ep_id_etapa, in_id_descripcion
> > where _tipos.projid == _projTable.ProjId &&
> > _tipos.ep_id_etapa == _tblInmueble.ep_id_etapa
> >
> > But I have'nt been able to display this information on the report,
> > must I do it with temporary tables?
> >
> > or is there a better and simpler way of displaying this 
information?
> >
> > Any help is greatly appreciated,
> > Thanks,
> > Karina
> >
> > 
> >
> 
> 
> 
> -- 
> Ahmet TÜTÜNCÜLER
> 
> 
> [Non-text portions of this message have been removed]
>

SV: [development-axapta] How to show field hidden by user in X++

2009-02-05 Thread Dahlsgaard Jan 
very bad idea.
You are changing code in aot on runtime, and unless you change it back, it will 
be like that next time you open the form, and also all other places this field 
is used.
There might even be a problem with missing X++ license, or if the user doesn't 
have access to SysDevelopment.



Fra: development-axapta@yahoogroups.com 
[mailto:development-axa...@yahoogroups.com] På vegne af somanna gl
Sendt: 5. februar 2009 04:45
Til: development-axapta@yahoogroups.com
Emne: Re: [development-axapta] How to show field hidden by user in X++




str Property;
TreeNode TreeNode;
str Name;
;

Name = "CustTable";
TreeNode = TreeNode::findNode("Data Dictionary\\Tables\\" /*+ Table*/);
if (TreeNode)
{
ttsbegin;
Property = TreeNode.AOTgetProperties();
Property = SetProperty(Property, "visible", "Yes");
TreeNode.AOTsetProperties(Property);
TreeNode.AOTcompile();
TreeNode.AOTsave();
}


From: christian.myrvold mailto:christian.a.myrvold%40gmail.com> >
To: development-axapta@yahoogroups.com 
 
Sent: Monday, February 2, 2009 6:45:33 PM
Subject: [development-axapta] How to show field hidden by user in X++

Hey everyone,

I've searched both the group postings and google for this, and haven't
found anything yet. I need to either:

1. Show a field in a form immediately after a user hides it (so it
looks like the "hide functionality" doesn't work), or
2. Disable the hide functionality when a user right clicks on the field.

I would say the the first is preferrable, if it's at all possible.

Sincerely,
Chris






[Non-text portions of this message have been removed]

RE: [development-axapta] printing AX Financial Statement in Secondary Currency

2009-02-05 Thread James Flavell 
Yes in the FS column setup one of the column types is 'Secondary amount' or
something like that. That will give you the amounts from the secondary
currency
 

  _  

From: development-axapta@yahoogroups.com
[mailto:development-axa...@yahoogroups.com] On Behalf Of Patricia Pua
Sent: 05 February 2009 10:32
To: development-axapta@yahoogroups.com
Subject: [development-axapta] printing AX Financial Statement in Secondary
Currency



Hello All, 

May I know if  there is any possibility to print AX Financial Statement base
on the Secondary Currency? 

For example if we have a Europe Entity, and our Base Currency is EURO
dollars and we also setup the Secondary Currency as USD.  At this moment we
can only print the AX Financial Statement base on EURO (ie base currency),
any of you know if it is possible to print the same report base on Secondary
Currency setup in Basic > Company > Other Tab?

Thanks

New Email addresses available on Yahoo!
Get the Email name you've always wanted on the new @ymail and
@rocketmail. 
Hurry before someone else does!
http://mail. 
promotions.yahoo.com/newdomains/sg/

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]

Re: [development-axapta] How to show field hidden by user in X++

2009-02-05 Thread somanna gl 

  strProperty;
TreeNodeTreeNode;
str   Name;
;

Name = "CustTable";
TreeNode  = TreeNode::findNode("Data Dictionary\\Tables\\" /*+ Table*/);
if (TreeNode)
{
   ttsbegin;
   Property   = TreeNode.AOTgetProperties();
   Property   = SetProperty(Property, "visible", "Yes");
   TreeNode.AOTsetProperties(Property);
   TreeNode.AOTcompile();
   TreeNode.AOTsave();
}




From: christian.myrvold 
To: development-axapta@yahoogroups.com
Sent: Monday, February 2, 2009 6:45:33 PM
Subject: [development-axapta] How to show field hidden by user in X++


Hey everyone,

I've searched both the group postings and google for this, and haven't
found anything yet. I need to either:

1. Show a field in a form immediately after a user hides it (so it
looks like the "hide functionality" doesn't work), or
2. Disable the hide functionality when a user right clicks on the field.

I would say the the first is preferrable, if it's at all possible.

Sincerely,
Chris

Re: [development-axapta] Re: Integration with Axapta

2009-02-05 Thread Agus Riyadi 
Hi,

One of our client uses Ax 3.0 with Galaxy.
However you said that you need it urgently, which seems that you have
limited time to set it up.
If you use Ax 4.0 + maybe you can use AIF.

Best regards,

Agus

2009/2/2 

>   Hi,
>
> if you are post 4.0 you should take a look at the AIF components.
>
> Mit freundlichen Grüßen / Best regards / Med venlig hilsen
>
> Jesper Jørgensen / Abt. NMT-XD
> Senior Product Manager
>
> arvato systems | Technologies GmbH
> An der Autobahn 18
> 33311 Gütersloh
>
> jesper.joergen...@bertelsmann.de 
>  jesper.joergen...@bertelsmann.de >
>
> Phone: +49 5242 / 40 80 54
>
> Fax: +49 5242 / 40 80 40
>
> Mobile: +49 172 / 571 03 34
>
> http://www.as-T.de http://www.as-t.biz/>
> arvato systems | Technologies GmbH
> Joachim-Jungius-Str. 9, 18059 Rostock
> Geschäftsführung: Erwin Pietz, Matthias Moeller
> Amtsgericht Rostock - HRB 7497
>
> 
>
> "Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und
> ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie
> sicher, dass die Information in dieser Nachricht ausschließlich an die
> adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie
> gesendet worden sein, dann informieren Sie bitte umgehend den Absender und
> löschen Sie die Nachricht. Vielen Dank."
>
> "The information in this e-mail and any attachments is confidential. The
> information must only be held in areas that have controlled and limited
> access to the addressed persons. If this e-mail has been sent to you in
> error, please immediately notify the sender and delete the e-mail. Thanks."
>
> 
>
> Von: 
> development-axapta@yahoogroups.com[mailto:
> development-axapta@yahoogroups.com ]
> Im Auftrag von Florian Dittgen
> Gesendet: Freitag, 30. Januar 2009 15:23
> An: development-axapta@yahoogroups.com
> Betreff: [development-axapta] Re: Integration with Axapta
>
> --- In 
> development-axapta@yahoogroups.com development-axapta%40yahoogroups.com>
> , "Trinadh Sura" 
> wrote:
> >
> > Dear All,
> >    what are the different types of method  can be  used for
> Integration with Axapta like ODBC.Can any one help me.it is urgent for
> client.
> > Regards
> > Trinadh
> >
> > [Non-text portions of this message have been removed]
> >
> ADO and ODBC.
> Have a look at
> http://blogs.msdn.com/floditt/archive/2008/11/04/axapta-3-ado-instead-
> of-odbc-or-install-the-sp6.aspx
> for an exsample.
>
> [Non-text portions of this message have been removed]
>
>  
>


[Non-text portions of this message have been removed]

[development-axapta] printing AX Financial Statement in Secondary Currency

2009-02-05 Thread Patricia Pua 
Hello All, 

May I know if  there is any possibility to print AX Financial Statement base on 
the Secondary Currency? 

For example if we have a Europe Entity, and our Base Currency is EURO dollars 
and we also setup the Secondary Currency as USD.  At this moment we can only 
print the AX Financial Statement base on EURO (ie base currency), any of you 
know if it is possible to print the same report base on Secondary Currency 
setup in Basic > Company > Other Tab?

Thanks


  New Email addresses available on Yahoo!
Get the Email name you've always wanted on the new @ymail and @rocketmail. 
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/sg/

[Non-text portions of this message have been removed]