add query field

Question

add query field

super48

SSCrazy

Points: 2682
More actions
November 18, 2014 at 7:05 am

#301303

while adding the Data sets ,
In field Option we get add query field and calculated filed.
I figured out how to add calculated field but
how to right in query in query field I tried writing query value field
But Result Is empty .
Please Explain how to write like syntax or screen shots or helpful.
I am using 2008r2 version.
Thanks and Regards
Sudarshan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

g.britton SSChampion Points: 13863 More actions · Answer 1

super48 (11/18/2014)
while adding the Data sets ,
In field Option we get add query field and calculated filed.
I figured out how to add calculated field but
how to right in query in query field I tried writing query value field
But Result Is empty .
Please Explain how to write like syntax or screen shots or helpful.
I am using 2008r2 version.
Thanks and Regards
Sudarshan

I'm having some difficulty understanding your question. When you say. "while adding the Data sets" do you mean that you are working in SQL Server Report Services (SSRS)?

Gerald Britton, Pluralsight courses

Ed Wagner SSC Guru Points: 287024 More actions · Answer 2

In SQL, a calculation can be performed as an expression in the column list of the SELECT statement. I'm not sure of what your question is either. Could you provide the DDL for the tables you're working with and explain what you're trying to calculate?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

super48 SSCrazy Points: 2682 More actions · Answer 3

yep sorry i mentioned everything except ssrs yeah its in ssrs.

in ssrs when you add dataset and right click and select fields option and click add there are two option you will get.

one is calculated field and another is query field.

Whats that query field?how to use it?

Regards

Sud

g.britton SSChampion Points: 13863 More actions · Answer 4

super48 (11/18/2014)
yep sorry i mentioned everything except ssrs yeah its in ssrs.
in ssrs when you add dataset and right click and select fields option and click add there are two option you will get.
one is calculated field and another is query field.
Whats that query field?how to use it?
Regards
Sud

Query field refers to a column that is returned by the query for the data set. If you add columns to your query, you will probably want to add them to the field list also. You can also use this to alias a column name so it is available under two field names.

Gerald Britton, Pluralsight courses