1. Richard Albrecht
  2. Valentina Reports ADK
  3. Пятница, Июль 26 2019, 04:28 PM
  4.  Подписаться через email
I have a data set that contains multiple records where name field is same, however there are invoice numbers that are different, so Name1 may have 3 records, but 3 different invoice numbers. Then Name2 has 2 Invoice numbers on so on.

Name1 Invoice100
Name1 Invoice130
Name1 Invoice141
Name2 Invoice110
Name2 Invoice135
Name3 Invoice110
Name3 Invoice410
Name3 Invoice480

So the report output would be:

Name1
Invoice100
Invoice130
Invoice141

----------Page Break

Name2
Invoice110
Invoice135

----------Page Break

Name3
Invoice110
Invoice410
Invoice480

Etc...

I can't figure out how to force the Page break when it moves to next Name.

Any suggestions.
Комментарий
There are no comments made yet.
Richard Albrecht Ответ принят
Got it.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
With grouping, sorting can be defined only in the application, not the query.

So you have:
Groping - NameField Ascending
Sorting - InvoiceField Ascending

And the order is wrong, records are not sorted by InvoiceField?
Could you please add a few example values?
Комментарий
There are no comments made yet.
Richard Albrecht Ответ принят
The report is not following the sort order. I tried using the order by in the sql as well as the grouping and sorting in the report writer.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Do you have a Report Header region?

If yes and If you need to print there something you can insert Page Break control to the Group Footer (instead of the new_page property of Group Header).

It is easy to see which field is too long.
In the Preview mode, you can switch to the Profile tab and check Names and Warnings options:
Вложения
Комментарий
There are no comments made yet.
Richard Albrecht Ответ принят
Works but now the first page is blank.

Also when you see a warning like field15 text to big, how do you find that field?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Sorry, it is in the group header:
Вложения
Комментарий
There are no comments made yet.
Richard Albrecht Ответ принят
Where is new_page property of the column header?:(
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Richard,

So you have grouping by name, right?
Then you can use new_page property of the column header.
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories