E10: First attempt to print SSRS report - error

#ygrps-yiv-905219887 {font-family:'Times New Roman';font-size:13px;}
We've had this issue on invoicing in particular and had to stop and start reporting services on our SQL box.

-T

On Fri, 24 Apr 2015 10:45:13 -0500, Joe Rojas jrojas@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div id="ygrps-yiv-905219887ygrp-text">
  
  
  <p>Hello,


I believe I have everything setup for E10 to print SSRS reports.
I attempted to do a print preview of the base Order Acknowledgement report but got this error in the System Monitor.
Any idea?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Ice.Core.SsrsReporting.SsrsReportRenderer.Render(SsrsRenderInformationBase renderInformation)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.RenderReportForPreviewOrClientPrint(SysRptLst sysRptLstRow)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.ProcessReportPart(String reportLocation, Action`1 modifySysRptLstRow)
at Ice.Core.RptBase.ReportDatabaseBuilder`1.XMLClose()
at Erp.Internal.OM.SalesOrderAck.RunProcess(Int32 instanceTaskNum, String outputFileName)
at Ice.Hosting.TaskCaller.ExecuteTask()
at Ice.Services.Lib.RunTaskSvc.RunTask(Int32 ipTaskNum)




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:20b2b1.png@b8ad4a66.4ea05476]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]

</div>
 


<div style="color:#fff;height:0;"></div>



--
Using Opera's mail client: http://www.opera.com/mail/
Hello,

I believe I have everything setup for E10 to print SSRS reports.
I attempted to do a print preview of the base Order Acknowledgement report but got this error in the System Monitor.
Any idea?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Ice.Core.SsrsReporting.SsrsReportRenderer.Render(SsrsRenderInformationBase renderInformation)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.RenderReportForPreviewOrClientPrint(SysRptLst sysRptLstRow)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.ProcessReportPart(String reportLocation, Action`1 modifySysRptLstRow)
at Ice.Core.RptBase.ReportDatabaseBuilder`1.XMLClose()
at Erp.Internal.OM.SalesOrderAck.RunProcess(Int32 instanceTaskNum, String outputFileName)
at Ice.Hosting.TaskCaller.ExecuteTask()
at Ice.Services.Lib.RunTaskSvc.RunTask(Int32 ipTaskNum)




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:20b2b1.png@b8ad4a66.4ea05476]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.




[Non-text portions of this message have been removed]
YOu have a problem in your SSRS Hideen Expression for Table 1. Look in SSRS Table.Visibility and see what it says?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 11:45 AM, Joe Rojas jrojas@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>Hello,


I believe I have everything setup for E10 to print SSRS reports.
I attempted to do a print preview of the base Order Acknowledgement report but got this error in the System Monitor.
Any idea?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Ice.Core.SsrsReporting.SsrsReportRenderer.Render(SsrsRenderInformationBase renderInformation)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.RenderReportForPreviewOrClientPrint(SysRptLst sysRptLstRow)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.ProcessReportPart(String reportLocation, Action`1 modifySysRptLstRow)
at Ice.Core.RptBase.ReportDatabaseBuilder`1.XMLClose()
at Erp.Internal.OM.SalesOrderAck.RunProcess(Int32 instanceTaskNum, String outputFileName)
at Ice.Hosting.TaskCaller.ExecuteTask()
at Ice.Services.Lib.RunTaskSvc.RunTask(Int32 ipTaskNum)




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:20b2b1.png@b8ad4a66.4ea05476]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]

</div>
 


<div style="color:#fff;min-height:0;"></div>

Do you mean open this report in SSRS to troubleshoot?
This is the base Epicor report so I wouldn’t expect there to be an issue with the report itself but I can take a look if that’s what you mean.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:7158d3.png@01dd6ffc.4f8ba2cc]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, April 24, 2015 11:49 AM
To: Vantage
Subject: Re: [Vantage] E10: First attempt to print SSRS report - error


YOu have a problem in your SSRS Hideen Expression for Table 1. Look in SSRS Table.Visibility and see what it says?


Jose C Gomez
Software Engineer

T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 11:45 AM, Joe Rojas jrojas@...<mailto:jrojas@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:


Hello,

