Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Help with group by
Migrateduser
Hello everybody,<br />
<br />
I've got a Table who should list information about "Departement". Each "departement" has a name, a creation date ... and many "communes" . <br />
<br />
Here is the report I want :<br />
<br />
<p class='bbc_indent' style='margin-left: 40px;'>DEPARTEMENT 1<br />
NAME<br />
DATE<br />
...<br />
Communes linked :<br />
<p class='bbc_indent' style='margin-left: 40px;'>COM1<br />
COM2</p></p>
<br />
Page break<br />
<br />
<p class='bbc_indent' style='margin-left: 40px;'>DEPARTEMENT 2<br />
NAME<br />
DATE<br />
...<br />
Communes linked :<br />
<p class='bbc_indent' style='margin-left: 40px;'>COM3<br />
COM4</p></p>
<br />
I have put a "group by DEPARTEMENT" but I obtain this report :<br />
<br />
<p class='bbc_indent' style='margin-left: 40px;'>DEPARTEMENT 1<br />
NAME<br />
DATE<br />
...<br />
Communes linked <br />
<p class='bbc_indent' style='margin-left: 40px;'>COM1</p></p>
<br />
<p class='bbc_indent' style='margin-left: 40px;'>DEPARTEMENT 1<br />
NAME<br />
DATE<br />
...<br />
Communes linked <br />
<p class='bbc_indent' style='margin-left: 40px;'>COM2</p></p>
<br />
<p class='bbc_indent' style='margin-left: 40px;'>DEPARTEMENT 2<br />
NAME<br />
DATE<br />
...<br />
Communes linked <br />
<p class='bbc_indent' style='margin-left: 40px;'>COM3</p></p>
<br />
<p class='bbc_indent' style='margin-left: 40px;'>DEPARTEMENT 2<br />
NAME<br />
DATE<br />
...<br />
Communes linked <br />
<p class='bbc_indent' style='margin-left: 40px;'>COM4</p></p>
<br />
<br />
It doesn't match very well with the wanted report... If somebody would help me...<br />
<br />
thanks
Find more posts tagged with
Comments
There are no comments yet