No Data returned to standalone RDLC

Aug 30 2015 12:27 PM
Hi all
 
Please could someone assist me with what I believe is a smallish issue. Please excuse my lack of knowledge as I am very new to RDLC reporting and reporting in general.
 
Following the Tutorial: http://www.c-sharpcorner.com/UploadFile/robo60/StandaloneRDLCReports11142007183516PM/StandaloneRDLCReports.aspx
and trying to apply it to my own project yet the standalone report shows no data.
 
I believe that the issue might be related to the SPROC I used to generate the report datasets.
 
In the Tutorial the SPROC and the DataTables  use  only String elements.
 
In my project I am returning String and decimal types for the 1 table and string, decimal and int types
 
My modified Sprocs
<CODE> 
CREATE PROC up_SSRS_TestReport_InputFields0
AS
SELECT DISTINCT
'1' AS Caption,
0.0000 AS TenderTotal
</CODE> 
AND
 <CODE>
CREATE PROC up_SSRS_TestReport_InputFields1
AS
SELECT DISTINCT
'1' AS Department,
2 AS TotalQTY,
0.0000 AS DeptSales
 </CODE>
 
I have just redone the full process start to finish in both a new Test Harness and in my own Project and still receive 2 empty tables
 
Many Thanks in advance for any and all advise 

Answers (1)