Sort inside reports

Sergey Pashkov sergey_pashkov at valentina-db.com
Tue Nov 19 07:18:27 CST 2013


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


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

> 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
>
>   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/20131119/ab5c2c87/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/20131119/ab5c2c87/attachment.jpg>


More information about the Valentina mailing list