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

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

SSRS 2008 R2 Dataset Field Value Property Data Type not numeric

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
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.

View Complete Post

More Related Resource Links

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

Error converting data type varchar to numeric.


I create a form to record data using ASP.NET and SQL database...
when i run the project show error "Error converting data type varchar to numeric"

what's the problem actually.i try to change in datatype in database..
but still showing error...


SSRS 2008 Graph Type?


Greetings -


I am required to plot the following graph in an SSRS report.


Sum of Total Credits to be shown on Positive side and total sum of Debits for a month on negative side. I have created a query which retrieves all the expenses for the month and sums them up before feeding the same to the graph for plotting. Both values returned are positive integers.


(Sorry for the diagram below, i tried to paste an image but it didn't work)

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis

SSRS 2008 Export to PDF fails for large data with System.Exception: Parameter is not valid

Hi, We are working on Range Bar Chart using SSRS 2008. The report has huge data. It is properly displaying the data, but when we tried to export to pdf it is failing with the following exception. Exporting to excel works fine. Also if the report has small/medium data it is property exporting to PDF. It is failing only in case of huge data (we have custom page size of 28" X 14"). Of course the report has lot of expressions we used to customize the colors/text as per our requirements.   Server Error in '/Reports_SQLDEV2008' Application. Parameter is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: Parameter is not valid. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:   [Exception: Parameter is not valid.]   [Exception: An error occurred during rendering of the report.]   [Exception: An error occurred during rendering of the report.]    Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream ou

SSRS 2008 R2 Data Source View Wizard does not recognize unique key constraints on views when using O

Hi, SSRS Data Source View Wizard does recongnize Primary/Foreign Key relationships from oracle datasouce tables, but does not recognize unique key constraints on views. How can I solve this problem. Thanks

Error converting data type nvarchar to numeric.

i create a form using form view tools in asp.net..when i click insert command it shows error..this is code which i use for InsertCommand:<asp:SqlDataSource ID="SqlDataSourceFormView" runat="server"         ConnectionString="<%$ ConnectionStrings:AED_PanasonicConnectionString2 %>"         SelectCommand="SELECT * FROM [Debtor]"        InsertCommand="INSERT INTO Debtor (CompanyName, Desc2, RegisterNo, Address1, Address2, Address3, Address4, PostCode)VALUES (@CompanyName, @Desc2, @RegisterNo, @Address1, @Address2, @Address3, @Address4, @PostCode)">        </asp:SqlDataSource>Error:-Error converting data type nvarchar to numeric.where i have to make changes?

How to align data in Chart legend in SSRS 2008?

Hi,I have created a chart of type 3D pie.  I put a String field for Category and Sum(numeric field) for Data.I wanted to show the legend as Category field and Data field and it's displaying as i set.Now how to make alignment of Data in legend, so that my numeric fields should align Right and String field should align Left.  I can make whole legend alignment but I want to make only the numeric field in the legend to align Right.Is it possible or there any work around?Please let me know.

SSRS 2008 - Data Source cannot be found in Preview

Hello; Something weird is happening to me - Never happened before on 100's of reports using Shared Data Sources. I have a Shared data source defined and when I try to preview a new report, I get a message saying that "The data source 'ProjectList' cannot be found" When I created the dataset, I pointed it to the shared data source. I can preview the data when I run my query from query designer, so it's obviously seeing my shared data source. If I use an embedded data source, the report renders just fine. I'm using SSRS 2008R2 BIDS to develop the report - the data source is hosted from a SQL Server 2008R1 database. Anyone ever seens this? How'd you get out of it? ThanksThanks Ron...

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)    

Is there any way to populate an InfoPath form field with the data from the site content type column?


I have a Form library with a form template.

The templat has a field "Office name" which should not be a fixed list of values, but a dynamical list, feeded from a different type of form. I'm a novice with InfoPath - Sharepoint and I want to find out, how can I can give users a possibility to create and maintain a list of offices and also have this list as a selection list inside main library form - ALL inside one library, if possible.

I assumed that if I publish main form (Itinerary) as a library template form and lookup form (OfficeInfo) as a SiteContent, I should be able somehow to connect to siteContent column and it's information. But I cannot see how - Site Content Gallery is not appering as a Connection item.

Can I use SiteConenct for this purpose or there are other ways to create end-user lookup lists?

Thank you!


SSRS 2008 R2 Map Report Type Web Viewable?



   Is it possible to run the map type report in the asp.net report viewer control? I tried to use the object datasource but ran into the expected issues with the spatial db types. If not what are the alternatives to distributing the map type report? (web based, subscription,anything?)

Im new to SSRS so any help will be greatly appreciated!


Bill Spaulding

Concatenating several rows data into one field Visual Studio 2008


Below is my a example of my table and data.  I am using Visual Studio 2008.  I need to concatenate field customer_report with like field ‘number’.  I added a new SQLDataSource and put the query below into it.


Select Main.number,

       Left(Main.CustomerNotes,Len(Main.CustomerNotes)-1) As "CustomerNotes"

From(Select distinct PS2.number, 

           (Select PS1.customer_report + ',' AS [text()]

SSIS 2008 data type bug



I am using SSIS 2008, I set a varaible @t1 to data type CHAR and set the value to Y next I used an Execute SQL Task with an ADO.NET connection to SQL 2008 R2 database to insert this the value of @t1 into a test table with only 1 column of data type NCHAR(1):

insert into test1

On the Parameter Mapping section of this task I put the Data Type as String and initially set the Parameter size to -1  

The only problem is it tries to insert a 2 character numeric value into the SQL table. If I set the value of @t1 to N the parameter mapping seems to convert this to 78, when I set the value of @t1 to Y the parameter mapping converts this to 89 it looks like it converts the character to an ASCII code.

Is this meant to be the intended behaviour, as all I wanted to do was insert the actual character into the destination column and not the ASCII code?



Error converting data type varchar to numeric



I am trying to execute below query.



CAST('123,456,789.00' AS DECIMAL(11,2))

Various Data type save in One Field


I use a ntext data type for all kind of data save in one field, but when i save  byte (that converted from image) follwing message is shown "Operand type clash: varbinary(max) is incompatible with ntext". Is ntext suitable for all kind of data type or what will be compatible for all data type support?

SSRS Change field properties dependent on the render type


I've built a report that has background images with text over the top, which when rendered as Word or Excel the images don't show and because the client has requested the text is white against the image, the text isn't visible.

What I'd like to do is run code within the report that identifies the render type and if xls will change the text color through an expression.

Any ideas would be greatful.


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