Hi everybody!
I'm new in Navision and this forum and hope, you can help me.
I have to print labels filtered by Mailing Groups. But there is only a field "No. of Mailing Groups" in the contact table.
How can i give the user the chance to choose a "Mailing Group" in the request form of the report 5056 ?
Thanks in advance!
0
Comments
Ok so once the report is designer mode You'll see Contact as first dataitem.
On the line below add "Contact Mailing Group" then click the -> button at the bottom this will indent the Contact Mailing Group. Next you are going to click on property button in the menu button.
Change the DataItemLink to Contact No.=FIELD(No.)
Change ReqFilterFields to Mailing Group Code
then click on Contact dataitem and go to property and change
PrintOnlyIfDetail to Yes
then click on View->Section. At the bottom you'll see Contact Mailing Group Body section. Select it and hit f4. which will ask to delete the body section. Select Yes.
That's it. Save the report and run it. On second tab you should be able filter by Mailing list group
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
This is the US version and does not have German Language.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
First i have test the report, it seems to be fine.
But when I see at the printed lables, there are some failures and problems
1. All labes belongs to the selected "Mailing Group", but not the first label. It has no Mailing Group.
2. When I have 5 contacts with the selected Mailing Group, it prints 6 contacts (5 + the first contact - which not belongs to the Mailing Group).
When i have 6 or 7 contacts with the selected Mailing Group, it also prints only 6 labels. By 8 contacts, he prints 9 labels.
I Think this is, because there are 3 labels in a row and we have set the setting "PrintOnlyIfDetail = YES".
3. The selected filter is saved. Now when the user wants to print other labes (not filtered bei Mailing Group) he forgot to delete the filter.
Can I delete the choosen filters by code?
4. If I also want to use for example "Business Relation" and "Industry Group", I must set the Filter to a non existing value, when i only want to print the contacts of a specific "Mailing Group".
Do you have any solution for this?
Thanks very much for your help.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n