Report 2C : How to "Know" the Data

Mike,

My SQL returns rows with GROUP BY Cycle, DataCenter. Ok.

There are 6 Datacenters in all. So each cycle will (can) have data for those datacenters (Max 6 rows per Cycle). Now

My Report should look like this

Cycle M1 M2 M3 M4 M5 M6

How do I look at each row (for a cycle) amd move the counts under each column.

Basically, 6 rows in SQL will end up a 1 row on the report.

How do I do that in BIRT?

Find more posts tagged with

Comments

mwilliams

Hi Nurani,

So your data comes in something like the following?

Cycle | Datacenter
C1 | M1
C1 | M2
C1 | M3
C1 | M4
C1 | M5
C1 | M6
C2 | M1
C2 | M2
C2 | M3
... | ...
... | ...
etc....

Let me know.

nuraniuscc

Yes, That's Right.

I'll have max of 6 rows per cycle, but all those values should go under 1 row on the Report.

Thanks

mwilliams

Nurani,

Here is a report design that will list the datacenters horizontally in a row next to the cycle. Is this what you're looking for? Or would you like the datacenters in actual columns? Let me know.

This design was made in BIRT 2.3.0

nuraniuscc

Hi Mike,

I copied this into my workspace and clicked on "Preview". I got the following error message. Looking for something in your C: Drive.

An exception occurred during processing. Please see the following message for details:Cannot open the connection for the driver: org.eclipse.datatools.connectivity.oda.flatfile.Cannot open flat file database under directory: C:Documents and SettingsmwilliamsworkspaceBIRT 2_3BIRT 2_3 at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1107) at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1071) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:88) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:928) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:876) at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:123) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:89) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:159) at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:111) at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:225) at javax.servlet.http.HttpServlet.service(HttpServlet.java:616) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:112) at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:269) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.ServletHandler.dispatch(ServletHandler.java:677) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpServer.service(HttpServer.java:909) at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

mwilliams

Nurani,

My mistake. I forgot to send the .csv file. It is attached. You'll have to open the dataSource in the report design and change the path to point where you have the .csv file saved.

nuraniuscc

Ok, I used the .csv file and I still have the same issue, what I had before. Rather than going back and forth on this, can you explain step by stpe how to
take 6 rows worth of data and stick it to one row on the report.

Also, I need to do an IF condition to make sure that the data pertains to a particular column.

This is the best way to approach this.

Thanks
Nurani Sivakumar

PS :- You have the fake report for this.... Right?

mwilliams

Nurani,<br />
<br />
If you go to the datacenter item in the report I sent you, you can go to the property editor's advanced section and see that the item was set to "inline" rather than "block". This allows for the data to be displayed in a line. If you're wanting the items in specific columns and not just in a straight line, you'll need to do a columnar/parallel type report. You can find an example of how to do that in the devShare here:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/?filtercontent=parallel&contenttype=-1&date=-2year&rating=0&results=10&cid=0'>devShare - Parallel Reports</a>