I believe I have everything setup for E10 to print SSRS reports.
I attempted to do a print preview of the base Order Acknowledgement report but got this error in the System Monitor.
Any idea?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Ice.Core.SsrsReporting.SsrsReportRenderer.Render(SsrsRenderInformationBase renderInformation)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.RenderReportForPreviewOrClientPrint(SysRptLst sysRptLstRow)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.ProcessReportPart(String reportLocation, Action`1 modifySysRptLstRow)
at Ice.Core.RptBase.ReportDatabaseBuilder`1.XMLClose()
at Erp.Internal.OM.SalesOrderAck.RunProcess(Int32 instanceTaskNum, String outputFileName)
at Ice.Hosting.TaskCaller.ExecuteTask()
at Ice.Services.Lib.RunTaskSvc.RunTask(Int32 ipTaskNum)




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291<tel:781-573-0291> | cell: 781-408-9278<tel:781-408-9278> | fax: 781-232-5191<tel:781-232-5191>

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring

[cid:20b2b1.png@b8ad4a66.4ea05476]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
Odd, the error it is throwing appears to be within the SSRS Report itself... specifically the main Tablix1....


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 12:00 PM, Joe Rojas jrojas@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>Do you mean open this report in SSRS to troubleshoot?

This is the base Epicor report so I wouldn’t expect there to be an issue with the report itself but I can take a look if that’s what you mean.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring



[cid:7158d3.png@01dd6ffc.4f8ba2cc]


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]


Sent: Friday, April 24, 2015 11:49 AM


To: Vantage


Subject: Re: [Vantage] E10: First attempt to print SSRS report - error



YOu have a problem in your SSRS Hideen Expression for Table 1. Look in SSRS Table.Visibility and see what it says?


Jose C Gomez
Software Engineer

T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 11:45 AM, Joe Rojas jrojas@...<mailto:jrojas@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:


Hello,

I believe I have everything setup for E10 to print SSRS reports.
I attempted to do a print preview of the base Order Acknowledgement report but got this error in the System Monitor.
Any idea?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Ice.Core.SsrsReporting.SsrsReportRenderer.Render(SsrsRenderInformationBase renderInformation)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.RenderReportForPreviewOrClientPrint(SysRptLst sysRptLstRow)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.ProcessReportPart(String reportLocation, Action`1 modifySysRptLstRow)
at Ice.Core.RptBase.ReportDatabaseBuilder`1.XMLClose()
at Erp.Internal.OM.SalesOrderAck.RunProcess(Int32 instanceTaskNum, String outputFileName)
at Ice.Hosting.TaskCaller.ExecuteTask()
at Ice.Services.Lib.RunTaskSvc.RunTask(Int32 ipTaskNum)




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291<tel:781-573-0291> | cell: 781-408-9278<tel:781-408-9278> | fax: 781-232-5191<tel:781-232-5191>

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring

[cid:20b2b1.png@b8ad4a66.4ea05476]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

</div><span class="ygrps-yiv-1668077174">
 


<div style="color:#fff;min-height:0;"></div>


Can you print other reports?


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 12:12 PM, Jose Gomez <jose@...> wrote:
Odd, the error it is throwing appears to be within the SSRS Report itself... specifically the main Tablix1....


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 12:00 PM, Joe Rojas jrojas@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>Do you mean open this report in SSRS to troubleshoot?

This is the base Epicor report so I wouldn’t expect there to be an issue with the report itself but I can take a look if that’s what you mean.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring



[cid:7158d3.png@01dd6ffc.4f8ba2cc]


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]


Sent: Friday, April 24, 2015 11:49 AM


To: Vantage


Subject: Re: [Vantage] E10: First attempt to print SSRS report - error



YOu have a problem in your SSRS Hideen Expression for Table 1. Look in SSRS Table.Visibility and see what it says?


Jose C Gomez
Software Engineer

T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 11:45 AM, Joe Rojas jrojas@...<mailto:jrojas@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:


Hello,

I believe I have everything setup for E10 to print SSRS reports.
I attempted to do a print preview of the base Order Acknowledgement report but got this error in the System Monitor.
Any idea?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Ice.Core.SsrsReporting.SsrsReportRenderer.Render(SsrsRenderInformationBase renderInformation)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.RenderReportForPreviewOrClientPrint(SysRptLst sysRptLstRow)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.ProcessReportPart(String reportLocation, Action`1 modifySysRptLstRow)
at Ice.Core.RptBase.ReportDatabaseBuilder`1.XMLClose()
at Erp.Internal.OM.SalesOrderAck.RunProcess(Int32 instanceTaskNum, String outputFileName)
at Ice.Hosting.TaskCaller.ExecuteTask()
at Ice.Services.Lib.RunTaskSvc.RunTask(Int32 ipTaskNum)




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291<tel:781-573-0291> | cell: 781-408-9278<tel:781-408-9278> | fax: 781-232-5191<tel:781-232-5191>

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring

[cid:20b2b1.png@b8ad4a66.4ea05476]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

</div><span>
 


<div style="color:#fff;min-height:0;"></div>



I just tried.
I was able to print the base version of a Purchase Order with no problem.

I was wondering, is there a way to reload the SSRS reports?





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:e21022.png@2df2df47.4f9e30a5]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, April 24, 2015 12:12 PM
To: Vantage
Subject: Re: [Vantage] E10: First attempt to print SSRS report - error


