Post reply

add query field

  • 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

  • November 18, 2014 at 7:14 am

    #1759275

    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

  • November 18, 2014 at 8:25 am

    #1759304

    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

  • November 18, 2014 at 9:48 pm

    #1759450

    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

  • November 21, 2014 at 8:26 am

    #1760172

    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

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

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