NAV 2013 R2 and Report Builder Query.

postsaurav

Hi all,

Hope you are doing well.

I had a query that I would like to discuss with you all.

With Release of NAV 2013 R2, Navision Reports can be developed/modified in Report Builder. (If I am not Wrong)

But when I open a standard Report Layout in Report Builder I see A Blank DataSource and DataSetFields as per the Report.

I am stuck at these points -

1. How Microsoft is generating the Layout Without Dataset?

2. Where is the query that is being fired to SQL to get these dataset Fields?

Waiting for your Response.

mohana_cse06

I can see Dataset fields in report builder..
how did you open Report Builder?

postsaurav

Hi Mohana,

With NAV 2013 R2 you have an option to choose either to use Visual Studio for Report Development or Report Builder.

By Default it is set to Visual Studio.

You can change the same from Tools -- Options.

Set YES for property - "Use Report Builder" and open the layout.

Miklos_Hollender

Are you you are using SQL 2012 and Report Builder V3 that came with it?

mohana_cse06

I know saurav

I opened it and I can see dataset fields under dataset_results

postsaurav

Hi Mohana,

Sorry i missed the first line.. ](*,)

Yeah i can also see the dataset fields.

But what i am looking for is - There will be a query that have been fired to SQL to get these dataset fields from SQL. (Normally i have one when i create a report in SSRS).

Where is that query and what is the dataset connection?