I'm learning about reporting in VS2008 (no we haven't moved to 2010 yet!), and I like the idea of rdlc files because it seems you can deploy the report as part of a web app rather than mess around deploying it to a report server. Is this correct?
We develop tiered apps that use LINQ to SQL, and the .dbml and LINQ queries are in a separate project to the web application. Also, depending on whether we are developing an internet or intranet web app, it will either reference that project directly, or
call its methods via a WCF service. However I can't seem to hook up my rdlc to either. From what I've read, this could be because we create "web application" projects and not "web site" projects. So my question is, is it possible to create an rdlc report within
a "web application" project and have it use either a business object or a WCF service as its data source?
If I try and create a data source in my web app project, it simply creates an XSD, and don't know what to do with this! If I go through the report wizard, all I can do is choose a database data source (i.e. from what's listed in the VS2008 server explorer)
- there is no option to choose an "object" or "service" data source, like you can when the rdlc resides in a report project.
You are correcly, RDL is server side processing report, it is created by SQL Server Business Intelligence Development Studio (BIDS). After designing the report, you should deploy it onto the reporting server; we can access the report through report server
or report manager. So data processing and connection to data base happen on the Reporting server. But in the RDLC file which is client side processing model, we can see that C is just Client ,we can integrate the report into our own web application system
which contains many function modules besides report part. So it is very flexible at integration system. The connection to data bass occurred on the client side and all the processing is on the Client side so you need to pass the data set to the report viewer.
RDLC file can be created by Visual studio. It is also possible to create RDLC report within a "web application" project and have it use either a business object or a WCF service as its data source.
The problem I have is that when I go through the Report wizard, the step "Select the Data Source" lists objects from various namespaces such as System, System.Data.Linq, and a few other assemblies that the project references. But it doesn't list any LINQ
entities (or other classes for that matter) from my own projects. If I click the wizard's button "Add Data Source" it just lets me select an existing connection string or create a new one. Nowhere in the wizard gives me the option to select an "object" or
"service" data source. The only time I see this is when adding a RDLC to a winforms project or a class library project, but not in a web application project.
I'm having the exact same problem and have not been able to find the answer yet. There was something I read about the business object class having to have at least one public property that returned a system type. It didn't make much sense and so far nothing
has worked for me. It seems like a problem with the add dataset wizard but who knows?
"The only time I see this is when adding a RDLC to a winforms project or a class library project, but not in a web application project."
yes this is the same for me, just with class library projects i can see the "Lets you choose objects that can later be used to generate data-bound controls."
andyste1
Member
8 Points
16 Posts
Confused about rdlc report & data sources in web app project
Feb 16, 2011 12:21 PM|LINK
Hi
I'm learning about reporting in VS2008 (no we haven't moved to 2010 yet!), and I like the idea of rdlc files because it seems you can deploy the report as part of a web app rather than mess around deploying it to a report server. Is this correct?
We develop tiered apps that use LINQ to SQL, and the .dbml and LINQ queries are in a separate project to the web application. Also, depending on whether we are developing an internet or intranet web app, it will either reference that project directly, or call its methods via a WCF service. However I can't seem to hook up my rdlc to either. From what I've read, this could be because we create "web application" projects and not "web site" projects. So my question is, is it possible to create an rdlc report within a "web application" project and have it use either a business object or a WCF service as its data source?
If I try and create a data source in my web app project, it simply creates an XSD, and don't know what to do with this! If I go through the report wizard, all I can do is choose a database data source (i.e. from what's listed in the VS2008 server explorer) - there is no option to choose an "object" or "service" data source, like you can when the rdlc resides in a report project.
Many thanks in advance
Andy
You-Hu Fu
Star
8174 Points
795 Posts
Re: Confused about rdlc report & data sources in web app project
Feb 18, 2011 10:06 AM|LINK
You are correcly, RDL is server side processing report, it is created by SQL Server Business Intelligence Development Studio (BIDS). After designing the report, you should deploy it onto the reporting server; we can access the report through report server or report manager. So data processing and connection to data base happen on the Reporting server. But in the RDLC file which is client side processing model, we can see that C is just Client ,we can integrate the report into our own web application system which contains many function modules besides report part. So it is very flexible at integration system. The connection to data bass occurred on the client side and all the processing is on the Client side so you need to pass the data set to the report viewer. RDLC file can be created by Visual studio. It is also possible to create RDLC report within a "web application" project and have it use either a business object or a WCF service as its data source.
For more information, please see: http://blogs.msdn.com/b/sqlforum/archive/2011/01/03/walkthrough-working-reportviewer-with-a-complex-business-object-with-a-nested-generic-list-type-property-as-data-source-for-local-reports.aspx
Thanks,
Challen Fu
Feedback to us
Microsoft One Code Framework
andyste1
Member
8 Points
16 Posts
Re: Confused about rdlc report & data sources in web app project
Feb 18, 2011 10:27 AM|LINK
Hi
The problem I have is that when I go through the Report wizard, the step "Select the Data Source" lists objects from various namespaces such as System, System.Data.Linq, and a few other assemblies that the project references. But it doesn't list any LINQ entities (or other classes for that matter) from my own projects. If I click the wizard's button "Add Data Source" it just lets me select an existing connection string or create a new one. Nowhere in the wizard gives me the option to select an "object" or "service" data source. The only time I see this is when adding a RDLC to a winforms project or a class library project, but not in a web application project.
Regards
Andrew
MarkHarmon
Member
2 Points
1 Post
Re: Confused about rdlc report & data sources in web app project
Sep 01, 2011 11:22 PM|LINK
I'm having the exact same problem and have not been able to find the answer yet. There was something I read about the business object class having to have at least one public property that returned a system type. It didn't make much sense and so far nothing has worked for me. It seems like a problem with the add dataset wizard but who knows?
caiouechi
Member
2 Points
1 Post
Re: Confused about rdlc report & data sources in web app project
Nov 19, 2012 02:46 PM|LINK
"The only time I see this is when adding a RDLC to a winforms project or a class library project, but not in a web application project."
yes this is the same for me, just with class library projects i can see the "Lets you choose objects that can later be used to generate data-bound controls."