Results 1 to 6 of 6

Thread: report label

  1. #1
    Junior Member
    Join Date
    Jan 2014
    Location
    Netherlands, Middelburg
    Posts
    14

    report label

    If i'm correct lianja is only capable of designing tabular reports.

    in my program a need a way to print labels like:

    --------------------------------------------------
    Name
    Address
    Zip_code City
    --------------------------------------------------

    any ideas?

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,662
    Hi Leon,

    Create a Lianja Server Page (.rsp) with your layout. Design the body in the HTML editor or code it.
    Create a Webview object and set its URL to the .rsp file, passing any required parameters.
    Call the Webview.print() method.

    e.g.

    Name:  label.jpg
Views: 120
Size:  77.8 KB

  3. #3
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,225
    Hi león,

    This has been a common Enhancement Request (ER) is so I have added this Into Lianja 5.6

    Code:
    close database
    open database southwind
    drop table label_example if exists
    create table label_example (width int, height int, margin int, lines int, spaces int, across int, ;
                                remark char(60), line1 char(50),line2 char(50),line3 char(50),line4 char(50),;
                                line5 char(50),line6 char(50),line7 char(50),line8 char(50),line9 char(50),;
                                line10 char(50),line11 char(50),line12 char(50),line13 char(50),line14 char(50),;
                                line15 char(50),line16 char(50))
    insert into label_example (width, height, margin, lines, spaces, across, remark, line1, line2, line3, line4, line5, line6) ;
                               values(30, 6, 2, 1, 10, 4, "Example label format", "contactname", "companyname", "address", "city", "postalcode", "country")
    close label_example
    create label example from label_example
    use customers
    label form example // to file output.txt
    close database 
    // the print that output.txt file
    See below.

    Name:  Screen Shot 2020-12-16 at 10.58.26 AM.jpg
Views: 118
Size:  90.0 KB

    Full syntax of the LABEL command is:

    Code:
    LABEL FORM <.lbl file>                 
           [<scope>]                     
         [TO TERMINAL]                     
         [TO PRINT]                     
         [TO FILE <.txt file>]                 
         [FOR <expL>]                        
         [WHILE <expL>]                        
         [SAMPLE]                     
         [SEPARATE]                    
         [FRAME]                    
         [WIDTH <expN>                    
    It also works with Virtual Tables, SET KEY, SET FILTER and SQL SELECT INTO CURSOR
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  4. #4
    Member
    Join Date
    Feb 2012
    Location
    Earth.Europe.Germany.Bavaria.Obing
    Posts
    43
    That's what I like sooo much with Lianja and the Team: Quick responses and extensions, based on our user needs!
    This really reminds me of the "good ol' days" when the Fox-Team at Microsoft was in close contact with the users at FoxForum.

    Perfect!
    wOOdy

  5. #5
    Junior Member
    Join Date
    Jan 2014
    Location
    Netherlands, Middelburg
    Posts
    14
    Hi Barry, Yvonne,

    thank you, this helps a lot and I look forward to the release of lianja 5.6

  6. #6
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,068
    Hi w00dy,

    Indeed. I think you were then when Tom Rettig described the need for a READ EVENTS, Susan brought it to Dr. Dave the afternoon of the same day she read it, and the MOAR was released the next morning. The Mother of All Reads. That was pre-MS days.

    Hank

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us