How to Determine Data Source Associated with Report

Within report design mode, I can see the DataSet, but I can't tell if this
was created using a Shared Data Source or was it created before I created
and started using a Shared Data Source. I have a problem publishing reports
that used the Shared Data Source. Now I want to check and see how I
originally set the DataSet -- to use the Shared Data Source or not. Any way
to see that?
Thanks,
Boolean1On Mar 1, 1:24 pm, "Boolean1" <Boole...@.comcast.net> wrote:
> Within report design mode, I can see the DataSet, but I can't tell if this
> was created using a Shared Data Source or was it created before I created
> and started using a Shared Data Source. I have a problem publishing reports
> that used the Shared Data Source. Now I want to check and see how I
> originally set the DataSet -- to use the Shared Data Source or not. Any way
> to see that?
> Thanks,
> Boolean1
In the 'Data' tab select the datasets for the report in question and
select the Edit Selected Dataset button [...]. On the 'Query' tab,
below Datasource: is the datasource for the dataset. Select the [...]
button to the right. Near the bottom of the General tab look to see if
'Use shared datasource reference' is checked. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer

How to Deploy the reports automatically in SSRS?

Hi,

I am creating a application to show reports for daily based information.

I have created the reports and i am changing the data source at run time.In order to view the updated reports, i have to deploy.

So i need to deploy the reports automatically.

can any one gave a idea to do this.

thanks

Hi,

You can do this via the RS command.

What you need to do is write a script (.rss) that would serve as an input file to the rs command.

this script should loop through a folder and upload all extension with .rdl

Create a folder in your D: drive for example called RS within that have your script and have a sub folder called reports which were you will have all your reports.

once this has been done go to cmd and do the following

1. Map to your folder ie cd: D:\RS

2. type in the following command

rs -i PublishReports.rss -s http://localhost/reportserver

PublishReports.rss is your script and http://localhost/reportserver is where you want to deploy the reports.

Hope this helps.

|||

Hi,

Thanks for your solution.

It's work fine.

How to Deploy the reports automatically in SSRS?

Hi,

I am creating a application to show reports for daily based information.

I have created the reports and i am changing the data source at run time.In order to view the updated reports, i have to deploy.

So i need to deploy the reports automatically.

can any one gave a idea to do this.

thanks

Hi,

You can do this via the RS command.

What you need to do is write a script (.rss) that would serve as an input file to the rs command.

this script should loop through a folder and upload all extension with .rdl

Create a folder in your D: drive for example called RS within that have your script and have a sub folder called reports which were you will have all your reports.

once this has been done go to cmd and do the following

1. Map to your folder ie cd: D:\RS

2. type in the following command

rs -i PublishReports.rss -s http://localhost/reportserver

PublishReports.rss is your script and http://localhost/reportserver is where you want to deploy the reports.

Hope this helps.

|||

Hi,

Thanks for your solution.

It's work fine.

How to deploy Semantic Models manually?

Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.

But how do you deploy a model file manually to the Reports Server?
When I use 'Upload File' option in Reports Manager and choose the semantic model file (Test.smdl), it gives the following error:

"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "

I tried uploading ds and dsv and also tried merging dsv xml content into smdl. But didn't work.

A reply with how to include DataSourceView element into the model file, will be highly appreciated.Hi All,

I figured it out myself....

The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.

