You’re offline. This is a read only version of the page.
15
BC Experts,
I'm attempting to build out a module where we track profitability of "projects", which include multiple purchase orders and sales orders. I am building it similar to how sales headers and sales lines work, with a "Project" Table and a "ProjectLines" table.
The "Project" table has a page of type List, where I can see the project number, salesperson, customer #, etc.. I have the "ProjectNumber" field set with DrillDownPageID property set to my "ProjectCard" Page. However, when I have multiple projects, clicking on any drilldown field will always lead me to the first record of that type!
For example below, clicking the projectnumber "100456" still leads me to the card page for the "100123" project number. Please see below for my project page Code as well as a screenshot.
Share
Reportpage 50102 Projects
{
PageType = List;
ApplicationArea = All;
UsageCategory = Lists;
SourceTable = projecttable;
layout
{
area(Content)
{
repeater(General)
{
field(ProjectNumber1; Rec.ProjectNumber)
{
ApplicationArea = All;
DrillDownPageId = projectcard;
}
} //multiple fields are defined below and removed for clarity
}
}
}
I cannot believe it was so simple; thank you!
Try adding card page id in your list page..
All responses (
Answers (
page 50102 Projects
{
PageType = List;
ApplicationArea = All;
UsageCategory = Lists;
SourceTable = projecttable;
CardPageId = ProjectCard;
layout
{
area(Content)
{
repeater(General)
{
field(ProjectNumber; Rec.ProjectNumber)
{
ApplicationArea = All;
//This is where my DrillDownpageID used to be
} //there are more fields after this not shown here
}
}
}
}
page 50100 ProjectCard
{
Caption = 'Billing Lead Sheet';
PageType = Card;
ApplicationArea = All;
UsageCategory = Documents;
SourceTable = projecttable;
Editable = true;
layout
{
area(Content)
{
group("General Information")
{
field(ProjectNumber; Rec.ProjectNumber)
{
ApplicationArea = All;
} //more fields exist that are not shown
}
}
}
}
Govinda,
Thanks for your response! I have a list page and card page for my "ProjectsTable" Table. They are both utilizing the source table of "ProjectTable". However, if I remove the "DrilldownpageID" from the projectlist page, I cannot click on the Project number to bring me onto the card view.
Here is a snippet of my List Page
page 50102 Projects
{
PageType = List;
ApplicationArea = All;
UsageCategory = Lists;
SourceTable = projecttable;
layout
{
area(Content)
{
repeater(General)
{
field(ProjectNumber; Rec.ProjectNumber)
{
ApplicationArea = All;
//This is where my DrillDownpageID used to be
} //there are more fields after this not shown here
}
}
}
}
And here is my Project Card Page
page 50100 ProjectCard
{
Caption = 'Billing Lead Sheet';
PageType = Card;
ApplicationArea = All;
UsageCategory = Documents;
SourceTable = projecttable;
Editable = true;
layout
{
area(Content)
{
group("General Information")
{
field(ProjectNumber; Rec.ProjectNumber)
{
ApplicationArea = All;
} //more fields exist that are not shown
}
}
}
}
Snippet (I cannot click on "100123" or "100456"):
Please let me know what I'm doing wrong..
Thanks!
I'm sorry for any confusion what do you mean by building it similar to what we have in the sales header and lines? the best practice is to create a list page and a card page for any datasource.. the list page displays a list of records, and when you select a record, it takes you to the corresponding card page in that case, you don't need to add a specific "drill down" property you can simply use the same data source for both the list page and the card page..
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156