Can you print other reports?


Jose C Gomez
Software Engineer

T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 12:12 PM, Jose Gomez <jose@...<mailto:jose@...>> wrote:
Odd, the error it is throwing appears to be within the SSRS Report itself... specifically the main Tablix1....


Jose C Gomez
Software Engineer

T: 904.469.1524<tel:904.469.1524> mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 12:00 PM, Joe Rojas jrojas@...<mailto:jrojas@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:


Do you mean open this report in SSRS to troubleshoot?
This is the base Epicor report so I wouldn’t expect there to be an issue with the report itself but I can take a look if that’s what you mean.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291<tel:781-573-0291> | cell: 781-408-9278<tel:781-408-9278> | fax: 781-232-5191<tel:781-232-5191>

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring

[cid:7158d3.png@01dd6ffc.4f8ba2cc]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>]
Sent: Friday, April 24, 2015 11:49 AM
To: Vantage
Subject: Re: [Vantage] E10: First attempt to print SSRS report - error


YOu have a problem in your SSRS Hideen Expression for Table 1. Look in SSRS Table.Visibility and see what it says?


Jose C Gomez
Software Engineer

T: 904.469.1524<tel:904.469.1524> mobile
E: jose@...<mailto:jose@...><mailto:jose@...<mailto:jose@...>>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Fri, Apr 24, 2015 at 11:45 AM, Joe Rojas jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>> wrote:


Hello,

I believe I have everything setup for E10 to print SSRS reports.
I attempted to do a print preview of the base Order Acknowledgement report but got this error in the System Monitor.
Any idea?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Ice.Core.SsrsReporting.SsrsReportRenderer.Render(SsrsRenderInformationBase renderInformation)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.RenderReportForPreviewOrClientPrint(SysRptLst sysRptLstRow)
at Ice.Core.SsrsReporting.ReportProcessorBase`1.ProcessReportPart(String reportLocation, Action`1 modifySysRptLstRow)
at Ice.Core.RptBase.ReportDatabaseBuilder`1.XMLClose()
at Erp.Internal.OM.SalesOrderAck.RunProcess(Int32 instanceTaskNum, String outputFileName)
at Ice.Hosting.TaskCaller.ExecuteTask()
at Ice.Services.Lib.RunTaskSvc.RunTask(Int32 ipTaskNum)




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291<tel:781-573-0291><tel:781-573-0291<tel:781-573-0291>> | cell: 781-408-9278<tel:781-408-9278><tel:781-408-9278<tel:781-408-9278>> | fax: 781-232-5191<tel:781-232-5191><tel:781-232-5191<tel:781-232-5191>>

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...><mailto:jrojas@...<mailto:jrojas@...>> | www.matsinc.com<http://www.matsinc.com><http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring

[cid:20b2b1.png@b8ad4a66.4ea05476]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Call support, they should have a fix for this.


From: "Joe Rojas jrojas@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, April 24, 2015 11:45 AM
Subject: [Vantage] E10: First attempt to print SSRS report - error

Hello,

I believe I have everything setup for E10 to print SSRS reports.
I attempted to do a print preview of the base Order Acknowledgement report but got this error in the System Monitor.
Any idea?

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix ‘Table1’ contains an error: Input string was not in a correct format.
  at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
  at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
  at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
  at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
  at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
  at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
  at Ice.Core.SsrsReporting.SsrsReportRenderer.Render(SsrsRenderInformationBase renderInformation)
  at Ice.Core.SsrsReporting.ReportProcessorBase`1.RenderReportForPreviewOrClientPrint(SysRptLst sysRptLstRow)
  at Ice.Core.SsrsReporting.ReportProcessorBase`1.ProcessReportPart(String reportLocation, Action`1 modifySysRptLstRow)
  at Ice.Core.RptBase.ReportDatabaseBuilder`1.XMLClose()
  at Erp.Internal.OM.SalesOrderAck.RunProcess(Int32 instanceTaskNum, String outputFileName)
  at Ice.Hosting.TaskCaller.ExecuteTask()
  at Ice.Services.Lib.RunTaskSvc.RunTask(Int32 ipTaskNum)




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:20b2b1.png@b8ad4a66.4ea05476]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.




[Non-text portions of this message have been removed]



------------------------------------
Posted by: Joe Rojas <jrojas@...>
------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:  You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/vantage/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/vantage/join
    (Yahoo! ID required)

<*> To change settings via email:
    vantage-digest@yahoogroups.com
    vantage-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    vantage-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/