Named Queries in Reports Video at Inductive University

Transcript

(open in window)

[00:00] In this lesson, I'll show you how to use a named query as a report data source. I'll start in the Data tab of my report and when I create a new data source, I can choose Named Query. In order to use a named query, I'll need to select one from the Path field here. I'll click the magnifying glass icon and choose my named query. You can see that automatically brings in the query in any parameters since this is a named query, I can't modify the query from the report section. I'd have to go into the named queries area within the project browser. However, since I set up my named query with a parameter, I can pass different values to it for my report. If I select the named query parameter and click the magnifying glass icon, I can also select one of my report parameters to pass. I'll select my site parameter. Moving over to the right side of the screen, I can specify the data key for this data source in like most other data sources named queries can be used as part of a nested query system.

[01:07] If I head over to the Preview tab, my report has data from my named query. As you can see it's very easy to use a named query in your report and pass parameters to it.

In this lesson, I'll show you how to use a named query as  a report data source. I'll start in the Data tab of my report and when I create a new  data source, I can choose Named Query. In order to use a named query, I'll need to select one from  the Path field here. I'll click the magnifying glass icon and choose my named query. You can see that automatically brings in the query in any parameters since  this is a named query, I can't modify the query  from the report section. I'd have to go into the named queries area  within the project browser. However, since I set up my named query with a parameter,  I can pass different values to it for my report. If I select the named query parameter and click the magnifying  glass icon, I can also select one of my report parameters to pass.   I'll select my site parameter. Moving over to the right side of the screen, I can specify the  data key for this data source in like most other data  sources named queries can be used as part of a nested  query system.

[01:07]          If I head over to the Preview tab, my report has data from my named query. As you can see it's very easy to use a named query in your  report and pass parameters to it.

We are experiencing playback issues from our video hosting provider. Please check back shortly.

LESSON LIST

Take topic challenge