Role tailored client reports with 3 tables

billbill Member Posts: 100
edited 2012-05-23 in NAV Three Tier
Hi all, i have a problem concerning role tailored clients reports. I have 3 tables customer customer ledger entry and G/L Entry. I want to group customer ledger entry and gl entry with customer. The gl entry table and cust ledger entry are intended to customer in classic client. I don't have a problem for 2 tables e.g customer and g/l entry, but when i insert the 3rd table i don't know how to group this table in role tailored client.

Any help please?

Comments

  • LambaLamba Member Posts: 260
    I don't think u need to create so many tables, if it's kind of compulsary then try either step:
    1. Create 3rd table with grping customer no. and CLE.Entry no.
    2. Then utilize the list having the grouping of customer.no., and insert 3 of the tables in that list and then check the
    result.
  • billbill Member Posts: 100
    Thank you very much, it worked!!!!

    now i have another issue. When i preview my report. The properties of save (export to excel, pdf e.t.c) are disable!!!!!! Any idea?
  • billbill Member Posts: 100
    No, in my case i need to export the data e.g in excel, but the save button is disabled. I want to enable it.
  • LambaLamba Member Posts: 260
    Which Client you are using?
    Refer the below link
    viewtopic.php?f=23&t=52436
  • billbill Member Posts: 100
    Microsoft Dynamics Nav 2009 R2. I can export other reports to excel, but there is a report that i can't exported to excel. The buttons are disabled.
Sign In or Register to comment.