After that, you need to remove all the attributes of the node except the last one (xmlns=http://schemas.microsoft.com/analysisservices/2003/engine), and then add the xsi type attribute (xsi:type="RelationalDataSourceView").

Now you can safely upload this model file to the Report Server using Report Manager and then associate a data source to make it work.
|||This has to be done manually with cutting and pasting? Is there an easier way?
|||Your xsi syntax is slightly incorrect. The valid attribute syntax is:

xmlns:xsi="RelationalDataSourceView"

Combining this with your previous instruction yeilds the following element declaration:
<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">
|||

The tool that helps me out is located at http://www.sqldbatips.com/showarticle.asp?ID=62. It creates the scripts and you can tweak them to do single deployments for any model component.

R

|||

None of this is working. when i try to save the model it asks me to save twice. then when i go back to smdl file i dont the changes, i see the old smdl that i had before pasting the datasourview node.

How to deploy Semantic Models manually?

Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.

But how do you deploy a model file manually to the Reports Server?
When I use 'Upload File' option in Reports Manager and choose the semantic model file (Test.smdl), it gives the following error:

"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "

I tried uploading ds and dsv and also tried merging dsv xml content into smdl. But didn't work.

A reply with how to include DataSourceView element into the model file, will be highly appreciated.Hi All,

I figured it out myself....

The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.

After that, you need to remove all the attributes of the node except the last one (xmlns=http://schemas.microsoft.com/analysisservices/2003/engine), and then add the xsi type attribute (xsi:type="RelationalDataSourceView").

Now you can safely upload this model file to the Report Server using Report Manager and then associate a data source to make it work.
|||This has to be done manually with cutting and pasting? Is there an easier way?
|||Your xsi syntax is slightly incorrect. The valid attribute syntax is:

xmlns:xsi="RelationalDataSourceView"

Combining this with your previous instruction yeilds the following element declaration:
<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">
|||

The tool that helps me out is located at http://www.sqldbatips.com/showarticle.asp?ID=62. It creates the scripts and you can tweak them to do single deployments for any model component.

R

|||

None of this is working. when i try to save the model it asks me to save twice. then when i go back to smdl file i dont the changes, i see the old smdl that i had before pasting the datasourview node.

How to deploy Semantic Models manually?

Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.

But how do you deploy a model file manually to the Reports Server?
When I use 'Upload File' option in Reports Manager and choose the semantic model file (Test.smdl), it gives the following error:

"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "

I tried uploading ds and dsv and also tried merging dsv xml content into smdl. But didn't work.

A reply with how to include DataSourceView element into the model file, will be highly appreciated.Hi All,

I figured it out myself....

The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.

After that, you need to remove all the attributes of the node except the last one (xmlns=http://schemas.microsoft.com/analysisservices/2003/engine), and then add the xsi type attribute (xsi:type="RelationalDataSourceView").

Now you can safely upload this model file to the Report Server using Report Manager and then associate a data source to make it work.|||This has to be done manually with cutting and pasting? Is there an easier way?|||Your xsi syntax is slightly incorrect. The valid attribute syntax is:

xmlns:xsi="RelationalDataSourceView"

Combining this with your previous instruction yeilds the following element declaration:
<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">|||

The tool that helps me out is located at http://www.sqldbatips.com/showarticle.asp?ID=62. It creates the scripts and you can tweak them to do single deployments for any model component.

R

|||

None of this is working. when i try to save the model it asks me to save twice. then when i go back to smdl file i dont the changes, i see the old smdl that i had before pasting the datasourview node.

How to deploy Semantic Models manually?

Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.

But how do you deploy a model file manually to the Reports Server?
When I use 'Upload File' option in Reports Manager and choose the semantic model file (Test.smdl), it gives the following error:

"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "

I tried uploading ds and dsv and also tried merging dsv xml content into smdl. But didn't work.

A reply with how to include DataSourceView element into the model file, will be highly appreciated.Hi All,

I figured it out myself....

The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.

After that, you need to remove all the attributes of the node except the last one (xmlns=http://schemas.microsoft.com/analysisservices/2003/engine), and then add the xsi type attribute (xsi:type="RelationalDataSourceView").

Now you can safely upload this model file to the Report Server using Report Manager and then associate a data source to make it work.|||This has to be done manually with cutting and pasting? Is there an easier way?|||Your xsi syntax is slightly incorrect. The valid attribute syntax is:

xmlns:xsi="RelationalDataSourceView"

Combining this with your previous instruction yeilds the following element declaration:
<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">|||

The tool that helps me out is located at http://www.sqldbatips.com/showarticle.asp?ID=62. It creates the scripts and you can tweak them to do single deployments for any model component.

R

|||

None of this is working. when i try to save the model it asks me to save twice. then when i go back to smdl file i dont the changes, i see the old smdl that i had before pasting the datasourview node.

How to deploy report in C# with ADO XML datasources

HI,

i m creating CR in C# and ADO.net XML file as data source. my application is calling CR in exe file for viewing report. although i hav work out the setup and deployment project, yet its still need to install Crystalreport in MS.Visual studio 2003.

any others way to solve this problem?

plz don hesitate to reply me k.

emiliecan you please clarify the question? You don't know what you need to package to get crystal working on the deployment machine?

How to deploy report from QA to PROD without changing data source

Hi. I love the time-saving features of Reporting Services. I desing my report
in VS2005. Then deploy them to my QA server and, when that passes testing,
put it into my PROD environment. That all works very nicely.
I have defined 2 data sources, one for QA and one for PROD. What gets to me
is that after deploying to QA I have to go into Report Manager and select the
QA data source for each of my reports. Then, once deployed to PROD I have to
do the same. This becomes a major headache when I have to make many small
changes to a report and repeat the process each time.
Is there a way to specify an alias of some form that can point to my
development server data source when on my machine, and to the appropriate
databases when on QA and PROD?
Thanks.It's not exactly clear but do you have 2 shared datasources? If so why? If
you have a shared datasource on your QA server and one on your PROD server
with the same name and location (and the same as in your project) then you
wouldn't have to do this. When reports are deployed to qa/prod they would
just work. A shared datasource seems to be exactly what you want but from
the sound of it you are already using one?
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Mike Kelly" <MikeKelly@.community.nospam> wrote in message
news:14B8552A-AFB7-42C9-AB9B-9F70A8D44763@.microsoft.com...
> Hi. I love the time-saving features of Reporting Services. I desing my
> report
> in VS2005. Then deploy them to my QA server and, when that passes testing,
> put it into my PROD environment. That all works very nicely.
> I have defined 2 data sources, one for QA and one for PROD. What gets to
> me
> is that after deploying to QA I have to go into Report Manager and select
> the
> QA data source for each of my reports. Then, once deployed to PROD I have
> to
> do the same. This becomes a major headache when I have to make many small
> changes to a report and repeat the process each time.
> Is there a way to specify an alias of some form that can point to my
> development server data source when on my machine, and to the appropriate
> databases when on QA and PROD?
> Thanks.|||We do what Jasper is suggesting.
We create a data source (maybe called Prod) in the project. The first time
we deploy, we go into report manager and change the connection information to
whatever it needs to be. Since redeployment does NOT change the connection (
unless you change the config), everything works fine.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Mike Kelly" wrote:
> Hi. I love the time-saving features of Reporting Services. I desing my report
> in VS2005. Then deploy them to my QA server and, when that passes testing,
> put it into my PROD environment. That all works very nicely.
> I have defined 2 data sources, one for QA and one for PROD. What gets to me
> is that after deploying to QA I have to go into Report Manager and select the
> QA data source for each of my reports. Then, once deployed to PROD I have to
> do the same. This becomes a major headache when I have to make many small
> changes to a report and repeat the process each time.
> Is there a way to specify an alias of some form that can point to my
> development server data source when on my machine, and to the appropriate
> databases when on QA and PROD?
> Thanks.|||Thanks Jasper and Wayne.
I am using shared data sources, but incorrectly. I was deploying them each
time. But was blind as to their inteded use. The word "Shared" threw me off
course. Now I see. I'll replace the two I was using (one for test and one for
prod) with a single one (since I only have a single database) and change the
definition for that one depeding on the environment it is running in. So
simple, once you get it!
"Wayne Snyder" wrote:
> We do what Jasper is suggesting.
> We create a data source (maybe called Prod) in the project. The first time
> we deploy, we go into report manager and change the connection information to
> whatever it needs to be. Since redeployment does NOT change the connection (
> unless you change the config), everything works fine.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Mike Kelly" wrote:
> > Hi. I love the time-saving features of Reporting Services. I desing my report
> > in VS2005. Then deploy them to my QA server and, when that passes testing,
> > put it into my PROD environment. That all works very nicely.
> >
> > I have defined 2 data sources, one for QA and one for PROD. What gets to me
> > is that after deploying to QA I have to go into Report Manager and select the
> > QA data source for each of my reports. Then, once deployed to PROD I have to
> > do the same. This becomes a major headache when I have to make many small
> > changes to a report and repeat the process each time.
> >
> > Is there a way to specify an alias of some form that can point to my
> > development server data source when on my machine, and to the appropriate
> > databases when on QA and PROD?
> >
> > Thanks.

How to deploy a custom component?

Hi

I developed a “data flow source” in my computer and it is ready!

It works in my computer, but how do I deploy this component in to the server? I have any programming environment on it.

Any Idea?

You will have to register it with the new computers GAC.

Here is a pretty good article on developing and registering a custom component (you will have to register with the web site but it is free):

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/2795/

how to delete object Data Source for local (rdlc) report?

I've created a couple of data sources and now would like to remove one on a local (*.rdlc) report, how do I go about doing this? Just to clarify, these data sources are for a local report in a smart client application (report made in VS2005 Report Designer, and not SQL Server 2005 Report Designer), they are found in the report's Data Sources window (not the applications) and can be accessed/assigned by the local report (Report > Data Sources...) - where you can remove the data source from being on the report, but not completely remove from the project.

Any help is appreciated.
Thanks.
PeterSorry, it was a newbie question. Found why I couldn't delete the extra data source, it was an XSD data source that I created outside of the Data Source folder, and simply lost track of it.

How to define programatically the width for columns?

Hi everyone,

Either Sql2k or Sql25k are targeted if you answer to this thread. When we have source/destination files we usually wish to define its properties, the width for each field and so on. My question is related with this, how do such by-hand tasks via scripting inside the own ETL? Tedious tasks are if there are more than 20 columns.

Is it possible? I think so regarding 2005 but about 2000 I haven't idea at all how to begin. Issue comes when one programmer must alter lots of columns due to for example, a new file format from mainframe is released.

Thanks in advance for your time or advices,

Any ideas?