locked
Report Builder 3.0 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Some questions:

    Does anyone know how to declare a variable for use in various sql statements instead of the filename? i.e.: (I'm using a csv file)

    Select * from filename, Instead of Select * from Members.csv

    Is Report Builder 3.0 limited as to what can be done with sql statements, even the GETDATE() function wouldnt work?.

    Why can I connect to the SQL Server Management Studio, but I cannot connect to the report server via RB 3.0?

    I will really appreciate if someone can help with this, I just can't find clear answers about RB 3.0 on the net.

    Wednesday, July 21, 2010 10:50 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    You can declare a variable in your SQL for filename:

    e.g.

    DECLARE @reportfilename varchar(20),

    SET @reportfilename = 'Members.csv'

    RB 3.0 should work with SQL statement, if you write the following it should work:

    DECLARE @D1 DateTime,

    SET @D1 = DATEADD(q,-1,GETDATE())

    I am guessing you are using RB 3.0 to connect to a SQL Server 2008 SSRS.  RB 3.0 can only work with SQL Server 2008 SSRS R2.  You can upgrade but not downgrade.  If you only have SQL Server 2008 SSRS then you should use RB 2.0.

    For more info please see the link below:

    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/8c394a4e-efc8-439e-9596-cb29e2cef483

    Hope this helps!

    Thanks, Michael Mei
    • Proposed as answer by Jerry Nee Friday, July 23, 2010 6:39 AM
    • Marked as answer by Jerry Nee Friday, July 30, 2010 6:12 AM
    Wednesday, July 21, 2010 11:03 PM