<div dir="ltr">Hello, Fabian,<div>this case was already discussed earlier</div><div><a 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><div class="gmail_quote">On Tue, Nov 19, 2013 at 3:29 PM, Fabian Eschrich <span dir="ltr"><<a href="mailto:info@faesch.de" target="_blank">info@faesch.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">yes, the results are right
when I try with my own query. I will send you report and database<br>
<br>
<blockquote style="border:0px none" type="cite">
<div style="margin:30px 25px 10px 25px"><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 src="cid:part1.01030104.08010606@faesch.de" name="142708d8417b7a4a_compose-unknown-contact.jpg" height="25px" width="25px"></div>
<div style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a href="mailto:sergey_pashkov@valentina-db.com" style="color:#737f92!important;padding-right:6px;font-weight:bold;text-decoration:none!important" target="_blank">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"><div class="im"><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><div class="im"><div>_______________________________________________<br>Valentina
mailing list<br><a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</div></div></div>
<div style="margin:30px 25px 10px 25px"><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 src="cid:part1.01030104.08010606@faesch.de" name="142708d8417b7a4a_compose-unknown-contact.jpg" height="25px" width="25px"></div>
<div style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a href="mailto:info@faesch.de" style="color:#737f92!important;padding-right:6px;font-weight:bold;text-decoration:none!important" target="_blank">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"><div class="im">
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><div><div class="h5"><div>_______________________________________________<br>Valentina
mailing list<br><a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</div></div></div></div><div><div class="h5">
<div style="margin:30px 25px 10px 25px"><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 src="cid:part1.01030104.08010606@faesch.de" name="142708d8417b7a4a_compose-unknown-contact.jpg" height="25px" width="25px"></div>
<div style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a href="mailto:sergey_pashkov@valentina-db.com" style="color:#737f92!important;padding-right:6px;font-weight:bold;text-decoration:none!important" target="_blank">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"><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 href="mailto:sergey_pashkov@valentina-db.com" target="_blank">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 href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</div></div>
</div></div></blockquote><div><div class="h5">
<br>
<div>-- <br>Mit freundlichen Grüßen / best
regards,<br>
Fabian Eschrich<br>
FAESCH Software<br>
<a href="mailto:info@faesch.de" target="_blank">info@faesch.de</a><br>
<br>
Fon: <a href="tel:%2B49%20%280%29371%20334246-10" value="+4937133424610" target="_blank">+49 (0)371 334246-10</a><br>
Fax: <a href="tel:%2B49%20%280%29371%20334246-11" value="+4937133424611" target="_blank">+49 (0)371 334246-11</a><br>
Skype: feschrich<br>
</div>
</div></div></div>
<br>_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
<br></blockquote></div><br></div>