Post reply

why us report services ''expressions''?? isn''t there a way to use just TSQL as usual?

  • August 3, 2006 at 11:11 am

    #172047

    is there a way i can use tsql instead of expressions?

    from design view; i have a text box that i dragged onto my report,

    and then under the properties -> expression area i typed in the following:

    select serverproperty ('machinename')

    since the data source is already setup shouldn't this work? i'm getting

    errors cause it's not a "Valid" expression. if i can't use tsql how do

    i affectively convert the tsql to a proper expression?

    thoughts?

    _________________________

  • August 3, 2006 at 1:03 pm

    #653186

    Reporting Services only recognizes VB.NET expressions within the report designer.  TSQL commands are valid only within the query.

  • August 3, 2006 at 2:44 pm

    #653213

    ok.. well now i know.

    thanks for the post

    _________________________

  • August 4, 2006 at 12:11 pm

    #653417

    you'd have to set up a new data source to run sql queries

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

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