RE: [Axapta-Knowledge-Village] Temp Table in Report

Yoni Breyne Tue, 30 Nov 2004 00:11:52 -0800

Hi Steven,

Using your example I would be doing it like this:

ClassDeclaration()

public class ReportRun extends ObjectRun
{
tmp_SalesTotal tmp_SalesTotal;

ReportSalesTotal caller; // calling class
}

public boolean fetch()
{
Boolean ret = false;

tmp_SalesTotal_1.setTmpData(caller.GetTmpTable()); // Name of the Datasource

while select tmp_SalesTotal_1

{

this.send(tmp_SalesTotal_1);

ret = true;

}

return ret;
}

Make sure that you have a reportsection for your tmptable on your report.

Greetz,

Yoni Breyne

From: Steven Egberghs [mailto:[EMAIL PROTECTED]
Sent: dinsdag 30 november 2004 9:02
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Temp Table in Report

This is what I used in Ax3.0SP2

regards

Steven

ClassDeclaration()

public class ReportRun extends ObjectRun
{
tmp_SalesTotal tmp_SalesTotal;

ReportSalesTotal caller; // calling class
}

public boolean fetch()
{
Query queryTmp;
QueryRun qr;

tmp_SalesTotal tmp;
;

queryTmp = element.query();
qr = new QueryRun(queryTmp);

tmp_SalesTotal_1.setTmpData(caller.GetTmpTable()); // Name of the Datasource
qr.setRecord(tmp_SalesTotalPool_1);

    while (qr.next())
    {
        tmp      = qr.get(tablenum(tmp_SalesTotal));

this.send(tmp);
}

return true;
}

public void init()
{
super();
caller = element.args().caller();

}

>>> [EMAIL PROTECTED] 30/11/2004 8:55:07 >>>

I tried this but unfortunatily it's not working also. May I'm doing something wrong, i will try again

Ahmed

Yoni Breyne <[EMAIL PROTECTED]> wrote:

Hi,

You should assign the content of your temporaryTable variable to the table variable declared as member of the report Query.

Eg.

You ‘ve created a Temporary Table named TmpTable.

This table is the source of your report.

So in the init you should write something like this: (where TmpTableQuery is the name of the Table in your report Query).

TmpTable                      tmpTableFill;

;

While(…)

{

            …

            tmpTableFill.insert();

}

TmpTableQuery.setTmpData(tmpTableFill);

Hope this will do,

Greetz,

Yoni

From: Steen Rabøl [mailto:[EMAIL PROTECTED]
Sent: zondag 28 november 2004 8:29
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Temp Table in Report

Hi

It’s very hard to tell you what is wrong with out knowing what you have done ;-)

Best

Steen Rabøl

From: mbsdeveloper [mailto:[EMAIL PROTECTED]
Sent: 28. november 2004 08:52
To: [EMAIL PROTECTED]
Subject: [Axapta-Knowledge-Village] Temp Table in Report

1-I tried to use temp table and show the data from temp table in
report since I fill-in the temp table on "init" trigger of the report
but unfortunality it's not showing anything. is it possible to use a
temp table in the report? please advise.

regards
Ahmed

Sharing the knowledge on Axapta.

Sharing the knowledge on Axapta.

Sharing the knowledge on Axapta.

Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.

Sharing the knowledge on Axapta.

Sharing the knowledge on Axapta.

Yahoo! Groups Sponsor

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 the Yahoo! Terms of Service.

RE: [Axapta-Knowledge-Village] Temp Table in Report

Reply via email to