Automating Reporting Services in my Windows App.

Is there a way of automating SQL Server Reporting Services reports in my win
app?
I want to be able to pick up events when the user right-clicks on the report
etc.
I really want to provide a context menu with options relevant to what
they've selected in the report.
As I understood it, the generated report is basically html and theres no
easy way of doing it...
I basically want the report to be more dynamic than just being generated and
then printed.
If not is in coming in a future version of SQL Server?Are you using the ReportViewer control?
http://gotreportviewer.com/
If on the server you may be able to add via .css?
http://weblogs.asp.net/jgalloway/archive/2006/09/01/SQL-Reporting-Services-_2D00_-CSS-fix-for-Firefox.aspx
Steve MunLeeuw
"James" <James@.discussions.microsoft.com> wrote in message
news:E1244EC6-5372-4AB2-8BC1-9D41827F2D8E@.microsoft.com...
> Is there a way of automating SQL Server Reporting Services reports in my
> win
> app?
> I want to be able to pick up events when the user right-clicks on the
> report
> etc.
> I really want to provide a context menu with options relevant to what
> they've selected in the report.
> As I understood it, the generated report is basically html and theres no
> easy way of doing it...
> I basically want the report to be more dynamic than just being generated
> and
> then printed.
> If not is in coming in a future version of SQL Server?|||yes, I'm currently looking into doing it via hyperlinks as in the following
article:
http://www.devx.com/dotnet/Article/30424/0/page/6
"Steve MunLeeuw" wrote:
> Are you using the ReportViewer control?
> http://gotreportviewer.com/
> If on the server you may be able to add via .css?
> http://weblogs.asp.net/jgalloway/archive/2006/09/01/SQL-Reporting-Services-_2D00_-CSS-fix-for-Firefox.aspx
> Steve MunLeeuw
> "James" <James@.discussions.microsoft.com> wrote in message
> news:E1244EC6-5372-4AB2-8BC1-9D41827F2D8E@.microsoft.com...
> > Is there a way of automating SQL Server Reporting Services reports in my
> > win
> > app?
> > I want to be able to pick up events when the user right-clicks on the
> > report
> > etc.
> > I really want to provide a context menu with options relevant to what
> > they've selected in the report.
> > As I understood it, the generated report is basically html and theres no
> > easy way of doing it...
> > I basically want the report to be more dynamic than just being generated
> > and
> > then printed.
> >
> > If not is in coming in a future version of SQL Server?
>
>sql

Automating Creation of Reporting Services Reports (Excel format)

Hello,

Currently, I have to manully create RS 2005 reports which I export into an Excel later. Is there a way to create a SSIS package that could automate this somehow?

Thanks for sharing your thoughts and ideas!

donnie100 wrote:

Hello,

Currently, I have to manully create RS 2005 reports which I export into an Excel later. Is there a way to create a SSIS package that could automate this somehow?

Thanks for sharing your thoughts and ideas!

You mean you want to use SSIS to build the RDL? I'm not really sure why you would want to do this but heigh-ho.

Is there a .Net API for SSRS? if there is then you could call it from a SSIS script task.

-Jamie

Automatically print multiple copies of the same report with different label on letter size p

Hi,

I am new to reporting services and I'm really stuck on a design problem. Can someone please help me?

I would like to design my own print function. When a user clicks on the print icon (preferably the one that came with reporting services), the report is automatically printed twice, once with "For Person A" and the second time with "For Person B" on it. It doesn't matter where these two labels are placed on the page. These two reports need to be printed on letter-size paper regardless of user's selection. How do I do this with minimum amount of code?

Any help would be greatly appreciated!

Depending on how the names of person A and person B actually get onto the report, you could add a grouping by person with a page break and actually make the report have 2 pages, 1 per person.|||

Hi

Thanks for your help.

The names are constant - ie they can be hardcoded.

If I make the report 1 page per person, does that mean the user will see two copies of the report in preview? Is there a way so that the user sees one copy but can print multiple copies with a single click?

Thanks!

|||

Hi

If there is a field with "Person A" and "Person B" you can add
a grouping by that field and set 'Page Break at end' on the grouping to true.

If this is a static value that has to be hard coded I cannot think of anything.

Problem when using the group by person approach is that the report will display
twice in the browser, each seperated by a pagebreak.

G

|||More specifically, the report will indicate that it has multiple pages (hence allowing the user to browse to the next page) but by default only the first page will show. When you export or print, all pages will be outputted.|||

Is there a way to do this without showing multiple copies (show one copy of the report in preview but prints two)?

Ideally I would like to create a print function that can be used across all reports, instead of changing all existing reports.

Thanks

|||

In that case your only other option is write your own rendering extension. That's quite involved and probably not how far you would want to go in this case.

You can't override the default print function.

|||Ok, got it. Thanks for your help :)

Automatically Generating PDFs With Reports Requiring Parameters

Hi,
I'm working on many reports that are generated using SQL Server
Reporting Services SP 1 from an ASP.NET 1.1 web application. One of the
things the users would like to do is have the report automatically
generate a PDF when they click on the View Report button after entering
the parameters for the report. Parameters could be a date, a city, a
state, etcetera. However, they would like to avoid having to choose the
format and click the Export link. Is there a way to manipulate the
functionality of the View Report button such that it does this
automatically? Thank you for any insights you can provide.
JabooHow are you accessing the reports?
1) Report Manager
2) URL parameters
3) Web Service
Kulgan.sql

Automatically Export reports in SQL Reporting services 2000

Is it possible to have a report automatically export the results to Excel, when the report is generated? ...rather than having to select the format and click Export? .Pl let me know-Thanks.

I found this article some days ago!

http://ryanfarley.com/blog/archive/2006/01/27/15689.aspx

sql

Automatically Export reports in SQL Reporting services 2000

Is it possible to have a report automatically export the results to Excel, when the report is generated? ...rather than having to select the format and click Export? .Pl let me know-Thanks.

I found this article some days ago!

http://ryanfarley.com/blog/archive/2006/01/27/15689.aspx

automaticall render as pdf after parameter selection

I am using reporting services and have a report that requires three
parameters. After the parameters are selected and the report is generated by
clicking the View Report button, I want the report to default to pdf view
instead of having to select that format and export after running it. Is this
possible? This way users can print or save from the pdf view without having
to take the extra step of exporting.
Thank you for your help!
SharlynI'm also interested in it.
tnx.
Tom.sql

Automatic Refresh Data

Is there any way in Reporting Service so that It will automatic
refresh data in the report with specified time interval ?
ThanksOn Mar 30, 11:35 pm, sqlpr...@.gmail.com wrote:
> Is there any way in Reporting Service so that It will automatic
> refresh data in the report with specified time interval ?
> Thanks
Yes, in the Reports Project, select the 'Layout' tab. Then select the
'Report' tab at the top and then 'Report Properties...' On the
'General' tab, select 'Auto Refresh' near the bottom and select the
number of seconds between refreshes.
Regards,
Enrique Martinez
Sr. Software Developer|||On Apr 1, 7:46 am, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Mar 30, 11:35 pm, sqlpr...@.gmail.com wrote:
> > Is there any way in Reporting Service so that It will automatic
> > refresh data in the report with specified time interval ?
> > Thanks
> Yes, in the Reports Project, select the 'Layout' tab. Then select the
> 'Report' tab at the top and then 'Report Properties...' On the
> 'General' tab, select 'Auto Refresh' near the bottom and select the
> number of seconds between refreshes.
> Regards,
> Enrique Martinez
> Sr. Software Developer
Thanks
it has done my work.|||On Apr 1, 12:47 am, sqlpr...@.gmail.com wrote:
> On Apr 1, 7:46 am, "EMartinez" <emartinez...@.gmail.com> wrote:
>
> > On Mar 30, 11:35 pm, sqlpr...@.gmail.com wrote:
> > > Is there any way in Reporting Service so that It will automatic
> > > refresh data in the report with specified time interval ?
> > > Thanks
> > Yes, in the Reports Project, select the 'Layout' tab. Then select the
> > 'Report' tab at the top and then 'Report Properties...' On the
> > 'General' tab, select 'Auto Refresh' near the bottom and select the
> > number of seconds between refreshes.
> > Regards,
> > Enrique Martinez
> > Sr. Software Developer
> Thanks
> it has done my work.
You're welcome. Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Developersql

Automatic Printing of Reporting Services reports through subscriptions

To all the techies,

We are trying to schedule the report for automatic printing using subscriptions. Does any one have any idea of how to achieve this?

Any inputs appreciated.

AM

You can take a look at the custom extention sample for Reporting Service. This extention allows you to deliver your subscription to a network printer known by the reporting server.

The default location is: C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\PrinterDelivery Sample.

|||i have read the install sheet that goes with the sample. my question is how does one get it going?

Automatic Printing of Reporting Services reports through subscriptions

To all the techies,

We are trying to schedule the report for automatic printing using subscriptions. Does any one have any idea of how to achieve this?

Any inputs appreciated.

AM

You can take a look at the custom extention sample for Reporting Service. This extention allows you to deliver your subscription to a network printer known by the reporting server.

The default location is: C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\PrinterDelivery Sample.

|||i have read the install sheet that goes with the sample. my question is how does one get it going?

Automatic printing from ReportViewer control

Hi,
I've got a WinForm app written in .NET 2.0 (C#). We have a series of SQL
Reporting Services reports which are on a remote server - not RDLCs. I've
got a ReportViewer control on one of the forms, and am able to render the
reports in the ReportViewer just fine. However, I would like to be able to
print these reports, preferably without displaying any UI at all, through
this app. Does anybody have any suggestions? I realize that RDLCs would
work in this case, but that's not an option, unfortunately.
Thanks, JimOn Jan 4, 6:34 pm, "LiveCycle" <livecy...@.sandbox.etech.adobe.com>
wrote:
> Hi,
> I've got a WinForm app written in .NET 2.0 (C#). We have a series of SQL
> Reporting Services reports which are on a remote server - not RDLCs. I've
> got a ReportViewer control on one of the forms, and am able to render the
> reports in the ReportViewer just fine. However, I would like to be able to
> print these reports, preferably without displaying any UI at all, through
> this app. Does anybody have any suggestions? I realize that RDLCs would
> work in this case, but that's not an option, unfortunately.
> Thanks, Jim
This link should be helpful.
http://forums.asp.net/p/516455/533549.aspx
Regards,
Enrique Martinez
Sr. Software Consultant

Automatic Printing

Hello All,
Thanks in advance for helping me to solve my problem. I want to print
the invoices automatically through Reporting Services. I am sending a
parameter to the Report which may contains one or more pages in it,
when i press any button, these report should print automatically with
all pages and page numbers without displaying it on screen. I tried
Pring Sample Delivery Services but i dont know why it wont work, when i
subscribe for that Delivery service it shows me error. Can anybody help
me how to solve this? again my requirement is to print invoices
automatically with all number of pages which accepts parameter (for ex.
Invoicenumber).
Thank you !
Waiting for Shower of answers
RajI think you will have to write custom delivery extension (that delivers
the report to a printer) at a predetermined schedule.
if you want to send the report the printer interactively (as i
understand from your use case), can you use the browser print button?
I read on BOL that ssrs 2005 has advanced print features.
Raj wrote:
> Hello All,
> Thanks in advance for helping me to solve my problem. I want to print
> the invoices automatically through Reporting Services. I am sending a
> parameter to the Report which may contains one or more pages in it,
> when i press any button, these report should print automatically with
> all pages and page numbers without displaying it on screen. I tried
> Pring Sample Delivery Services but i dont know why it wont work, when i
> subscribe for that Delivery service it shows me error. Can anybody help
> me how to solve this? again my requirement is to print invoices
> automatically with all number of pages which accepts parameter (for ex.
> Invoicenumber).
> Thank you !
> Waiting for Shower of answers
> Raj

Automate deployment of reporting project

I have to deploy reports several times a day [to our teesting environment]
due to contstant changes by devlopers. Does anyone know of a way to automate
the deployment process? Even doing something with VBA will work. I don't
see any possible references listed in the VBA references section - would the
createobject method work? Has anyone does this? I would love to get this on
a schedule and off my plate.
Thanks in advance,
John Hennesey
p.s. Third party programs are an option too, if anyone knows of any.You should be able to do all you need with a bit of scripting and the rs
utility. The following link should give you an idea, based on the reporting
services sample reports:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_sampleapps_v1_1apd.asp
"JohnHennesey" wrote:
> I have to deploy reports several times a day [to our teesting environment]
> due to contstant changes by devlopers. Does anyone know of a way to automate
> the deployment process? Even doing something with VBA will work. I don't
> see any possible references listed in the VBA references section - would the
> createobject method work? Has anyone does this? I would love to get this on
> a schedule and off my plate.
> Thanks in advance,
> John Hennesey
> p.s. Third party programs are an option too, if anyone knows of any.|||Thank you for your response. This will do the trick, will take a bit of
massaging to get it to where I want it to be. Ideally if I could use the
Visual Sourcesafe object model to pull down the latest code, then use a .Net
object model to open the solution, change the deployment path then deploy it
would be ideal.
But, I can use command line script to pull down the latest code base from
SS, then iterate through the file list (.rdl's only) via the Scripting engine
and deploy from there.
Thanks for your help!
John
"David Jennaway" wrote:
> You should be able to do all you need with a bit of scripting and the rs
> utility. The following link should give you an idea, based on the reporting
> services sample reports:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_sampleapps_v1_1apd.asp
> "JohnHennesey" wrote:
> > I have to deploy reports several times a day [to our teesting environment]
> > due to contstant changes by devlopers. Does anyone know of a way to automate
> > the deployment process? Even doing something with VBA will work. I don't
> > see any possible references listed in the VBA references section - would the
> > createobject method work? Has anyone does this? I would love to get this on
> > a schedule and off my plate.
> >
> > Thanks in advance,
> > John Hennesey
> >
> > p.s. Third party programs are an option too, if anyone knows of any.

Autoincrementing file share

Hi all,
I'm really new at reporting services. I'm hoping someone can help.
I have a subscription that runs daily. The MSDN tells me
"AutoIncrement, the report server appends a timestamp or number to the file
name to distinguish it from existing files of the same name".
Currently the number is being appended to the file name daily, however I
would like the timestamp appended. Any ideas how to achieve this?
Thanks
DebbieSorry about the duplicate posts. I couldn't find the original one I posted.
Now that I have found it, I can't delete this one. >_<
Debbie
"Debbie" wrote:
> Hi all,
> I'm really new at reporting services. I'm hoping someone can help.
> I have a subscription that runs daily. The MSDN tells me
> "AutoIncrement, the report server appends a timestamp or number to the file
> name to distinguish it from existing files of the same name".
> Currently the number is being appended to the file name daily, however I
> would like the timestamp appended. Any ideas how to achieve this?
> Thanks
> Debbie
>

Auto Print

I am using Visual studio 2005. This may be a vb question but it deals with reporting services.

I have a local report using the reportviewer control. (rdcl 2005 fmt)

It displays perfectly, and when i click the print button it prints flawlessly.

How do i print the document to the default printer automatically?

This seems like a basic function that i can't seem to find the answer to.

Thanx

Jerry Cicierega

I found the answer. Its not as bad as it looks. Thois is a form called "slip.vb" I am printing to a slip printer. The form has a rpt viewer on it. The form nevers shows. It is just used as a containor for the report. I created the report as an RDL report. I coppied it into the program folder and re-named it to a RDCL extension. I then established the datasource. and it worked interactivly. I then added the following code and presto. Auto Print. I also asume the default printer is the printer of choice.

Imports System.IO

Imports System.Data

Imports System.Text

Imports System.Drawing.Imaging

Imports System.Drawing.Printing

Imports System.Collections.Generic

Imports Microsoft.Reporting.WinForms

Public Class Slip

Private m_currentPageIndex As Integer

Private m_streams As IList(Of Stream)

Public Sub Print_Slip()

Me.TxnHistoryTableAdapter.Connection.ConnectionString = My.Utilities.ConnectionString

Me.TxnHistoryTableAdapter.FillBy(Me.PCZonDataSet.TxnHistory, My.GlobalVariables.ComputerData.ComputerName, My.GlobalVariables.ComputerData.Sequencenumber)

Export(Me.ReportViewer1.LocalReport)

m_currentPageIndex = 0

Print()

End Sub

Private Function CreateStream(ByVal name As String, _

ByVal fileNameExtension As String, _

ByVal encoding As Encoding, ByVal mimeType As String, _

ByVal willSeek As Boolean) As Stream

Dim stream As Stream = New FileStream(name + "." + fileNameExtension, FileMode.Create)

m_streams.Add(stream)

Return stream

End Function

Private Sub Export(ByVal report As LocalReport)

Dim deviceInfo As String = _

"<DeviceInfo>" + _

" <OutputFormat>EMF</OutputFormat>" + _

" <PageWidth>9in</PageWidth>" + _

" <PageHeight>11in</PageHeight>" + _

" <MarginTop>0.0in</MarginTop>" + _

" <MarginLeft>0.0in</MarginLeft>" + _

" <MarginRight>0.25in</MarginRight>" + _

" <MarginBottom>0.25in</MarginBottom>" + _

"</DeviceInfo>"

Dim warnings() As Warning = Nothing

m_streams = New List(Of Stream)()

report.Render("Image", deviceInfo, _

AddressOf CreateStream, warnings)

Dim stream As Stream

For Each stream In m_streams

stream.Position = 0

Next

End Sub

Private Sub Print()

If m_streams Is Nothing Or m_streams.Count = 0 Then

Return

End If

Dim printDoc As New PrintDocument()

AddHandler printDoc.PrintPage, AddressOf PrintPage

printDoc.Print()

If Not (m_streams Is Nothing) Then

Dim stream As Stream

For Each stream In m_streams

stream.Close()

Next

m_streams = Nothing

End If

End Sub

Private Sub PrintPage(ByVal sender As Object, ByVal ev As PrintPageEventArgs)

Dim pageImage As New Metafile(m_streams(m_currentPageIndex))

ev.Graphics.DrawImage(pageImage, ev.PageBounds)

m_currentPageIndex += 1

ev.HasMorePages = (m_currentPageIndex < m_streams.Count)

End Sub

End Class

auto numbering

Hello,

For analyses and reporting I would like to add a 'ranking' to a
table/view.
Example:
Using the 'order by desc' clause in query I get a list of Customers
ordered by Turnover (descending). I would like to add that ranking
numbers (same as recordnumbers) in the query. I would like to have the
following result:
Cust_nr Cust_Name Turnover_2004 Ranking
002234 Bayer 139.000 1
003456 Rentokill 123.456 2
001231 Air France 105.000 3
etc.

When the 'ranking' is part of the query/table I can use this ranking in
an other query.

Important: This questions is not about making an (empty) table structure
for filling in by an application and generating a new unique number each
time a record is added.

I hope you can help me.

Thanks,

Hans

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!On 10 Mar 2005 03:14:43 -0600, Hans de Korte wrote:

>Hello,
>For analyses and reporting I would like to add a 'ranking' to a
>table/view.
>Example:
>Using the 'order by desc' clause in query I get a list of Customers
>ordered by Turnover (descending). I would like to add that ranking
>numbers (same as recordnumbers) in the query. I would like to have the
>following result:
>Cust_nr Cust_Name Turnover_2004 Ranking
>002234 Bayer 139.000 1
>003456 Rentokill 123.456 2
>001231 Air France 105.000 3
>etc.
>When the 'ranking' is part of the query/table I can use this ranking in
>an other query.
(snip)

Hi Hans,

I'd recommend against storing it in the table, as you'll need to update
all rankings each time some data in the table changes. (Of course, if
you have a static database, where data won't change but that you have to
run extensive reports off, things change).

In a live database, I'd define a view to hold the ranking:

CREATE VIEW CustomersRanked
AS
SELECT Cust_nr, Cust_Name, Turnover_2004,
(SELECT COUNT(*)
FROM Customers AS b
WHERE b.Turnover_2004 > a.Turnover_2004) + 1 AS Ranking
FROM Customers AS a
ORDER BY Turnover_2004 DESC
(untested)

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||Thanks, the soluttion is working excellent!!

Regards,

Hans

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!