.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

report generate vwd 2008 - website data sources window empty

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :ASP.Net
I need to create report in asp.net web application, I'm working on vwd 2008 express, installed report add-on i have create dataset file xxx.xsd and use storder procedure for data adapter. when I am trying to add columns into report body I cannot see dataset in website data sources window. when i right click on window it just show refresh option. how can I get my data set into window. and add columns in to report? please help... 

View Complete Post

More Related Resource Links

asp.net VS-2005 Website Data Sources is empty



When I create a rdlc file(Report) the dialog box : "Website Data Sources" is empty, I can add a typed dataset, but the buisness objects (Classes) I created sometime disappear and sometime shown,

When I click/ remove some references it show and hide.

I would really appriciate some help,

thanks in advance,


I followed:


It works fine but after a while, it disappears again.

I tried it on several computers(which means it's not a problem of my machine), and tried it on several projects, all behave the same.


Empty Website Data Source windown


Hi all,

I am Visual Web Developer user and facing a problem when I am creating a local report (.rdlc) file.

I am using Business objects as the Data Source for this report. It was working perfectly until all the items in the Website Data Source window suddenly "disappeared". The "Add New Data Source" button on this window is also disabled. Now the window is just like a blank box only. And I can't continue working with the report file like this...

I have tried undoing what I did before but it does not help at all...

Any reason for this to happen? There is no sign or something at least indicating what is wrong.

Please help.


 ps: found a similar thread in this forum but not solved

Report Builder Report manage data sources - relink programmatically

As part of a site definition solution several report builder report rdl files are uploaded to a report folder.  After a site is created with the defintion, the reports must be manually re-linked to the data source through the UI context menu ("Manage Data Sources").  I have been trying to figure out how to do the re-linking programmatically without luck.  Any ideas? ( Reporting Services is configured as integrated with sharepoint)

Report with two data sources

Hello, I have two data sources: an Oracle table and a SSAS cube. I need to make a report with some information from the table and some from the cube. Example:   Oracle table ID, Comment SSAS ID, Value, Description Report ID (the join key); Value; Description; Comment.   Is it possible to do that? Many thanks  

What are my options when I need to create a report with data from multiple sources?

Hello all,  What are my options when I want to create a report that will get records from multiple data sources based on data from a parameter? The user will enter the customer ID, I have to check that ID against 5 different data sources. Have you guys done anything similar? Should I leverage SSIS on this request, adding an extra layer of complexity? Should I do this all from SSRS? What are my options?

model report from two different data sources SQL server and access DB

Can we merge two model reports into one . One model report is from SQL server and another one from Access DB. How is that possible. Can you please give a idea how to do that. I need to display data from sql server as well as access DB using model report.  I need to get data from two different sources like sql and oracle or SQL and access db. So can combine tables from these data sources into the DSV or model. I need to use it in a report   Thanks Madhavi

Creating a report from multiple data sources

I am working on a report where it requires pulling data from various sources, databases and data exported into excel sheets from different databases. The objective of the report is to create a single report with all the Providers (HPs) that have been terminated. So what I have done is that I have exported all the data on a local server in the pubs database and I am using a TSQL query to return the report. The same providers may exists in the various data sources so I have to make sure that I am only returning the data once...how ever the challenge is that, other than FirstName and LastName, there are no consistent IDs that we can use in all. For example, not all of the records have the SSN, PhoneNumber, or other IDs that uniquly identify the record. I have to create a report that returns the result set and identifiys the matching records and the source system the data is from..for example the output should display as such: Termed System firstname lastname SSN homephone phonenumber Active System AMIE Jeannine Donigan NULL 3522631007 Nurse SL Linde Peggy Vanrensselaer NULL 6077321218 Sbdev Below is the approach I I have taken to return the data and I wanted to know if there is a more efficient and better way of doing this: DECLARE @matchingTerminated Table ( FirstName Varchar(255), LastName Varchar(255), Gender Varchar(255), SSNEncrypted varchar(255), Birt

SQL 2008 R2 Custom Data Connection Issue with Data Flow - Data Sources


I have a custom data connection that we used in SQL 2005 to connect to a non-standard source to pull data.  We are in the process of upgrading to SQL 2008 R2 and I am running into an issue that hopefully someone can help me with. 

I have upgraded my custom connection code for SQL 2008 R2.  I can set up a connection using the custom code inside of an SSIS package.  However, when I go to a data flow task and try to select a connection for a data source object, OLEDB or ADO.Net data sources, my connection is not available.  If I select new on the connection option, my connection type is not available.  To get around this in SQL 2005 I used the data reader source.  The data reader source is not available in SQL 2008 R2.  So I am stuck. 

My custom connection is implemented as an IDBConnection.

Problem with Report viewer , no data is displayed and report comes out as empty


Hi ,


I have a problem using Report Viewer With SQL Reporting Services 2005.



I had a really weird issue with a ReportViewer.  It would show the little green Loading progress bar image . but it wouldn't show any data, just a white background where the output should be.  I knew the data was there because exporting to Excel or PDF showed the data just fine. 


  The problem is report toolbar is display but NO DATA is displayed and the report comes out as EMPTY .



Thanks in advance..


Can you please help me out in resolving this problem.



SQL Server 2008 R2 Disk Usage report showing incorrect data file


When I go to ANY database (System, AdventureWorks*, user) in Managemant Studio, I right-click on the db, select Reports, select Standard Reports, and select Disk Usage.  The disk usage report shows the correct db on top, but always only shows AdventureWorks_Data.mdf when I expand Disk Space Used by Data Files section.  This happens to any db I try.  When I look at Database Properties/Files for that database, the logical and physical file names are correct.

Since the correct files appear in Database Properties/Files, I'm hoping it's just a bug in the report.  Same thing happens if I run a Disk Usage by Table report for ANY database,  The tables for AdventureWorks always only appear,

Thanks,  Mike

SSRS 2008 crashng when running a report with huge amount of data


We have a huge amount data that is loaded (using flat files, upto 80GB in size) from the mainframe on a daily basis after which our users use SSRS to view the results using predeployed reports. One of the report query brings back a huge amount of data but when rendering the reports, it dies and restarts the service.

library!ReportServer_0-12!1310!10/14/2010-17:49:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database., ;
session!ReportServer_0-12!1310!10/14/2010-17:49:45:: e ERROR: Sql Error in GetSnapshotData: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
ui!ReportManager_0-11!1b34!10/14/2010-17:49:45:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the dat

window.open call does not work in Dynamic Data Website


I have a Dynamic Data .net 3.5 website.  I am trying to have a popup display from the code behind.  Below is the code.  The calling form has an update panel surrounding the content.  I get a 404 'resource cannot be found' when it runs.  I have tried OpenNewWindow("ConfirmExam.aspx"); and OpenNewWindow("~Exams/ConfirmExam.aspx");.  The ConfirmExam.aspx and the calling page are in the same folder called Exams.  The calling page is a custom page iin /Custom Pages/Exams/Insert.aspx.  The ConfirrmExam.aspx page has yes and no buttons.  It executes code to go to a page based on the response.  I am open to suggestions.

//this is the method call

//this is the method definition
public void OpenNewWindow(string url)
               ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), "newWindow", String.Format("<script>window.open('{0}');</script>", url), false);


Generate report on all empty folders in document libraries


I would like to perform a scan of all my document libraries in my site collection to determine which folders are empty and therefore can be safely removed.  Is there any built-in functionality in SharePoint 2007 that would allow me to do this?


Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

How to use report viewer 2010 in VS 2008


I downloaded report viewer 2010 from here


Now I want to actually use it in a website.  How do I do that?  Do I have to modify some part of web.config?  Specifically, what do I need to change?


Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

Crystal Report parameter value window.


 Hi friends,

   I am using Crystal report which displays the result of stroed procedure which have 2 paramater.

  When i run report it shows two window for getting each parameter.

  My need is, can i have one window for getting all the paramter value for stored procedure.


  With Advanced thanks,






ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend