Verify the Data Connector
From the XLReporter Project Explorer select, Tools, Connector Groups.
Select the SQL Server connector and then select Add.
Set the Type to Standard and click OK
On the Setup tab of the group
Add a table or view to the Selected Tables/Views.
Set Records to Fetch to Top n and the value to 1000.
Under the Columns tab, in Available Columns, add columns from the selected table or view to the Selected Columns list.
Select Preview and click Refresh.