How to merge several rows in one with separator

[fsimon]

Hi,

I would like to display several rows of a table in one line on the report. I saw on this topic (http://forum.stimulsoft.com/viewtopic.php?&t=5459) that there's a function to do that :

Code: Select all

{Func.EngineHelper.JoinColumnContent(DataSourceName, "ColumnName", delimiter)}

When i try to use it in a dataBand on my report i get the following exception.
Is this function enabled in Reports.Fx for java ?
Could we use it in the expression area of a text field inside a databand (without data source assigned on it) ?

Many Thanks for your help

Code: Select all

sept. 16, 2014 5:18:16 PM com.stimulsoft.web.servlet.StiServlet runAction
Grave: 
com.stimulsoft.base.exception.StiException: java.lang.RuntimeException: Parser error: The name '{0}' does not exist in the current context, Func, , ,  
	at com.stimulsoft.flex.events.StiAbstractAction.run(StiAbstractAction.java:22)
	at com.stimulsoft.web.servlet.StiServlet.runAction(StiServlet.java:29)
	at com.stimulsoft.web.servlet.StiDesignerFxServlet.processingParam(StiDesignerFxServlet.java:69)
	at com.stimulsoft.web.servlet.StiDesignerFxServlet.processing(StiDesignerFxServlet.java:50)
	at com.stimulsoft.web.servlet.StiDesignerFxServlet.doPost(StiDesignerFxServlet.java:38)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:455)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:536)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: Parser error: The name '{0}' does not exist in the current context, Func, , ,  
	at com.stimulsoft.report.engine.parser.StiParser.ThrowError(StiParser.java:876)
	at com.stimulsoft.report.engine.parser.StiParser.ThrowError(StiParser.java:857)
	at com.stimulsoft.report.engine.parser.StiParser.postProcessTokensList(StiParser.java:1189)
	at com.stimulsoft.report.engine.parser.StiParser.MakeTokensList(StiParser.java:1216)
	at com.stimulsoft.report.engine.parser.StiParser.ParseToAsm(StiParser.java:2238)
	at com.stimulsoft.report.engine.parser.StiParser.ParseTextValue(StiParser.java:2189)
	at com.stimulsoft.report.engine.parser.StiParser.ParseTextValue(StiParser.java:2119)
	at com.stimulsoft.report.engine.parser.StiParser.checkForDataBandsUsedInPageTotals(StiParser.java:2296)
	at com.stimulsoft.report.engine.engineV2.StiRenderProviderV2.Render(StiRenderProviderV2.java:242)
	at com.stimulsoft.report.engine.engineV2.builders.StiReportV2Builder.RenderSingleReport(StiReportV2Builder.java:64)
	at com.stimulsoft.report.StiReport.RenderReport(StiReport.java:1984)
	at com.stimulsoft.report.StiReport.Render(StiReport.java:1884)
	at com.stimulsoft.report.StiReport.Render(StiReport.java:1815)
	at com.stimulsoft.report.StiReport.Render(StiReport.java:1805)
	at com.stimulsoft.report.StiReport.Render(StiReport.java:1790)
	at com.stimulsoft.report.StiReport.render(StiReport.java:1773)
	at com.stimulsoft.flex.StiRenderReportAction.render(StiRenderReportAction.java:17)
	at com.stimulsoft.flex.events.StiRenderReport.process(StiRenderReport.java:33)
	at com.stimulsoft.flex.events.StiAbstractAction.run(StiAbstractAction.java:20)
	... 31 more

[Alex K.]

Hello,

We have added this function in Java version. You can use the following expression:

Code: Select all

{JoinColumnContent(DataSourceName, "ColumnName", delimiter)}

Will be available in the next release in the end of this month.

Thank you.

[fsimon]

Hello,

We have added this function in Java version. You can use the following expression:

Code: Select all

{JoinColumnContent(DataSourceName, "ColumnName", delimiter)}

Will be available in the next release in the end of this month.

Thank you.

Thank you Aleksey

[Alex K.]

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.