Showing posts with label dataset. Show all posts
Showing posts with label dataset. Show all posts

Monday, March 12, 2012

RDLC not recognizing DataSet

ASP.NET 2.0 Project
Added
rdlc file
DataSet with DataTable to be populated dynamically at runtime
I cannot set DataSetName in the dropdown -- it does not recognize my
DataSet and I cannot type into it.
If I compile I receive this error for my RDLC
"Error 1 The table 'table1' is in the report body but the report has
no data set. Data regions are not allowed in reports without
datasets."Are you saying that in the "Report Data Sources" window you do not see any
datasets (it actually shows the datatables) in the "Project Data Sources"
dropdown?
Where exactly are you trying to enter this dataset
Do you have an xsd created?
In the datasources window (Which shows when you are looking at a report),
what do you see? And can you create a new datasource from there?
// Andrew
> ASP.NET 2.0 Project
> Added
> rdlc file
> DataSet with DataTable to be populated dynamically at runtime
> I cannot set DataSetName in the dropdown -- it does not recognize my
> DataSet and I cannot type into it.
> If I compile I receive this error for my RDLC
> "Error 1 The table 'table1' is in the report body but the report has
> no data set. Data regions are not allowed in reports without
> datasets."
>

Friday, March 9, 2012

RDL to RDLC Dataset Bind Question

We got some existing Reports that are set to RDL files but now they want to be able to create a web user interface so the user can interact through such method. As I am finding out, these reports need to be converted to RDLC so that they can all the proper information so they can be binded. My question is, the datasets are already set (I beleive it's the .rdlc.data files) on the RDL solution project. Now I want transfer those DataSets to my Website project and bind those datasets to my Report Viewer Control. Is that the right approach? Or do we have to re-create the Datasets and then bind? Can I use Web Services to bind to these reports? Thanks for the input and all help is appreciated. Big Smile

there is no need to do this what you need to do is to just deploythose reports on the reporting server then create web page and addreport viewer control to it to enable the user view the reports youdeveloped you can see this example to know how to do this

http://www.c-sharpcorner.com/UploadFile/asif.blog/DynamicDataGrouping08042006115320AM/DynamicDataGrouping.aspx

http://www.gotreportviewer.com/

RDL and Data

Hi, does anyone know how to (if possible) to decouple the RDL file
from the embedded dataset reference? I know how to do this with the
RDLC file but not the other.The only option is to write a data processing extension. Look up the phrase
in Books Online.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ross_smith@.csaa.com> wrote in message
news:345d7886-7370-4720-8109-2c79a9ca85fe@.j28g2000hsj.googlegroups.com...
> Hi, does anyone know how to (if possible) to decouple the RDL file
> from the embedded dataset reference? I know how to do this with the
> RDLC file but not the other.|||On Feb 21, 7:43=A0am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> The only option is to write a data processing extension. Look up the phras=e
> in Books Online.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <ross_sm...@.csaa.com> wrote in message
> news:345d7886-7370-4720-8109-2c79a9ca85fe@.j28g2000hsj.googlegroups.com...
>
> > Hi, does anyone know how to (if possible) to decouple the RDL file
> > from the embedded dataset reference? I know how to do this with the
> > RDLC file but not the other.- Hide quoted text -
> - Show quoted text -
Thanks, i will check it out