Printing records

Issues related to label design (working with databases, data processing, RFID encoding etc.) and printing (from NiceLabel Express, NiceLabel Pro, NiceForm and NicePrint)

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
teo.jurado
Enthusiast
Posts: 16
Joined: Mon Oct 07, 2013 12:49 pm

Printing records

Post by teo.jurado » Thu Nov 14, 2019 12:59 pm

Hi:

How to change column order (position) from any printing label...
Now i can change this order, but i can't save and can't have idea how to change in powerform..
or how is ordered from any database or excel page?

User avatar
Mytch
NiceLabel Support
NiceLabel Support
Posts: 158
Joined: Fri Jul 13, 2018 10:26 pm
Location: Milwaukee, Wisconsin
Contact:

Re: Printing records

Post by Mytch » Mon Nov 18, 2019 5:50 pm

teo.jurado,

Are you referring to column order at print time?:
screenshot_09.jpg
screenshot_09.jpg (69.78 KiB) Viewed 2587 times
This is done automatically when database is connected to with Database Wizard. If you would really like to change the order, you can edit the SQL query:
screenshot_18.jpg
screenshot_18.jpg (59.39 KiB) Viewed 2587 times
The database I show was originally having ProductID first, but I moved it to be selected last, and now column reflects as such.

Regards,
Mytch

teo.jurado
Enthusiast
Posts: 16
Joined: Mon Oct 07, 2013 12:49 pm

Re: Printing records

Post by teo.jurado » Mon Nov 18, 2019 5:57 pm

Simple, so simple I did not think about it! .. :oops:

Thanks....

User avatar
Mytch
NiceLabel Support
NiceLabel Support
Posts: 158
Joined: Fri Jul 13, 2018 10:26 pm
Location: Milwaukee, Wisconsin
Contact:

Re: Printing records

Post by Mytch » Mon Nov 18, 2019 6:52 pm

teo.jurado wrote:
Mon Nov 18, 2019 5:57 pm
Simple, so simple I did not think about it! .. :oops:

Thanks....
No worries :) It is not the most simple thing ever.. and somewhat inconvenient. We should be able to change column order from Database Wizard's field selection, but this does not allow you to manipulate order. This is why we must use custom SQL syntax, which is really used for retrieving content from the database. Maybe a feature request for Suggestion Box:
viewforum.php?f=12

Regards,
Mytch

teo.jurado
Enthusiast
Posts: 16
Joined: Mon Oct 07, 2013 12:49 pm

Re: Printing records

Post by teo.jurado » Mon Nov 18, 2019 6:57 pm

Thanks.. Thanks, I'll create the suggestion.

Post Reply