How filter several registers in sections
DarkHorse
Member Posts: 389
Hello everybody, I've the following code in a report:
IF
("Gen. Prod. Posting Group"='001') AND
("Entry No."<>56920) AND
("Document Type"="Document Type"::" ")
THEN
BEGIN
CurrReport.SHOWOUTPUT(FALSE);
contador:=contador-1;
END;
But, on Entry No. section I want to put several entry numbers but I can't, I don't know what is the condition; on DataItemTableView I can put for example 56920&<>58756&<>57486 but on report sections i doesn't run. How can I put serveral numbers?.
Many thanks in advance.
IF
("Gen. Prod. Posting Group"='001') AND
("Entry No."<>56920) AND
("Document Type"="Document Type"::" ")
THEN
BEGIN
CurrReport.SHOWOUTPUT(FALSE);
contador:=contador-1;
END;
But, on Entry No. section I want to put several entry numbers but I can't, I don't know what is the condition; on DataItemTableView I can put for example 56920&<>58756&<>57486 but on report sections i doesn't run. How can I put serveral numbers?.
Many thanks in advance.
1
Comments
-
Hello
There are several solutions one of them can be re-arrange your code lines, for example:
IF
("Gen. Prod. Posting Group"='001') AND
("Document Type"="Document Type"::" ")
THEN
BEGIN
if ("Entry No."<>56920) AND
("Entry No."<>56921) AND
("Entry No."<>56922)
then
begin
CurrReport.SHOWOUTPUT(FALSE);
contador:=contador-1;
end
END;
Probably there are more efficient ways but this one popped-up when i looked at your code.
Gerrit0 -
Thank you; I already had prove it, but it miss two (( on the code; like this:
IF
("Gen. Prod. Posting Group"='001') AND
("Document Type"="Document Type"::" ")
THEN
BEGIN
if (("Entry No."<>56920) AND
("Entry No."<>56921) AND
("Entry No."<>56922))
then
begin
CurrReport.SHOWOUTPUT(FALSE);
contador:=contador-1;
end
END;
Thank you very much for your help.0 -
i will suggest to use IN instead of writing so many and
so if sentence will be:
if NOT ("Entry No." IN [56920,56921,56922]) then0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 328 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