.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

Error while creating Report model Report model project

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

Hi Everyone,

                  I am getting an error:"Value cannot be null.Parameter name :item".When trying to creating Report model in the Report model project ,but able to create Data Source and Data Source View.If anyone has come across this problem and got the solution,kindly share it ,i am need of the solution very much .



Chaithanya M

View Complete Post

More Related Resource Links

The report cannot be opened because the data source associated with it is not a report model.


i tried to open a report i created in sql business intelligence development studio in the report builder in wss3 and it gave me this error:

Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report 'http://servername:port#/Reports/report.rdl' cannot be opened because the data source 'http://servername:port#/DataSource Library/datasource.rsds' associated with it is not a report model.

This report was not created in Report Builder. Try opening this report in Report Designer instead.

can i fix this so i can open my reports in report builder?


Report Model/Report Builder/Out of Memory Exceptions

We are getting out of memory exceptions on our server. We are using Report Builder against a Report Model in RS2008. Here is part of the errors we are getting. I cannot find any information for an error 200. Here is part of the error log:   processing!ReportServer_0-2!17d8!08/25/2010-10:07:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;  Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.ReportIntermediateFormat.Sorting' threw an exception. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.    at Microsoft.ReportingServices.ReportIntermediateFormat.Sorting..cctor()    --- End of inner exception stack trace ---    at Microsoft.ReportingServices.ReportIntermediateFormat.Sorting..ctor(ConstructionPhase phase)    at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.ProcessingRIFObjectCreator.CreateRIFObject(ObjectType objectType, IntermediateFormatReader& context)    at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadRIFObject(Boolean ve

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

problem deploying report model to wss3 site

hi, im having trouble deploying my report model. when i click on deploy i have to enter a user name and password (i asume that it is the username and password i use to enter my wss 3 site) after that it begin to deploy then i get these 2 errors: Error 1 The required field UserName is missing from the input structure. c:\documents and settings\administrator\my documents\visual studio 2005\projects\essreportproject\essreportproject\ESSP.ds 0 0  Error 2 The path of the item '/Data Sources/ESSP' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. c:\documents and settings\administrator\my documents\visual studio 2005\projects\essreportproject\essreportproject\ESSP.smdl 0 0  when i go to my page in wss3 i can see the datasource and model directory, but i cant use them can someone help me with this and explain it for me.  

Error while creating Termstore using Object Model

Hi, I'm creating term store Group using object model using the below mentioned code:- string TermStore = drManagedMetadataGroups["Term Store"].ToString(); string GroupName = drManagedMetadataGroups["Group Name"].ToString(); string Description = drManagedMetadataGroups["Description"].ToString(); string GroupManagers = drManagedMetadataGroups["Group Managers"].ToString(); string Contributors = drManagedMetadataGroups["Contributors"].ToString(); try { //Type importManagerType = typeof(ImportManager); //Type[] parameterTypes = new Type[1] { typeof(TermStore) }; //ConstructorInfo constInfo = importManagerType.GetConstructor(BindingFlags.NonPublic | BindingFlags.Instance, null, CallingConventions.ExplicitThis, parameterTypes, null); //if (constInfo != null) //{ TaxonomySession session = new TaxonomySession(web.Site); TermStore ts = session.TermStores[TermStore]; //ts.AddTermStoreAdministrator(@"test-account-01\d39373g"); //logger.LogToOperations(string.Format("Added managed metadata group administrator '{0}' to '{1}'", GroupName, TermStore), EventLogEntryType.Information); if (!M

Using "As Of" date in a report model

Hi Everyone. I have an organisation structure table that contains start and end dates so that I can use it to sequence financial reports with the structure "as of" a set date. Along with this, I also have some slow moving dimension tables related to chart of account structure that also have start and end dates. Now, I can build a model with this OK and when I create a report, I can add the selections ( "as of date between start orgstructure date and end orgstructure date and as of date between account structure start and end structure start) without any problem but its much to complicated for my ad-hoc report writers to use. Is there any way of setting up a parameter field in a model so that I can build the selections into the model itself so my users only need to feed it the date?  

Consolidated report across more than one model

Hi, We are using  Great plains  as our ERP applicatioon  and exploring the options of using report builder as ad hoc reporting too for end user reporting.  In GP each company has an exclusive database.  I have created a report model for each of the company and users are good to go with reporting for each company. However fthe finance department would like to consolidated report  accross all companies. How can I consolidate each of these company models into one giant model. Regards Vincent        

Report Builder 2.0 Strange column when using model

Hi, We have build a simple dsv and model and are writing reports in report builder. Every time we add in a linked table we are getting a column appearing with strange values e.g. "AH.gEAAA=" these appear to come from no where and have a column name the same as the table, Can anyone please explain what they are and how to get rid of them please.

changes to report builber model



I have a report deployed using report builder v1.

 Now I have changed the model and re-deployed it and the report now crashes.

Is there a way to fix this problem as our clients will bebuilding reports using Report Builder V1 and deploying them. We will make changes to the report model and send out new releases of the model without knowing what reports are out there on the client side.




Report Model based on Analysis Services Cube doesn't work


Hi all,

I am working in BIDS and would like to create a Report Model based on a cube.

Creating a Data Source based on SSAS goes well, but when I want to make a Data Source View, the earlier created Data Source doesn't show up, which is necessary for the final resulting Report Model.

Could somebody help me out in solving this issue? (And also tell me why this is issue is rising?)


SQL Server 2008 & BIDS 2008 (Version 9.0.3x)

Report Model--is there a limit on the number of rows?

Is there a limit on the number of rows that a report model will support? Our report model has tables that have millions of rows of data. When we regenerate the model it starting to take hours to regenerate. Is that expected? Is there a limit on the number of rows that can be used with a model?
Kim B.

Sorting Parameter Value in Report From SSRS Report Model in 2008 R2


I have created a report model in 2008 R2. Now, when I am trying to create a report from the report model, I having trouble in sorting the parameter value in multiselect dropdown list.

I have tried setting Attribute Property Sort Direction as Descending , but it always comes up as Ascending.

Any suggestion would be highly appreciated.



Remote Debugging error while creating business data connectivity model


Hi Everyone,

                  I have a scenario where I have to get the data from two of the stored proc's in the SQL Server and create an assocation between those models.I cannot use Sharepoint designer as there is no relationship existing between those two entities.So,I have used visual studio business data connectivity model to fulfill this requirement.I created the model with filter descriptors,input parameters and all and related those as suggested by MSDN and used LINQ to SQL to pull the actual stored procedure into the readlist and readitem methods.My issue here is,when I debug this project,I am receiving an error message tht says "remote procedure cannot be debugged.this usually indicates debugging hasn't been enabled".Then I changed the debug entry in the web.config to true to solve this issue.But,still I received the same error...what do you think might be stopping me from going ahead..ur suggestions and tips helps me a lot..


Thanks all..


Report Builder 3.0-Report Model



How to create report using report model(model created in sql server 2008 R2) in Report Builder 3.0


Urgent!!!How can we sort the parameter list in report created using report model in ssrs 2008 r2?


How can we sort the parameter list in report created using report model in ssrs 2008 r2? Do I need to change some property in Model or elsewhere?


How to generate MySite Usage Report using Sharepoint Object Model


Hi All,

In my Portal i have MySites some where around 15000 where in every day i need to auto generate MySites usage report in excel format.

Can some one please help me out how to acheive the same using Sharepoint Object Model.

Required Summerised "MySite" Usage Report using Sharepoint 2007 object model


Hi All,

I have a requirement like I need one report which will provides the MySite Usage Report

In detail: One report having information about MySite User,Total Hits since created, Average No of requests per day over past 30 days, Distinct users over past 30 days, Size (KB) on "MySite" in Sharepoint.

Please let me know any solution or thoughts either using content database queries  or object model.

Advance Thanks

Ashok Gamini

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