1

Printing?

Seems so hard to get a print layout. Is there a way to create a form that can be used to print? I see either a list print view, or a one page per record print view.

13 replies

null
    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    In the form print preview you can drag a view element onto the form that will allow you to print a list containing multiple records. You can also create multiple print previews by adding tabs at the top of the print preview screen.

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Can you explain this a bit more please? "In the form print preview you can drag a view element onto the form that will allow you to print a list containing multiple records." What is the form print preview, and where do I get an element to drag onto it? Is there a video showing this?

     

    I do see the tabs now, and I will work on that method. Is there a way there to print more than one record per page with a tab layout?

    • Sean
    • 4 yrs ago
    • Reported - view

    https://www.youtube.com/watch?v=_FA5-uMV8u8

     

    It will take about hour and twenty minutes out of your day.

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    See free Nioxus video "Creating Reports in Ninox and Printing Embedded Views":

     

    https://www.youtube.com/watch?v=_FA5-uMV8u8

    It is long, but it will open a whole new world.

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Sean, we both submitted the exact same link at the same time. :-)

    • Sean
    • 4 yrs ago
    • Reported - view

    Dean, I thought you might post the link. I guess I should have been more patient  ;-)

    • Mr_K
    • 4 yrs ago
    • Reported - view

    Thanks. I will watch. Andy does like to make LONG videos!

    • Mr_K
    • 4 yrs ago
    • Reported - view

    I watched Andy's video. Extremely helpful. Did need to take a few breaks, and a nap! Anyway, thanks Andy and thanks here for the link.

     

    Question: Andy shows creating code to print the current record and save it to his desktop. I created a button with the code. It works, but mine printout opens directly in my PDF app. How do I make it save to the desktop?

    • Sean
    • 4 yrs ago
    • Reported - view

    I haven't watched the whole video, but I did find a point in the video where he saves to the desktop. What pops up when he clicks on the button is his PDF app. It has a folder list on the left side and prompts him to save the file. My PDF app (PDF Expert) does the same thing yours does so I think it has more to do with the default PDF app.

    • Mr_K
    • 4 yrs ago
    • Reported - view

    I own PDF Expert too. I wonder what the difference is? I'm not sure I would change it since more often than not I want to preview the results, then I can save them if they look good.

    • Sean_Wood
    • 2 yrs ago
    • Reported - view

    Hope someone catches this thread. I have watched the Nioxus tuorial about printing embeded views. Having adapted the code to my tables it works perfectly.
    I want to add a feature where the line items are pre-selected according to a month field using select ...where Month= xMonthChoice I've added this field as choice field in the original table just like it is in the line items table using the same words and order of the month choice. Here is the code I did. When I choose January or February , it works fine, but all other choices give a blank report! any ideas?  My fields are in french btw.

    let i := null;
let xCurrRec := Id;
let xAnnee := 'Année';
let xCodeSaison := 'Code année';
let xChoixMois := 'Choix pour impression';
let i := (create 'Année Impression Mois');
i.('Année' := xAnnee);
i.('Choix du mois' := xChoixMois);
for j in select 'Décompte mensuel' where xChoixMois = Mois do
    let k := (create 'Décompte mens Imprimer');
    k.(Mois := j.Mois);
    k.('Année' := j.'Année');
    k.(Nom := j.Nom);
    k.('Nom si invité' := j.'Nom si invité');
    k.('H.Supp.' := j.'H.Supp.');
    k.('H.Rempl.' := j.'H.Rempl.');
    k.('H.Mission Mensuel' := j.'H.Mission Mensuel');
    k.('Année Impression Mois' := i)
end;
printRecord(record('Année Impression Mois',number(i)), "Impression Mois");
delete (select 'Année Impression Mois')

     

      • Sean_Wood
      • 2 yrs ago
      • Reported - view

      AlexisO I think I just found the solution. As I was comparing choice fields I think the function was copying over only the ID of the choice and then comparing a text with an id.
      I changed it to text(Choicefield) instead of just the field and it now works, it lists only the month of choice to print.

    • spinner_7580
    • 1 yr ago
    • Reported - view

    Hoping someone sees this and responds...

     

    I am experiencing odd behavior with the above code example ref above.  Like others I have watched and re-watch the Nioxus video 600.08 many, many times.  I have used the code format above - but with my fieldnames etc.

    The odd behavior:  the very last line of code in the 600.08 video is shown below and highlighted.

    Notice the double quotes surrounding the line.  Didn't seen right to me... notice  code above where the last line is not in double quotes - which seems correct.

    If I surround the my printRecord line with double quotes my report is generated with expected data BUT when looking at the helper print table the data remains - the table is not deleted.

    So, when I run another report, I end up with incorrect results reported because the records from the previous "run" are still in the table - not deleted.

    If I remove the double quotes so:

    delete (select 'My Print table') as in  example above the report is blank - no records.  Inspecting the helper print table shows no records.  It's as if copying the data to the print table didn't happen "in time" as if the delete command happened before the copy could complete.

    I can "double-clutch" by using a separate button that just has the the delete command but I don't want to depend on my users to "remember" to click the delete button before the run a report...

    Hmmm, maybe that's the solution.... I tried putting the delete command at beginning and that works.  However, of course, that means that the print helper table will always have data in it when not "in use".

    Surprised this hasn't come up before.....

    Really scratching my head on this and would appreciate some help.

    I'm using Mac app ver. 3.8.11

Login to reply

Content aside

  • 1 Likes
  • 1 yr agoLast active
  • 13Replies
  • 2079Views
  • 2 Following