Drilldown to another company

julkifli33julkifli33 Member Posts: 1,073
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 B)
then it will show the details from company B
is it possible to do that?

Thanks.

Best Answers

Answers

  • RockWithNAVRockWithNAV Member Posts: 1,139
    Answer ✓
    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.
  • yzhumsyzhums Member Posts: 10
    Answer ✓
    Hi, hope the following will help.
    https://yzhums.com/21252/

    Thanks.
  • julkifli33julkifli33 Member Posts: 1,073
    Hi @RockWithNAV thank you so much.

    Hi @yzhums thanks a lot for the link
  • julkifli33julkifli33 Member Posts: 1,073
    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;
    
  • DenSterDenSter Member Posts: 8,304
    edited 2022-01-19
    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
  • yzhumsyzhums Member Posts: 10
    Answer ✓
    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/
  • julkifli33julkifli33 Member Posts: 1,073
    Hi @yzhums
    thanks so much !
    this is what i am looking for.
Sign In or Register to comment.