Print from page part

Mitznaj
Member Posts: 11
Good morning everybody.
Starting from a list of data which represent shelves, i select a shelf and double clicking opens its card page, which is a documen type, that contains all the items placed on that shelf.
This document contains some general data, which are a description of the shelf, and a second area wich is a part(page) with all the rows of the items that are on that specific shelf.
All items contain columns like quantity, description, destination, etc.. but the most important column is "printLabel" which is a boolean type. My goal is to flag or unflag that boolean and use an action button to launch the print of the labels, only for the selected items. I already prepared a report with a request page with all the data i need on the labels.
My question is: i know how to create an action button and launch the report and manually fill it; but i don't know how to launch "X" reports where "X" is the number of selected items("printLabels" flagged) and autofill those reports with the data i need, it would be even better if the users don't see the reports and the labels are automatically printed with the desired data. Keep in mind also that the action has to take data from a part(page) and not directly from the main document page.
Do you have any suggestions please?
Starting from a list of data which represent shelves, i select a shelf and double clicking opens its card page, which is a documen type, that contains all the items placed on that shelf.
This document contains some general data, which are a description of the shelf, and a second area wich is a part(page) with all the rows of the items that are on that specific shelf.
All items contain columns like quantity, description, destination, etc.. but the most important column is "printLabel" which is a boolean type. My goal is to flag or unflag that boolean and use an action button to launch the print of the labels, only for the selected items. I already prepared a report with a request page with all the data i need on the labels.
My question is: i know how to create an action button and launch the report and manually fill it; but i don't know how to launch "X" reports where "X" is the number of selected items("printLabels" flagged) and autofill those reports with the data i need, it would be even better if the users don't see the reports and the labels are automatically printed with the desired data. Keep in mind also that the action has to take data from a part(page) and not directly from the main document page.
Do you have any suggestions please?
0
Answers
-
I've a general idea that do you want to achieve but I don't have so clearly how you're trying to do.
If you've already a field of those that you already want to print using setrange on that filter and then SETTABLEVIEW(Rec) on the report should be enough.
If it's to know which one the user have selected, you should review markedonly or SETSELECTIONFILTER1 -
Thank you for the answer. The problem is that if i understand well SETTABLEVIEW works only on a record and i have to select multiple(all the items where printLabel is True). Am i wrong?
I'll explain my project better, so you understand it:
The shelf and the items are objects from different tables.
I created a page representing the shelf and another page containing the items.
In my project the users should open the list of all the shelves(shelf page), selecting one of those it will open the card/document of that particular shelf and inside of it with all other fields there will be a Page part(page) invoking the list(page) of all the items.
The point is that i'm unable to select any record from the Part(Page), neither i know any function that can help me do so. Is it impossible?
Do you have any suggestion?
0 -
I'm not able to interact with the part page atl all. For example how can i invoke the part(page) and get the first record?
If i have to select the first record of the primary page i just do this:
IF Rec.FINDFIRST THEN
MESSAGE('First record :%1',Rec);
Which is the code for the part(page)?0 -
Settableview can have thousands of records. Where do you have that relationship between shelfs and items? You looks like talking being something unrelated but you must have it. Which is the name of that table?0
-
Hello, they are related by primary key value, that indicates the shelf itselft, all other columns are unrelated. I copied the structure from an already existing table that was used for shipments.
Table1 is the master table, Table2 is the part(page list).
In Table2 i select all the records which have Table1 PK in common.
Taking one step back from printing the labels, i want to interact somehow with the records of Table2(the part) in c/al code, because i'm not able to do it.
Like sorting the records, calling another action(maybe simple report) with these reports etc... Just to be clear: all of this interactions with Table2 have to happen while i'm viewing it inside of Table1.
Do you have any suggestion?0 -
UP0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions