Report Organization

I am taking over a RS solution from an ex employee and looking for some
report organization help.
I see you can have a shared datasource with RS.
In the solution there are about 20 projects. Each project contains reports
that are displayed in a folder seen off Report Manager. Is this the proper
way to organize reports -- through projects? Is there a way to have
IIS/Report Manager folder structure to appear in the solution explorer?
Or do you have to create the structure manually? Any help would be
appreciated.
Thanks.Yes very much the right way for you to maintain is using "Projects", moreover
I suggest you can add one more thing as well. i.e. Source control like VSS
integration so that all your reports are very well managed. Regarding your
2nd question it is a "No".
Amarnath
"Brian Shannon" wrote:
> I am taking over a RS solution from an ex employee and looking for some
> report organization help.
> I see you can have a shared datasource with RS.
> In the solution there are about 20 projects. Each project contains reports
> that are displayed in a folder seen off Report Manager. Is this the proper
> way to organize reports -- through projects? Is there a way to have
> IIS/Report Manager folder structure to appear in the solution explorer?
> Or do you have to create the structure manually? Any help would be
> appreciated.
> Thanks.
>
>

Report Model/Datasource View, Primary Data Source Problem

I have a datasource view DSV1. It points to a datasource DS1 that is considered the "primary".

I have created a Report Model that uses DSV1 (and thus uses DS1)

