Aspose Words for SSRS SQL2008R2 - Error - Aspose.Words Product Family

Aspose.com » Public Forums for Customers an... » Aspose.Words Product Family » Aspose Words for SSRS SQL2008R2 - Error

Aspose Words for SSRS SQL2008R2 - Error

Last post 09-03-2010, 4:10 AM by DmitryV. 5 replies.


	Sort Posts: Previous Next

06-22-2010, 3:35 PM 244864

LordoftheRink
Joined on 06-17-2010
Posts 7
Issues: WORDSRPT-11 (Won't Fix)

Aspose Words for SSRS SQL2008R2 - Error

When rendering some of our reports we get the following error:

An error occurred while exporting the report.
error message	The Hidden expression for the tablix ‘tblQtytotal1’ contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null.
stack trace	at Microsoft.ReportingServices.RdlExpressions.ReportRuntime.ProcessBooleanResult(VariantResult result, Boolean stopOnError, ObjectType objectType, String objectName) at Microsoft.ReportingServices.RdlExpressions.ReportRuntime.EvaluateStartHiddenExpression(Visibility visibility, IVisibilityHiddenExprHost hiddenExprHostRI, ObjectType objectType, String objectName) at Microsoft.ReportingServices.ReportIntermediateFormat.TablixMember.EvaluateStartHidden(IReportScopeInstance romInstance, OnDemandProcessingContext context) at Microsoft.ReportingServices.ReportIntermediateFormat.TablixMember.ComputeStartHidden(RenderingContext renderingContext) at Microsoft.ReportingServices.ReportIntermediateFormat.Visibility.ComputeHidden(IVisibilityOwner visibilityOwner, RenderingContext renderingContext, ToggleCascadeDirection direction, Boolean& valueIsDeep) at Microsoft.ReportingServices.ReportIntermediateFormat.TablixMember.ComputeHidden(RenderingContext renderingContext, ToggleCascadeDirection directio

Please advise. Thank you...Ken

06-22-2010, 4:56 PM 244882 in reply to 244864

aske012
Joined on 03-30-2010
Posts 2,642

Re: Aspose Words for SSRS SQL2008R2 - Error

Hi Ken,

Could you please attach your .RDL reports here for testing and possibly the data source or a simplified version of the data source you are using for testing purposes.

The developer responsible for Aspose.Words Reporting Services will take a look at this issue shortly.

Thanks,

Adam Skelton
Programming Writer
Aspose Auckland Team

06-23-2010, 12:00 PM 245074 in reply to 244864

LordoftheRink
Joined on 06-17-2010
Posts 7

Re: Aspose Words for SSRS SQL2008R2 - Error

Attachment: Present (inaccessible)

Hello,

Per your request I have attached the report. There are multiple datasets in this report that are filled from stored procedures. If necessary, I will send those as well.

It appears that this problem only occurs with hidden expressions in tablix objects that hide the tablix if countrows()=0 and the dataset is empty.

I hope this helps. Please let me know if you need any more information. Thank you....

Ken

06-23-2010, 2:12 PM 245109 in reply to 244864

LordoftheRink
Joined on 06-17-2010
Posts 7

Re: Aspose Words for SSRS SQL2008R2 - Error

After further evaluation we discovered that this error occurs when a hidden row/tablix expression references a field item that is not associated with the bound dataset.

06-25-2010, 1:09 AM 245371 in reply to 245109

alexey.noskov
Joined on 10-08-2007
Posts 18,308

Re: Aspose Words for SSRS SQL2008R2 - Error

Thank you for additional information. Your request has been logged in our defect database. The developer, who is responsible for Aspose.Words for Reporting Services will answer you shortly.

Best regards.

Alexey Noskov
Developer/Technical Support
Aspose Auckland Team

09-03-2010, 4:10 AM 256940 in reply to 245109

DmitryV
Joined on 02-27-2005
Posts 4,404

Re: Aspose Words for SSRS SQL2008R2 - Error

Hi,

Does the error occur when rendering to Word formats or to other (built-in) formats as well? The point is, judging by the stack trace and the origin of the error, it seems like Aspose.Words has nothing to do with the issue.

Thanks.

Dmitry Vorobyev
Fields and Reporting Team Leader
Aspose Auckland Team