Peduliar problem in SSRS

Hi all ,

I am encountering a peculiar problem while creating a linked report in SSRS.

The scenario:

My first reports contains 3 columns . The first 3 columns contain data from vendor table in AdventureWorks DB. They are VendorID , Name, CreditRating. The fourth column contains a link to the second report. It is just a link which jumps to the other report and passes the above three values as parameters to the second report.

The second report contains 4 parameters which includes VendorID , Name, CreditRating and one more Postedby parameter which has to be entered manually when the second report is displayed. The three parameters from first report are passed on and one extra parameter has to entered manually then only the second report displays.

It works fine when I check it on Visual Studio preview mode. I click the link for a particular row in First Report and it asks me to enter the Postedby Parameter. After entering it it displays the 2nd report. But the problem arises when I deploy it to report server. When I click the link on first report it throughs an error like " The Parameter 'PostedBy' is missing a value" whereas it should prompt the user to enter the PostedBy Parameter.

I am stuck in this and not able to understand why this happens in ReportServer and not in Visual Studio Preview mode.

Does anybody has any idea why this is happening ?

Any Suggestion will be appreciated.

Regards...

Girija Shankar Beuria

You must specify the default value for the fourth parameter. Visual Studio is an interactive environment, so you get to enter the value on request by the VS. But in production environment, reports are consumed by other applications and the report will not be able to request for an input from the calling application and this applies to Report Manager also which is an external web application that consumes the reporting services.

Shyam

|||

just go to the code and see if there is any parameter hard coded in xml.

Remove that parameter and save it .

This will probably solve your problem.

Vamsi Krishna Korasiga

Peculiar Replication (Could be OT)

We have 2 types of Production Database. One is an OLTP database another contains all the Master Tables. We also have 2 copies of each and this repeats itself for each country where the plant is located. Is there someone who can explain to me how we might
setup this Replication so that the Master tables which are maintained in one location gets replicated over to the other places and also the updated from those locations are also propogated to all locations. We had MS come into the picture and they have cr
eated triggers such that the data is copied over but they seem to delete the record and insert it back again for an Update and sometimes inbetween the delete and insert the leased line goes down and the result is a total failure.
Regards,
Trevor Benedict R
Trevor,
this is typically implemented using merge replication. You'll need to consider partitioning of data for each subscriber, or the posibility of conflicts and how they should be resolved. There's a good set of explanations of general concepts in BOL.
The network failures you experience are usually solved in merge by simply restarting the merge agent.
HTH,
Paul Ibison

PDF rendering error; log file entries included.

