.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 count data from two dataset

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :Sql Server

HI all,

I have created report in SSRS R2, in which i have used twi dataset in SSAS cube

Dataset contains contain follwong columnas below


Dataset1  :  player,run

                   A       20

Dataset2 : Player,Run

                 B          10

                 C          21

                 D          24

where dataset1 contains run for one player while dataset2 contains runs of all player

now i want to write expression which gives me how many player who score more than player a i.e in above case result should be 2.


for this i have write below expression in Textbox of report.


then i got an error as below


"An error occured during local report processing.the definition of

View Complete Post

More Related Resource Links

Data Points: DataSet and DataTable in ADO.NET 2.0


ADO. NET 2. 0 sports some exciting enhancements to the core classes found in ADO. NET 1. x and introduces a variety of new classes, all of which promise to improve performance, flexibility, and efficiency.

John Papa

MSDN Magazine November 2005

ADO.NET: Tackle Data Concurrency Exceptions Using the DataSet Object


ADO.NET provides many techniques for improving the performance of data-intensive applications and for making them easier to build. The DataSet, the hallmark of the ADO.NET object model, serves as a miniature, disconnected facsimile of a data source. While using the DataSet improves performance by reducing expensive trips to the database server, it also introduces the possibility of multiple users attempting to change the same data simultaneously, thereby generating data concurrency exceptions. This article examines the common causes behind data concurrency exceptions and presents techniques for overcoming them.

David Burgett

MSDN Magazine April 2003

count the num of rows in dataset



Anyone can tell me which part when wrong if my code is wrong ?

I'm using VS2010 have a dataset. Here is my code.

Dim temp_sec As Data.DataSet

temp_sec = ac.getTempTime("741", "10 July 2010")

suppose to have 13 rows yet i got my msgbox is 0 rows Undecided

SSRS 2008 R2 Dataset Field Value Property Data Type not numeric

We're building SSRS 2008 R2 reports using SSAS as data sources.  There are several occaissions where the data types of certain dataset field values that represent cube measures are not numeric.  As such, when these fields are used in an aggregate function they throw an error.  Is there a way to remedy this in the dataset? Thanks for your help.

Displaying a count of records in a Data View Web Part outside the web part itself?

I have a DVWP with 400 rows. I have these inside a Div tag, which makes it scrollable. I also have several URL filters set up to show certain records. I would like to add the count to the page to display the number of records when the filters are activated. I have added the View Footer to the DVWP but this just gets placed at the bottom (still inside the Div tag). It would also be cool to be able to do counts with criteria so I could do comparisons (ie, 50 records overdue/400 total etc). Thanks

Is there a way to manually or programmatically set the dataset field's data type? This dataset is

Is there a way to manually or programmatically set the dataset field's data type?  The reason I am asking this question is that I am trying to sum a column of data in a report.  I noticed it is possible to sum a column of data if the datatype of a field in the .rdl file is of type <rd:TypeName>System.Int32</rd:TypeName>. Whereas it is not possible to sum a column of data in an .rdl file when the datatype of a field is <rd:TypeName>System.String</rd:TypeName> . When I create a dataset in BIDS 2008, by default, the dataset gives a field a type System.String.  I need to be able to change the field type to System.Int32 in order to sum the column. My datasource is a web service.  The results returned by the web service method has a datatype of int as follows: <xs:element name="Dollars" type="xs:int" minOccurs="0" /> So it seems the dataset created by the reporting services is giving my webservice a type of System.String. Is there some way of manually changing the type? thanks, Lloyd

DataSet does not support System.Nullable<>. at System.Data.DataColumn.set_DataType(Type value)

Hi All, I'm populating array of objects into DataTable.  One of the field is of type date and my be null..Can't seem to fix it. can anyone help.. Thanks,-----------------------------------------------------------Employees[] e = Service.GetEmployee();Util.ConvertToDataTable(e);-----------------------------------------------------------error:Unhandled Exception: System.NotSupportedException: DataSet does not support System.Nullable<>. at System.Data.DataColumn.set_DataType(Type value)    

append data on one dataset

Hi    i create a loop for select data from one table based on different condition. e.g. for ...... select * from [table]  where condition 1 select * from [table wheere condition 2   i have a problem, how can i fill each select into one dataset since i want to display all and bind into gridview   pls advice, thx    

How to import data from xml file into a dataset


I want to import data from a xml file into a dataset
this is my xml file  


<?xml version="1.0" encoding="UTF-8" standalone="no"?>


  <Person Personid="10">



    <Birthday>1360 </Birthday>














when I use this code
I have these tables in my dataset
But I want to have FIVE (more) tables for Fax,Mob

ASPX.vb data from dataset to textbox?


i want data from dataset display in textbox1 i did like this


Protected Sub Page_Load(ByVal sender As Object,

how to send data from dataset to textbox or label


i have dataset with sum(column1),sum(column2) , how can i take data in column1 into textbox1 or label1, column2 to textbox2. thank

Insert data to ms access from datagridview using dataset


please give me sample code for insert data to MS ACCESS  from grid view using dataset

Textboxes on form not showing data from dataset row item when data is there


This procedure is call from the page load:

    Private Sub ImportDataFromDataset()
        Dim dsImport As New DataSet
        Dim drImport As DataRow
        dsImport = Session("ComponentTypeImportDataset")
        drImport = dsImport.Tables(0).Rows(0)
        With drImport
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