Alpha DevCon 2018
Results 1 to 13 of 13

Thread: report gurus... i need your help

  1. #1
    Member
    Real Name
    Francis Dizon
    Join Date
    Jan 2006
    Location
    Philippines
    Posts
    404

    Default report gurus... i need your help

    hi to all

    i am trying to print an ID on single report with two pages with different design/layout.

    page 1 has a picture background embedded on the report plus data of the employee and his/her picture
    page 2 has other information with frames
    we will be using evolis dualis 3 ID printer

    thanks in advance

    Francis
    Francis

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,995

    Default Re: report gurus... i need your help

    You failed to mention in what manner you are experiencing problems.
    There can be only one.

  3. #3
    Member
    Real Name
    Francis Dizon
    Join Date
    Jan 2006
    Location
    Philippines
    Posts
    404

    Default Re: report gurus... i need your help

    Stan,

    what i know in creating a report, you create only one pattern or format for every page.
    how to create a report with first page would be like your drivers license front side
    and the second page would be the back of your drivers license in one report only?

    thanks
    Francis

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,995

    Default Re: report gurus... i need your help

    The report should have a detail section only.

    Place a conditional object on the report. Set up two expressions controlling the conditional object.

    mod(SYSTEM->PageNumber,2) = 1
    Label: Odd numbered pages
    mod(SYSTEM->PageNumber,2) = 0
    Label: Even numbered pages

    Now place objects on the appropriate "pane" of the conditional object. You will probably have to place a bitmap or other graphic on the odd page pane instead of embedding the graphic in the report background.

    To get part of the data on one page and the rest on the next you will need either a page break object at the bottom of the odd page pane or two records for each id. The two records approach could be accomplished by appending twice to a temporary table.
    Last edited by Stan Mathews; 12-22-2016 at 10:20 AM.
    There can be only one.

  5. #5
    Member
    Real Name
    Francis Dizon
    Join Date
    Jan 2006
    Location
    Philippines
    Posts
    404

    Default Re: report gurus... i need your help

    Stan,

    Thanks!
    One more question... is it possible to print border less on an ID size printing media?

    thanks again
    Francis

  6. #6
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,995

    Default Re: report gurus... i need your help

    I would think that would depend on your printer/driver. Alpha doesn't add a border or have any restrictions. Alpha uses the capabilities of your printer as communicated by the print driver.
    There can be only one.

  7. #7
    "Certified" Alphaholic Tom Henkel's Avatar
    Real Name
    Tom Henkel
    Join Date
    May 2002
    Location
    New Jersey, USA
    Posts
    1,840

    Default Re: report gurus... i need your help

    Francis,
    Does your card printer print BOTH sides at once?

    We print ID cards with basic employee info and a photo on one side, then on the other side, we print employee specific barcodes, and some other disclaimer info.

    We need to fee the card twice, once for each side, so I created 2 reports, One for side one, then pause the routine until the card is flipped and put back into the printer, then print the side 2 report.

    This is a snippet of the badge print code.
    We have lots of global variables and other things going on, but the core of what we're doing is in here.

    Hope it helps.
    Code:
    filter = "Emp_id = [varN->parameter1]"
    query.filter = replace_parameters(filter,local_variables())
    query.order = ""
    
    ui_msg_box(Agency+" Employee Badge","Please put a BLANK Employee card into the printer"+chr(13)+chr(13)+"With the BLACK Stripe DOWN, facing LEFT in the printer..")
    delete repname
    DIM repname as C = "ID CARD - FRONT@"+ppath+chr(92)+"employee.ddd"
    :Report.print(repname,query.filter,query.order)
    
    ui_msg_box(Agency+" Employee Badge","Please put the Employee card back into the printer"+chr(13)+chr(13)+"With the BLACK Stripe DOWN, facing RIGHT in the printer..")
    
    filter = "Emp_id = [varN->parameter1]"
    query.filter = replace_parameters(filter,local_variables())
    query.order = ""
    repname = "ID CARD - BACK@"+ppath+chr(92)+"employee.ddd"
    :Report.print(repname,query.filter,query.order)
    
    'delete options
    delete oldOptions
    delete ans
    delete badgeno
    delete repname
    end
    Tom

  8. #8
    Member
    Real Name
    Jo Hulsen
    Join Date
    Mar 2006
    Location
    The Netherlands
    Posts
    330

    Default Re: report gurus... i need your help

    Francis,
    I have a report with two pages per record.
    I created a report without report, page or continuation headers/footers.
    Next I created a group with a group header.
    I don't use the detail section and put all the information in the group header. At the end of the first page a page break is inserted and the second page has different content.
    In fact I also have a report with three pages. The first 2 pages are like I explained, the third page is inserted into the group footer.
    Jo Hulsen
    Dommel Valley Solutions
    The Netherlands

  9. #9
    "Certified" Alphaholic MoGrace's Avatar
    Real Name
    Robin
    Join Date
    Mar 2006
    Location
    Los Angeles
    Posts
    3,397

    Default Re: report gurus... i need your help

    For Guru Jo,
    What the heck are you printing? Almost sounds like a check..
    Robin

    Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

  10. #10
    Member
    Real Name
    Jo Hulsen
    Join Date
    Mar 2006
    Location
    The Netherlands
    Posts
    330

    Default Re: report gurus... i need your help

    Hi Guru Robin,
    It is a questionnaire, starting with company logo of the client, then followed by variable information about the course such as type of course, date, place and trainer/instructor.
    Next is the questionnaire itself that doesn't entirely fit on the first page. The last part follows on page two, after a page break. That page has a different type of logo and the remaining questions. Another form was required for the trainer/instructor to submit remarks and ask questions about the course. I could have designed a separate report for that, but decided to place that in the group footer. That page has an entirely different design to the first two pages. The only thing in common with the first two pages is the variable info about the course.
    Jo Hulsen
    Dommel Valley Solutions
    The Netherlands

  11. #11
    "Certified" Alphaholic MoGrace's Avatar
    Real Name
    Robin
    Join Date
    Mar 2006
    Location
    Los Angeles
    Posts
    3,397

    Default Re: report gurus... i need your help

    Sounds interesting Jo - and very clever.
    Robin

    Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

  12. #12
    Member
    Real Name
    Francis Dizon
    Join Date
    Jan 2006
    Location
    Philippines
    Posts
    404

    Default Re: report gurus... i need your help

    hi all,

    thanks all for your solutions.
    I have come up with this report but haven't tested it yet on the ID printer.
    the printer prints front and back with single feed.
    it will flip the card after printing the front side.
    the printer brand and model is Evolis Dualys.

    thanks
    will update you all after printing the first ID

    Francis
    Attached Images Attached Images
    Last edited by fddizon; 01-31-2017 at 06:40 AM.
    Francis

  13. #13
    Member
    Real Name
    Francis Dizon
    Join Date
    Jan 2006
    Location
    Philippines
    Posts
    404

    Default Re: report gurus... i need your help

    hi to all

    sorry for the late update
    i have resorted to different approach
    since the the client changes its background from year to year, and i dont wanna end up changing background everytime,
    i have come up to saving the needed records to excel file
    Evolis printer is bundled with a software called e-media
    this is where the create designs on the id
    we just link the information they need from the exported records in excel

    thanks
    Francis

Similar Threads

  1. Any PHP gurus out there?
    By frankbicknell in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 01-05-2011, 07:29 AM
  2. Any Alpha5 Web CSS gurus out there?
    By envisionsolutions in forum Application Server Version 10 - Web/Browser Applications
    Replies: 4
    Last Post: 11-05-2010, 04:47 PM
  3. Any SQL Gurus?
    By Ted Giles in forum Alpha Five Version 9 - Desktop Applications
    Replies: 13
    Last Post: 12-11-2008, 07:06 AM
  4. Many many SQL gurus help
    By jpellard in forum Web Application Server v7
    Replies: 0
    Last Post: 02-22-2007, 04:09 PM
  5. Need an opinion from the Xdialog Gurus
    By Mario Prieto in forum Alpha Five Version 5
    Replies: 2
    Last Post: 09-01-2003, 07:39 AM

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
  •