First of all, why don't you just create this report the Drag&Drop MorphX way? That
would be sooooo much easier. Ok, you probably have some reason I guess.
If you really want to go all the way with X++ here's some tips :
qr = New QueryRun(q);
qr.setRecord(_table1);
qr.setRecord(_table2);
qr.setRecord(_table3);
// Here you'll need to create the section to print the info.
// Start with this...
ReportSection mySection = element.design().addProgrammableSection(1);
// The from here you can use mySection object to build the section by
// adding controls, preferably text.
while(qr.next()){
textControl1.text(_table1.Id);
textControl2.text(_table1.name);
// and so on
element.execute(1); //print the section...
}
By the way I don't know what element.Get do. I don't use element.send since it's
easier with programmable section.
Steeve...
-----Message d'origine-----
De : axapta_dude [mailto:[EMAIL PROTECTED]
Envoyé : 5 août 2004 11:47
À : [EMAIL PROTECTED]
Objet : [Axapta-Knowledge-Village] send and get
Hi..I'm a newbie and need some help from the expert.Below is a simplify exa=
mple for my
problem.
I'm using three table:
Table1 - id,name,age
Table2 - name , address
Table3 - age , status
Inside Fetch Method:
Query q =new query();
QueryRun qr;
QueryBuildDatasSource  qbd1,qbd2,qbd3;
QueryBuildLink qbl1,qbl2;
Table1 _table1;
Table2 _table2;
Table3 _table3;
qbd1 = q.addDataSource(TableNum(Table1));
qbd2 = qbd1.addDataSource(TableNum(Table2));
qbd2.joinmode(JoinMode::InnerJoin);
qbl1 = qbd2.addlink(FieldNum(Table1,Name),FieldNum(Table2,Name));
qbd3 = qbd1.addDataSource(TableNum(Table3));
qbd3.joinmode(JoinMode::InnerJoin);
qbl2 = qbd3.addlink(FieldNum(Table1,Age),FieldNum(Table3,Age));
qr = New QueryRun(q);
while(qr.next())
{ THIS IS THE PART THAT I'M NOT SURE.I WANT TO USE ELEMENT.GET AND ELEMENT.=
SEND.
I HOPE YOU GUYS CAN FILL THIS PART
}
I want the report to look something like this:
ID NAME ADDRESS STATUS
Thanx in advanced,Bye.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
