<html><head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
</head><body style="background-color: rgb(255, 255, 255); color: rgb(0,
0, 0);" text="#000000" bgcolor="#FFFFFF">Hi Sergey,<br>
<br>
thanks for your reply.<br>
I think this could be a workaround. But number is not unique field.
transaction id is.<br>
<br>
Best regards<br>
<br>
Fabian<br>
<br>
<blockquote style="border: 0px none;"
cite="mid:CAOAvatwx=1YqT3A5Jc7iBPT8EAr1=Ver_bkUWqnwsRPd7vN9+g@mail.gmail.com"
type="cite"><div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="sergey_pashkov@valentina-db.com" photoname="Sergey
Pashkov" src="cid:part1.00090809.01070003@faesch.de"
name="compose-unknown-contact.jpg" width="25px" height="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true"
href="mailto:sergey_pashkov@valentina-db.com" style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Sergey Pashkov</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">20. November 2013
09:53</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div dir="ltr">Hello, Fabian,<div>this
case was already discussed earlier</div><div><a moz-do-not-send="true"
href="http://www.valentina-db.com/bt/view.php?id=4689">http://www.valentina-db.com/bt/view.php?id=4689</a><br></div><div><br></div><div>
You print "number" for each "transactionid".</div><div>So maybe you can
group by "number" and not a "transactionid"?</div><div><br></div><div>Best
regards,</div><div>Sergey Pashkov</div>
</div><div class="gmail_extra"><br><br><br></div>
<div>_______________________________________________<br>Valentina
mailing list<br><a class="moz-txt-link-abbreviated"
href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a
class="moz-txt-link-freetext"
href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></div></div>
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="info@faesch.de" photoname="Fabian Eschrich"
src="cid:part1.00090809.01070003@faesch.de"
name="compose-unknown-contact.jpg" width="25px" height="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true" href="mailto:info@faesch.de"
style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Fabian Eschrich</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">19. November 2013
14:29</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
yes, the results are right
when I try with my own query. I will send you report and database<br>
<br>
<br>
<div>_______________________________________________<br>Valentina
mailing list<br><a class="moz-txt-link-abbreviated"
href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a
class="moz-txt-link-freetext"
href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></div></div>
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="sergey_pashkov@valentina-db.com" photoname="Sergey
Pashkov" src="cid:part1.00090809.01070003@faesch.de"
name="compose-unknown-contact.jpg" width="25px" height="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true"
href="mailto:sergey_pashkov@valentina-db.com" style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Sergey Pashkov</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">19. November 2013
14:18</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div dir="ltr"><div><span
style="font-family:arial,sans-serif;font-size:13px">Can't reproduce yet.</span></div><div><span
style="font-family:arial,sans-serif;font-size:13px"><br></span></div><div><span
style="font-family:arial,sans-serif;font-size:13px">"E5076", "E5077",
"E5078", "E5075" - do you get a list of these values for the same "type"
value?</span><br>
</div><div><br></div><div>What will you get, if you execute the
following queries in SQL Editor, with your object names, of course?</div><div><br></div>1)
SELECT * FROM "t1" ORDER BY "type", "number"<div>
2) SELECT * FROM ( SELECT * FROM "t1" ) ORDER BY "type", "number"<br><div><br></div><div>Are
these results right?</div><div><br></div><div>VReports always print
data in the same order, as it was returned by the DB.<br>
<div><br></div><div>Best regards,</div><div>Sergey Pashkov</div></div></div></div><div
class="gmail_extra"><br><br><br></div>
<div>_______________________________________________<br>Valentina
mailing list<br><a class="moz-txt-link-abbreviated"
href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a
class="moz-txt-link-freetext"
href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></div></div>
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="info@faesch.de" photoname="Fabian Eschrich"
src="cid:part1.00090809.01070003@faesch.de"
name="compose-unknown-contact.jpg" width="25px" height="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true" href="mailto:info@faesch.de"
style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Fabian Eschrich</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">19. November 2013
13:33</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
Hi Sergey,<br>
<br>
the numbers are not sorted at all. In the result I see "E5076" "E5077",
"E5078" and then "E5075"<br>
<br>
I use VStudio 5.4.3 with remote valentina server.<br>
The fields are Varchar.<br>
<br>
Best regards<br>
<br>
Fabian<br>
<br>
<div>_______________________________________________<br>Valentina
mailing list<br><a class="moz-txt-link-abbreviated"
href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a
class="moz-txt-link-freetext"
href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></div></div>
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="sergey_pashkov@valentina-db.com" photoname="Sergey
Pashkov" src="cid:part1.00090809.01070003@faesch.de"
name="compose-unknown-contact.jpg" width="25px" height="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true"
href="mailto:sergey_pashkov@valentina-db.com" style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Sergey Pashkov</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">19. November 2013
12:12</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div dir="ltr">Hi, Fabian<div><br></div><div>You
have chosen sorting "Ascending" for the "number" field in the Report
Editor dialog.<br></div><div>But all of the numbers are sorted
descending.</div><div>
<br></div><div>Right?</div><div><br></div><div>If yes, then I'll ask you
to send your compressed project to <a moz-do-not-send="true"
href="mailto:sergey_pashkov@valentina-db.com">sergey_pashkov@valentina-db.com</a>?</div><div><br></div><div>
What version do you use? 5.4.3?</div><div>Datasource - local Valentina
DB?</div><div>And what are the field types for the "type" and for the
"number"?</div><div><br></div><div>Thank you.</div><div><br>
</div><div>Best regards,</div><div>Sergey Pashkov</div><div><br></div><div><br></div><div
class="gmail_extra"><br><br><br></div></div>
<div>_______________________________________________<br>Valentina
mailing list<br><a class="moz-txt-link-abbreviated"
href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a
class="moz-txt-link-freetext"
href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></div></div></blockquote>
<br>
<div class="moz-signature">-- <br>Mit freundlichen Grüßen / best
regards,<br>
Fabian Eschrich<br>
FAESCH Software<br>
<a class="moz-txt-link-abbreviated" href="mailto:info@faesch.de">info@faesch.de</a><br>
<br>
Fon: +49 (0)371 334246-10<br>
Fax: +49 (0)371 334246-11<br>
Skype: feschrich<br>
</div>
</body></html>