report model template is missing

I want to create a new report model project, however in VS Business intelligence Development Studio, I could find the report model template in the New project dialog box. Anyone coulf tell me how can I add the templeate? Thanks

Do you have any other business intelligence projects installed like report server project?

Try this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1479717&SiteID=1

Report Model Project: Multiple Data Sources

I have setup a "Report Model Project" with multiple data sources, and
imported tables from each of these into my data source view. When I try to
use the wizard to create a report model I get an error on the "Completing the
Wizard" stage when I click "Run".
An error occurred while executing a command.
Message: Invalid object name 'dbo.<table name>'.
Command:
SELECT COUNT(*) FROM [dbo].[<table name>] t
The <table name> will always relate to the first table it attempts to
process from the secondary (non-primary) data source. I figured this out by
setting up the project from scratch with the opposite data source as primary.
It seems like it is looking in the primary data source for the table that it
should be trying to use the secondary data source to query.
Any help is appreciated. :)A report model can only reference one data source in this release. Data
source views are more flexible than supported by report models.
-Carolyn
"Greg T. Smith" wrote:
> I have setup a "Report Model Project" with multiple data sources, and
> imported tables from each of these into my data source view. When I try to
> use the wizard to create a report model I get an error on the "Completing the
> Wizard" stage when I click "Run".
> An error occurred while executing a command.
> Message: Invalid object name 'dbo.<table name>'.
> Command:
> SELECT COUNT(*) FROM [dbo].[<table name>] t
> The <table name> will always relate to the first table it attempts to
> process from the secondary (non-primary) data source. I figured this out by
> setting up the project from scratch with the opposite data source as primary.
> It seems like it is looking in the primary data source for the table that it
> should be trying to use the secondary data source to query.
> Any help is appreciated. :)

report model project question

I am having a problem trying to get the correct data on the report.
It is a typical schema where we have clients, doctors and both of those have
doctors. I am unable to show clients, client addresses and doctors on the
same report builder report. I can get 2 of those not 3.
any ideas? (is this a limitation of the product?)It all depends on the relation you set to be visible in the report model. So
you need to select the proper table and the keys.
Amarnath
"dave" wrote:
> I am having a problem trying to get the correct data on the report.
> It is a typical schema where we have clients, doctors and both of those have
> doctors. I am unable to show clients, client addresses and doctors on the
> same report builder report. I can get 2 of those not 3.
> any ideas? (is this a limitation of the product?)|||What do you mean "the relation you set to be visible"? How and where do you
specify visible options?
Sorry new to this.
thank you
dave
"Amarnath" wrote:
> It all depends on the relation you set to be visible in the report model. So
> you need to select the proper table and the keys.
> Amarnath
>
> "dave" wrote:
> > I am having a problem trying to get the correct data on the report.
> >
> > It is a typical schema where we have clients, doctors and both of those have
> > doctors. I am unable to show clients, client addresses and doctors on the
> > same report builder report. I can get 2 of those not 3.
> >
> > any ideas? (is this a limitation of the product?)|||Ok, Visible means nothing like enabling or disabling. but what I meant was,
setting the right relation, so that it can be selected for your reports from
report builder. If you dont have the relation or if the PK or FK is not
present in the tables, then that can't be selected, which you will come to
know when you go for setting the relation using the wizard.
Amarnath
"dave" wrote:
> What do you mean "the relation you set to be visible"? How and where do you
> specify visible options?
> Sorry new to this.
> thank you
> dave
> "Amarnath" wrote:
> > It all depends on the relation you set to be visible in the report model. So
> > you need to select the proper table and the keys.
> >
> > Amarnath
> >
> >
> > "dave" wrote:
> >
> > > I am having a problem trying to get the correct data on the report.
> > >
> > > It is a typical schema where we have clients, doctors and both of those have
> > > doctors. I am unable to show clients, client addresses and doctors on the
> > > same report builder report. I can get 2 of those not 3.
> > >
> > > any ideas? (is this a limitation of the product?)

report model project problem - entity not showing up

