Sort inside reports

Fabian Eschrich info at faesch.de
Tue Nov 19 07:29:52 CST 2013


yes, the results are right when I try with my own query. I will send you
report and database

> Sergey Pashkov <mailto: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 <mailto: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 <mailto: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 <mailto: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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131119/9510b023/attachment-0001.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/9510b023/attachment-0001.jpg>


More information about the Valentina mailing list