[resolvido] Repórter order by in group

Moderador: Avelino Sampaio

Nilton GO
Mensagens: 4
Registrado em: 18 Out 2017, 21:35

[resolvido] Repórter order by in group

Mensagempor Nilton GO » 10 Nov 2017, 16:46

I need the "order by" to be in the group id field (sector_id) in the report.
I make the clients report (tbClient), related to two tables, where the sector table (tbSetor) is the group, and the table (tblocal) is the subgroup. I need to use the sector_id field as order by of the group. I made the query and when opening the correct relation appears, but when opening as a report the order is done with the field sector_description. This sector_description field is what you see in the report.

Disable adblock

Precisamos do seu apoio. Faca uma doacao para o site atraves do Paypal.


Avatar do usuário
Avelino Sampaio
Mensagens: 1883
Registrado em: 04 Jun 2015, 18:27
Contato:

Re: Repórter order by in group

Mensagempor Avelino Sampaio » 13 Nov 2017, 09:39

Hi Nilton

Open the report in Design view
Click the Design tab of the ribbon.
In the "Grouping and Totals" group, click the "Group and sort" button
==================================================
Clique no link abaixo e veja um ótimo kit de ensino que tenho para você.
http://www.usandoaccess.com.br
==================================================

Nilton GO
Mensagens: 4
Registrado em: 18 Out 2017, 21:35

Re: Repórter order by in group

Mensagempor Nilton GO » 13 Nov 2017, 11:39

I was able to solve it, with a simple explanation, short and fast.
It was a week ago and I could not get help on how to solve it. I am very grateful.

Disable adblock

Precisamos do seu apoio. Faca uma doacao para o site atraves do Paypal.



Voltar para “Relatórios”

Quem está online

Usuários neste fórum: Nenhum usuário registrado e 1 visitante