Hi Hema,
You can use fieldId2Ext function. For ex :
LedgerTable_ds.query().dataSourceTable(tablenum(LedgerTable)).addRange(fieldId2Ext(fieldnum(LedgerTable,
Dimension),1)).value(QueryValue("DepartmentName"));
Anil Ozay
MBSCP, MCP
Software Engineer
Anadolu Group (www.bilisimanadolu.com)
On 4
Check this form on local Axapta server. Dont apply on real server, because this
includes
a table. You can open with notepad. Especially chech modified method in
stringedit.
You must change below line, because our dimension[1] is Department. Apply for
your
system.
queryBuildRange.value("Departm
Hi,
sorry. can u explain with example. Thank u.
regs,
Hema. S
Yavuz YILDIZ
Ok.
1. Create a string edit in form.
2. Make 2 relations (Description and Num fields) between your table and
Dimensions table.
3. Type your table name in StringEdit's Datasource property
4. And type your table's field name in StringEdit's Field property
It will be appear dimension[1] in your form
Hi,
Thank u. but, i dont want in reports. i want to execute query based on the
specific dimension in forms. how do i give?
regs,
Hema. S
Yavu
Drag and drop dimension[1] field to Range in Datasources.
--- [EMAIL PROTECTED] wrote:
> Hi,
>
> how do i give the selected dimension in queryrange. the following code
> shows error
>
>
> dim=this.query
> ().dataSourceNo(1).addRange(fieldnum(eamworkrequest,dimension[1]));
>
> provide the
Hi,
how do i give the selected dimension in queryrange. the following code
shows error
dim=this.query
().dataSourceNo(1).addRange(fieldnum(eamworkrequest,dimension[1]));
provide the solution. thank u.
regs,
Hema. S
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapt
7 matches
Mail list logo