I am having a problem getting a report with many charts to export to PDF.
Currently the report contains 52 line charts (possibility for much more than
that)and fails when the subscription is running. If I only choose data that
returns about 10 or less charts than it will successfully create the PDF.
Is there a file size limitation or another setting I am missing in the
configuration?
Begin of log entries.
ReportingServicesService!reportrendering!f54!02/25/2005-20:37:19:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Threading.ThreadAbortException: Thread was being aborted.
at System.Drawing.SafeNativeMethods.GdipDrawImageRectI(HandleRef
graphics, HandleRef image, Int32 x, Int32 y, Int32 width, Int32 height)
at System.Drawing.Graphics.DrawImage(Image image, Int32 x, Int32 y, Int32
width, Int32 height)
at System.Drawing.Bitmap..ctor(Image original, Int32 width, Int32 height)
at System.Drawing.Bitmap..ctor(Image original)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.Process32bppArgbImages(CanvasImage
image, StringBuilder streamString, StringBuilder imageContentString, Int64&
streamLength)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImage
image, Double left, Double top, Double width, Double height, Boolean
scaleImage)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects
outlines, CanvasImage image, Double left, Double top, Double width, Double
height)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Chart.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ListContent.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.List.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!runningjobs!f54!02/25/2005-20:37:22:: i INFO:
CancelableJobExecution.Execute caught some other thread abort exception
ReportingServicesService!library!f54!02/25/2005-20:37:22:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!f54!02/25/2005-20:37:24:: Error
sending email. System.Threading.ThreadAbortException: Thread was being
aborted.
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!f54!02/25/2005-20:37:25:: Error thrown
by delivery provider: System.Threading.ThreadAbortException: Thread was being
aborted.
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
at
Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
ReportingServicesService!notification!f54!02/25/2005-20:37:26:: e ERROR:
Error occured processing notification. Thread was being aborted.
ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27::
NotificationPolling no longer processing item
36b6fea8-ebac-4de7-b5ef-74c792df8276, will be requeued
ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27:: Queue worker
thread caught unhandled exception: System.Threading.ThreadAbortException:
Thread was being aborted.
at
Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
at
Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
at
Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
state)Sometimes PDF rendering chews up quite a bit of memory. (Yes, there is room
for optimization if future versions :) You're probably hitting the upper
limits of the machine.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff S." <JeffS@.discussions.microsoft.com> wrote in message
news:FF469815-A1B9-4155-9A62-710DA4EFDBC7@.microsoft.com...
>I am having a problem getting a report with many charts to export to PDF.
> Currently the report contains 52 line charts (possibility for much more
> than
> that)and fails when the subscription is running. If I only choose data
> that
> returns about 10 or less charts than it will successfully create the PDF.
> Is there a file size limitation or another setting I am missing in the
> configuration?
>
> Begin of log entries.
> ReportingServicesService!reportrendering!f54!02/25/2005-20:37:19:: e
> ERROR:
> Throwing
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.Threading.ThreadAbortException: Thread was being
> aborted.
> at System.Drawing.SafeNativeMethods.GdipDrawImageRectI(HandleRef
> graphics, HandleRef image, Int32 x, Int32 y, Int32 width, Int32 height)
> at System.Drawing.Graphics.DrawImage(Image image, Int32 x, Int32 y,
> Int32
> width, Int32 height)
> at System.Drawing.Bitmap..ctor(Image original, Int32 width, Int32
> height)
> at System.Drawing.Bitmap..ctor(Image original)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.Process32bppArgbImages(CanvasImage
> image, StringBuilder streamString, StringBuilder imageContentString,
> Int64&
> streamLength)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImage
> image, Double left, Double top, Double width, Double height, Boolean
> scaleImage)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects
> outlines, CanvasImage image, Double left, Double top, Double width, Double
> height)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Chart.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ListContent.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.List.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
> Int32 endPage, Boolean render)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> evaluateHeaderFooterExpressions, CreateAndRegisterStream
> createAndRegisterStreamCallback)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- End of inner exception stack trace --
> ReportingServicesService!runningjobs!f54!02/25/2005-20:37:22:: i INFO:
> CancelableJobExecution.Execute caught some other thread abort exception
> ReportingServicesService!library!f54!02/25/2005-20:37:22:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!emailextension!f54!02/25/2005-20:37:24:: Error
> sending email. System.Threading.ThreadAbortException: Thread was being
> aborted.
> 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!f54!02/25/2005-20:37:25:: Error
> thrown
> by delivery provider: System.Threading.ThreadAbortException: Thread was
> being
> aborted.
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> at
> Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem
> item)
> ReportingServicesService!notification!f54!02/25/2005-20:37:26:: e ERROR:
> Error occured processing notification. Thread was being aborted.
> ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27::
> NotificationPolling no longer processing item
> 36b6fea8-ebac-4de7-b5ef-74c792df8276, will be requeued
> ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27:: Queue worker
> thread caught unhandled exception: System.Threading.ThreadAbortException:
> Thread was being aborted.
> at
> Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem
> item)
> at
> Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem
> item)
> at
> Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
> state)
>

Pbm with CONTAINS

Hi,
Can i use 'Contains' with a ColumnName like
SELECT * FROM <Table_Name>
WHERE CONTAINS ( <ColumnName>, (SELECT <AnotherColumn> FROM
<anotherTable> ))
regards laraHi
I don't think you can do this, you may want to try something like:
SELECT T.col1
FROM Test1 t, Test2 s
WHERE T.col1 LIKE '%' + s.col1 + '%'
John
"Lara" wrote:

> Hi,
> Can i use 'Contains' with a ColumnName like
> SELECT * FROM <Table_Name>
> WHERE CONTAINS ( <ColumnName>, (SELECT <AnotherColumn> FROM
> <anotherTable> ))
> regards lara
>
>