I have a client table and a clientdoctors table.
In the data source view i see all the needed tables in the diagram organizer
pane. I also see the relationship between the clientdoctors table (which
holds clientid and doctorid), as well as client table and doctor table.
That all looks fine. The problem however is that when in my report model i
do not see those relationships at all between the client - client doctor -
doctor tables. There are a few situations just like this that i cannot
explain.
I am new to the report model project but i dont know why i dont see these
relationships inthe report model or while using report builder.
Any ideas please'Have you deployed properly? I mean you didn;t get any error. After deploying
you get to see in Report Builder. Just check.
Amarnath
"dave" wrote:
> I have a client table and a clientdoctors table.
> In the data source view i see all the needed tables in the diagram organizer
> pane. I also see the relationship between the clientdoctors table (which
> holds clientid and doctorid), as well as client table and doctor table.
> That all looks fine. The problem however is that when in my report model i
> do not see those relationships at all between the client - client doctor -
> doctor tables. There are a few situations just like this that i cannot
> explain.
> I am new to the report model project but i dont know why i dont see these
> relationships inthe report model or while using report builder.
> Any ideas please'|||Yes everything deployed properly. It seems like the problem was related to
keys on the tables. i.e. i had to place keys on the middle table.
"Amarnath" wrote:
> Have you deployed properly? I mean you didn;t get any error. After deploying
> you get to see in Report Builder. Just check.
> Amarnath
>
> "dave" wrote:
> > I have a client table and a clientdoctors table.
> >
> > In the data source view i see all the needed tables in the diagram organizer
> > pane. I also see the relationship between the clientdoctors table (which
> > holds clientid and doctorid), as well as client table and doctor table.
> >
> > That all looks fine. The problem however is that when in my report model i
> > do not see those relationships at all between the client - client doctor -
> > doctor tables. There are a few situations just like this that i cannot
> > explain.
> >
> > I am new to the report model project but i dont know why i dont see these
> > relationships inthe report model or while using report builder.
> >
> > Any ideas please'|||You need to have key relationship otherwise it wont select tables in the
report model itself. If you have completed the wizard of creating report
model. then it would have asked for keys when you select tables for
relations. So just check if all the keys are in place and deploy.
Amarnath
"dave" wrote:
> Yes everything deployed properly. It seems like the problem was related to
> keys on the tables. i.e. i had to place keys on the middle table.
>
> "Amarnath" wrote:
> > Have you deployed properly? I mean you didn;t get any error. After deploying
> > you get to see in Report Builder. Just check.
> >
> > Amarnath
> >
> >
> > "dave" wrote:
> >
> > > I have a client table and a clientdoctors table.
> > >
> > > In the data source view i see all the needed tables in the diagram organizer
> > > pane. I also see the relationship between the clientdoctors table (which
> > > holds clientid and doctorid), as well as client table and doctor table.
> > >
> > > That all looks fine. The problem however is that when in my report model i
> > > do not see those relationships at all between the client - client doctor -
> > > doctor tables. There are a few situations just like this that i cannot
> > > explain.
> > >
> > > I am new to the report model project but i dont know why i dont see these
> > > relationships inthe report model or while using report builder.
> > >
> > > Any ideas please'

Report Model Deployment Problem (DataSource)

I created a new Report Model project and specified folders for both the model and the datasources. For some reason, every time I deploy the model I get an error stating the datasource cannot be found. I've tried changing the project properties to no end. Here's the specific output

Deploying to http://localhost/ReportServer?%2f

Deploying data source '/Data Sources/CRM Database Conection'.

Deploying model 'CRM Filtered View Model'.

The item '/Data Sources/CRM Database Connection' cannot be found.

This seems to happen a lot when creating logical joins from tables from different datasources.

Report Model Deployment Problem (DataSource)

I created a new Report Model project and specified folders for both the model and the datasources. For some reason, every time I deploy the model I get an error stating the datasource cannot be found. I've tried changing the project properties to no end. Here's the specific output

Deploying to http://localhost/ReportServer?%2f

Deploying data source '/Data Sources/CRM Database Conection'.

Deploying model 'CRM Filtered View Model'.

The item '/Data Sources/CRM Database Connection' cannot be found.This seems to happen a lot when creating logical joins from tables from different datasources.

Report model data sources

Is it possible to have a custom data processing extension as the data source in a report model project?

No, this is currently not supported.

-- Robert

sql

Report Model - Custom Code or Assembly Reference

Hi, I'm trying to create a new Report Model Project, but I have a problem. The problem is that I have a one custom column in the database table, lets say column's name is 'Test', with encoded data, so I need to add a new field to the generated model, lets say 'Test Decoded', and use a some method from my custom assembly to decode the data in the expression designer. I don't see how to use a method from my added custom assembly in the expression designer, also I was browsing Google many hours without an result. Also Data - > Add New Datasources -> Object throws an exception in the VS2005 (Report Model Project). Maybe someone can help me. Thanks

HI,Maryan:

Not possible as far as i know. The Report Model used for the Report Builder to generate ad-hoc report.

I don't think you could use custom assembly in the Report Model. I suggest the you to do the decode job in the SQL Server side.

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

Hi Rex Lin, thank you for a reply. Exactly - I need to create a Models to enable my customers to create own specific reports by the Report Builder (nice feature of the SSRS 2005 from the first view). That is why we have selected this solution from Microsoft.

