>> Hello and welcome.
My name is Soren Klemmensen,
and in then this how do I video,
we're going to create a report in
an extension for Dynamics
365 Business Central.
We're going to do this
in the following steps.
Step one: create
the report itself.
Step two: we're going to
make the report sociable in
the rotunda and in step
three: we're going to create
the report layout
ready for design.
Let's get started.
First, we will create
a file to hold our report.
Then we will use the report
Snippet to create
the framework for report.
We'll call it 50100.
We'll call it BookList.
We'll change the
source table to book.
Then we'll go on to
the columns and we'll
design the data structure
by filling out the number,
fill in the first column and name
it and then we'll define
the second column.
That one will be
the title. So that's it.
Now we'll remove, in this case,
we'll remove the request page
and the actions, we
don't need them.
You could leave them
there they would
be problems doing that.
Then we'll go up and we'll
have a caption the report
itself and then we'll
have to set some other
properties here.
One being the default layout.
This page will make it word.
We'll also set the word layout
pointer that to a file.
Notice that this file
does not exist at
this point and we'll
also set the IDLC layout pointer
to another file.
Both these files do
not exist right now.
Then we will set
the usage category.
This means the report
will now be searchable
in the rotunda without
being on the rotunda,
and we'll set the application
area to all sorts
available in all no matter
how you run the application.
Now, as soon as we
build the application,
you'll see the two files
layouts that we defined to
the application gets generated
and added to the application.
The generated report layout has
the curated data structure
as defined in the code.
You can now modify
a report layout with
your favorite tool such as
Microsoft SQL Server
Report Builder
or Microsoft Word to
finish your report.
Let's summarize what we did.
First, we created a report.
Then we made the
report searchable in
rotunda and we ended
recreating layouts ready
for you to design.
If you want to know more
about how to create
apps for Dynamics 365
Business Central,
you can go to
aka.ms/BusinessCentralApps
for more information.
I hope you enjoyed the video and
I hope to see you
back another time.
