Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (8)

Resolved Simple Name / Invoice numbers report

  1. Richard Albrecht
    Richard Albrecht
  2. Valentina Reports ADK
  3. Friday, July 26 2019, 04:28 PM
  4.  Subscribe via 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.
  1. VS_ReportEditor
  2. SOLVED!
Comment
There are no comments made yet.
Responses (8)
Sergey Pashkov
Sergey Pashkov Accepted Answer
Hello Richard,

So you have grouping by name, right?
Then you can use new_page property of the column header.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 1
Richard Albrecht
Richard Albrecht Accepted Answer
Where is new_page property of the column header?:(
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 2
Sergey Pashkov
Sergey Pashkov Accepted Answer
Sorry, it is in the group header:
Attachments (1)
Screenshot 2019-07-26 20.39.44.png Screenshot 2019-07-26 20.39.44.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 3
Richard Albrecht
Richard Albrecht Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 4
Sergey Pashkov
Sergey Pashkov Accepted Answer
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:
Attachments (1)
Screenshot 2019-07-26 21.50.15.png Screenshot 2019-07-26 21.50.15.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 5
Richard Albrecht
Richard Albrecht Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 6
Sergey Pashkov
Sergey Pashkov Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 7
Richard Albrecht
Richard Albrecht Accepted Answer
Got it.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 8
  • Page :
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories