sqlt-sqlreporting-servicessql-server-2008-r2bids

SSRS not displaying data but displays data when query runned in tsql

I have a SSRS report that do not display data in preview mode. However, when I run the same query in SQL Server 2008 R2 I can retrieve the results

What could cause this?

I also used Set FMTOnly to off because I use temptables.

Solution

  • if you use "SQL Server Business Intelligence Development Studio" not "Report Builder" then on reporting services (where is you table):

    1. click View -> Properties Window (or just press F4)
    2. select the tablix
    3. on properties window find "General" and in the "DataSetName" choose your "Dataset"
    4. On tablix fields set values from your "DataSets"

    Or just do like here(from 8:50): http://www.youtube.com/watch?v=HM_dquiikBA