Hi Arijit, I've already downloaded the sample code for the temporary table in report. The sample work great. However my concern is how to apply it to my own scenario. I have a report that populate the temp table from a buildquery method of the class that is extended from runbasereport. I can not apply the same code in the sample xpo to my actual program it is giving me error.
The sample code is Public boolean fetch { boolean ret; queryRun qr; FormDataSource formDataSource; TRG_TempTable TRG_TempTable; query q = new query(element.query()); ; if (templTableReport) qr= new query(this.queryRun().setRecord(tempTableReport. .parmTempTable())); qr= new QueryRun(q); while (qr.next()) { element.send(TRG_TempTable); } return ret; My program code look like this. Public boolean Fetch() { I have some variable init here qr = new QueryRun(MYclass.buildquery()); this.queryRun(qr); while (qr.next) { element.send(Table1); } return } MYclass is the class with dialog buildquery - populate the temp table how can I change the code qr = new QueryRun(MYclass.buildquery()); to qr= new query(this.queryRun().setRecord(tempTableReport. .parmTempTable())); Thanks, Patrick --- In Axapta-Knowledge-Village@yahoogroups.com, "chuapatrickd" <[EMAIL PROTECTED]> wrote: > > Hi Arijit, > > Thanks for the reply. I'll check this site and let you know what > happen. > > regards, > Patrick > > > --- In Axapta-Knowledge-Village@yahoogroups.com, "Arijit Basu" > <arijit.basu@> wrote: > > > > Hi, > > Check out this link on temp tables in Reports. > > http://www.axaptapedia.com/index.php/Temporary_tables > > There are XPO downloads here. > > Lemme know if it helped > > > > Cheers > > Arijit > > http://daxguy.blogspot.com/ > > > > On 1/22/07, chuapatrickd <chuapatrickd@> wrote: > > > > > > Hi to All, > > > > > > I'm trying to use a temporary table as data source for my report. > > > However after populating it with the desired data, the report > would > > > have no data in it. What I did is to make the temp table as > permanent. > > > This time, the report did print ok with the selected customer. My > > > problem is if there are more than 1 user who will print the same > > > report. The problem I foresee is that the selectec customer for > first > > > user will be overriden by the second users. This result in an > incorrect > > > output. How will I be able to solve this problem? any idea will be > > > greatly appreciated. How come that the temp does not store the > data in > > > the report ? > > > > > > regards, > > > Patrick > > > > > > > > > > > > > > > > > -- > > > > > > Arijit Basu > > > > > > [Non-text portions of this message have been removed] > > >