Create SRS Reports against Sharepoint

Hello, everyone!
Being new to SRS and Sharepoint, I was wondering:
Are there any walkthroughs or guides that can show me how to create an SRS
Report that displays data from a Sharepoint site?
For example, if I have a list on some site, and I want to run a report in
SRS to simply display the data from that list so it can be sent out via
Subscription, or printed in some specific fashion, how do I make the
connection to the Sharepoint database for that report?
I know this can be made through Access - querying the data and displaying it
in a form and whatnot, but I don't know where to begin for SRS.
Thanks in advance!Infact I have used reporting web part for SPS and integrated RS in SPS.
infact it comes with SSRS 2005
Good guidence is look at bryant blog site.
Amarnath
"Adam St. Pierre" wrote:
> Hello, everyone!
> Being new to SRS and Sharepoint, I was wondering:
> Are there any walkthroughs or guides that can show me how to create an SRS
> Report that displays data from a Sharepoint site?
> For example, if I have a list on some site, and I want to run a report in
> SRS to simply display the data from that list so it can be sent out via
> Subscription, or printed in some specific fashion, how do I make the
> connection to the Sharepoint database for that report?
> I know this can be made through Access - querying the data and displaying it
> in a form and whatnot, but I don't know where to begin for SRS.
> Thanks in advance!|||"Amarnath" wrote:
> Infact I have used reporting web part for SPS and integrated RS in SPS.
> infact it comes with SSRS 2005
> Good guidence is look at bryant blog site.
> Amarnath
Thank you, Amarnath. Where can I find Bryant's blog site?

Create reports with SQL Express

Is it possible to create reports with Sql Express edition i.e. like you can with SQL full edition? If not are there any other add on free tools that allow you to do this?

Thanks

See this link here for the SQL Server toolkit:

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

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Create reports in ASP format?

We use an internal tool that can display ASP pages. I would like to use SQL Reporting Services to create reports in ASP format. The ASP page will access the database to get data. Is this possible possible with Reporting Services?

Ric

Hmmm... from what I understand, an ASP page is very similar to an ASPX page (created by Visual Studio). Possibly you could embed a report viewer in your ASP page. However, I'm not really sure that this is possible.

I'm not so sure that you want to create reports in ASP format -- that isn't possible. I think you are saying you want to display reports within an ASP page.

|||Active Server Pages and C# are completely different. Similar only because they are both programming languages. ASP was never meant to work with SQL Reporting Services. ASP works through ODBC and other interfaces and can connect to SQL databases and display the data onto web pages that have been setup using HTML tables using such things as the for loop etc..., but was never meant to work in this enviorment.

Create reports from a workstation

Can you create a Report project from a workstation? Any help would be
greatly appreciated. Thanks.
JacobSure, you just need Visual Studio .NET on the workstation.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jacob" <Jacob@.discussions.microsoft.com> wrote in message
news:8950817B-FE57-44A9-B786-941A3A9982B2@.microsoft.com...
> Can you create a Report project from a workstation? Any help would be
> greatly appreciated. Thanks.
> Jacob|||You can create your own reports programmatically no VS required.
using http://www.rdlcomponents.com
Thanks
Jerry
"Jeff A. Stucker" wrote:
> Sure, you just need Visual Studio .NET on the workstation.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jacob" <Jacob@.discussions.microsoft.com> wrote in message
> news:8950817B-FE57-44A9-B786-941A3A9982B2@.microsoft.com...
> > Can you create a Report project from a workstation? Any help would be
> > greatly appreciated. Thanks.
> >
> > Jacob
>
>

Create report with complex and nested stored procedures

Hi all,

I had developed all my reports using CRXI and stored procedures of MSSQL 2000. Now I am migrating from CRXI to SSRS. But i have a problem because of my report stored procedures. These stored procedures are complex and nested. When i try to use procedures in a report, it gives a error. When i comment out my EXEC line in my procedures, it goes OK.

Please help me to do this ?

It can only mean that the nested stored procedure has issues and needs to be fixed. The stored procedure that you use in SQL Reporting services can use a stored procedure which has nested another stored procedure.

Shyam

Create report with an ADO dataset

Hello,

We are trying to convert our Crystal XI reports to SQL Reporting Services 2005. Our crystal reports get their data from ADO datasets which are populated through code at run time. Is it possible to do this in SQL Reporting Services?

The only options for a dataset seem to be query and stored procedure. When i have a blank dataset it throws an error. When i try to link my dataset to code, it throws an error.

Thanks for your help!Can you give more information on what you are trying to do? Reporting Services is based on .Net. Are you saving an ADO recordset as XML somewhere and they trying to read it from there?|||With all our crystal reports, we use an ADO dataset. We place fields on the report from the dataset, then at run time fill the dataset based off data generated in code, not a stored procedure.

We need to be able to do the same with reporting services reports. The only option available seems to be a dataset that is linked to a query or a stored procedure. We want to be able to fill the dataset by calling a method in our code.

Does that make sense?|||

Hi,

You can create a Custom Assembly and reference that in the SSRS report.

Create a data source of type "XML". Create a dataset based on this data source in the SSRS.

You can call the function in the Custom Assembly that returns an XML dataset.

The following function was written in the Custom Code window and it reads an .xml file and returns it as data to the calling function.

Public Function fGetXMLQuery() as String

dim ABC as String

Using sr As System.IO.StreamReader = New System.IO.StreamReader("C:\TestFile.xml")

' Read and display the lines from the file until the end
' of the file is reached.

ABC= "<Query> " + _
" <XmlData> " + _
sr.ReadToEnd + _
" </XmlData> " + _
"</Query>"
sr.Close()
End Using
fGetXMLQuery = ABC

End Function

The Query string for the Dataset is "=Code.fGetXMLQuery()"

HTH

Ashish

|||

I tried the above method but getting Incorrect Syntax near '<'

can any one please help me on this?

My XML is below

<Query> <XmlData> <?xml version="1.0" standalone="yes"?>
<NewDataSet>
<tblSiteType>
<iSiteTypeID>1</iSiteTypeID>
<vcSiteTypeName>Pre-Production</vcSiteTypeName>
</tblSiteType>
<tblSiteType>
<iSiteTypeID>2</iSiteTypeID>
<vcSiteTypeName>Production</vcSiteTypeName>
</tblSiteType>
<tblSiteType>
<iSiteTypeID>3</iSiteTypeID>
<vcSiteTypeName>Integration</vcSiteTypeName>
</tblSiteType>
</NewDataSet> </XmlData> </Query>

-ranga

|||I got mine working using this procedure:

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

Hi,

I was working on the MSDN Tutorial "Using XML Data in a Report", Lesson

2: Defining a Report Dataset for an ADO.NET DataSet from a Web Service

at the follwoing link

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

When i run the following query, everything goes as expected (i.e. the

displayed data is the extracted data from all XML elements and

attributes down to the leaf node on the first XML path it finds in the

dataset )

http://tempuri.org/GetEmployeeManagers

Name="GetEmployeeManagers">

But when i add the other section to specify the elements to be used in

retrieving the data

1. <ElementPath IgnoreNamespaces="True"> GetEmployeeManagersResponse {}/ GetEmployeeManagersResult/diffgram{}/ Results {}/Table </ElementPath>

the following error is dispalyed:

===================================

An error occurred while creating a data extension command.

The XmlDP query is invalid. (Microsoft Report Designer)

The XmlDP query is invalid.

(Microsoft.ReportingServices.DataExtensions)

There are multiple root elements. Line 9, position 2. (System.Xml)

Please help me with this...

|||So your web service works? Have you tested it through Internet Explorer?

Your query (in Visual Studio) should look something like this:

<Query>

<ElementPath

IgnoreNamespaces="True">

GetEmployeeManagersResponse

{}/

GetEmployeeManagersResult/diffgram{}/

Results {}/Table {FirstName,

LastName, Address, City}

</ElementPath>

<SoapAction>

http://tempuri.org/GetEmployeeManagers

</SoapAction>

<Method Namespace="http://tempuri.org/"

Name="GetEmployeeManagers">

</Method>

</Query>

Where i have FirstName,

LastName, Address, City this is a list of your field names you want to return. If you want to return all fields, then leave this out (also leave out the curly brackets).

Hope this helps, let me know if it does or doesn't.

Create report with an ADO dataset

Hello,

We are trying to convert our Crystal XI reports to SQL Reporting Services 2005. Our crystal reports get their data from ADO datasets which are populated through code at run time. Is it possible to do this in SQL Reporting Services?

The only options for a dataset seem to be query and stored procedure. When i have a blank dataset it throws an error. When i try to link my dataset to code, it throws an error.

Thanks for your help!Can you give more information on what you are trying to do? Reporting Services is based on .Net. Are you saving an ADO recordset as XML somewhere and they trying to read it from there?|||With all our crystal reports, we use an ADO dataset. We place fields on the report from the dataset, then at run time fill the dataset based off data generated in code, not a stored procedure.

We need to be able to do the same with reporting services reports. The only option available seems to be a dataset that is linked to a query or a stored procedure. We want to be able to fill the dataset by calling a method in our code.

Does that make sense?|||

Hi,

You can create a Custom Assembly and reference that in the SSRS report.

Create a data source of type "XML". Create a dataset based on this data source in the SSRS.

You can call the function in the Custom Assembly that returns an XML dataset.

The following function was written in the Custom Code window and it reads an .xml file and returns it as data to the calling function.

Public Function fGetXMLQuery() as String

dim ABC as String

Using sr As System.IO.StreamReader = New System.IO.StreamReader("C:\TestFile.xml")

' Read and display the lines from the file until the end
' of the file is reached.

ABC= "<Query> " + _
" <XmlData> " + _
sr.ReadToEnd + _
" </XmlData> " + _
"</Query>"
sr.Close()
End Using
fGetXMLQuery = ABC

End Function

The Query string for the Dataset is "=Code.fGetXMLQuery()"

HTH

Ashish

|||

I tried the above method but getting Incorrect Syntax near '<'

can any one please help me on this?

My XML is below

<Query> <XmlData> <?xml version="1.0" standalone="yes"?>
<NewDataSet>
<tblSiteType>
<iSiteTypeID>1</iSiteTypeID>
<vcSiteTypeName>Pre-Production</vcSiteTypeName>
</tblSiteType>
<tblSiteType>
<iSiteTypeID>2</iSiteTypeID>
<vcSiteTypeName>Production</vcSiteTypeName>
</tblSiteType>
<tblSiteType>
<iSiteTypeID>3</iSiteTypeID>
<vcSiteTypeName>Integration</vcSiteTypeName>
</tblSiteType>
</NewDataSet> </XmlData> </Query>

-ranga

|||I got mine working using this procedure:

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

Hi,

I was working on the MSDN Tutorial "Using XML Data in a Report", Lesson

2: Defining a Report Dataset for an ADO.NET DataSet from a Web Service

at the follwoing link

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

When i run the following query, everything goes as expected (i.e. the

displayed data is the extracted data from all XML elements and

attributes down to the leaf node on the first XML path it finds in the

dataset )

http://tempuri.org/GetEmployeeManagers

Name="GetEmployeeManagers">

But when i add the other section to specify the elements to be used in

retrieving the data

1. <ElementPath IgnoreNamespaces="True"> GetEmployeeManagersResponse {}/ GetEmployeeManagersResult/diffgram{}/ Results {}/Table </ElementPath>

the following error is dispalyed:

===================================

An error occurred while creating a data extension command.

The XmlDP query is invalid. (Microsoft Report Designer)

The XmlDP query is invalid.

(Microsoft.ReportingServices.DataExtensions)

There are multiple root elements. Line 9, position 2. (System.Xml)

Please help me with this...

|||So your web service works? Have you tested it through Internet Explorer?

Your query (in Visual Studio) should look something like this:

<Query>

<ElementPath

IgnoreNamespaces="True">

GetEmployeeManagersResponse

{}/

GetEmployeeManagersResult/diffgram{}/

Results {}/Table {FirstName,

LastName, Address, City}

</ElementPath>

<SoapAction>

http://tempuri.org/GetEmployeeManagers

</SoapAction>

<Method Namespace="http://tempuri.org/"

Name="GetEmployeeManagers">

</Method>

</Query>

Where i have FirstName,

LastName, Address, City this is a list of your field names you want to return. If you want to return all fields, then leave this out (also leave out the curly brackets).

Hope this helps, let me know if it does or doesn't.

Create PIE/BAR Charts using DTS?

Hi All,
I'm using DTS in Sql Server 2000 for the first time, and would like to create Ad-Hoc reports with Pie/Charts and graphs. Is this possible in SQL Server/DTS, or would I need something like Cyrstal Reports?
Thanks!
MattDTS (Data Transformation Services) is an Extraction, Loading and Transformation tool (ETL). It is not a reporting tool.

For creating reports with charts and such, you want to look at SQL Server Reporting Services (SSRS). It comes with SQL 2005, but under certain circumstances, it may require a separate license.

Be forewarned, SSRS comes with a fairly steep learning curve.

Regards,

hmscott|||I agree with the poster of the previous post. DTS is an ETL tool designed to provide a set of interfaces for the import, export and within reason, the manipulation of data relevant to either of these processes.

Although DTS does provide support to invoke .VBS scripts and to call stored procedures and possibly other database objects, this functionality should be restricted for use to enhance the processes for which DTS is designed, import and export.

To accomplish your goal, I would recommend using DTS to manage your ETL requirments and then invoking a specific API designed specifically to render your PIE Chart. This process would involve two steps, the first one being optional. First, a database transaction, encapsulated within a stored procedure, would be created to produce a report of the data that is to be used as input to the graphing function.

The graphing functionality can be provided by any language or application. The decision will come down to what development languages your team is comfortable with, or what reporting packages the company has available. Two such packages that are quite popular in reporting are Business Objects and Microsoft Reporting Services.

Another option of course, for the graphical rendering of the data, is to develop a simple graphing function in a high level language such as .NET and Java. Your process can then be developed in one of these languages to call a stored procedure, to process the result set, and then to pass the set to a custom written graphing routine.

Regards,

Create Global Variable like VB... can it be done?

I just want to store the value of a parameter in a global variable that all my reports in the same project can use.

My goal is to create a dynamic query. For example:

Company Name: Widgets inc.

Divisions: Sales, Service, Tech, Accounting

I have a matrix and when I click on the more information button it goes to another report. I want the next report to know what division is currently selected in the dropdown parameter. So, being a VB programmer, I thought I could store parameter1.division.value into a global variable and update the variable whenever the parameter changes.

This way, on the next report, my query's where statement is the global variable.

@.GlobalVariable = parameter1.division.value

Select name, address, phone FROM Employee WHERE division = @.GlobalVariable

I am using Visual Studio to design this project although I would prefer to use VB or ASP. But this is my only stumbling block right now. Everything else is complete.

Please let me know if anyone can help.

Thanks.

John

There is not a concept of a global variable for multiple reports that I know of.

You could potentially do something with a table that could store the global value by user id & identifier, and retrieve the variable from the table. Or you could setup a web service to get/set the variable.

You may be able to add a reference to a DLL in every report, and share between them, though I woud think it would be destroyed after the report session times out.

http://www.codeproject.com/dll/data_seg_share.asp

cheers,

Andrew

|||

Looks like you need a report parameter. You don't need to show it to the user, but just default it.

Create Error when Exporting to Excel

Is there a way to purposly throw an error when exporting to excel?
What I'm wanting is a way for reports to show up correctly in the browser,
but when users right click and export to excel, it will throw an error or
display garbled.
I posted a question early today regarding disabling right-click, but if that
is not possible, then this may be a work around.
(I still prefer the disabling of right click however ;).
Any suggestions?On Mar 1, 1:40 pm, labsRc...@.community.nospan
<labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> Is there a way to purposly throw an error when exporting to excel?
> What I'm wanting is a way for reports to show up correctly in the browser,
> but when users right click and export to excel, it will throw an error or
> display garbled.
> I posted a question early today regarding disabling right-click, but if that
> is not possible, then this may be a work around.
> (I still prefer the disabling of right click however ;).
> Any suggestions?
As far as I know, there's not a way to accomplish this without
sacrificing exporting to the remaining formats. What are you trying to
accomplish in general?
Enrique Martinez
Sr. SQL Server Developer|||Thank you for responding!
This is the background and what we are trying to accomplish:
Background:
We are creating reports that we want certain users to be able to view
regional reports, and drill down to employee detail. The report was great.
However, we do not want users to be tempted to save these reports to their
computer. I already disabled the "export" options from the built in RS
toolbar.
But someone pointed out that users can still right-click with their mouse on
the RS report and select "Export to Excel" - which is undesirable.
Therefore, I thought of two possible solutions:
1) Find a way to capture the mouse right-click event to disable it.
(Like you can via javascript through static html pages, or by setting the
oncontextmenu=false.)
Those methods don't work with RS to disable the click, therefore I'm
searching for a different method to disable it..
OR
2) Another approach I thought of, if I can't disable the click, is find
someone to format the RS Reports, through hidden fields, or something, that
is not compatable with Excel, so that even if they do right click and export
- it won't show them what they want.
The reason for all this is that we don't want user personal information to
be saved on their personal computer.
Any suggestions would be appreciated, thanks!
"EMartinez" wrote:
> On Mar 1, 1:40 pm, labsRc...@.community.nospan
> <labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> > Is there a way to purposly throw an error when exporting to excel?
> >
> > What I'm wanting is a way for reports to show up correctly in the browser,
> > but when users right click and export to excel, it will throw an error or
> > display garbled.
> >
> > I posted a question early today regarding disabling right-click, but if that
> > is not possible, then this may be a work around.
> >
> > (I still prefer the disabling of right click however ;).
> >
> > Any suggestions?
> As far as I know, there's not a way to accomplish this without
> sacrificing exporting to the remaining formats. What are you trying to
> accomplish in general?
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 1, 9:07 pm, labsRc...@.community.nospan
<labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> Thank you for responding!
> This is the background and what we are trying to accomplish:
> Background:
> We are creating reports that we want certain users to be able to view
> regional reports, and drill down to employee detail. The report was great.
> However, we do not want users to be tempted to save these reports to their
> computer. I already disabled the "export" options from the built in RS
> toolbar.
> But someone pointed out that users can still right-click with their mouse on
> the RS report and select "Export to Excel" - which is undesirable.
> Therefore, I thought of two possible solutions:
> 1) Find a way to capture the mouse right-click event to disable it.
> (Like you can via javascript through static html pages, or by setting the
> oncontextmenu=false.)
> Those methods don't work with RS to disable the click, therefore I'm
> searching for a different method to disable it..
> OR
> 2) Another approach I thought of, if I can't disable the click, is find
> someone to format the RS Reports, through hidden fields, or something, that
> is not compatable with Excel, so that even if they do right click and export
> - it won't show them what they want.
> The reason for all this is that we don't want user personal information to
> be saved on their personal computer.
> Any suggestions would be appreciated, thanks!
> "EMartinez" wrote:
> > On Mar 1, 1:40 pm, labsRc...@.community.nospan
> > <labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> > > Is there a way to purposly throw an error when exporting to excel?
> > > What I'm wanting is a way for reports to show up correctly in the browser,
> > > but when users right click and export to excel, it will throw an error or
> > > display garbled.
> > > I posted a question early today regarding disabling right-click, but if that
> > > is not possible, then this may be a work around.
> > > (I still prefer the disabling of right click however ;).
> > > Any suggestions?
> > As far as I know, there's not a way to accomplish this without
> > sacrificing exporting to the remaining formats. What are you trying to
> > accomplish in general?
> > Enrique Martinez
> > Sr. SQL Server Developer
Have you considered using a custom front-end ASP.NET application to
accomplish this, since it would be much more dynamic?
Enrique Martinez
Sr. SQL Server Developer|||I will try this, thanks!
"EMartinez" wrote:
> On Mar 1, 9:07 pm, labsRc...@.community.nospan
> <labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> > Thank you for responding!
> >
> > This is the background and what we are trying to accomplish:
> >
> > Background:
> > We are creating reports that we want certain users to be able to view
> > regional reports, and drill down to employee detail. The report was great.
> > However, we do not want users to be tempted to save these reports to their
> > computer. I already disabled the "export" options from the built in RS
> > toolbar.
> >
> > But someone pointed out that users can still right-click with their mouse on
> > the RS report and select "Export to Excel" - which is undesirable.
> >
> > Therefore, I thought of two possible solutions:
> > 1) Find a way to capture the mouse right-click event to disable it.
> > (Like you can via javascript through static html pages, or by setting the
> > oncontextmenu=false.)
> > Those methods don't work with RS to disable the click, therefore I'm
> > searching for a different method to disable it..
> >
> > OR
> >
> > 2) Another approach I thought of, if I can't disable the click, is find
> > someone to format the RS Reports, through hidden fields, or something, that
> > is not compatable with Excel, so that even if they do right click and export
> > - it won't show them what they want.
> >
> > The reason for all this is that we don't want user personal information to
> > be saved on their personal computer.
> >
> > Any suggestions would be appreciated, thanks!
> >
> > "EMartinez" wrote:
> > > On Mar 1, 1:40 pm, labsRc...@.community.nospan
> > > <labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> > > > Is there a way to purposly throw an error when exporting to excel?
> >
> > > > What I'm wanting is a way for reports to show up correctly in the browser,
> > > > but when users right click and export to excel, it will throw an error or
> > > > display garbled.
> >
> > > > I posted a question early today regarding disabling right-click, but if that
> > > > is not possible, then this may be a work around.
> >
> > > > (I still prefer the disabling of right click however ;).
> >
> > > > Any suggestions?
> >
> > > As far as I know, there's not a way to accomplish this without
> > > sacrificing exporting to the remaining formats. What are you trying to
> > > accomplish in general?
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
> Have you considered using a custom front-end ASP.NET application to
> accomplish this, since it would be much more dynamic?
> Enrique Martinez
> Sr. SQL Server Developer
>|||It sounds to me like you are trying to lock this down too much... I
mean, if a user really wants to save the data, then they can...Select
all, copy and paste or print screen etc. There will always be a
workaround. Hence, I think the goal is unrealistic and you may just
have to trust the users to act responsibly to some degree.
However, if you really need to, you could create your own interface to
the reporting services web service as someone already suggested.
however, there will be many things you have to think of if you really
want to prevent saving the report data locally.

Create dynamic reports

Hi,

I receive an xml object that represent just about any kind of a table containing unknown amount of text fields, and need to create a Table report out of it, the header fields are not pre-determined.

Is this possible with Crystal reports and in particular in the .Net free addition of Crystal reports ?

if so - HOW ? please explain as articulately as possible

Thanks
. .
|
~

NimCo.You can try using CDO (Crystal Data Objects) to pass info to Crystal Reports. Basically, you populate an array and pass the array to the report.

Look here for an example of CDO in VB 6, maybe you can adapt it to your needs...

http://www.dev-archive.com/forum/showthread.php?s=&threadid=281658&highlight=cdo

Create Data Driven Subscription via C# code? SSRS 2005 EE (or Batch Reports?)

Hello,

Does anyone know if you can create a Data Driven Subscription via code (C#)? The web based Report Manager does it via the Subscriptions.aspx (I assume). Seems like they are using theMicrosoft.ReportingServices.UI.Pages.Subscriptions namespace.

I can't find any info on anybody doing it. So, here's my need, please tell me if I am on the right track.

In my ASP.NET 2.0 C# app, we use the SSRS Web Service (reportservice2005) to generate PDF reports in a new window. If the User requests a large amount of pages (say 1000), the request is timing out, as well as tying up the web server.

So, the thought was, why not submit these reports to a "Batch". It seems that Data Driven Subscriptions could do it but what I'd want is to create the Subscription on the fly and clean them up after they run (or weekly).

Should I go this approach,OR should I write a Windows Service (or Console App) that just uses the same SSRS Web Service (reportservice2005) to create my reports in batch mode?

Any thoughts are helpful.

Nothing like answering your own question. I guess after a good night's sleep I Googled the right phrase to see this link:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005_methods.aspx

There is a CreateDataDrivenSubscription() method.

However, given my original question on proper approach,should I be doing it this way or write the windows service or console app to do it?

Thoughts?

|||We are looking into the same concept. We are trying to create a single data-driven subscription that runs nightly and all the "requests" for the day are processed. We're achieving this by inserting the "request" into the database. The only problem we are having now is how to do this for multi-value parameters since each row creates a different subscription and you can only reference one column per parameter. Good luck!

Create custom template in VS 2003 for SQL 2005 Reporting Service

Hello,
I'd like to create custom templates in Visual Studio 2003 when creating
reports for SQL 2005 RS, but I'm unable to find anything online that shows
how to do this. VS2003 has about 5 generic templates available, but it'd be
nice to have a template customized to our corporate colors and logo. Is
this possible'
Thanks --
Alexyes, create blank report with the formatting you want and copy the resulting
rdl file to the c:\program files\microsoft visual studio 8\common
7\ide\privateassemblies\projectitems\reportproject folder. this will add a
new template to the New Item dialog box.
"Alex" <samalex@.gmail.com> wrote in message
news:OJRpgup2HHA.2064@.TK2MSFTNGP03.phx.gbl...
> Hello,
> I'd like to create custom templates in Visual Studio 2003 when creating
> reports for SQL 2005 RS, but I'm unable to find anything online that shows
> how to do this. VS2003 has about 5 generic templates available, but it'd
> be nice to have a template customized to our corporate colors and logo.
> Is this possible'
> Thanks --
> Alex
>