Drilldown to another company

julkifli33

Hi All,
I am using BC SaaS.
I have created new page that show total sales for all companies.
let's say I have company A,B,C

so it will be something like
Name Total Sales
Company A $1000
Company B $2000
Company C $4000

then user open company A.
what i am looking for is when user click $2000 (which is for company
then it will show the details from company B
is it possible to do that?

Thanks.

RockWithNAV

You need to write a manual code using CHANGECOMPANY Function and then bring in all Records in some temp table and then you can display it out. Direct Drill down to Company B from Company A you can not do.

yzhums

Hi, hope the following will help.
https://yzhums.com/21252/

Thanks.

yzhums

julkifli33 wrote: »

Hi... i am just thinking.
when i drill down, can we open new tab?

trigger OnDrillDown()
var
Cust: Record Customer;
begin
  Cust.ChangeCompany(Rec.CompanyName);
  Page.Run(Page::"Customer List", Cust);
end;

Hi, try this.
https://yzhums.com/21578/

RockWithNAV

You need to write a manual code using CHANGECOMPANY Function and then bring in all Records in some temp table and then you can display it out. Direct Drill down to Company B from Company A you can not do.

yzhums

Hi, hope the following will help.
https://yzhums.com/21252/

Thanks.

julkifli33

Hi @RockWithNAV thank you so much.

Hi @yzhums thanks a lot for the link

julkifli33

Hi... i am just thinking.
when i drill down, can we open new tab?

trigger OnDrillDown()
var
Cust: Record Customer;
begin
  Cust.ChangeCompany(Rec.CompanyName);
  Page.Run(Page::"Customer List", Cust);
end;

DenSter

julkifli33 wrote: »

Hi... i am just thinking.
when i drill down, can we open new tab?

trigger OnDrillDown()
var
Cust: Record Customer;
begin
  Cust.ChangeCompany(Rec.CompanyName);
  Page.Run(Page::"Customer List", Cust);
end;

That will open the regular customer list page that is filled with customers from the other company, but then when you go to related tables it reads from the current one. You would have to create a new customer list that works on the other company

yzhums

julkifli33 wrote: »

Hi... i am just thinking.
when i drill down, can we open new tab?

trigger OnDrillDown()
var
Cust: Record Customer;
begin
  Cust.ChangeCompany(Rec.CompanyName);
  Page.Run(Page::"Customer List", Cust);
end;

Hi, try this.
https://yzhums.com/21578/

julkifli33

Hi @yzhums
thanks so much !
this is what i am looking for.