pros and cons of using transaction replication doing initialization from database backups

I am using transaction replication between a transaction and reporting database server. When I use a snapshot to initialize my subscribers, I currently get a lot of deadlocks during the snapshot creation. I am considering using a database backup instead. Can anyone tells me how to reduce the table locks that I am getting during snapshot creation or advice on using database backups?

Hi,

Transactional replication provides several different sync method to help alleviate locking issue on publication DB. You can take a look at @.sync_method in sp_addpublication (http://msdn2.microsoft.com/en-us/library/ms188738.aspx).

You can try with concurrent/concurrent_c. And if you are using SQL 2005 SP2 and you are using enterprise edition, you can also use "database snapshot/database snapshot character". Snapshot agent creates a DB snapshot on the publication DB and then generates replication snapshot based on the DB snapshot. So it significantly reduces the possiblities of deadlocking on the publication DB.

Peng

property probelm

We have a development machine, and a web server, both running SQL Reporting
Services. My problem is that when I move reports from the development machine
to the server, they lose properties, like font and can grow setttings. Please
help me identify the problem.
--
Thanks,
CGWNever mind... I was just missing a font on the other machine.
"CGW" wrote:
> We have a development machine, and a web server, both running SQL Reporting
> Services. My problem is that when I move reports from the development machine
> to the server, they lose properties, like font and can grow setttings. Please
> help me identify the problem.
> --
> Thanks,
> CGW

Prompting for userid and password

Hi,
I have a web application which is calling a reporting services URL to load
couple of reports.
The web server is on Machine A and the reporting services and the SQL Server
are on Machine B.
Both the Machines A and B are not on any domain...
But when I log into my website and then try to generate a report, the web
application is popping up an prompt to enter the userid and password.
When U enter the userdid and password of the machine B, I am to view my
reports.
Can anyone please help me in resolving the above issue, where the user would
not want to enter the userid and password.Check the Reporting Services virtual directories in IIS. If they are not
setup with "Enable anonymous access", you need to enable this.
Kaisa M. Lindahl Lervik
"Ashok Segu" <Ashok Segu@.discussions.microsoft.com> wrote in message
news:99B66025-A1E6-49A1-8BFB-0E7B78A92189@.microsoft.com...
> Hi,
> I have a web application which is calling a reporting services URL to load
> couple of reports.
> The web server is on Machine A and the reporting services and the SQL
> Server
> are on Machine B.
> Both the Machines A and B are not on any domain...
> But when I log into my website and then try to generate a report, the web
> application is popping up an prompt to enter the userid and password.
> When U enter the userdid and password of the machine B, I am to view my
> reports.
> Can anyone please help me in resolving the above issue, where the user
> would
> not want to enter the userid and password.|||Add the url of the SSRS services to your "Trusted Sites" in Internet
Options. Surprisingly this works.
Ashok Segu wrote:
> Hi,
> I have a web application which is calling a reporting services URL to load
> couple of reports.
> The web server is on Machine A and the reporting services and the SQL Server
> are on Machine B.
> Both the Machines A and B are not on any domain...
> But when I log into my website and then try to generate a report, the web
> application is popping up an prompt to enter the userid and password.
> When U enter the userdid and password of the machine B, I am to view my
> reports.
> Can anyone please help me in resolving the above issue, where the user would
> not want to enter the userid and password.

Prompting a User ID and Pwd

Hi,
I am developing reports using Reporting Server.With these reports i am
going to run in ASP.Net, but its prompting SQL Server User ID and Password.
Can any one knows the solution for without prompting the User ID and Password.
Is this Possible?
Regards,
Mallihi,
while creating the Data source , in the credentials give
ur sqlserver database username and passwork. and chk the
button allow saving password. then it will not ask u for
any password
>--Original Message--
>Hi,
> I am developing reports using Reporting Server.With
these reports i am
>going to run in ASP.Net, but its prompting SQL Server
User ID and Password.
>Can any one knows the solution for without prompting the
User ID and Password.
>Is this Possible?
>Regards,
>Malli
>
>.
>|||Hi,
I tried as you said, but its not working.whenever i am running the report
in browser it prompts user id and password.can you give me the solution.
Thanking you.
Regards,
Malli.
"anonymous@.discussions.microsoft.com" wrote:
> hi,
> while creating the Data source , in the credentials give
> ur sqlserver database username and passwork. and chk the
> button allow saving password. then it will not ask u for
> any password
> >--Original Message--
> >Hi,
> > I am developing reports using Reporting Server.With
> these reports i am
> >going to run in ASP.Net, but its prompting SQL Server
> User ID and Password.
> >Can any one knows the solution for without prompting the
> User ID and Password.
> >
> >Is this Possible?
> >
> >Regards,
> >Malli
> >
> >
> >
> >.
> >
>

prompted for the Reporting Service CD

I am having trouble installing SQL Server Reporting Service SP1 I get
prompted for the Reporting Service CD which I put in but it then
claims it cant find the MSI '
Any ideasTry this:
Run set from a cmd window and pass sp1 setup a /x flag. This will extract
the files to the hard drive. After this run sp1setup.exe.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter" <peter.freeborn@.halliburton.com> wrote in message
news:2006656e.0407120731.5795bce4@.posting.google.com...
> I am having trouble installing SQL Server Reporting Service SP1 I get
> prompted for the Reporting Service CD which I put in but it then
> claims it cant find the MSI '
> Any ideas

Prompt page in SSRS

Hi,

I checked in SQL Server Reporting Services and it has the option to create only the reports. How do I create any prompt page from SSRS? Is it possible to do it? Thank You.

Regards,

Das.

What do you mean by prompt page ? Asking for some parameters before rendering the report ? That can be done by clicking in the background of the report and navigating through report parameters.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Project structure when using RepSvcs

Hi,
I have a WinForm project in VS .NET and need to incorporate Reporting
Services.
The application will display the reports to the users on a form with an IE
control.
Is it possible to add the report items to the application project? or
Must I create a separate project of type report and have the reports there?
How could the reports be invoked by the application?
Thanks in advance,
RichardIf you are using IE control you have only one choice. One, the reports need
to be in their own project. Two, they have to be deployed to a server in
order to test your links.
As far as invoking the reports, it confuses me. You stated that you are
using the IE control. The only way to use this control is doing URL
integration. All you are doing is assembling a string and setting the URL
property for the control.
I guess in a convoluted way you could use web services, stream the html to a
file and give the IE control a
If you are using VS.Net 2005 then look at the new controls. There is a
winform and webform controls. The new winform control is a much better way
of integrating reports (I am using it in a Winform application. I use IE
control in a In-Touch application... real time control user interface).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:F4FA857A-45A2-4158-A1ED-C238D66D6CD2@.microsoft.com...
> Hi,
> I have a WinForm project in VS .NET and need to incorporate Reporting
> Services.
> The application will display the reports to the users on a form with an IE
> control.
> Is it possible to add the report items to the application project? or
> Must I create a separate project of type report and have the reports
> there?
> How could the reports be invoked by the application?
> Thanks in advance,
> Richard|||Sorry Bruce, I meant a ReportViewer control on a WinForm.
"Bruce L-C [MVP]" wrote:
> If you are using IE control you have only one choice. One, the reports need
> to be in their own project. Two, they have to be deployed to a server in
> order to test your links.
> As far as invoking the reports, it confuses me. You stated that you are
> using the IE control. The only way to use this control is doing URL
> integration. All you are doing is assembling a string and setting the URL
> property for the control.
> I guess in a convoluted way you could use web services, stream the html to a
> file and give the IE control a
> If you are using VS.Net 2005 then look at the new controls. There is a
> winform and webform controls. The new winform control is a much better way
> of integrating reports (I am using it in a Winform application. I use IE
> control in a In-Touch application... real time control user interface).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:F4FA857A-45A2-4158-A1ED-C238D66D6CD2@.microsoft.com...
> > Hi,
> >
> > I have a WinForm project in VS .NET and need to incorporate Reporting
> > Services.
> > The application will display the reports to the users on a form with an IE
> > control.
> > Is it possible to add the report items to the application project? or
> > Must I create a separate project of type report and have the reports
> > there?
> > How could the reports be invoked by the application?
> >
> > Thanks in advance,
> >
> > Richard
>
>|||Ahhh, HUGE difference. There are two ways to use the Winform control: server
and local mode.
Server mode, develop your reports in a reports project, separately. Test out
your report there, deploy and then integrate with Winform control (which is
what I do).
Local mode. Develop report initially in a reports project. Test out report.
Copy rdl file, renaming it to rdlc. Bring the rdlc into your winform
project. Note that you do have much more to do to get full functionality of
a report in local mode. It is nowhere near as simple as integrating in a
report which is deployed to a server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:5820FB57-5FC6-4742-A571-1531CC73E4E0@.microsoft.com...
> Sorry Bruce, I meant a ReportViewer control on a WinForm.
> "Bruce L-C [MVP]" wrote:
>> If you are using IE control you have only one choice. One, the reports
>> need
>> to be in their own project. Two, they have to be deployed to a server in
>> order to test your links.
>> As far as invoking the reports, it confuses me. You stated that you are
>> using the IE control. The only way to use this control is doing URL
>> integration. All you are doing is assembling a string and setting the URL
>> property for the control.
>> I guess in a convoluted way you could use web services, stream the html
>> to a
>> file and give the IE control a
>> If you are using VS.Net 2005 then look at the new controls. There is a
>> winform and webform controls. The new winform control is a much better
>> way
>> of integrating reports (I am using it in a Winform application. I use IE
>> control in a In-Touch application... real time control user interface).
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:F4FA857A-45A2-4158-A1ED-C238D66D6CD2@.microsoft.com...
>> > Hi,
>> >
>> > I have a WinForm project in VS .NET and need to incorporate Reporting
>> > Services.
>> > The application will display the reports to the users on a form with an
>> > IE
>> > control.
>> > Is it possible to add the report items to the application project? or
>> > Must I create a separate project of type report and have the reports
>> > there?
>> > How could the reports be invoked by the application?
>> >
>> > Thanks in advance,
>> >
>> > Richard
>>

Project Hierarchy and Shared Data Sources

Our desires might be misguided, so I would like to hear what some of the more
learned members have to say:
Issue 1:
It appears that Reporting Services supports a folder paradigm that nicely
models how we desire to organize our reports. However, this folder paradigm
is not supported in Visual Studio .NET. In other words, it does not appear
that I can construct a VS.NET solution that contains folders and sub folders
that describe a tree structure.
While the VS.NET solution is â'flatâ' I can however modify the Properties of
each Report Project and set TargetFolder such that as the projects are
deployed they end up in a hierarchy on the report server.
My question is this: Have any of you â'seenâ' this condition and if so, what
have you learned or what have you done about it? Did you perhaps adopt the
same approach as I, accepting the VS .NET solution structure as â'flatâ' and
use the TargetFolder property to achieve the desired hierarchy on the report
server?
Issue 2:
We desire to use a single shared data source for all of our reports. A
shared data source is contained in a given Report Project. There does not
seem to be a way that I can use one projectâ's shared data source in another
projectâ's report. If we consider the hierarchical folder paradigm described
in Issue 1 (above), it seems the only solution is to establish the same
shared data source in each and every Report Project I create.
I suppose alternatively, that I could dispense with attempting to use a
shared data source entirely. Rather, I would just imbed the same data source
into each and every report developed. My thinking here is somewhat an issue
of reuse/maintenance. If I only need one, I donâ't feel I should have to have
more than one instance across the entire Report Server. This may be contrary
to some of the larger scale objectives of Reporting Services, where perhaps
it is desired that different folders access different data using different
credentials and whatnot. At present, we donâ't even name a real DB Server in
the Connection String, but rather a logical name, which is handled via an
Alias that is established on each of our target environments (Dev, QA,
Staging, Beta, Production) such that the deployed reports/data sources will
point to their appropriate DB.
My question here is: Is it possible to use a single shared data source
across many individual report projects without having to physically copy that
shared data source to each project?You are correct on Issue 1. I have just organized my projects for a 1 to 1
relationship with the folders but if you want the folders organized in a
tree you have to do as you mention here. For SQL Server I just put in the
connection but for other data sources (like Sybase) I put in a file dsn.
For example: FILEDSN=C:\Data\Reports\IWTS\development.dsn
Bruce Loehle-Conger
MVP SQL Server Reporting Services
For Issue number 2 I do the following. Yes I have to have a shared
datasource created for each folder BUT the actual
"Herman K" <HermanK@.discussions.microsoft.com> wrote in message
news:70D2647C-D786-4A5D-80B8-B713B69EAC4A@.microsoft.com...
> Our desires might be misguided, so I would like to hear what some of the
more
> learned members have to say:
> Issue 1:
> It appears that Reporting Services supports a folder paradigm that nicely
> models how we desire to organize our reports. However, this folder
paradigm
> is not supported in Visual Studio .NET. In other words, it does not
appear
> that I can construct a VS.NET solution that contains folders and sub
folders
> that describe a tree structure.
> While the VS.NET solution is 'flat' I can however modify the Properties of
> each Report Project and set TargetFolder such that as the projects are
> deployed they end up in a hierarchy on the report server.
> My question is this: Have any of you 'seen' this condition and if so, what
> have you learned or what have you done about it? Did you perhaps adopt
the
> same approach as I, accepting the VS .NET solution structure as 'flat' and
> use the TargetFolder property to achieve the desired hierarchy on the
report
> server?
> Issue 2:
> We desire to use a single shared data source for all of our reports. A
> shared data source is contained in a given Report Project. There does not
> seem to be a way that I can use one project's shared data source in
another
> project's report. If we consider the hierarchical folder paradigm
described
> in Issue 1 (above), it seems the only solution is to establish the same
> shared data source in each and every Report Project I create.
> I suppose alternatively, that I could dispense with attempting to use a
> shared data source entirely. Rather, I would just imbed the same data
source
> into each and every report developed. My thinking here is somewhat an
issue
> of reuse/maintenance. If I only need one, I don't feel I should have to
have
> more than one instance across the entire Report Server. This may be
contrary
> to some of the larger scale objectives of Reporting Services, where
perhaps
> it is desired that different folders access different data using different
> credentials and whatnot. At present, we don't even name a real DB Server
in
> the Connection String, but rather a logical name, which is handled via an
> Alias that is established on each of our target environments (Dev, QA,
> Staging, Beta, Production) such that the deployed reports/data sources
will
> point to their appropriate DB.
> My question here is: Is it possible to use a single shared data source
> across many individual report projects without having to physically copy
that
> shared data source to each project?
>|||Bruce, did you have a 'finished' reply to my second issue? It seems you got
cut off midstream. I see you said that I would need the datasource to be
present in each folder but...
"Bruce L-C [MVP]" wrote:
> You are correct on Issue 1. I have just organized my projects for a 1 to 1
> relationship with the folders but if you want the folders organized in a
> tree you have to do as you mention here. For SQL Server I just put in the
> connection but for other data sources (like Sybase) I put in a file dsn.
> For example: FILEDSN=C:\Data\Reports\IWTS\development.dsn
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> For Issue number 2 I do the following. Yes I have to have a shared
> datasource created for each folder BUT the actual
> "Herman K" <HermanK@.discussions.microsoft.com> wrote in message
> news:70D2647C-D786-4A5D-80B8-B713B69EAC4A@.microsoft.com...
> > Our desires might be misguided, so I would like to hear what some of the
> more
> > learned members have to say:
> >
> > Issue 1:
> >
> > It appears that Reporting Services supports a folder paradigm that nicely
> > models how we desire to organize our reports. However, this folder
> paradigm
> > is not supported in Visual Studio .NET. In other words, it does not
> appear
> > that I can construct a VS.NET solution that contains folders and sub
> folders
> > that describe a tree structure.
> >
> > While the VS.NET solution is 'flat' I can however modify the Properties of
> > each Report Project and set TargetFolder such that as the projects are
> > deployed they end up in a hierarchy on the report server.
> >
> > My question is this: Have any of you 'seen' this condition and if so, what
> > have you learned or what have you done about it? Did you perhaps adopt
> the
> > same approach as I, accepting the VS .NET solution structure as 'flat' and
> > use the TargetFolder property to achieve the desired hierarchy on the
> report
> > server?
> >
> > Issue 2:
> >
> > We desire to use a single shared data source for all of our reports. A
> > shared data source is contained in a given Report Project. There does not
> > seem to be a way that I can use one project's shared data source in
> another
> > project's report. If we consider the hierarchical folder paradigm
> described
> > in Issue 1 (above), it seems the only solution is to establish the same
> > shared data source in each and every Report Project I create.
> >
> > I suppose alternatively, that I could dispense with attempting to use a
> > shared data source entirely. Rather, I would just imbed the same data
> source
> > into each and every report developed. My thinking here is somewhat an
> issue
> > of reuse/maintenance. If I only need one, I don't feel I should have to
> have
> > more than one instance across the entire Report Server. This may be
> contrary
> > to some of the larger scale objectives of Reporting Services, where
> perhaps
> > it is desired that different folders access different data using different
> > credentials and whatnot. At present, we don't even name a real DB Server
> in
> > the Connection String, but rather a logical name, which is handled via an
> > Alias that is established on each of our target environments (Dev, QA,
> > Staging, Beta, Production) such that the deployed reports/data sources
> will
> > point to their appropriate DB.
> >
> > My question here is: Is it possible to use a single shared data source
> > across many individual report projects without having to physically copy
> that
> > shared data source to each project?
> >
>
>|||To answer your second question, yes you can have the same data source for
mutliple reports in multiple folders, but you need to connect each report to
the data source individually after you publish. You can either do this
manually or write a script. I haven't written a script yet to do this yet,
but someone here might have a code example.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Herman K" <HermanK@.discussions.microsoft.com> wrote in message
news:CAB6F427-B5FD-4711-8CB2-7865E992345C@.microsoft.com...
> Bruce, did you have a 'finished' reply to my second issue? It seems you
> got
> cut off midstream. I see you said that I would need the datasource to be
> present in each folder but...
> "Bruce L-C [MVP]" wrote:
>> You are correct on Issue 1. I have just organized my projects for a 1 to
>> 1
>> relationship with the folders but if you want the folders organized in a
>> tree you have to do as you mention here. For SQL Server I just put in the
>> connection but for other data sources (like Sybase) I put in a file dsn.
>> For example: FILEDSN=C:\Data\Reports\IWTS\development.dsn
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> For Issue number 2 I do the following. Yes I have to have a shared
>> datasource created for each folder BUT the actual
>> "Herman K" <HermanK@.discussions.microsoft.com> wrote in message
>> news:70D2647C-D786-4A5D-80B8-B713B69EAC4A@.microsoft.com...
>> > Our desires might be misguided, so I would like to hear what some of
>> > the
>> more
>> > learned members have to say:
>> >
>> > Issue 1:
>> >
>> > It appears that Reporting Services supports a folder paradigm that
>> > nicely
>> > models how we desire to organize our reports. However, this folder
>> paradigm
>> > is not supported in Visual Studio .NET. In other words, it does not
>> appear
>> > that I can construct a VS.NET solution that contains folders and sub
>> folders
>> > that describe a tree structure.
>> >
>> > While the VS.NET solution is 'flat' I can however modify the Properties
>> > of
>> > each Report Project and set TargetFolder such that as the projects are
>> > deployed they end up in a hierarchy on the report server.
>> >
>> > My question is this: Have any of you 'seen' this condition and if so,
>> > what
>> > have you learned or what have you done about it? Did you perhaps adopt
>> the
>> > same approach as I, accepting the VS .NET solution structure as 'flat'
>> > and
>> > use the TargetFolder property to achieve the desired hierarchy on the
>> report
>> > server?
>> >
>> > Issue 2:
>> >
>> > We desire to use a single shared data source for all of our reports. A
>> > shared data source is contained in a given Report Project. There does
>> > not
>> > seem to be a way that I can use one project's shared data source in
>> another
>> > project's report. If we consider the hierarchical folder paradigm
>> described
>> > in Issue 1 (above), it seems the only solution is to establish the same
>> > shared data source in each and every Report Project I create.
>> >
>> > I suppose alternatively, that I could dispense with attempting to use a
>> > shared data source entirely. Rather, I would just imbed the same data
>> source
>> > into each and every report developed. My thinking here is somewhat an
>> issue
>> > of reuse/maintenance. If I only need one, I don't feel I should have
>> > to
>> have
>> > more than one instance across the entire Report Server. This may be
>> contrary
>> > to some of the larger scale objectives of Reporting Services, where
>> perhaps
>> > it is desired that different folders access different data using
>> > different
>> > credentials and whatnot. At present, we don't even name a real DB
>> > Server
>> in
>> > the Connection String, but rather a logical name, which is handled via
>> > an
>> > Alias that is established on each of our target environments (Dev, QA,
>> > Staging, Beta, Production) such that the deployed reports/data sources
>> will
>> > point to their appropriate DB.
>> >
>> > My question here is: Is it possible to use a single shared data source
>> > across many individual report projects without having to physically
>> > copy
>> that
>> > shared data source to each project?
>> >
>>|||You can certainly share a datasource by using the web API. You can
write a script that will upload a new report to the Report Server and
then tell it to use the datasource that is already there.
Plenty of examples in the doc, but specifically check out
CreateReport (to publish a report)
SetReportDataSources (to then set a datasource for that report)|||Very well (to all) then that is the way I will have to do it. I was kind of
hoping to be able to implement this 'referential' data source at design time
and just have that carry through during deployment, but it looks as if we
will have to hook it up after the fact.
In this case the developer is going to have to utilize 'their' data source,
which would be in a project and if its in the project I might as well let it
flow to the server. However, if I am going to do that, I might as well let
folks just standardize on imbedding the data source in the report itself and
if we should ever need to change it, just do so by parsing the XML in each
and every RDL.
"cmarinella@.gmail.com" wrote:
> You can certainly share a datasource by using the web API. You can
> write a script that will upload a new report to the Report Server and
> then tell it to use the datasource that is already there.
> Plenty of examples in the doc, but specifically check out
> CreateReport (to publish a report)
> SetReportDataSources (to then set a datasource for that report)
>

Progress Reporting in an external application

I have a custom external application that executes some packages. I would like to display the execution progress as it would appear in the Progress tab of the SSIS designer. How would I do that? Any help is appreciated.Implement IDTSEvents interface (the simplest way is inherit from DefaultEvents class, and override the methods you need), then call package.Execute(,,IDTSEvents,) method passing your object. Process the events from package and show the progress in the way you want.

Programming Subscription Options

Hello,
We are developing our own ASP.NET 2.0 (C#) front-end for Reporting Services. We are trying to create an interface for setting up standard subscriptions that is similar to Report Manager.

On Report Manager's Report Server File Share options page, there are two options Render Format and Overwrite options that we need help with. Can we query the ReportServer and get the available Render Formats to populate a dropdownlist? Or, do we have to hard-code the values?

Same for the Overwrite options, are these hard-coded? Or, can the valid values be retreived from ReportServer?

Finally, on the Report Server E-mail setup page, there is a Priority field that we need to replicate. Again, are the valid values hard-coded into the dropdownlist or retreived from the ReportServer?

Thanks.I answered this in the newsgroup but will post my answer here as well.

You can call GetExtensionSettings to get the settings that a delivery
extension accepts. The extensions will return a populated list of renders
that it supports as well as the full set of options that it supports.

Programming Subscription Options

Hello,
We are developing our own ASP.NET 2.0 (C#) front-end for Reporting Services.
We are trying to create an interface for setting up standard subscriptions
that is similar to Report Manager.
On Report Manager's Report Server File Share options page, there are two
options Render Format and Overwrite options that we need help with. Can we
query the ReportServer and get the available Render Formats to populate a
dropdownlist? Or, do we have to hard-code the values?
Same for the Overwrite options, are these hard-coded? Or, can the valid
values be retrieved from ReportServer?
Finally, on the Report Server E-mail setup page, there is a Priority field
that we need to replicate. Again, are the valid values hard-coded into the
dropdownlist or retrieved from the ReportServer?
Thanks.You can call GetExtensionSettings to get the settings that a delivery
extension accepts. The extensions will return a populated list of renders
that it supports as well as the full set of options that it supports.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"sam" <nospam@.company.com> wrote in message
news:uDhn8VD$FHA.140@.TK2MSFTNGP12.phx.gbl...
> Hello,
> We are developing our own ASP.NET 2.0 (C#) front-end for Reporting
> Services.
> We are trying to create an interface for setting up standard subscriptions
> that is similar to Report Manager.
> On Report Manager's Report Server File Share options page, there are two
> options Render Format and Overwrite options that we need help with. Can
> we
> query the ReportServer and get the available Render Formats to populate a
> dropdownlist? Or, do we have to hard-code the values?
> Same for the Overwrite options, are these hard-coded? Or, can the valid
> values be retrieved from ReportServer?
> Finally, on the Report Server E-mail setup page, there is a Priority field
> that we need to replicate. Again, are the valid values hard-coded into
> the
> dropdownlist or retrieved from the ReportServer?
> Thanks.
>|||Thanks Daniel!
Another quick question for you...
How does Report Manager validate that the Path is in Uniform Naming
Convention (UNC) format? More than likely, our end users will enter
something like: D:\Product\Reports, and I guess we'll need to validate it.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23wXU5iE$FHA.216@.TK2MSFTNGP15.phx.gbl...
> You can call GetExtensionSettings to get the settings that a delivery
> extension accepts. The extensions will return a populated list of renders
> that it supports as well as the full set of options that it supports.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "sam" <nospam@.company.com> wrote in message
> news:uDhn8VD$FHA.140@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> > We are developing our own ASP.NET 2.0 (C#) front-end for Reporting
> > Services.
> > We are trying to create an interface for setting up standard
subscriptions
> > that is similar to Report Manager.
> >
> > On Report Manager's Report Server File Share options page, there are two
> > options Render Format and Overwrite options that we need help with. Can
> > we
> > query the ReportServer and get the available Render Formats to populate
a
> > dropdownlist? Or, do we have to hard-code the values?
> >
> > Same for the Overwrite options, are these hard-coded? Or, can the valid
> > values be retrieved from ReportServer?
> >
> > Finally, on the Report Server E-mail setup page, there is a Priority
field
> > that we need to replicate. Again, are the valid values hard-coded into
> > the
> > dropdownlist or retrieved from the ReportServer?
> >
> > Thanks.
> >
> >
>|||We don't validate all UNC paths, I believe it just checks that it starts
with \\
No real magic. :)
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"sam" <nospam@.company.com> wrote in message
news:%236XyizE$FHA.1312@.TK2MSFTNGP09.phx.gbl...
> Thanks Daniel!
> Another quick question for you...
> How does Report Manager validate that the Path is in Uniform Naming
> Convention (UNC) format? More than likely, our end users will enter
> something like: D:\Product\Reports, and I guess we'll need to validate it.
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23wXU5iE$FHA.216@.TK2MSFTNGP15.phx.gbl...
>> You can call GetExtensionSettings to get the settings that a delivery
>> extension accepts. The extensions will return a populated list of
>> renders
>> that it supports as well as the full set of options that it supports.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "sam" <nospam@.company.com> wrote in message
>> news:uDhn8VD$FHA.140@.TK2MSFTNGP12.phx.gbl...
>> > Hello,
>> > We are developing our own ASP.NET 2.0 (C#) front-end for Reporting
>> > Services.
>> > We are trying to create an interface for setting up standard
> subscriptions
>> > that is similar to Report Manager.
>> >
>> > On Report Manager's Report Server File Share options page, there are
>> > two
>> > options Render Format and Overwrite options that we need help with.
>> > Can
>> > we
>> > query the ReportServer and get the available Render Formats to populate
> a
>> > dropdownlist? Or, do we have to hard-code the values?
>> >
>> > Same for the Overwrite options, are these hard-coded? Or, can the
>> > valid
>> > values be retrieved from ReportServer?
>> >
>> > Finally, on the Report Server E-mail setup page, there is a Priority
> field
>> > that we need to replicate. Again, are the valid values hard-coded into
>> > the
>> > dropdownlist or retrieved from the ReportServer?
>> >
>> > Thanks.
>> >
>> >
>>
>

programmaticly print a report

hi all.

how can i print a report from c# code?

the report is stored on the reporting server.

Hi.

Here's an article for printing based on RS 2000, but it should be very similar for RS 2005:

http://www.csharphelp.com/archives3/archive545.html

Good luck!

Jessica

|||there is a vb.net program that will do it. look for a thread called : How to print a report to a printer by me.

Programmatically generating a reporting model?

Is there documentation/examples on how to programmatically generate a report model (.smdl XML file)? The situation I'm in would make generating the model manually via Visual Studios difficult (would have to hire lots of people).

Any ideas or suggestions would be greatly appreciated.

One option is to download the XSD here and generate an object model from it:

http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd

Programmatically create a Report Model

We would like to take advantage of the Report Builder tool to provide
end-user ad-hoc reporting. The database for the application can be
different depending on how the client configures it (they can add various
fields and data collection forms). At TechEd, I attended a session on
Microsoft Dynamics AX 4.0 and its tight integration with Reporting
Services/Report Builder. This is very much in line with what we'd like to
do. I imagine the users adding a field (through our interface), setting a
few properties, and then after some automated process occurs, they would be
able to use Report Builder to access any data collected in that field.
What we'd like to do is programmatically generate and maintain a report
model based on how the individual install is configured. I've found some
documentation that makes me believe this is possible, but I'm hoping someone
can nudge me in the right direction. The ReportingServices2005 class has
several model related methods (CreateModel) and I found the .xsd for the
semantic model XML file
(http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
but no real documentation on how to put together a Report Model document
from scratch. Looking at the files generated from BIDS is somewhat
overwhelming and I have no idea where I'd pull most of the information.
Any help that can be provided would be greatly appreciated. Thanks!
RussellHi Russell,
Thank you for your posting!
From your description, my understanding of this issue is: You want to
programmatically manage the Report Model xml file (smdl). If I
misunderstood your concern, please feel free to let me know.
I would like to know what information you want to pull from the Report
Model. The smdl file is a xml file and I think you could control the file
in VS .NET.
The CreateModel of the Reporting Services 2005 class is used to upload the
Report Model file to Report Server. I think it is not quite meet your
requirement.
Here is an article about refine a report model.
Refining a Report Model
http://www.sqlmag.com/Article/ArticleID/50048/sql_server_50048.html
Hope this information will be helpful and please let me know the result.
Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Russell,
I would like to know whether the information is helpful. Feel free to let
me know if you have any questions.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Russel
did you have any success with that? did you solve it by creating the SMDL
File with an XMLTextWriter or did you find an other solution? an oblect that
could be referenced?
i am having the same problem and would like to establish the SMDL file fully
by code, from scratch.
any info is appreciated.
Kind Regards, Rene
"RussellReed" schrieb:
> We would like to take advantage of the Report Builder tool to provide
> end-user ad-hoc reporting. The database for the application can be
> different depending on how the client configures it (they can add various
> fields and data collection forms). At TechEd, I attended a session on
> Microsoft Dynamics AX 4.0 and its tight integration with Reporting
> Services/Report Builder. This is very much in line with what we'd like to
> do. I imagine the users adding a field (through our interface), setting a
> few properties, and then after some automated process occurs, they would be
> able to use Report Builder to access any data collected in that field.
> What we'd like to do is programmatically generate and maintain a report
> model based on how the individual install is configured. I've found some
> documentation that makes me believe this is possible, but I'm hoping someone
> can nudge me in the right direction. The ReportingServices2005 class has
> several model related methods (CreateModel) and I found the .xsd for the
> semantic model XML file
> (http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/SemanticModeling.xsd),
> but no real documentation on how to put together a Report Model document
> from scratch. Looking at the files generated from BIDS is somewhat
> overwhelming and I have no idea where I'd pull most of the information.
> Any help that can be provided would be greatly appreciated. Thanks!
> Russell
>
>

Programmatically changing shared data sources when running SQL Reporting Service 2005 Repo

Can someone please help me or point me to the right sources on how I can possibly programmatically change the shared data source that was assigned to an RDL when a user runs it from my asp page? I have to create several reports and would like to have the option to let users choose the sql server to connect to and possibly different login credentials. What should I do?

Please help.

Hope these articles can help you -

http://msdn2.microsoft.com/en-us/library/ms252085(VS.80).aspx

http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/

Programmatically alter grouping

Hi Everyone:
We are evaluating the SQL Server Reporting Services for use in our
current web project. The users will have the ability to select report
fields that they can group on and filter on, via a web page.
The materials I have read so far have not touched on how one can
programmatically alter groups on a report and also how should the
report that offers several grouping options to the user be designed(as
in whether the report should have all possible groupings defined at
design time and "disabled" by default)?
In Crystal Report we remember creating the various goups and
"deactivating" them at design time and programmatically altering the
group hierarchy at run time.
If anyone has any information on this issue, it would be very much
appreciated. Thanks a lot.
-Raghu.http://blogs.msdn.com/chrishays/archive/2004/07/15/184646.aspx
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Raghu" <raghu_seshadri@.hotmail.com> wrote in message
news:5c2d0972.0407150214.106d400d@.posting.google.com...
> Hi Everyone:
> We are evaluating the SQL Server Reporting Services for use in our
> current web project. The users will have the ability to select report
> fields that they can group on and filter on, via a web page.
> The materials I have read so far have not touched on how one can
> programmatically alter groups on a report and also how should the
> report that offers several grouping options to the user be designed(as
> in whether the report should have all possible groupings defined at
> design time and "disabled" by default)?
> In Crystal Report we remember creating the various goups and
> "deactivating" them at design time and programmatically altering the
> group hierarchy at run time.
> If anyone has any information on this issue, it would be very much
> appreciated. Thanks a lot.
> -Raghu.|||Your blog made an interesting reading. I will give this technique a
try. Thank you very much for your assistance.
Regards,
Raghu.|||Hi Chris:
I tried the grouping technique explained in your blog. It worked like
a charm. Thanks a lot for your help.
Regards,
Raghu.

Programmatically adding a user to the System User role

We have been working on an application that will be using a forms-authenticated report server (RS2005) as a reporting back-end. Using the reporting services web service I have been able to assign permissions to objects in reporting services no problem. The issue is that each user needs to be added to the System User role to be able to use the report builder properly. I can't seem to find a way to do this programmatically. Any idea?Nevermind, GetSystemPolicies() is what I was looking for.