SSRS - What does SemanticQuery mean??

Here's the situation:

You open up a stock Dynamics GP SSRS report and you examine the data source. Your objective is to learn how Dynamics GP does things, or maybe to 'soup it up' a little by adding a field or something like that.

When you examine the spot in the data source where the query or stored procedure normally is, you see this:

What on earth is a SemanticQuery??

 

 

It has to do with Report Models. There is an underlying object in SSRS called a Report Model. If you go to the home page in SSRS you'll see a folder for Report Models:

 

If your goal was to somehow edit the query... that's going to be tough. But there are things you can do

In the Data Set Properties window, click on Query Designer

 

 

 Here you can add fields by double clicking on them in the Fields area.

In the Data Set Properties window, you can still add parameters, filters, etc.

To get a better understanding of how this all works, follow this tutorial.

 

 

 

 

 


RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences