How To Query From Report Model
Jan 31, 2008Hi, it's my first time for using report model as the datasource of reporting service. But I don't know how to build the query string to get data from the report model.
Can anyone help me?
Thanks
ADVERTISEMENT
Report Model Deployment : The Model ID Of The Submitted Model Must Match That Of The
Dec 5, 2005Running 2005 Beta 3 Refresh. When I first deploy, it works fine. Subsequent deployments yield the following error:
View 9 Replies View RelatedUnable To See A Named Query In The Report Model
Dec 5, 2006Hi guys,
I added a Named Query on my existing data source view and I recreate the report model, however, I am unable to see the Named Query on the Report Model, I can see only the tables.
Does anybody has any idea?
Sincerely,
Report Model - How To Create A Unique Logical Primary Key In A Named Query
Apr 7, 2008
Hi,
Te following situtation is :
ReportModel is created ,there is only a named query in DSV ,it has a few tables in it(The relationship are inner joins and outer joins).
The question is how could I create a unique logical primary key to identify each unique row in the named query dataset, and also you cannt generate a model unless the named query has a logical primary key . how can I solve this problem,any help?
Report Builder Using Report Model Based On Linked Server (Excel) - Primary Key?
Sep 6, 2007I've created a linked server with a pretty basic Excel spreadsheet, and used this command to create a linked server to it:
sp_addlinkedserver ''XL_SPS_1', 'Excel', 'Microsoft.Jet.OLEDB.4.0', 'c:MyExcel.xls', null, 'Excel 8.0'
I want to use this as the data from which to build a report model. As linked servers don't show up in the Data Source View wizard, I created a view in SQL Server:
create view MyExcel
as
select * from XL_SPS_1...Sheet1$
Okay, great, now the view shows up in the DSV wizard and I can create the data source view. However, when I create a new report model based on this data source view, the Report Model Wizard tells me at "Create entities for all tables" that I've got an error when it processes dbo_MyExcel that "Table does not have a primary key."
I assume this is where the identifying attributes for the entities in the report model are taken from, so I really can't go further. Does anyone have an idea as to how to add a primary key to a linked server (Excel) in SQL 2005? Can this be done? Other than importing spreadsheet data to a SQL table, how can I get around this?
Thanks,
--Stan
Can't Connect To Remote Report Server Model From Report Wizard
Mar 6, 2008
Hi,
I have created and deployed a data source (which uses "Credentials supplied by the user running the report") and a model which uses this data source.
Also I have built a report using Report Builder and all works well.
Now I wish to use Visual Studio to build a report, so I'm trying to create a data source from my computer which the report should use and I want it to use the model on the remote server. In the Report Wizard I am using "Report Server Model" and the following connection string:
Server="http://<remoteserver>/reportserver";datasource="/Models/MyModel"
IHowever I can't make the credentials to work. I've tried them all with no luck. What username/password must I use? Because so far nothing of what I have tried works.
Any help is highly appretiated.
Kind Regards,
Robert
Report Model: Drill On Calculated Field In Report Builder
Feb 11, 2007Hi,
I've created dsv that contain all fields from table database. in the smdl I've remove some fileds due to security. All fields in the smdl do not contain drill.
Issue: When I created calculated field in the report builder the field has a link. When I clicked the drill I saw all the record data including field that not in the smdl.
Questions:
1) Can I remove the link from the calculated fields?
2) Can I prevent from users drill to fields that not in the smdl?
Thanks,
Assaf
Dynamic Refresh Of Report Model In The Report Builder
Jan 22, 2007Is it possible to dynamically refresh the report model of the report builder?
could it even be using code with any of the interfaces?
When we add a table or add a column to the table in database , will the report model get refreshed automatically or do we need to do it externally. If so, can we use any of the objects and write a custom code in VB.
Problem Writing A Report On A Generated Report Model
Apr 26, 2006I get this error message:
Semantic query execution failed.
The 'PerspectiveID' custom property for the 'query' perspective is either not set or is not set to the string data type.
The report model does have a perspective.
Anyone else seen this?
Report Designer Report That Queries A Cube Model
Jun 15, 2007In Report Designer I am able to create a Model data source and see my entities/fields.
But when I run the report I get a "Failed to execute Query" message.
I know in the past this was an issue because Designer doesn't allow you to specify a perspective.
Does anyone know if this has been resolved?
I'm using SP2
Thank you,
Joe
Deploy A Report Model Using Report Manager
Feb 13, 2008I have a report model that I am trying to deploy using report manager web service. A folder is created by the administrator to place all my SSRS reports. I deployed .rdl files using the "Upload file" function in "Report Manager". All the SSRS reports work fine but when I tried to upload .smdl file (report model file) using the Report Manager's "Upload file" function it gave me the following error message.
The permissions granted to user 'xxxxxxman' are insufficient for performing this operation. (rsAccessDenied)
Does this mean I only have permission to upload .rdl file but NOT .smdl file to my designated folder?
How To: Link A Report To A Model As A Clickthrough Report
Jul 14, 2006I'm having some difficulty linking a custome drilldown or clickthroug report to another report that I have already created in report builder. I followed a MSDN article found at http://msdn2.microsoft.com/en-us/library/ms345226.aspx but I cannot find the " Select a page area, select Drill-through reports" option in report manager. Does anyone have a better explanation on how to do this? I'm assuming that when you create the clickthrough report there has to some sore of filter on it that relates to the item of the clickthrough. I guess I'm I little confused, any help would be great. Thanks.
View 5 Replies View RelatedUse Report Server Project To Connect To Report Model Project Data Source View?
Jan 17, 2008Hello,
I've created a Report Model Project that can be used by Report Builder to generate ad-hoc reports. I'm trying to create a connection string in my Report Server Project that points to the Report Model Project data source view.
All I can do is create a regular datasource, which bypasses the metadata contained in the Data Source View.
Basically I want my Report Server Project and my Report Builder reports to leverage the same metadata. Is this possible? If so how do I get the connection string?
Thanks!!
-Matt
Report Model
Mar 5, 2008I'm creating report model using named queries. Is it possible to specify parameters?
View 3 Replies View RelatedReport Model API?
Mar 21, 2007Is there an API or a way to consume a Report Model? I want to try and roll my own simple web-based / thin-client Report Builder without using the ClickOnce control.
Thanks,
--jason
Report Model
Apr 28, 2008Here is one scenario. There is category X which has subcategories A,B,C,D. A has 5 products and B has some 7 products, C 5 products and D has some 12 products. My problem is I need create a Report model where is if we select X
all the list of subcategories and their products should be displayed. I.e if we select X then
A
1
2
3
4
5
B
1
2
3
4
5
C and so on..........every thing should be displayed that are under category, i.e subcategories under that category and the products under each subcategory of that category.
Can anyone please help me out to create a Report Model to generate ad hoc reports
Report Model And It's Datasource
Aug 4, 2006hi everyone,
I created a report model and deployed it. When I open the rpt builder on web I get the following error.
'The selected data source does not have and content available'
Seemed like it would be a easy issue, but I cannot retrieve any data in the rpt model. The datasource I'm using does work for rpts not associated with the rpt model. Any suggestions? It seems like I've missed a step. Thanks, Lisa
Report Model, Which Approach?
Nov 23, 2006Hi All,
I'm a newbie to Report Model and not able to find some conceptual information, Can you guys answer following:
I€™ve
Employee [Name]
->Employee_Days [Day] (1-*)
->Employee_Day_Activities [Activity_Type, HoursSpent] (1-*)
schema and a generated model out of it. Now I€™ve few report requirements which will be developed based on Report Model. These Reports needs aggregate of All similar activities and the hrs spent and it'll be shown with every employee. Like Employee Xyz has spent 14 hrs total on Sick Activity, which will be shown as
Employee Sick Hrs Maternity Hrs WorkHrs
Xyz 14 0 20
Now i need to know the approach to develop it like i'v to ways in my mind
- create 3 custom fields(Sickhrs,Maternityhrs,Workhrs) in the Employee Entity(model), so that managers can create reports like above by simple drag and drop
- leave model as it is.. just create more descriptive fields in all the three table and let managers do the activity grouping etc to develop report like above..
Which approach should i follow? Moreover can you point me to some conceptual info like how report model works..etc..
regards
faraz
Can't Generate Report Model
Dec 5, 2007Hi,
I just wonder if anyone comes across this problem. When I generate a report model based on a cube, I got this error
The ID property for the Role 'xx' has a local name that exceeds the maximum length of 250 characters. (IDLocalNameLengthExceeded) Get Online Help
note: xx is my cube name.
It used to work fine before and I have changed anything since then so I don't know why it fails now. Please help!
Thanks in advance
Report Model With Oracle
Feb 22, 2008Hi,
I am using Oracle 9.2.6.0 and SQL 2005 SP2.
I have created a report model based on Oracle DB.
I use .Net Providers/Oracel Client Data Provider driver for my data source to connect to Oracle. It works fine but the performance is a bit slow.
Then I tried to use .Net Providers for OLEDBOracle Provider for OLEDB driver. When I deploy, I got the following error message: "System.OleDB".
I tried to use my last resort, which is Native OLEDBOracle Provider for OLEDB. When I deploy, I got the following error message: "Exception of type 'System.NotSupportedException' was thrown".
Anyone has this issue before?
What is the best driver to use and what is the best approach in term of performance.
Thanks and Regards,
XL
Add New Fields To Report Model
Jan 30, 2008Hi,
I've looked in vain for an answer to this, and it seems like it should be simple. Some new fields have been added to a table, and I need to add them to the Report Model. When I go to the data source view, the new fields do not show up in the table. Is there an easy way to get the new fields to show up, or do I need to delete the table (and of course the relationships), and then add it back. Thanks for any help.
Report Model Inheritance
Aug 3, 2007The Adventure Works Model comes with 'Sales Person' entity inheriting 'Employees'. The Binding dropdown in the inheritance property for 'Sales Person' provides a 'FK_SalesPerson_Employee_SalesPersonID' choice.
The Refining a Report Model in Model Designer Tutorial Lesson 10: Inheriting Properties from Other Entities, walks you through the process of setting this inheritance, but the Binding dropdown, after you set InheritsFrom to Employee, provides only the (None) choice. Anyone know why?
Problem With Report Model.
Sep 6, 2006Hi,
I am using report model as my data source and when I preview my report, I got the following error message:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create command for data source 'xxxx'. (rsErrorCreatingCommand)
An attempt has been made to use a data extension 'SQL' that is not registered for this report server. (rsSemanticQueryExtensionNotFound)
Anyone has any idea how to fix it?
Many Thanks,
UT
Deploying A Report Model
Sep 19, 2007
First, let me freely admit I know nothing about report models or how to deploy them. I was trying to learn by going through the tutorials. The creating part I get, but the deployment part seems to be over my head.
The error message I get is "A connection cannot be made to the report server http://hqjds02/Reports."
I don't understand why. Yeah...I get that it can't connect for some reason. Probably because I have messed things up somehow.
This is how I've got the deployment properties set:
TargetDataSourceFolder: Development (DV)/Data Sources
TargetModelFolder: Development (DV)/Models
TargetServerURL: http://hqjds02/Reports
In searching for an answer earlier I saw where someone wrote that I should be able to go to the URL and copy and paste it from IE. The actual URL is http://hqjds02/Reports/Pages/Folder.aspx?ItemPath=%2fDevelopment+(DV)&ViewMode=Detail . I tried it, but it didn't work.
What am I doing wrong?
Thanks,
Jennifer
How To Change A Report's(.rdl) Model
Mar 28, 2007Hi!
I've created a report with Report Builder using a Model. I want to keep the same report, but I have to use another model (this model is almost the same as previous one, except that it has some extra tables).
I tried to change my report's model from Report Manager (Report_Name -> Properties -> Data Sources), but it didn't work.
Any suggestions?
Best regards.
Execution Log For Report Model
May 25, 2007Is there any way to capture Report Model usage?
I was hoping to use the ExecutionLog (along with the RSExecutionLog_Update.dtsx SSIS Package). Closer investigation though shows that when a user executes the report built off the Model it gets logged with a ReportID Guid pointing to the root of the Catalog. Other than the Format being RGDI and the Source being AdHoc, there doesn't appear to be anyway to tell if the user ran this against ReportModel A or ReportModel B.
Anyone have any ideas?
Thanks,
Rick
Report Model Expression
Nov 20, 2006I'm new to Report Model and trying to create a new expression field with IF condition on related Role's attribute when i do this it gives error "The arguments to the following function are not valid: = (Equal to)" but if put direct Entity's column it works fine.. heres the expression
IF(Activity Type List Value Display Name = "Sick Day", 1, 0)
"Activity Type" is the Role(1--*) in Employee Table, and i'm adding this expression in the Employee Table
are there any sample models that i can download with some complex filters/expressions etc?
regards
faraz
Report Model Parameters?
Apr 3, 2008
Question.... I don't even know if this is possible.
I work for a Education Service Center that deals with school distrcit data. I have created various report models that work fine for these districts. Is it possible to pass parameters or filter out data in report models...Lets say I have ReportModel1 and this contains all campuses....and if jdoe logs in I only want him to have access to campus1.
This application I have created is in ASP.NET and grants permission at sign on based on their Active Directory memberships to groups. They can see the canned reports via a reportviewer control and I pass parameter values for campuses to filter it out accordingly.
They access report builder via a menu button linked to http://servername/ReportServer/ReportBuilder/ReportBuilder.application
I was wonder if their is code or method of passing a parameter or filter type to accomplish the same here?
I could always create report models for each campus....
ReportModelCampus1
ReportModelCampus2
ReportModelCampus3
....etc....
But this seems rather ridiculous.
Alex Flores
Report Model Error In WSS 3.0
Jan 12, 2007The model specified must be a generated model. (rsModelNotGenerated)
This error comes up after clicking on the new report model. The report model and datasource deployed to the sharepoint server with no issues.
Report Model With XML Datasource
Jan 5, 2007
Is there a way to create a Report Model with XML / WebService as datasource?
I am able to generate reports that connect to a WebService through Report Designer, but unable to find similar functionality in Model Designer.
What Does A Filter Do In Report Model
Jan 24, 2007In a Model designer when you select and Entity you have list of Attributes on the right side. There you have the option to add new "Folder", "Source Field", "Expression", "Role" and "Filter".
Can anyone explain in a bit detail what this filter can be used for. Can it be used to filter data from underlying entity? (I am not looking for SecurityFilter)
I am working on Microsoft SQL Server 2005 - 9.00.3027.00
Thanks,
Rahul
Report Model Security
Feb 6, 2008I have been playing with SRS 2005 for a few months now and have a decent setup going but am strugling with model security.
I have set my selected users up in the home folder and also as site users in site settings, they can launch the report builder and create reports fine.
HOWEVER
I intend to use the software accross multiple systems ie WMS, TMS, Finance package, T&A and therefore I only want the WMS users to see the WMS models and T&A users to only see the T&A models etc
No matter what settings are adjusted it seems that if you can launch the report builder then you can access all models and this poses an issue for me as systems like T&A and financials that I need to be as secure as possible.
I am aware that I can limit access to to models using Management studio but it seems to be basically on a column basis rather than the whole model.
Help!!!
Also aware of the fact im an idiot and basically posted the same thing 5 or 6 times! Hopefully the others are deleted
Report Model Is Generating Without Data
Feb 22, 2007I have been generating report models for users to use with Report Builder and there is no data when they select the model. I noticed that the tables I chose did not have a primary key and when I chose a different table, with a primary key, and generated a model from it, then there was data for the user to use in Report Builder.
Is there a documented work around or will I need to set a primary key on each table?