Printer Delivery Sample Modified
Jan 3, 2008
I am trying to modify the Printer Delivery Sample (RS 2005).
The original sample works fine: there was no any problem with deployment and running it.
What I need to accomplish is saving each delivered report as a local XML file.
For now (to start with), I'm just trying to read the rendered report as XML, and write the string (whatever the report contains) into a text file.
I added the following code to the PrintReport(...) method in the PrinterDeliveryProvider.cs file:
deviceInfo = String.Format(
System.Globalization.CultureInfo.InvariantCulture,
@"<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>",
"xml");
RenderedOutputFile[] testFiles = notification.Report.Render("XML", deviceInfo);
using (FileStream fs = File.Create(@"C: est est.txt"))
{
using (StreamWriter sw = new StreamWriter(fs))
{
sw.WriteLine("******************");
try
{
Stream streamTemp = (Stream)testFiles[0].Data;
byte [] byteData = new byte[streamTemp.Length];
for (int i = 0; i < byteData.Length; i++)
{
byteData[ i ] = (byte)streamTemp.ReadByte();
}
using (MemoryStream ms = new MemoryStream(byteData))
{
string result = Convert.ToBase64String(ms.ToArray());
sw.WriteLine(result);
}
}
catch (Exception ex)
{
sw.WriteLine(ex.Message);
}
sw.Flush();
}
}
After I re-deploy the modified assembly and create a simple subscription, it fires, and there are no exceptions. But instead of some good-looking XML in the test.txt file, I get this:
******************
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
[Actually, there are much more slashes, but I am showing just the beginning of the file - for brevity...]
When I run this report in ReportManager and export it as "XML file with report data", that XML exported file looks exactly as I expect it to. So, the data is there, in the report, but how do I extract it?
I've been trying to figure out why I am not getting the real content of the report in XML format.
Maybe, this line is wrong: RenderedOutputFile[] testFiles = notification.Report.Render("XML", deviceInfo);
AND/OR this line is wrong: deviceInfo = String.Format(................etc.
AND/OR I am using a wrong method for converting the Stream to a string.
...or, something else?
Could someone kindly help me figure out what I'm doing wrong, please?
View 3 Replies
ADVERTISEMENT
Sep 18, 2007
I have installed the printer delivery sample and made the changes to the config files as described in the documentation but can only see it available as an option in the data driven subscriptions section. Anyone know how I can get it to show up in the standard subscriptions option?
Cheers,
Martin
View 4 Replies
View Related
Mar 14, 2007
Can anyone help on this topic...
i need to set Printer Delivery Extension, and create a subscription for report which will be sent to the printer automatically
View 1 Replies
View Related
Mar 28, 2006
Hi
Books online mention the existence of sample code for several custom tasks, including the one mentioned in the title. But, when I try to find this code in the location mentioned it is nowhere to be found.
I have run a search on the rest of my drive and come up empty.
Can anyone tell me where to find this?
Thanks
View 3 Replies
View Related
Feb 29, 2008
Im trying to use VB.net 2005 to write a sample app to access a DB. Are there any samples for this and any samples of how I go about making the DB in the first place?
View 1 Replies
View Related
Dec 7, 2005
Anybody please help me about the printer. I have a user want to print the letter from tray3, he slects the tray3, but it always print from tray2. I tried by myself. It is the same thing. Anybody can help me?
View 9 Replies
View Related
Apr 12, 2001
Greetings,
1. I would like to print one of my database to a printer, how can I do that?
2. I would like to transfer one of my database to Microsoft Excel 97/2000, how can I do that?
Thank you very much.
View 6 Replies
View Related
Mar 1, 2007
Is there a way to route a file directly to a printer? I have a process that creates PDF file in a known location and I would like to route them directly to the printer after creation.
View 2 Replies
View Related
Apr 17, 2007
I have a client who tells me in Access you could assign the printer directly to the report using PrtDevNames and PrtDevMode. Apparently it's true.
Can this be done in Reporting Services?
View 2 Replies
View Related
Jan 8, 2007
Is there anyway to count number of pages sent to the printer, to track them?
View 2 Replies
View Related
Jan 8, 2007
I have a windows NT service, which prints to a laser printer programmatically using MSRS 2K. It works fine with a HP printer however when I try printing to a Lexmark Printer it does not always print. Somebody help. Microsoft please release a latest patch for MSRS 2K, its been so long since we had one.
View 2 Replies
View Related
Oct 18, 2006
The code below is a class file done in vb.net. The original idea came from reading this forum and some blogs.
To use the code below, you can create a windows application or service.
then create a class file and drop this code in it.
Remeber to reference the 2005 report execution service and also in the program settings include the path to your server.
IE: ReportExecutionService = http://localhost/ReportServer/ReportExecution2005.asmx or whatever your server URL is at.
Setup the public properties for printername (sharenames work fine), Number of copies and Report name.
That is all there is to it. This code is REALLY expandable to add more options.
Please remember to let me kow if you like this.
Imports System
Imports System.Drawing
Imports System.Drawing.Imaging
Imports System.Drawing.Printing
Imports System.IO
Imports System.Web.Services.Protocols
Imports PrintReport.ReportExecution
Imports System.Runtime.InteropServices ' For Marshal.Copy
Namespace PrintReport
Friend Class app
Private m_sPrinterName As String
Private m_sReportName As String
Private m_sNumCopies As Integer
<STAThread()> _
Public Sub Main(ByVal args As String())
Dim pe As PrintMain = New PrintMain()
pe.PrintReport(m_sPrinterName, m_sReportName, m_sNumCopies)
End Sub
Public Property pPrinterName()
Get
Return m_sPrinterName
End Get
Set(ByVal value)
m_sPrinterName = value
End Set
End Property
Public Property pReportName()
Get
Return m_sReportName
End Get
Set(ByVal value)
m_sReportName = value
End Set
End Property
Public Property pNumCopies()
Get
Return m_sNumCopies
End Get
Set(ByVal value)
m_sNumCopies = value
End Set
End Property
End Class
Friend Class PrintMain
Private rs As New ReportExecutionService()
Private m_renderedReport As Byte()()
Private m_delegate As Graphics.EnumerateMetafileProc = Nothing
Private m_currentPageStream As MemoryStream
Private m_metafile As Metafile = Nothing
Private m_numberOfPages As Integer
Private m_currentPrintingPage As Integer
Private m_lastPrintingPage As Integer
Public Sub New()
' Create proxy object and authenticate
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
rs.Url = My.Settings.ReportExecutionService '"http://localhost/ReportServer/ReportExecution2005.asmx"
End Sub
Public Function RenderReport(ByVal reportPath As String) As Byte()()
' Private variables for rendering
Dim deviceInfo As String
Dim format As String = "IMAGE"
Dim firstPage As Byte() = Nothing
Dim encoding As String = ""
Dim mimeType As String = ""
Dim warnings As Warning() = Nothing
Dim reportHistoryParameters As ParameterValue() = Nothing
Dim streamIDs As String() = Nothing
Dim pages As Byte()() = Nothing
Dim historyID As String = Nothing
Dim showHideToggle As String = Nothing
Dim execInfo As New ExecutionInfo
Dim execHeader As New ExecutionHeader()
Dim SessionId As String
Dim extension As String = ""
rs.ExecutionHeaderValue = execHeader
execInfo = rs.LoadReport(reportPath, historyID)
'rs.SetExecutionParameters(parameters, "en-us")
SessionId = rs.ExecutionHeaderValue.ExecutionID
' Build device info based on the start page
deviceInfo = String.Format("<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>", "emf")
'Exectute the report and get page count.
Try
' Renders the first page of the report and returns streamIDs for
' subsequent pages
firstPage = rs.Render(format, deviceInfo, extension, encoding, mimeType, warnings, streamIDs)
' The total number of pages of the report is 1 + the streamIDs
m_numberOfPages = streamIDs.Length + 1
pages = New Byte(m_numberOfPages - 1)() {}
' The first page was already rendered
pages(0) = firstPage
Dim pageIndex As Integer = 1
Do While pageIndex < m_numberOfPages
' Build device info based on start page
deviceInfo = String.Format("<DeviceInfo><OutputFormat>{0}</OutputFormat><StartPage>{1}</StartPage></DeviceInfo>", "emf", pageIndex + 1)
pages(pageIndex) = rs.Render(format, deviceInfo, extension, encoding, mimeType, warnings, streamIDs)
pageIndex += 1
Loop
Catch ex As SoapException
'Console.WriteLine(ex.Detail.InnerXml)
Catch ex As Exception
'Console.WriteLine(ex.Message)
Finally
'Console.WriteLine("Number of pages: {0}", pages.Length)
End Try
Return pages
End Function
Public Function PrintReport(ByVal printerName As String, ByVal ReportName As String, Optional ByVal NumCopies As Integer = 0) As Boolean
Me.RenderedReport = Me.RenderReport(ReportName)
Try
' Wait for the report to completely render.
If m_numberOfPages < 1 Then
Return False
End If
Dim printerSettings As PrinterSettings = New PrinterSettings()
printerSettings.MaximumPage = m_numberOfPages
printerSettings.MinimumPage = 1
printerSettings.PrintRange = PrintRange.SomePages
printerSettings.FromPage = 1
printerSettings.ToPage = m_numberOfPages
printerSettings.Copies = NumCopies
printerSettings.PrinterName = printerName
Dim pd As PrintDocument = New PrintDocument()
m_currentPrintingPage = 1
m_lastPrintingPage = m_numberOfPages
pd.PrinterSettings = printerSettings
' Print report
'Console.WriteLine("Printing report...")
AddHandler pd.PrintPage, AddressOf pd_PrintPage
pd.Print()
Catch ex As Exception
'Console.WriteLine(ex.Message)
Finally
' Clean up goes here.
End Try
Return True
End Function
Private Sub pd_PrintPage(ByVal sender As Object, ByVal ev As PrintPageEventArgs)
ev.HasMorePages = False
If m_currentPrintingPage <= m_lastPrintingPage AndAlso MoveToPage(m_currentPrintingPage) Then
' Draw the page
ReportDrawPage(ev.Graphics)
' If the next page is less than or equal to the last page,
' print another page.
If m_currentPrintingPage <= m_lastPrintingPage Then
m_currentPrintingPage += 1
ev.HasMorePages = True
End If
End If
End Sub
' Method to draw the current emf memory stream
Private Sub ReportDrawPage(ByVal g As Graphics)
If Nothing Is m_currentPageStream OrElse 0 = m_currentPageStream.Length OrElse Nothing Is m_metafile Then
Return
End If
SyncLock Me
' Set the metafile delegate.
Dim width As Integer = m_metafile.Width
Dim height As Integer = m_metafile.Height
m_delegate = New Graphics.EnumerateMetafileProc(AddressOf MetafileCallback)
' Draw in the rectangle
Dim destPoint As Point = New Point(0, 0)
g.EnumerateMetafile(m_metafile, destPoint, m_delegate)
' Clean up
m_delegate = Nothing
End SyncLock
End Sub
Private Function MoveToPage(ByVal page As Int32) As Boolean
' Check to make sure that the current page exists in
' the array list
If Nothing Is Me.RenderedReport(m_currentPrintingPage - 1) Then
Return False
End If
' Set current page stream equal to the rendered page
m_currentPageStream = New MemoryStream(Me.RenderedReport(m_currentPrintingPage - 1))
' Set its postion to start.
m_currentPageStream.Position = 0
' Initialize the metafile
If Not Nothing Is m_metafile Then
m_metafile.Dispose()
m_metafile = Nothing
End If
' Load the metafile image for this page
m_metafile = New Metafile(CType(m_currentPageStream, Stream))
Return True
End Function
Private Function MetafileCallback(ByVal recordType As EmfPlusRecordType, ByVal flags As Integer, ByVal dataSize As Integer, ByVal data As IntPtr, ByVal callbackData As PlayRecordCallback) As Boolean
Dim dataArray As Byte() = Nothing
' Dance around unmanaged code.
If data <> IntPtr.Zero Then
' Copy the unmanaged record to a managed byte buffer
' that can be used by PlayRecord.
dataArray = New Byte(dataSize - 1) {}
Marshal.Copy(data, dataArray, 0, dataSize)
End If
' play the record.
m_metafile.PlayRecord(recordType, flags, dataSize, dataArray)
Return True
End Function
Public Property RenderedReport() As Byte()()
Get
Return m_renderedReport
End Get
Set(ByVal value As Byte()())
m_renderedReport = value
End Set
End Property
End Class
end namespace
View 27 Replies
View Related
Aug 10, 2007
I am looking for a way to remove the printer symbol from the report manger because it dows not work on some client machines because they are locked down. For us it is completely sufficient to export to PDF.
Is there a setting or an entry in the web config or something else. A hint would be helpful
Thanks
HANNES
View 3 Replies
View Related
Aug 1, 2007
I believe this is an extension of the problem described here:
http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=115351
The service pack for Visual Studio has fixed the problem when I print my report from VS, however when I deploy and print my reports from the SSRS website they are still incorrect.
My SSRS server is running SQL 2005 with service pack 2 installed and the 9.00.3152 9333097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 also applied.
I find it hard to believe the problem was fixed in the developer tool but NOT in the client tool?
How can I develop reports when the output from the developer tool is different to the output from the client tool?
For example I specify a box to be 5cm wide, and when printed from visual studio it is 5cm wide, but when printed from the SSRS website it is not 5cm wide!
Thanks.
View 6 Replies
View Related
Aug 22, 2007
Hello,
I am trying to get a SSRS 2005 report to print from my Visual Studio 2005 C++ application without using the ReportViewer to preview it first. What I have done is created a dll that I call into when I want to access a certain report and print it. While searching around on the internet I found an MSDN article about printing a report without previewing and it had an example in C# code. So I used that as a guide for my C++ code but I am still having problems with rendering the report properly so it can be printed. When I try to render a report using the "Image" format, my streamid string is empty but the byte array that the render routine returns is not. Here is the code I am using, what could be the problem here?
Note: m_Streams is define elsewhere as
array<String^>^ m_Streams = gcnew array<String^>(10);
void Print::Export(LocalReport^ report)
{
array<Warning^>^ Warn = gcnew array<Warning^>(10);
String^ deviceinfo =
"<DeviceInfo>" +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0.25in</MarginTop>" +
" <MarginLeft>0.25in</MarginLeft>" +
" <MarginRight>0.25in</MarginRight>" +
" <MarginBottom>0.25in</MarginBottom>" +
"</DeviceInfo>";
String^ mimeType;
String^ enc;
String^ FileExt;
array<Byte>^ bytes;
bytes = report->Render("Image",deviceinfo, mimeType, enc, FileExt, m_Streams,Warn); // m_Streams has a length of
return; // 0 after the Render
}
void Print:: PrintPage(System:: Object^ sender, System:: Drawing:: Printing:: PrintPageEventArgs^ ev)
{
Metafile^ pageImage = gcnew Metafile(m_Streams[m_CurrentPage]);
ev->Graphics->DrawImage(pageImage, ev->PageBounds);
m_CurrentPage++;
ev->HasMorePages = (m_CurrentPage < m_Streams->Length);
return;
}
void Print:rintRpt()
{
String^ printerName = "Default";
if (m_Streams->Length < 0)
return;
PrintDocument^ printDoc = gcnew PrintDocument();
if (!printDoc->PrinterSettings->IsValid) {
return;
}
printDoc->PrintPage += gcnew PrintPageEventHandler(this, &Print:: PrintPage);
printDoc->Print();
return;
}
void Print::Run()
{
LocalReport^ report = gcnew LocalReport();
DataSet^ ds = gcnew DataSet();
LoadData(ds);
report->ReportPath = "c:\bmi\bulrpt\Report1.rdlc";
ReportDataSource^ RDS = gcnew ReportDataSource();
RDS->Name = "DataSet1_Subject";
RDS->Value = ds->Tables["Subject"];
report->DataSources->Add(RDS);
Export(report);
PrintRpt();
return;
}
DataTable^ Print:: LoadData(DataSet^ ds)
{
System:: String ^ConnStr = "SELECT * FROM Subject";
SqlConnection^ conn = gcnew SqlConnection("Data Source=JOE-PC\BMIMSDESERVER; Initial Catalog=stx52013;Integrated Security = TRUE");
SqlCommand^ command = gcnew SqlCommand(ConnStr, conn);
SqlDataAdapter^ adapt = gcnew SqlDataAdapter(command);
adapt->TableMappings->Add("Table", "Subject");
conn->Open();
adapt->Fill(ds);
return ds->Tables["Subject"];
}
View 2 Replies
View Related
Feb 1, 2007
Very strange problem here with Reporting Services SQL 2005 SP1 with latest patch KB 918222 on Windows Server 2003 SP1. The clients PC are Windows XP both SP1 and SP2 and that's not affecting our problems.
When my default printer is set to the "Printer 1" (HP LaserJet 9000), when i look a report's into the Report Viewer and i click on the print button (printer image button that use the ActiveX RSClientPrint), i let the default printer to "Printer 1". In this case, the report is printed correctly.
Again with my default printer set to "Printer 1", i look the same report into the Report Viewer and i click on the print button again. This time i select another printer "Printer 2" (an older HP LaserJet 8000 DN) and the report is printed correctly.
Now the problem is when i set the "Printer 2" as default printer. If i go to the Report Viewer and i click on the print button for the same report that was printed correctly before, now the report seem's to be ok into the preview before i print, but when i send the job to the "Printer 2" the report require a unknown paper format, so the "Printer 2" ask paper into the tray 1 (manual feed) and the result of the printed report is not good. The right and the bottom seem's to be cutted. I tried to reduce the report dimension without good results. The report is always cutted to right and bottom and the printer ask paper into the tray 1 (unknown paper).
Is't not the end, if i print the same report on the "Printer 1" when the default printer is "Printer 2", the report is printed correctly.
I have tried to use another printer than the "Printer 2" to see if the problem is the printer. I tried the "Printer 3" (HP LaserJet 9050) as default printer, i print the report on this one and i have the same problem than with the "Printer 2". And if i set "Printer 1" as default and i print on the "Printer 3" the report is printing correctly.
For all the printers i have the latest drivers. The same problem is occuring on all other PC other than mine.
We have checked the printers configuration and all seem's to have the same configuration.
Can this be a bug with the ActiveX RSClientPrint or what ?
Note that all previews before printing are good with all printers, but with the "Printer 2" and "Printer 3" set to default, the printed report was not the one i saw into the Preview.
Below a link to a sample report that we have. All our reports have the same global dimensions.
http://pages.videotron.com/poulinst/report.zip
View 1 Replies
View Related
Feb 5, 2008
My company has a .Net app that embeds the reportwriter for displaying (and printing) reports. This seems to work fine visa vis printing reports in landscape mode, although odly if you look at the printer properties it SAYS it is priting in portrait. In any case, the problem comes when this default reportwriter isn't used but rather an rdl file is generated programmatically. No matter what width and height settings we use, the document unfailingly prints in portrait mode. I've looked to see whether there is any way to force the printer mode, but it seems there isn't, at least not through an rdl. Or what SHOULD work (setting the width larger than the heigh) does not. I'm wondering if anyone else here has run into difficulties like this if there are any solutions or places I might look for answers? Thanks!
View 1 Replies
View Related
Aug 24, 2006
Hi,
Does anyone know how to print from a CLR trigger?
Cheers
James
View 1 Replies
View Related
Apr 15, 2004
Is anyone else having problems with subscriptions and delivery with SQL Reporting Services? I can set up a subscription and uncheck "Include Report" and the email sends fine. When I try and "Include Report" such as a PDF I get "Failure sending mail: The Report Server has encountered a configuration error; more details in the log files" This was the default set up. I guess I am not sure as to what user/service accounts should be used. The Reporting Service and SQL are on the same machine (2003).
Thanks for ANY suggestions!!
If it helps. The Log file:
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!117c!04/15/2004-17:38:10:: Notification 6fbda5ab-c633-4e37-a168-29348fcc58e0 completed. Success: False, Status: Failure sending mail: The Report Server has encountered a configuration error; more details in the log files, DeliveryExtension: Report Server Email, Report: eBusinessRequests, Attempt 0
ReportingServicesService!dbpolling!117c!04/15/2004-17:38:10:: NotificationPolling finished processing item 6fbda5ab-c633-4e37-a168-29348fcc58e0
ReportingServicesService!library!117c!04/15/2004-17:44:46:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
ReportingServicesService!dbpolling!a60!4/15/2004-17:46:09:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!117c!04/15/2004-17:46:09:: EventPolling processing item 60afa787-7b2b-4a39-b61f-f52c87620ca1
ReportingServicesService!library!117c!04/15/2004-17:46:09:: Schedule bf0fc6ef-14b1-4967-b4ca-d86d49641cb6 executed at 04/15/2004 17:46:09.
ReportingServicesService!schedule!117c!04/15/2004-17:46:09:: Creating Time based subscription notification for subscription: 7c778107-5940-43b3-8b62-62630510d503
ReportingServicesService!library!117c!04/15/2004-17:46:09:: Schedule bf0fc6ef-14b1-4967-b4ca-d86d49641cb6 execution completed at 04/15/2004 17:46:09.
ReportingServicesService!dbpolling!117c!04/15/2004-17:46:09:: EventPolling finished processing item 60afa787-7b2b-4a39-b61f-f52c87620ca1
ReportingServicesService!dbpolling!a60!4/15/2004-17:46:09:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!117c!04/15/2004-17:46:09:: NotificationPolling processing item 23e10ae2-063e-41da-b1bf-241e7a3ec010
ReportingServicesService!emailextension!117c!04/15/2004-17:46:10:: Email successfully sent to "preisinger@ronco.net" <preisinger@ronco.net>
ReportingServicesService!notification!117c!04/15/2004-17:46:10:: Notification 23e10ae2-063e-41da-b1bf-241e7a3ec010 completed. Success: True, Status: Mail sent to preisinger@ronco.net, DeliveryExtension: Report Server Email, Report: eBusinessRequests, Attempt 0
ReportingServicesService!dbpolling!117c!04/15/2004-17:46:10:: NotificationPolling finished processing item 23e10ae2-063e-41da-b1bf-241e7a3ec010
ReportingServicesService!library!117c!04/15/2004-17:54:46:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
ReportingServicesService!library!117c!04/15/2004-18:04:46:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
ReportingServicesService!dbpolling!a60!4/15/2004-18:12:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!117c!04/15/2004-18:12:10:: EventPolling processing item 047ca2e8-cba6-426d-a444-c568507ed611
ReportingServicesService!library!117c!04/15/2004-18:12:10:: Schedule f6403b01-2257-4915-b1a7-8e956063bb53 executed at 04/15/2004 18:12:10.
ReportingServicesService!schedule!117c!04/15/2004-18:12:10:: Creating Time based subscription notification for subscription: 1e5a59b4-7ce3-4d68-93fe-46eaa3fa6265
ReportingServicesService!library!117c!04/15/2004-18:12:10:: Schedule f6403b01-2257-4915-b1a7-8e956063bb53 execution completed at 04/15/2004 18:12:10.
ReportingServicesService!dbpolling!117c!04/15/2004-18:12:10:: EventPolling finished processing item 047ca2e8-cba6-426d-a444-c568507ed611
ReportingServicesService!dbpolling!a60!4/15/2004-18:12:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!117c!04/15/2004-18:12:10:: NotificationPolling processing item 233cdee0-a477-4ae0-9af3-10871c1c7d63
ReportingServicesService!library!117c!04/15/2004-18:12:10:: i INFO: Call to RenderFirst( '/eBusinessRequests/eBusinessRequests' )
ReportingServicesService!library!117c!04/15/2004-18:12:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 110;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
ReportingServicesService!library!117c!04/15/2004-18:12:10:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!117c!04/15/2004-18:12:10:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report Server has encountered a configuration error; more details in the log files ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyDate)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
View 3 Replies
View Related
Dec 8, 2004
Using the BCP utility ->
With a degree character in the flat data file, can anyone deliver this to a table without SQL Server changing it to stacked bar: ¦
CREATE TABLE "dbo"."F_conv"
(
"col1" VARCHAR(21) NOT NULL
)
;
myformat.fmt
8.0
1
1SQLCHAR030"
"1col1""
mydata.dat file
1332 NS 4° Tall 32 oz
bcp command
bcp "MY_DB"."dbo"."F_conv" in "mydata.dat"
-q -S<server> -Usa -Psa -f"myformat.fmt"
View 3 Replies
View Related
Mar 27, 2007
hi all,
I have created a report using sql server 2005 RS.Ive deployed it in the server(localhost)also.In the subsription section of the report manager ive mentioned a emailid to whom ive to send the report.Ive selected the report server email delivery method from the dropdown list.After entering the emailid and scheduling the report and when i click ok i find that the report was not delivered.Im getting this error.
Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.
I culdnt find enything in the log files.
Can any1 help me as how to accomplish this?
Balaji
View 2 Replies
View Related
May 4, 2006
Hi,
I'm new to SSIS but have been using BizTalk for a while. My question is, if the FTP task in SSIS ensures guranteed delivery of the files transferred. I know that in BTS, potnetially you can start processing incomplete files (unless you set the staging, temp folder). Can this be a problem in SSIS FTP transfer? I'll be dealing with very large files (5 gigs in some cases) transfers via FTP, on an unreliable network in my project, which means that the file can be partially transferred when the connection breaks down.
I need to know, if in SSIS
(1) FTP task supports partial transfers, and then resuming the download/ upload of these files from point of failure, when the network is again available (Regets, Reputs)?
(2) If EOF is received, before the rest of data is received, especially in the case if 1) is supported, then does FTP task believe that whole file is received or will it wait for the rest of content, before task completion?
I'll appreciate if someone can answer these and can also send me the details of FTP implementation in SSIS
Thanks,
Ali Shahzad
View 1 Replies
View Related
Apr 11, 2007
I'm using the web service to run reports from an application. However, I don't want to wait for a report to complete; I would like to just have the report emailed to the user when it is complete. I've only found email delivery through subscriptions. Is there another way to deliver reports via email?
If I have to use subscriptions I would like to set them to run "immediately". I've found that setting the start date to sometime in the past does not seem to run the report. Is there some way to set a schedule to run immediately. I've thought of setting the time to the near future, but I seem to have the problem of getting the proper timestamp. Can I get this through the web service some how?
Thanks,
Sam
View 1 Replies
View Related
Mar 16, 2007
Is SSRS limited to delivering reports to recipients inside your domain (active directory)? I'm using an SMTP server for report delivery an have set the SendMailToUserAlias to False and still can only send reports to e-mails with my domain (user@mycompany.com). I need to send reports to recipients outside my company -- is SSRS capable? If so, how do I configure it to do so?
View 1 Replies
View Related
May 21, 2008
I am trying to send an email out, from an SQL Server with Microsoft Office 2000 Premium (Professional also available) (could have option for Office
2003 also) installed on it (only outlook is installed, however we can change
that) It's Windows 2k3 running Microsoft SQL 2000 server SP 4.
I need to be able to, via SQL (or a stored procedure) automate sending of emails out via xp_sendmail or some other system, with delivery receipts attached to them, so that when they hit the client's server we know it. I can get it to send a delivery receipt when remoting into outlook and sending an email through outlook automatically, however it does not attach one to the ones going out with xp_sendmail. I know there's a way to do it via ASP.Net, but I'd much prefer to have a job that goes out and finds which emails need sent, and have the database server auto make the email, and sent it out on our behalf, instead of requiring someone to go in and click sends, and such via ASP.Net.
Any help will be greatly appreciated.
View 2 Replies
View Related
Jul 27, 2006
Hi There
I was wondering if someone could elaborate (or provide a link) on how the once only delivery works for servcie broker.
For example you have DB1 that sends messages to DB2. DB1 has corruption at 1pm, you retore the database to 12:30pm, this will have all the messages that were in this instance at 12:30 , however between 12:30 AND 1PM several successful messages were sent. These messages are in the restored DB1 queue, they get sent again?
How does service borker ensure that these messages are not processed again. The only thing i can think of is that the inititator or target keep a complete history of messages processed. But surely this "table" would get huge and slow down servcie broker if it had to check this tale every time a message is sent or received.
I cannot find much in BOL on this topic, or maybe i cannot find the topic.
Thanx
View 1 Replies
View Related
Aug 31, 2006
Hi!
Well..
I've several big tables which take part in the merge replication (web synchronization is used)
Is there any *painless* solution to delivery these tables to the subscribers?
Otherwise I've the snapshot with dozens of Mb..
Yes, the Parameterized Row Filters can be used, but sometimes it's necessary to get the whole table
Thanks
Paul
View 6 Replies
View Related
Aug 24, 2007
I have a delivery extension that prints to network printers.
Now I add a subscription like a few minutes in the future via web service for each report to print.
Is there a way I can trigger the delivery directly?
Thanks for ideas, guys.
Michael
View 3 Replies
View Related
Apr 4, 2008
hello,
I am trying to enable service broker by issuing this command:
USE master ;
GO
ALTER DATABASE msdb SET ENABLE_BROKER ;
GO
It is taking a while to do that and I am wondering whether msdb needs to be in single user mode? Some smaller dbs completed right away. Going through Surface area config I got a message that I need a service broker endpoint and I looked at my other db and that has dbmail functioning and same message saying this instance needs an endpoint in surface config, what do you think is wrong?
View 1 Replies
View Related
Mar 14, 2007
I have a report server set with an smtp account with Alias set to False but will not allow me to send e-mail outside the network. E-mail report delivery works fine to any e-mail with @mycompany.com but to an e-mail like @hotmail.com it gets rejected saying e-mail not recognized. I tried all config possibilities know to this man but nothing works. If long into the smtp server itself I can send e-mails outside of company. I'm thinking it may require a password from SSRS config but there is no place to put one. Any one know how to config SSRS to deliver e-mails to any and all e-mails accounts?
View 1 Replies
View Related
Jun 12, 2007
I have a report which is scheduled to run every monday morning and it generates PDF and writes it to a shared location. Shared location and schedule is defined through Subscription. All this is working fine so far. Now I need to provide a facility from the webpage to execute this scheduled task on demand. So there would be a button on the website which would actually run this scheduled task and update the PDF at the shared location. How do I run this scheduled task/subscription using the vb.net code. Is there anything in ReportService2005 or ReportExecution2005 webservice? Please advise.
Thanks
View 3 Replies
View Related
Jul 23, 2007
Hi all,
We're running into some random errors on our reporting server (Windows Server 2003, SQL Server 2000 Enterprise). In the application logs, we're seeing several Schedule and Delivery Processor errors (ID 108)...one for each processing extension (FileShare, Excel, HTML, etc.). In the security logs, at the same time of day, are several failure audits with the following info:
EventID: 680
User: NT AUTHORITYSYSTEM
Description: Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0. Logon account: sqluser.
The odd thing is that the schedules that are failing run perfectly about 98% of the time. Once every few weeks we have a situation like this and all of our reports (approximately 200 of them...mostly Excel, all of them sent via E-Mail) fail.
Any ideas as to what might be causing this, and why it would only happen occasionally? Any help would be appreciated! Thanks!
-Brian
View 3 Replies
View Related
Mar 19, 2007
I am having a strange intermittent problem sending reports via e-mail subscription. The report will be delivered only 20-25% of the time. I have checked the SQL logs, SQL Agent logs, System, App and Secuirty logs and see nothing obvious.
I put a network monitor on the reporting box and looked at all SMTP traffic. What happens is the reporting server connects to the SMTP box, sends the From Address and gets an OK, sends the To Address and gets an Ok. Next the reporting server sends a RSET command to the SMTP and it closes the connection.
No e-mail sent, but reporting services/SQL agent indicate success. Here is a log of the
409 25.765625 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 220 Wake County Email - Authorized Use Only, 45 bytes
410 25.765625 10.1.70.133 10.1.70.23 SMTP SMTP: Cmd sqlrptr, 14 bytes
411 25.781250 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 250-xxxxxxxxx.xxxxxxxxxx Hello sqlrptr ([10.1.70.133]), pleased to meet you, 106 bytes
412 25.781250 10.1.70.133 10.1.70.23 SMTP SMTP: Cmd FROM: xxxxxxxxx@xxxxxxxxx.xxx, 40 bytes
413 25.781250 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 250 xxxxxxxxx@xxxxxxxxx.xxx... Sender OK, 44 bytes
414 25.781250 10.1.70.133 10.1.70.23 SMTP SMTP: Cmd TO: <xxxxxxxxx@xxxxxxxxx.xxx>, 40 bytes
415 25.781250 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 250 xxxxxxxxx@xxxxxxxxx.xxx... Recipient OK, 49 bytes
416 25.781250 10.1.70.133 10.1.70.23 SMTP SMTP: Cmd RSET, Resets mail connection, 6 bytes
417 25.781250 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 250 Reset state, 17 bytes
Any suggestions?
View 1 Replies
View Related