Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Error when publish the report - You do not have the following permissions on report reportname

Posted on by 295

I created a very simple report in Customer list but when I published and opened it, system show error : You do not have the following permissions on Report Customer Report List: Execute.

pastedimage1675584797801v1.png

My code:

report 50145 "Customer Report List"
{

    DefaultLayout = RDLC;
    RDLCLayout = 'customerlistreport.rdl';
    dataset
    {
        dataitem(Customer; Customer)
        {
            column(No_; "No.")
            {

            }
            column(Name; Name)
            { }
            column(Balance__LCY_; "Balance (LCY)")
            {

            }

        }

    }

}
pageextension 50145 "Customer List Report" extends "Customer List"
{
    actions
    {
        addbefore(Reports)
        {
            action(CustomerReport)
            {
                ApplicationArea = all;
                trigger OnAction()
                begin
                    mycustomerreport.Run();
                end;

            }
        }

    }
    var
        mycustomerreport: report "Customer Report List";
}
app.json sets the default ID Range:
  "idRanges": [
    {
      "from": 50100,
      "to": 50149
    }
  ],
Does it cause from the license ?
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Error when publish the report - You do not have the following permissions on report reportname

    Thanks for the update.

  • Hoang Ng Profile Picture
    Hoang Ng 295 on at
    RE: Error when publish the report - You do not have the following permissions on report reportname

    I did not use Dev license.

    After checking my license, the ID Range is allowed as below:

    Start from 50000

    Reports,Queries,Pages,XML Ports: up to 50099

    Codeunits: up to 50019

    Tables: up to 50009

    I could run the report successfully after correct the ID to 50001

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,565 Super User 2024 Season 2 on at
    RE: Error when publish the report - You do not have the following permissions on report reportname

    Hi, did you use a development license?
    As far as I know, development in SaaS does not require a development license, but the On-Premises version still needs it.
    Your error message looks like you're using a Cronus license, which doesn't have an ID range of 50145.

    Hope this helps.

    Thanks.

    ZHU

  • Hoang Ng Profile Picture
    Hoang Ng 295 on at
    RE: Error when publish the report - You do not have the following permissions on report reportname

    I uninstalled, unpublished  then published again but the error is still there.

    Could you please tell me how to check the license allow me to build the new report or not ?

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Error when publish the report - You do not have the following permissions on report reportname

    Try publishing it, otherwise you need to check your license.

    Thanks

  • Hoang Ng Profile Picture
    Hoang Ng 295 on at
    RE: Error when publish the report - You do not have the following permissions on report reportname

    Thanks Nitin

    I have just done the command as your advice but it still showed same error

    pastedimage1675611474765v1.png

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Error when publish the report - You do not have the following permissions on report reportname

    Hi,

    Try generating permission in your AL code with below command.

    pastedimage1675611114805v1.png

  • Hoang Ng Profile Picture
    Hoang Ng 295 on at
    RE: Error when publish the report - You do not have the following permissions on report reportname

    I am using On promise

    Yes, I am assigned Super user.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Error when publish the report - You do not have the following permissions on report reportname

    If you are in BC online you can rule out the license.

    Are you defined as a super user?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans