Source language: Translate to:

sort with report designer

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

sort with report designer

Postby Pilou » Thu Aug 25, 2011 1:26 am

Hello

How to sort with report designer

example

Catégorie.Fruits
or
catégorie.Legumes

Thank you for your answers

pilou
User avatar
Pilou
 
Posts: 545
Joined: Sun Oct 16, 2005 4:17 pm

Postby Pilou » Thu Aug 25, 2011 2:11 am

Hello

I think I found

dbpSort "AddrBook" "Contacts" "State = ASC"
User avatar
Pilou
 
Posts: 545
Joined: Sun Oct 16, 2005 4:17 pm

Postby Pilou » Thu Aug 25, 2011 8:47 am

Hello

I still need your help!

I managed to sort groups with this command

dbpSort "AddrBook" "Contacts" "State = ASC"

But how to sort by categories have only

page = 1 fruit
2 pages = vegetables
page = 3 canned
etc ...

Thank you for your help

pilou
User avatar
Pilou
 
Posts: 545
Joined: Sun Oct 16, 2005 4:17 pm

Postby Neosoft Support » Thu Aug 25, 2011 10:55 am

In addition to sorting the data, you need to use the "Group Header" partition in your report to separate records into specific groups.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Postby Pilou » Thu Aug 25, 2011 10:59 am

Thank you for your answers

I need to do to sort like this?
dbpSort "management2" "management2" "DIVERS3 = ASC"
dbpPreviewReport "management2" "[PubDir] liste.dbr" "= DisplayMode FitPage"

So I can sort the groups but not individually!
User avatar
Pilou
 
Posts: 545
Joined: Sun Oct 16, 2005 4:17 pm

Postby Pilou » Thu Aug 25, 2011 12:23 pm

Here is my problem with pictures

PICTURE1

Image

PICTURE2

Image

Image 1 dbr my report designer with "Group Header" in DIVERS3 I

CM2
CM1
CE2
CE1
CP
GS
MS
PS
image 2 the sorting is done

I want the same thing but for individual pages CM2 CM1 PAGE THEN CAN PAGE CE1 etc. ....

thank you
User avatar
Pilou
 
Posts: 545
Joined: Sun Oct 16, 2005 4:17 pm

Postby Neosoft Support » Fri Aug 26, 2011 10:57 am

The dbpSort action allows you to sort on more than one field if you need to sort within the group.

If you want page breaks after each group, add a "Group Footer" partition to your report.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Postby Pilou » Fri Aug 26, 2011 11:24 am

Merci

If you want page breaks After EACH group, add a "Group Footer" partition to your report.

At what level to put it?

merci
User avatar
Pilou
 
Posts: 545
Joined: Sun Oct 16, 2005 4:17 pm

Postby Pilou » Fri Aug 26, 2011 1:49 pm

Thank you thank you Neosoft Support

Ok I found this and thanks to you I'll make an example of images to
NéoFRbooK.

thank you again

pilou
User avatar
Pilou
 
Posts: 545
Joined: Sun Oct 16, 2005 4:17 pm

Postby shariya » Wed Sep 07, 2011 3:30 pm

Hello, I have a similar problem!

my table (only one field):

FIELD 1

in the FIELD 1 there are this items in this order:

Product 1
Product 2
Product 3
Product 61
Product 5

after "sort asc":

Product 1
Product 2
Product 3
Product 5
Product 61

well...on report (report designer) the order of products is:

Product 1
Product 2
Product 3
Product 61
Product 5

And not:

Product 1
Product 2
Product 3
Product 5
Product 61

why??? :(

Thanks in advance
shariya
 
Posts: 6
Joined: Fri Nov 16, 2007 4:22 am

Postby Pilou » Wed Sep 07, 2011 3:39 pm

Hecho

Voir picture !

group Footer

Image
User avatar
Pilou
 
Posts: 545
Joined: Sun Oct 16, 2005 4:17 pm


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest