Sort inside reports

[Sergey Pashkov]

Hello, Fabian,
this case was already discussed earlier
http://www.valentina-db.com/bt/view.php?id=4689

You print "number" for each "transactionid".
So maybe you can group by "number" and not a "transactionid"?

Best regards,
Sergey Pashkov


On Tue, Nov 19, 2013 at 3:29 PM, Fabian Eschrich <info at faesch.de> wrote:

> yes, the results are right when I try with my own query. I will send you
> report and database
>
>   Sergey Pashkov <sergey_pashkov at valentina-db.com>
>  19. November 2013 14:18
> Can't reproduce yet.
>
> "E5076", "E5077", "E5078", "E5075" - do you get a list of these values for
> the same "type" value?
>
> What will you get, if you execute the following queries in SQL Editor,
> with your object names, of course?
>
> 1) SELECT * FROM "t1" ORDER BY "type", "number"
> 2) SELECT * FROM ( SELECT * FROM "t1" ) ORDER BY "type", "number"
>
> Are these results right?
>
> VReports always print data in the same order, as it was returned by the DB.
>
> Best regards,
> Sergey Pashkov
>
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>   Fabian Eschrich <info at faesch.de>
>  19. November 2013 13:33
>  Hi Sergey,
>
> the numbers are not sorted at all. In the result I see "E5076" "E5077",
> "E5078" and then "E5075"
>
> I use VStudio 5.4.3 with remote valentina server.
> The fields are Varchar.
>
> Best regards
>
> Fabian
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>   Sergey Pashkov <sergey_pashkov at valentina-db.com>
>  19. November 2013 12:12
> Hi, Fabian
>
> You have chosen sorting "Ascending" for the "number" field in the Report
> Editor dialog.
> But all of the numbers are sorted descending.
>
> Right?
>
> If yes, then I'll ask you to send your compressed project to
> sergey_pashkov at valentina-db.com?
>
> What version do you use? 5.4.3?
> Datasource - local Valentina DB?
> And what are the field types for the "type" and for the "number"?
>
> Thank you.
>
> Best regards,
> Sergey Pashkov
>
>
>
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
> --
> Mit freundlichen Grüßen / best regards,
> Fabian Eschrich
> FAESCH Software
> info at faesch.de
>
> Fon:     +49 (0)371 334246-10
> Fax:     +49 (0)371 334246-11
> Skype:   feschrich
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131120/40c4b06b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: compose-unknown-contact.jpg
Type: image/jpeg
Size: 770 bytes
Desc: not available
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131120/40c4b06b/attachment.jpg>