[development-axapta] using group by and calculated fields

Hello, I am new to Axapta so please forgive me if this is an easy question. I am trying to make a calculated field and a group by in the same query.  This is the query I'm trying to reproduce in Axapta: SELECT Sum(SalesLine.RemainSalesPhysical*SalesLine.SalesPrice), SalesLine.salesID FRO

Re: [development-axapta] Question about Queries.

Thanks Vishal... --- [EMAIL PROTECTED] wrote: > > Hi Roberto > > Try this > > > static void Job5(Args _args) > { > Query   eisQuery = new Query(); > InventTrans eisInventTrans; > QueryRun    eisQueryRun; > ; > > //eisInventTrans.Qty > eisQuery.addDataSource(Table

[development-axapta] Re: Vertical barcode on report

Hmm..? I cannot find any property to rotate controls in Axapta reports. regards Vegar --- In development-axapta@yahoogroups.com, "Nitesh" <[EMAIL PROTECTED]> wrote: > > hi Vegar Imsland, > > try to set the properties of the control in which u r printing the Barcode > as u require > >

[development-axapta] Re: Outer join in X++

Hi Matt, >I cut out the cases where the address has changed but the custtable has not.. What do you mean with this? The select I gave should show all records from custTable and all records (that match) from addressTable (so it CAN show more then 1 record from addresstable for 1 record f

[development-axapta] (unknown)

_ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your g

[development-axapta]

email-body was scanned and no virus found email-body was scanned and no virus found [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/grou

AW: [development-axapta] Add dynalinks programatically

Hi Lars, try this _q.dataSourceNo(1).addDynalink(fieldNum(, ), element.args().record(), fieldnum(, ) ); Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen NMS - Entwicklung Axapta arvato systems Technologies GmbH An der Autobahn 18 33311 Gütersloh

Re: [development-axapta] Add dynalinks programatically

hi lars, u can do it by opening form1 first... then system will handle the relation automatically.. give valid journal id... static void Job13(Args _args) {   formrun  f,f1;   LedgerJournalTable  table;   Args args1 = new Args();   Args args2 = new Args();   FormControl   fc;   ;     select

Re: [development-axapta] Documentation

hi Jason Dykeson: yes like this, if u have information about many other as i am having registration on this site. i would like to have if u have other URLs Regards Nitesh - Original Message - From: "Jason Dykeson" <[EMAIL PROTECTED]> To: Sent: Friday, March 11, 2005 3:32 PM Subject

Re: [development-axapta] Vertical barcode on report

hi Vegar Imsland, try to set the properties of the control in which u r printing the Barcode as u require Nitesh - Original Message - From: "vegar410" <[EMAIL PROTECTED]> To: Sent: Friday, March 11, 2005 2:42 PM Subject: [development-axapta] Vertical barcode on report > > > > I

RE: [development-axapta] Documentation

You mean www.axapta-links.com ? JasonD -Oorspronkelijk bericht- Van: Nitesh [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 11 maart 2005 10:40 Aan: development-axapta@yahoogroups.com Onderwerp: [development-axapta] Documentation hi all, do any one have the information related to

[development-axapta] Add dynalinks programatically

Hi all, Is it possible somehow to add dynalinks programatically? Example: Form 1 calls Form2. Between those, there's a dynalink which is maintained by the kernel (I think). When I change a record in form1, the corresponding record is shown in Form2. Which record depends on the relations

Re: [development-axapta] Question about Queries.

hello Lars; sorry to say u r not fulfilling the requirements of the Roberto's problem. i think u need to the requirement. solution sent by visal is ok. what u think regards Nitesh - Original Message - From: "Lars Holm" <[EMAIL PROTECTED]> To: Sent: Friday, March 11, 2005 2:37 PM

[development-axapta] Documentation

hi all, do any one have the information related to the Axapta technical documentation sites?? regards Nitesh   -- email-body was scanned and no virus found email-body was scanned and no virus found [Non-text portions of this message have been removed] Yahoo! Group

Re: [development-axapta] Question about Queries.

Hi Roberto Try this static void Job5(Args _args) {     Query   eisQuery = new Query();     InventTrans eisInventTrans;     QueryRun    eisQueryRun;     ;     //eisInventTrans.Qty     eisQuery.addDataSource(TableNum(InventTrans));     eisQuery.dataSourceTable(TableNum(InventTrans)).orderMod

[development-axapta] Vertical barcode on report

I am trying to print a barcode vertically in the upper left corner of a report. I found some suggestions on how to do this on previously posted messages, but none of them worked. Any suggestions on how to do this? regards Vegar Imsland Yahoo! Groups Sponsor ADVERTISEMEN

RE: [development-axapta] Question about Queries.

Try something like this (example on custtrans)     query = new Query();     qbds = query.addDataSource(tablenum(CustTrans));     qbds.addRange(fieldnum(CustTrans, Accountnum)).value('test');     qbds.addSortField(fieldnum(CustTrans, AccountNum));     qbds.orderMode(OrderMode::GroupBy);     qb

[development-axapta] Text Case

Hi guys, I'm new to this, and will probably make some silly question, forgive me. Here goes: - How can I convert, in X++ a text case, from a string variable - Is there any class that converts numbers to text representing those numbers? For the last one, I started a Class which works ok fo

[development-axapta] What does 'ReIndex" function exactly do

Hi, Admistration -Perioidic -  SQL Admi - Index Actions - Reindex. What does Reindex do exactly?. I thought Index is used for better Searching the records in the Tables. Any help. -Padmaja     - Do you Yahoo!? Yahoo! Small Business - Try o

RE: [development-axapta] Adding new field to inventrans and getting it populated

Hi James Its very simple, there are multiple ways to do this. One way can be... Say you have created a field called "InternalReferenceMMS" (or InternalReferenceESG in your case *s*) on "InventTrans" Now create a new method on class InventMovement say Str 20 internalReferenceMMS

RE : [development-axapta] adding sections to a programmed report in x++ code

Maybe the autoSection set the property "DataField" of the section and you need to set a sort order corresponding to that DataField so the section can be executed.  But, I've never done that. Regards, Steeve... -Message d'origine- De : Isaura Ortiz [mailto:[EMAIL PROTECTED] Envoyé

[development-axapta] Question about Queries.

Hello to All Is there a way to make a query that gives the same result of doing: select sum(FieldX) from TableX where FieldY == Something; The way i found goes like this, but I am sure that there should be a nicer way. Amount SumAmount; Query queryX; QueryRun queryrunX; TableX tableM; que