Report sort order & summary
Hello gordk
Thanks for your help, but your idea is not working
I'll give you a short simplified example. I have a report to show some info about articles grouped by article groups. My records are sorted on GroupID and ArticleID.
Report output is:
GroupID: 1 GroupName: First group
ArticleID ArticleName Price
2 Art2 1.1
5 Art5 0.9
8 Art8 1.0
(on page 1)
GroupID: 2 GroupName: Another group
ArticleID ArticleName Price
1 Art1 5.1
3 Art3 2.9
4 Art4 2.0
9 Art9 0.1
(on page 2)
I have a summary page, and this page contain only ArticleID and page number. For my report this sumarry page is:
ArticleID Page number
2 Page 1
5 Page 1
8 Page 1
1 Page 2
3 Page 2
4 Page 2
9 Page 2
I succesfully create report with data and the summary. My problem is that I want to have record sorted only on ArticleID for summary page, and I want this page to be:
ArticleID Page number
1 Page 2
2 Page 1
3 Page 2
4 Page 2
5 Page 1
8 Page 1
9 Page 2
Is this possible?
Thanks in advance for your efforts.
Thanks for your help, but your idea is not working
I'll give you a short simplified example. I have a report to show some info about articles grouped by article groups. My records are sorted on GroupID and ArticleID.
Report output is:
GroupID: 1 GroupName: First group
ArticleID ArticleName Price
2 Art2 1.1
5 Art5 0.9
8 Art8 1.0
(on page 1)
GroupID: 2 GroupName: Another group
ArticleID ArticleName Price
1 Art1 5.1
3 Art3 2.9
4 Art4 2.0
9 Art9 0.1
(on page 2)
I have a summary page, and this page contain only ArticleID and page number. For my report this sumarry page is:
ArticleID Page number
2 Page 1
5 Page 1
8 Page 1
1 Page 2
3 Page 2
4 Page 2
9 Page 2
I succesfully create report with data and the summary. My problem is that I want to have record sorted only on ArticleID for summary page, and I want this page to be:
ArticleID Page number
1 Page 2
2 Page 1
3 Page 2
4 Page 2
5 Page 1
8 Page 1
9 Page 2
Is this possible?
Thanks in advance for your efforts.