I created a new datasource, DS2 that I would like to use instead of DS1. (I can't just modify DS1 because if I modify it, it will overwrite it when we go to our Production environment and break that datasource)

So, I can go into DSV1 and change all the references from DS1 to DS2.

But that's where the problem lies.

When I try to build, I get the following error:

"The Table property of the Entity "E1" refers to the Table "dbo_View", which is not in the primary data source."

Somehow, the entity is tied to the "primary" datasource. When I change it back to DS1, everything works fine. Any thoughts? What can I do?

Here is what I've noticed:

If I look at the code for the Data Source DS1, the XML shows an <ID> tag and a <NAME> tag.

In SSRS, it is requiring that the ID be named "DS1", but the name can be whatever I want.

So if I change the name, it looks like I can deploy no problem without overwriting my old Datasource, but I just wish I could have these two pieces updated without a problem.

Any idea why this is?

Report Model with XML datasource

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.

JDee,

Here's a link for setting the Report Service XML datasource. I hope this works for you.

http://msdn2.microsoft.com/en-us/library/ms345334.aspx

Ham

|||I'm interested in the same possibility. As far as I've understood, it's possible to generate models only from relational data sources. It would be a great surprise for me if not.|||RS 2005 supports only SQL Server (2000 and up), Analysis Services 2005 and starting with SP2 Oracle as data sources.|||Yes, from my understanding models are generated from relational data sources. I believe XML can represent relational database (http://www.w3.org/XML/RDB.html). I think a data provider which supplies XML as data source would be a neat feature in the upcoming versions.

Report Model with XML datasource

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.

JDee,

Here's a link for setting the Report Service XML datasource. I hope this works for you.

http://msdn2.microsoft.com/en-us/library/ms345334.aspx

Ham

|||I'm interested in the same possibility. As far as I've understood, it's possible to generate models only from relational data sources. It would be a great surprise for me if not.|||RS 2005 supports only SQL Server (2000 and up), Analysis Services 2005 and starting with SP2 Oracle as data sources.|||Yes, from my understanding models are generated from relational data sources. I believe XML can represent relational database (http://www.w3.org/XML/RDB.html). I think a data provider which supplies XML as data source would be a neat feature in the upcoming versions.

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 as datasource in ordinary report

I think the report model concept is great and it works well for the report
builder. Can a report model or a data source view be used as a datasource for
ordinary reports? We have a large number of reports built upon complex
relational queries (join join join join...), but pretty much the same query
for all the reports. One way of solving this is by building an olap cube, but
the thing is that all this reports are automaticly genererated from a
"backroom" database for quality checking and then all the data is loaded into
a final datawarehouse. But maybe it's possibel to do this without a cube in
the backroom.OK, I've figured it out myself. A report model can definitly be the data
source for a report and it works very well, actually!
"Erik Hedlund" wrote:
> I think the report model concept is great and it works well for the report
> builder. Can a report model or a data source view be used as a datasource for
> ordinary reports? We have a large number of reports built upon complex
> relational queries (join join join join...), but pretty much the same query
> for all the reports. One way of solving this is by building an olap cube, but
> the thing is that all this reports are automaticly genererated from a
> "backroom" database for quality checking and then all the data is loaded into
> a final datawarehouse. But maybe it's possibel to do this without a cube in
> the backroom.|||I didn't think that it could be, can you clue me in?
"Erik Hedlund" <ErikHedlund@.discussions.microsoft.com> wrote in message
news:EB83FAA1-FCE7-4A89-8125-18FEB3C71489@.microsoft.com...
> OK, I've figured it out myself. A report model can definitly be the data
> source for a report and it works very well, actually!
> "Erik Hedlund" wrote:
>> I think the report model concept is great and it works well for the
>> report
>> builder. Can a report model or a data source view be used as a datasource
>> for
>> ordinary reports? We have a large number of reports built upon complex
>> relational queries (join join join join...), but pretty much the same
>> query
>> for all the reports. One way of solving this is by building an olap cube,
>> but
>> the thing is that all this reports are automaticly genererated from a
>> "backroom" database for quality checking and then all the data is loaded
>> into
>> a final datawarehouse. But maybe it's possibel to do this without a cube
>> in
>> the backroom.|||Create a data source, a datasource view and a report model and deply it to
the report server.
Create a report and select report model as the data source and specify a
connectionstring for it. Example:
server=http://localhost/reportserver;datasource=/Models/name of report model
And then your on!
"Steve MunLeeuw" wrote:
> I didn't think that it could be, can you clue me in?
> "Erik Hedlund" <ErikHedlund@.discussions.microsoft.com> wrote in message
> news:EB83FAA1-FCE7-4A89-8125-18FEB3C71489@.microsoft.com...
> > OK, I've figured it out myself. A report model can definitly be the data
> > source for a report and it works very well, actually!
> >
> > "Erik Hedlund" wrote:
> >
> >> I think the report model concept is great and it works well for the
> >> report
> >> builder. Can a report model or a data source view be used as a datasource
> >> for
> >> ordinary reports? We have a large number of reports built upon complex
> >> relational queries (join join join join...), but pretty much the same
> >> query
> >> for all the reports. One way of solving this is by building an olap cube,
> >> but
> >> the thing is that all this reports are automaticly genererated from a
> >> "backroom" database for quality checking and then all the data is loaded
> >> into
> >> a final datawarehouse. But maybe it's possibel to do this without a cube
> >> in
> >> the backroom.
>
>sql

report model and it's datasource

hi 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

If there is no primary key defined, you can build the model, but no contents. Do you have primary key defined?sql

Report Model - Custom DataSource

Hi!
We have implemented a custom DataProcessingExtension for Reporting Services
2005.
Now we want to implement a Report Model based on this DataProcessingExtension
(for the usage in ReportBuilder).
Can can I accomplish this, because as the documentation says you can only
create a Report Model based on a SQL Server database or Analysis Server database?
Thanks for your help
Klaus Aschenbrenner
www.csharp.at
http://www.sqljunkies.com/weblog/klaus.aschenbrenneHi Klaus,
Were you ever able to make your custom DataProcessingExtension support
Report Models?
I'd be interested in hearing how it went...
Jeremy Wiebe
Klaus Aschenbrenner wrote:
> Hi!
> We have implemented a custom DataProcessingExtension for Reporting Services
> 2005.
> Now we want to implement a Report Model based on this DataProcessingExtension
> (for the usage in ReportBuilder).
> Can can I accomplish this, because as the documentation says you can only
> create a Report Model based on a SQL Server database or Analysis Server database?
> Thanks for your help
> Klaus Aschenbrenner
> www.csharp.at
> http://www.sqljunkies.com/weblog/klaus.aschenbrenner

Report Manager

Hello
I have developed couple of reports. I am using Sql Server 2000 as datasource
and which is at other machine and not on the development machine.
When I try to access report from my machine I can access the reports using
either http://mycomputerIP/Reports or http://mycomputerIp/RerportServer
I can access the reports.
When the other users try to access reports from their machine, I dont know
somehow they can not access the report using
http://mycomputerIP/Reports
User can see the consol but when they hit the report they gets the error of
page can not be displayed.
What could be the reason for this?
I am running sharepoint on my machine.
I would appreciate if someone could help me here.
Thanks
AmeetIf you have installed Rs on a machine with Sharepoint you must have theses
considerations.
ms-help://MS.RSBOL80.1033/rsadmin/htm/drp_deploying_v1_0lmh.htm
Fernando Hunth
Senior Developer
Huddle Group S.A.
fernando@.huddle.com.ar
Huddle Group S.A. | Enterprise Technology Services
Microsoft Certified Partner
Ciudad de Buenos Aires · Argentina
www.huddle.com.ar
"Ameet" wrote:
> Hello
> I have developed couple of reports. I am using Sql Server 2000 as datasource
> and which is at other machine and not on the development machine.
> When I try to access report from my machine I can access the reports using
> either http://mycomputerIP/Reports or http://mycomputerIp/RerportServer
> I can access the reports.
> When the other users try to access reports from their machine, I dont know
> somehow they can not access the report using
> http://mycomputerIP/Reports
> User can see the consol but when they hit the report they gets the error of
> page can not be displayed.
> What could be the reason for this?
> I am running sharepoint on my machine.
> I would appreciate if someone could help me here.
> Thanks
> Ameet
>

Report item expression can only refer to fields within the current data set scope

I switched my reports datasource and made sure the new query outputs
the same fields. However i now get this error...
Report item expression can only refer to fields within the current
data set scope or, if inside an aggregate, the specified data set
scope
I've checked everywhere to confirm I'm pointing to the right dataset
and I am.On Oct 10, 9:09 pm, jobs <j...@.webdos.com> wrote:
> I switched my reports datasource and made sure the new query outputs
> the same fields. However i now get this error...
> Report item expression can only refer to fields within the current
> data set scope or, if inside an aggregate, the specified data set
> scope
> I've checked everywhere to confirm I'm pointing to the right dataset
> and I am.
You might want to select the Refresh icon in the Data view. Also, if
you are using a parameter in the dataset, you will want to make sure
that it is mapped correctly (via the Data view >> Edit Selected
Dataset [...] >> Parameters tab). Another thing to check is to make
sure that you did not accidentally misspell one of the dataset fields
since the previous dataset. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant