Problem with Microsoft Report on Terminal Server
06-Nov-1313 Leave a comment
http://support.microsoft.com/kb/2768741
http://go4answers.webhost4life.com/Example/problem-microsoft-report-terminal-63827.aspx
IT and business subjects
08-May-1313 Leave a comment
SOLVED
> Start > All Programs > Reporting Services Configuration Manager
> Connect
> Execution Account
> Put in new Account + Password
23-Feb-1212 Leave a comment
May be set in code or in ReportViewer control
Dim report as New LocalReport()
report.ReportPath = “Reports\ReportName.rdlc”
The errors you may get include:
When reports are added their default Build Action is Embedded Resource.
To fix this change to Content and choose a copy policy, probably Copy if Newer
Add the report as a “Linked” file ( Add existing item > Add as Link )(probably) at the same directory level as in the referenced project
Then on these linked files choose the necesary options as above
23-Feb-1212 Leave a comment
Also see next blog entry
Steps
‘See my blog. For this to work the Build Action must be changed from Embedded Resource to Content and a Copy policy chosen
‘For this to work from a different project. Add this file as a link in that project and then do above on linked file.
report.Render(“Image”, deviceInfo, AddressOf CreateStream, warnings)
For Each stream As Stream In m_streams
stream.Position = 0
Next
‘MsgBox(“End of Export”)
End Sub
‘ Draw a white background for the report
ev.Graphics.FillRectangle(Brushes.White, adjustedRect)
‘ Draw the report content
ev.Graphics.DrawImage(pageImage, adjustedRect)
‘ Prepare for the next page. Make sure we haven’t hit the end.
m_currentPageIndex += 1
ev.HasMorePages = (m_currentPageIndex < m_streams.Count)
ev.HasMorePages = False ‘#1074 srs fudge. Routecard was on 2 pages, should always be 1
End Sub
Private Sub Print()
‘MsgBox(“Start of Print”)
If m_streams Is Nothing OrElse m_streams.Count = 0 Then
Throw New Exception(“Error: no stream to print.”)
End If
Dim printDoc As New PrintDocument()
If Not printDoc.PrinterSettings.IsValid Then
Throw New Exception(“Error: cannot find the default printer.”)
Else
AddHandler printDoc.PrintPage, AddressOf PrintPage
m_currentPageIndex = 0
printDoc.Print()
End If
‘MsgBox(“End of Print”)
End Sub
Troubleshooting
28-Jan-1212 Leave a comment
Easily found on web. See example in SRS.ReportingServices.Functions and also in my invoice report.
With acknowledgement to:
http://www.jigsawboys.com/2010/03/04/ordinal-number-in-reporting-services/
Public Function FormatOrdinal(day as Integer) As String
SELECT CASE (day Mod 100)
CASE 11,12
CASE 13
Return day.ToString() + “th”
END SELECT
SELECT CASE day Mod 10
Case 1
Return day.ToString() + “st”
Case 2
Return day.ToString() + “nd”
Case 3
Return day.ToString() + “rd”
Case Else
Return day.ToString() + “th”
END SELECT
End Function
Good luck!
28-Jan-1212 Leave a comment
Code for Ordinal Number readily avialable on web. Example use in SRS.ReportingServices.Functions and also in my invoice report
Next deploying the assembly to the report server
Good luck. Acknowledgments to:
26-Jan-1212 Leave a comment
With thanks to:
http://www.bidn.com/blogs/BrianKnight/ssis/972/ssrs-action-to-open-a-url-in-a-new-window
=”javascript:void(window.open(‘”+ Fields!ReferURL.Value + “‘,’_blank’))”
22-Jan-1212 Leave a comment
After some effort I found that data in SSRS Development environment was being cached in a files called <ReportName>.rdl.data
So you may be expecting data to change and finding that it is not. To get around this you can do one of the following:
The following error may be due to this cache of data
[rsInvalidExpressionDataType] The Value expression used in textrun ‘InvoiceTitle.Paragraphs[0].TextRuns[0]’ returned a data type that is not valid.
Good luck!
19-Dec-1111 Leave a comment
So easy does not need much detail here.
My publish on a schedule to either a file share or by email.
To use Email settings need to set up in SSRS configuration of server.
PROBLEM
Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.
SOLUTION
The report credentails were Windows Authentication. For my scenario it was feasible to save low read-only credentials with the report.
04-Dec-1111 Leave a comment
See post below
May need to go to Programs > turn windows features on or off for IIS Manager
http://www.developmentnow.com/g/115_2005_11_0_0_641257/Report-Manager-Start-Up.htm
I believe the setting you are looking for is the “Shutdown worker processes
after being idle for…” on the Performance tab of the application pool that
the Reports virtual directory is assigned to.
See old post below for details:
[quoted text, click to view]
If you are running Windows 2003 server for your IIS reportserver, then this
is a simple issue – I’ll explain what happens:
The report service engine, once it is idle for more than the default 20
minutes, the worker process is shutdown.
This is controlled by IIS.
Open up the Internet Information Services (IIS) Manager
Expand the server node then the application pools.
On my IIS machine, I created an application pool dedicated to the
reportserver & reportmanager virtual webs.
But anyways, for the application pool that the reportserver is pointing to
if you left everything to their defaults will be the DefaultAppPool.
Right click the default app pool and select properties.
There are two things that are checked by default – On the recycling tab
there is a checkbox for recycling worker processes – it is currently set to
1740 minutes (29 hours). Leave it.
The other one is on the performance tab – which is the one you are
interested in changing….
See the “Idle Timeout” section and increase the number of minutes to be 8
hours a typical working day – 8*60 = 480 minutes.
Next, to be sure the “morning person” that runs the first report doesn’t get
the delay, set up a schedule for either a dummy or adhoc report to fire off
like at 6am so that the report component worker processes get loaded.