# report using fetch

**URL:** <https://www.dynamicsuser.net/t/report-using-fetch/43530>\
**Category:** Developer Forum\
**Created:** [February 7, 2013, 6:35am UTC](https://www.dynamicsuser.net/t/report-using-fetch/43530 "2013-02-07T06:35:43Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![nick017](https://avatars.discourse-cdn.com/v4/letter/n/ea666f/32.png) [@nick017](https://www.dynamicsuser.net/u/nick017)\
**Post date:** [February 7, 2013, 6:35am UTC](https://www.dynamicsuser.net/t/report-using-fetch/43530/1 "2013-02-07T06:35:43Z")

</div>

“The data source is not embedded within a (parent) data source.”

This is the error i get while trying to fetch a record from a table in report using fetch method without using datasource or querry in AOT.

How do i solve this error

the following is the fetch method which i have written in Report

public boolean fetch()  
{  
CarTable carTable1,carTable2;  
QueryRun qr;  
QueryBuildDatasource QueryBuildDatasource1;  
;  
qr = new QueryRun(element);  
QueryBuildDatasource1 = element.query().dataSourceTable(tablenum(CarTable));  
while (qr.next())  
{  
if (qr.changed(tableNum(CarTable)))  
{  
carTable1 = queryRun.get(tableNum(CarTable));  
if(carTable1)  
{  
element.newPage();  
}  
this.send(carTable1);

if(carTable1.CarBrand)  
{  
while select carTable1 where carTable1.CarId == carTable2.CarId  
{  
element.send(carTable1);  
}  
}  
}  
}  
return true;  
}

I want to fetch records from just 1 table …i.e cartable display on report

---

<div class="post-metadata">

**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\
**Post date:** [February 7, 2013, 6:44am UTC](https://www.dynamicsuser.net/t/report-using-fetch/43530/2 "2013-02-07T06:44:12Z")

</div>

Is it Nav or AX?

---

<div class="post-metadata">

**Author:** ![nick017](https://avatars.discourse-cdn.com/v4/letter/n/ea666f/32.png) [@nick017](https://www.dynamicsuser.net/u/nick017)\
**Post date:** [February 7, 2013, 6:55am UTC](https://www.dynamicsuser.net/t/report-using-fetch/43530/3 "2013-02-07T06:55:49Z")

</div>

ax 2009

---

<div class="post-metadata">

**Author:** ![MartinDrab](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)\
**Post date:** [February 7, 2013, 9:02am UTC](https://www.dynamicsuser.net/t/report-using-fetch/43530/4 "2013-02-07T09:02:38Z")

</div>

First of all, you use _qr_ variable to iterate through results and _queryRun_ variable to get table buffer. That’s obviously wrong.

And are you aware of that the statement _QueryBuildDatasource1 = element.query().dataSourceTable(tablenum(CarTable));_ does nothing useful?

---

<div class="post-metadata">

**Author:** ![nick017](https://avatars.discourse-cdn.com/v4/letter/n/ea666f/32.png) [@nick017](https://www.dynamicsuser.net/u/nick017)\
**Post date:** [February 7, 2013, 12:40pm UTC](https://www.dynamicsuser.net/t/report-using-fetch/43530/5 "2013-02-07T12:40:48Z")

</div>

sorry i was unaware of it …thanks a lot now how to i iterate with help of qr?

---

<div class="post-metadata">

**Author:** ![MartinDrab](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)\
**Post date:** [February 7, 2013, 12:55pm UTC](https://www.dynamicsuser.net/t/report-using-fetch/43530/6 "2013-02-07T12:55:06Z")

</div>

You already iterate through query results by _while (qr.next())_. You need to call _get()_ on the same object (i.e. _qr_, not on _queryRun_).

---

<div class="post-metadata">

**Author:** ![nick017](https://avatars.discourse-cdn.com/v4/letter/n/ea666f/32.png) [@nick017](https://www.dynamicsuser.net/u/nick017)\
**Post date:** [February 8, 2013, 4:34am UTC](https://www.dynamicsuser.net/t/report-using-fetch/43530/7 "2013-02-08T04:34:59Z")

</div>

Thanks very much Martin…