.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

How to use .XSD file as DataSet to create SSRS report?

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :ASP.Net


I am  planning to create a SSRS report and lunch it in a ASP.NET web application (not using report server). Since the dataset need to be manipulated before used to generate report (some data fields of tables need to be filled  using data got from other system using COM+ components) , I hope I can use a .XSD file as the DataSet to create SSRS report and bind data source dynamically in code. It is not a problem using Crystal Report, but I have no idea how to do it either in Report Designer or in VS 2005. Please advise





View Complete Post

More Related Resource Links

Convert Xml content from a Dataset to another Dataset for SSRS report?

Hi All Does anybody know how to convert xml field from SQL Query to Dataset? For example I have a table T with Fields A(VARCHAR), B(INT), & C(XML). Field C has <test><row>ROW 1</row><row>ROW 2</row></test> I make a query to get this data and call this Dataset1 Now I want the Column C content to be converted into a dataset  call it Dataset2 so that I can drag and drop tables from there to make my reports. Is it possible to do it without using webservice?Another limitation I have, I should not have to connect to DB again, so this boils down to use the already data contained in Dataset1. I was trying to somehow embed this XML content in the query at runtime dynamically? I am currently looking for a way to use the Dataset1 as the datasource and and parse the XML content of Dataset1 to Dataset2. Also, is it that XML content needs to hardcoded in the query, can't we do it dynamically and run the query?

Execute a SSRS Report from CRM using URL to output to PDF with a specific file name


We have a CRM installation from which I am trying to do some reports which use the CRMAF filters so the reports are sensitive to entitiy selections.

eg execute a sales report for a number of selected accounts.

The specific RDLs have been created in VS2008 and uploaded to the reporting server via the Report import tools within CRM and all work as expected however the output of the report is in HTML via the web browser.

I have changed the configuration of the report in CRM so that it uses the URL method like below so that the report is rendered into PDF which is great.



This method prompts for the user to open/save the PDF file which is acceptable however I would like to replace the default file name (which is the report name) with one of my own.

For example rather

SSRS 2008 R2 After using SSL, In Report Manager new datasource link, upload file link, subscription



I have provided my setting and environment information below. My goal is to set Report Manager and Report Server URL with SSL connection so all URLs uses HTTPS (Secure connection) all the time. and remove HTTP access .

I applied following settings for this but I am getting errors. With Current Settings that I mensioned below, I am able to login into WebService URL successfully with all links working. For Report Manager URL  I logged in successfully but for some pages I am getting HTTP links instead HTTPS. It shows HTTP links for new datasource link, upload file link, subscription links so it shows blank page

I tried to look for solution and I applied but did not worked. I did some experiment with changing urls using application and manually from RSReportServer.config file but still not succedded.

Steps taken to solve problem:

  • To force to use HTTPS only, I tried to change SecureConnectionLevel = 0 to  1,2 or 3 but when accessing to Report Manager it gives 401 Authentication error.
  • If I remove http://+:80/ReportServer and tried to visit 2nd URL with HTTPS. The Web Service URL opens successfully. but Report Manager url gives me er

Rdl Report's Parameter DataSet Using SSRS




I have to design a Page Similar to Report Server's Viewer Page where if any Parameter is multivalued and if any Stored Procedure/Query Name is specified in the Report, then a it is internally executed and checkbox dropdown list is displayed to select the values.

Similar to that I have to design an aspx page with the similar behaviour. How to get Stored Procedure Name(if Specified/Query) of any Parameter of a report? So that I can bind my Checkbox list on the aspx page.


Please Help!


Getting SSRS Report DataSet Field list from C#


Hi All,


1. We have requirement where users can build there own SSRS Reports and integrate it with the existing system dynamically.

2. We have an Existing Application (Called APP1), our approach is user will build the report as per there requirement and from APP1 we have report configuration screen when user will select the report file to import to our system.

3. While doing importing, we have special requirement like

3.1 Retrieve the all fields from the Report DataSource and display to the user

3.2 User configures that what values they want to filter when the report is shown from the application. ex: employee information is      displayed in the report, DataSet query is "select empid,empname,..... * from employee" 

        3.3 from APP1 when user gives the report we have to dynamically load the report and get the fields from the dataset, so user can                configure like this, when the report is shown report must ask for parameter value for empid .


Unable to upload report file to SSRS 2008 R2 Express

I'm attempting to upload a report file into an instance of SQL Server 2008 R2 Reporting Services (Express edition), and I'm having difficulty. While I can do things like create folders and manage security, I am unable to upload a report definition (.rdl) file from either the web console or via the ReportService2005.asmx web service. Both avenues eventually time out and generate a 401 error (though I am not sure that this 401 is legitimate, as it takes over a minute and a half to generate the error).

This instance is running the web services on a non-standard port (8080) in HTTP (not HTTPS) mode, as it's on a Windows XP Pro machine with an existing website on IIS.

I have looked at the report server access log, and this appears to happen when it errors out:

    rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: ReadCallback(): failed to read in read callback.
    rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.
    rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: HttpPipelineCallback::ReadEntityBody(): failed reading data.
    rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.

