No Data returned to standalone RDLC

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

CREATE PROC up_SSRS_TestReport_InputFields0

AS

SELECT DISTINCT

'1' AS Caption,

0.0000 AS TenderTotal

AND

CREATE PROC up_SSRS_TestReport_InputFields1

AS

SELECT DISTINCT

'1' AS Department,

2 AS TotalQTY,

0.0000 AS DeptSales

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Stephen Dougherty11y ago
Found the issue and resolved.

As I was using TableAdapters to fill the data from the database they are added with a DataSet.

Whilst I was removing the table from the DataSet and adding to the Report DataSet - I was only adding the name and not the actual Table