ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Subscriptions with charts (PDF/Excel)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbooth

United Kingdom
69 Posts

Posted - 04/17/2014 :  01:58:07  Show Profile  Reply with Quote
RP version 186. A subscription of a report containing a chart and table only emails the table. Applying the fix in the Help / Administration / Schedules / Charting Support help text has no effect.

Regards
Dave Booth

admin

1635 Posts

Posted - 04/17/2014 :  02:08:40  Show Profile  Reply with Quote
You have to install Report Portal 4.0 for .NET 4.0. .NET 2.0 does not have the charting component needed to include the chart.

Alternatively, you can follow these instructions: http://www.reportportal.com/help/scheduler/Charting.htm
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 04/17/2014 :  03:29:48  Show Profile  Reply with Quote
That's what was done. To test it, a report with just a table was subscribed and that worked; then a chart added, subscription failed with this error dump :

A chart element with the name 'acro' already exists in the 'SeriesCollection'.
at System.Web.UI.DataVisualization.Charting.ChartNamedElementCollection`1.InsertItem(Int32 index, T item)
at System.Collections.ObjectModel.Collection`1.Add(T item)
at RpScheduler.RpChart.MakeMultiChart(Chart& oChart, XmlNodeList& oRows, Int32 iRow, XmlNamespaceManager& nsMgr, Hashtable& oCellArray, Int32 iColumnTuples, Boolean bCommaDecSeparator, XmlNodeList& oColumns, Hashtable& oMinLevelCols)
at RpScheduler.RpChart.MakeChart(XmlDocument& oDoc)
at RpScheduler.XmlaRequest.ExecuteMdx(String sMdx, String sServer, String sCatalog, String sURL, String sOptionXml, String sConditionalFormat)
at RpScheduler.XmlaRequest.GetReportHtml(String sReportId, String sUserId, String sJobId)
at RpScheduler.Scheduler.ProcessReport(String sReportId, String sReportType, String sJobId, String sDeliveryType, String sContentType, String iLanguageId, String sToUserId, String sToUserName, String sToEmail, String sToNtUserId, String sToNtPassword, String sConditionOperator, String iConditionRow, String iConditionCol, String sConditionValue, String sMultiCondition, String& sMultiConditionOut, String& sStylePage, String& sReportHtml, String& sError, String& sMDX, String& sReportDesc, String& sFilterLabel, Boolean& bConditionMet, String& sStyleThemeId, String sReportName, String sTempPath, String& sFilePath, String sXmlaProperties); XMLA: http://frenzy.fusion-group.net/xmla/msmdpump.dll; NtUserId: FUSION-GROUP\dbooth
Go to Top of Page

marco

Netherlands
588 Posts

Posted - 04/17/2014 :  04:49:42  Show Profile  Reply with Quote
Is the error with .Net 2.x or 4.x ?

Marco
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 04/17/2014 :  04:59:21  Show Profile  Reply with Quote
Marco,

The server has .NET version 4.0.30319.

Regards
Dave
Go to Top of Page

admin

1635 Posts

Posted - 04/17/2014 :  05:01:44  Show Profile  Reply with Quote
Does the source table have two rows with the same row header ‘acro’?
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 04/17/2014 :  05:13:29  Show Profile  Reply with Quote
Yes, 'acro' is a value of the User attribute in the MDX below and appears twice as it belongs to a Company hierarchy with 'acro' having two differing parent attributes :

Select non empty Crossjoin(NonEmptyCrossjoin({
Descendants([Sales Order Details].[Quotation Status].[All])}),{
[Measures].[Number of Orders]}) on columns,
non empty NonEmptyCrossjoin(
[Sales Order Details].[User].Members) on rows
From [Order Intake]
Where ([Sales Order Details].[Order Type].&[Quotation], [Ordering Division].[Divisions by Code].[All])
CELL PROPERTIES CELL_ORDINAL, VALUE, FORMATTED_VALUE, FORE_COLOR, BACK_COLOR
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 04/17/2014 :  05:23:42  Show Profile  Reply with Quote
Update, when the User attribute is made unique by filtering on the parent hierarchy, the subscription errors with message 'Empty path name is not legal.'.
Go to Top of Page

admin

1635 Posts

Posted - 04/17/2014 :  12:08:09  Show Profile  Reply with Quote
Can you please provide the full error description for “Empty path name is not legal”? What is the MDX?
Go to Top of Page

admin

1635 Posts

Posted - 04/21/2014 :  23:44:52  Show Profile  Reply with Quote
Please try this hot fix:

1. Download and unzip: http://www.reportportal.com/download/rp_net4_186_RpScheduler.zip
2. Stop RP Scheduler service
3. Backup old file and copy the unzipped file to: C:\inetpub\wwwroot\ReportPortal(_186)\binRpScheduler.exe
4. Start RP Scheduler service
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 04/22/2014 :  02:32:58  Show Profile  Reply with Quote
That patch has fixed PDFs, thank you. They are now included in subscriptions where the Content Type is PDF. Where Excel or HTML is selected, the subscription sends an email header with no attachment, not a problem since PDF is functional.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page