Actually this column is implementation of the Custom Fields of the some model, so in this column are decoded X custom columns, as result from the real column in the table - ColumnA, we need to create dynamic columns ColumnA1, ColumnA2, ColumnA3... based on the decoded content of the column ColumnA. So Model on the server side (SSRS) should contain all these dynamic columns (if some doesn't exist in the decoded column it will be Null). Unfortunaly we received this DB from the other team and we can't change the architecture of database, because there are real projects that already use it. It is possible to implement Custom Fields in the more accurate way, but it can't be a subject of discussion...

Ok, you wrote that it is not possible. But, do you know that if we will create Report Server Project, create some datasource based on a some query, then add Reference to the custom assembly, then we can add custom fields to the datasource and use methods from the custom assembly in the Expression and it works! It also requires to deploy (copy) custom assembly to the both folders in 'C:\Program Files\...', one for the Visual Studio and the next one for the SSRS 2005. So, the SSRS support it - it can execute a some set of the predefined functions in the Expression or to call a custom assembly without problems. So, why it doesn't work in the Report Model - I don't know. It is more - Report Model project contains context menu "New Assembly Reference..." in the solution explorer, also there is menu at the top Data->Add Datasource->Object Datasource (this is exactly what I need), but it always crashes after the first click on the Next button. I'm sure - this is a bug. An any report enginemust supports custom code - it is clear. Maybe development team already working on the Sql Server 2008, 2011... and do not have a time to complete existing services...

Please let me know if you have a some ideas, you have more detailed description of my problem now. Also maybe you are related to the development team and you can ask them directly ;) Please note, the database server uses Sql Server 2000, so we can not use a some features like Table-Valued Functions or Managed Code on the server side. Also a custom Data Processing Extension isn't good solution for me (theoretically it is possible to parse command query, and if it is related to the table with decoded column..., but I do not think it is good). Thank you again

|||

Also I have a new question. We moved our database to the SQL Server 2005. We can not use Table-Valued Function (TVF), because our origin table contains more than 200000 records, and TVF haven't access to the Select/Query Parameters (it can be much more powerful in this case), so to create a dynamic table with 200k records and then select 10-20 records for report will be really very bad idea. I created CLR based stored procedure and deployed it to the server, it works, but I don't know how to use it in the Report Model Project, because Data Source View asks only for tables and views... You suggested me to decode columns on the Server Side, my quesion is - how? I already have lost one week and I'm trying to to break an impasse.

|||

Ok, I found solution by myself. As usually it is not possible to receive an answer for non standard/simple question on these forums, even from Microsoft guys. If someone have the same problem - my solution is based on the one CLR based Table-Valued Function (TVF) that accept one parameter (ID of the row) and do all required custom logic, one additional Transact-SQL TVF that use first TVF and feature of the SQL server '... CROSS APPLY ...', actually it selects ID from the real DB table and pass it as the input parameter to the first TVF through CROSS APPLY, and one DB View that selects data from the second Transac-SQL TVF. In the model designer I used this view - it works ;)

Report Layout after deploy

Hi everybody,

I have problem to creating the report using report server. After report degining as report project, the report appeared proper in the layout . But it doesn't show with proper alignment, After deploy this report in the reporting server . How to rectify this.

Please anybody is in, share with your idea.

Good day

What do you mean by alignment ? Make sure that Reporting Services tries to guess (also in the designer) how you want to data to be displayed in the report, meaning that like in excel numeric values are aligned right and string values are aligned left by default.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Try viewing the report as a PDF - sometimes there are differences in the way it is displayed as a web page and PDF.

The PDF may be closer/the same as the way you designed it.

99

|||

It sounds like you have overlapping report items (rather than e.g. an item being contained within another item).

Overlapping items are only supported in PDF, image rendering, and preview, but not in HTML.

-- Robert

|||

Yes, You are right. The controls are overlapped in my report degin . After rectify this, the report display properly. After that, i m facing another problem for using the subreport. it hasn't display properly. If you have any solution, please provide to me

Thanks

Report from ASP.NET datagrid

I'd like to populate a datagrid in my asp.net project and run a report
from the grid. Does anyone have any suggestions on how to do this?
Thanks in advance.You could go the link route and use URL access to access the report or you
could create a viewer page with the report viewer on it and pass the
necessary parameters to it on the query string. How extensible do you need
it to be? Will usability be affected if another page is displayed? What
are security requirements?
"gallan" <gregallan@.tvl.com> wrote in message
news:1147822435.406853.303450@.j55g2000cwa.googlegroups.com...
> I'd like to populate a datagrid in my asp.net project and run a report
> from the grid. Does anyone have any suggestions on how to do this?
> Thanks in advance.
>