Can I create multiple report tables from one Dataset?


I'm producing a report in Report Builder 3.0 that needs to show events grouped by time of day, and another table with the same data grouped by day of week. Both tables show the same results, just grouped differently. The query that generates the ungrouped data is expensive, so I don't want to run it twice.

I've created queries in Management Studio that get the ungrouped data into a global temp table, and then I can fetch both grouped data sets from there. Unfortunately I can't get this to work in Report Builder. I have one Dataset that runs the main query, saves it into global temp, and then returns the first result set. The second Dataset returns the results from global temp. This keeps failing, the second result set is blank.

Does Reporting services run the queries in the order they are in the report, or are they run concurrently? If they are run concurrently this would explain it. Is there anything I can do to change this so that the second query doesn't run until the first one has completed?

Is there a better way of achieving the results I'm after?

create csv file from dataset in asp.net


anyone can help me to create the .CSV files from the dataset ds11, from the following code...

int _count = ListSeCh.Items.Count;
        if (_count != 0)
            DataTable dtTemp = new DataTable();
            dtTemp.Columns.Add("Id", typeof(string));
            dtTemp.Columns.Add("Name", typeof(string));
            for (int j = 0; j <= _count - 1; j++)
                DataRow dr;
                dr = dtTemp.NewRow();
                dr["Id"] = ListSeCh.Items[j].Value;
                dr["Name"] = ListSeCh.Items[j].Text;


create Zip file from dataset in asp.net


I have to generate zip file from this code.


help anyone plzzz....TIA

Create a XML file from Database table using Dataset



I've got a SQL database with a table named contact with different column such Name, Address, email ...

I would like to generate a XML file based on the table data:


     <name> John</name>

    <address> 100 main street </address>



After some research it looks like I can use a dataset from that table to create my xml.

Being a beginner I cannot find the right steps / syntax to do so.

Is there any tutorial showing how to work with dataset and XLM?

Thank you for your helps 


how to execute all the dataset in SSRS report in parallel.


hi All,

I have created report in SSRS R2 ,in which ihave used 7 dataset.

Individually each dataset took 10 sec to execute and hence when i ran the report ,report took 70 sec to execute,it gives a sense that each dataset execute in sequence ,though i want to execute the all the dataset in parallel so that it took only 10 sec to execute the report.


kindly Suggest


create xml file from a dataset

I have a SQL database with a dataset created, and I know that i can use writeXML(strfile) method to write the dataset into an xml file.

My question is that how do I render that xml file directly to user's browser, without creating the file on the server? I ask this because the writeXML method expects a filename as the parameter.

I am new to xml, please advice. thanks

Report - Drill down/Expand details? - how do I create this report in SSRS


I'm having trouble making this drilldown/expand details report. It is probably simple - but is beyound the basic drill down examples that I have found.

My data has multiple rows per product because 2 of the columns are joined with tables that include multiple rows per product. This is related products and prices for quantity intervals.

Is it possible to use grouping so that I could have these show as 1 row per product and then be able to expand the information

Any solution will do – it could be like this:

Create and Use a Typed DataSet by Using Visual C# .NET

This article shows you how to create and use a typed DataSet in a small Web application. Typed DataSets, which inherit from the DataSet class, create first-class members of a DataSet's DataTables and DataColumns, yielding the many benefits that come with the use of strong typing.

Access to report file denied. Another program may be using it.


Migrated from Windows 2000 ASP.NET 1.1 to Windows 2003, ASP.NET 2.0 and had this error. All the forums/MSDN/Blogs says to give Read/Write Access to C:\Windows\Temp folder. Why should we give Full Access to some folder in Production server?? In windows 2000, ASP.NET 2.0 development machine, no files are created when we run crystal reports from aspx pages. Then why in Windows 2003 servers, we need to give rights to temp folder?? It is a simple code


And the code is not storing anything on the disk. Then why should it store the GUID.rpt file in Temp file in Windows 2003 server?? Any alternative is there not to store anything on the disk when Crystal Reports are opened in aspx page??


Crystal report with dataset and list - please help


Hi Guys;

i'm new in reporting so thanks to be patient with me,

here is my problem, i have created a report then a report viewer,, i passed some parameters to the report it goes well.

i'm working with local data stored in List<object>, i tried to fill my dataset (data) with those local data stored in the list, i filed Cry

looking for yor help


file upload in Create User Wizard Created User event with UpdatePanel Tag wont work?



In my Create User Wizard1 Created User Wizard Event, I am collecting extra information from text boxes and allowing

the user to uplad a file.



I have put the Submit button within an Update Panel Tag but since I have done this it does not work.

Is there a way round it. In this situation would you use a trigger.?


<br />

  <asp:UpdatePanel ID="UpdatePanel2" runat="server">

  <asp:Button ID="StepNextButton" runat="server"  CommandName="MoveNext"  align="middle"
                                            Text="Submit my Profile" />

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