Thanks all, It worked, actually it was kind of complicated and I had to change some things but it worked fine.
I tried using the element.send(_tipos) but it gave me an error, so instead I used the .executeSection() and it worked, then also I had to change to Generated Design instead of AutoDesignSpecs, so that I could have Group Sections. So even I made it kind of dynamic, cause I had a lot of Subtotales and only used one Footer. Thanks, Karina --- In [email protected], Ahmet Tütüncüler <ahmettutuncu...@...> wrote: > > Hi, > > No you don't have to use a temporary table. > > Try to write element.send(_tipos); after your query. > > Ahmet > > On Tue, Jan 20, 2009 at 5:37 PM, karinasaenzs <karinasae...@...>wrote: > > > Hi, > > > > I am new to Axapta and am working on a report that has totals and > > subtotals sections. > > > > In this sections I am working with queries that look like this: > > > > select count(recid), ep_id_etapa, in_id_descripcion > > from _tipos group by ep_id_etapa, in_id_descripcion > > where _tipos.projid == _projTable.ProjId && > > _tipos.ep_id_etapa == _tblInmueble.ep_id_etapa > > > > But I have'nt been able to display this information on the report, > > must I do it with temporary tables? > > > > or is there a better and simpler way of displaying this information? > > > > Any help is greatly appreciated, > > Thanks, > > Karina > > > > > > > > > > -- > Ahmet TÜTÜNCÜLER > > > [Non-text portions of this message have been removed] >
