Eclipse Plugin Central :: View topic

Error using COUNT(*)

Eclipse Plugin Central Forum Index » Editor » Sunshine Reports

Author

Message

Guest

Post subject: Error using COUNT(*)

Posted: Jun 30, 2004 - 04:42 AM

hi! i get this error whenever i use SQL functions like COUNT() or SUM()

can someone help me?

this is the error

dori.jasper.engine.JRException: Error evaluating report expressions BeanShell script.
Message : In file: eval stream Encountered "( ISUP_ITU_CAUSE . ROWID )" at line 23, column 28.

Line 23 : JRFillField field_COUNT(ISUP_ITU_CAUSE.ROWID) = null;

at dori.jasper.engine.fill.JRBshCalculator.<init>(JRBshCalculator.java:122)

at dori.jasper.engine.design.JRBshCompiler.compileReport(JRBshCompiler.java:124)

at dori.jasper.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:136)

at com.sunshinereports.ui.editors.G.A(Unknown Source)

at com.sunshinereports.ui.editors.SunshineReportsEditor.E(Unknown Source)

at com.sunshinereports.ui.editors.O$2.run(Unknown Source)

at org.eclipse.jface.action.Action.runWithEvent(Action.java:842)

at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:541)

at org.eclipse.jface.action.ActionContributionItem.access$4(ActionContributionItem.java:494)

at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:466)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:82)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:847)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2173)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:1863)

at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2347)

at org.eclipse.ui.internal.Workbench.run(Workbench.java:2330)

at org.eclipse.core.internal.boot.InternalBootLoader.run(InternalBootLoader.java:858)

at org.eclipse.core.boot.BootLoader.run(BootLoader.java:461)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.eclipse.core.launcher.Main.basicRun(Main.java:299)

at org.eclipse.core.launcher.Main.run(Main.java:765)

at org.eclipse.core.launcher.Main.main(Main.java:599)

Guest

Post subject:

Posted: Aug 16, 2004 - 04:16 AM

Try to write your sql statement as :
select cust_id, COUNT(*) AS orders from Orders group by cust_id having count(*) >=2

and use as field declaration 'orders'

Guest

Post subject: Re: Error using COUNT(*)

Posted: Jun 22, 2005 - 10:16 AM

铃声铃声下载下载铃声手机下载铃声手机铃声下载手机铃声免费铃声下载免费铃声手机铃声免费下载免费手机铃声三星手机铃声下载彩信免费彩信免费彩信下载彩信下载彩信铃声彩信铃声下载彩信图片下载手机彩信下载彩信动画图片待机图片 [/quote]铃声铃声下载手机铃声下载手机铃声免费铃声下载免费铃声手机铃声免费下载三星手机铃声下载和弦铃声诺基亚铃声下载诺基亚铃声诺基亚手机铃声和弦铃声三星铃声铃声下载 371m彩信 midi铃声 midi铃声下载特效铃声下载原唱铃声 qq铃声 mp3手机铃声诺基亚3100铃声下载联想手机铃声下载原唱铃声下载移动铃声下载铃声下载单音铃声搞笑铃声 mid铃声下载手机特效铃声单音铃声下载和弦铃声手机铃声图片下载手机特效铃声下载短信铃声移动手机铃声下载手机和弦铃声 cect手机铃声下载彩信铃声诺基亚3120铃声下载和旋铃声下载原声铃声下载铃声图片诺基亚免费铃声下载免费和弦铃声下载免费mp3铃声下载免费和弦铃声三星铃声免费下载免费mp3铃声诺基亚免费铃声手机铃声免费下免费铃声图片下载免费特效铃声下载免费三星手机铃声 midi铃声免费下载三星免费铃声免费手机和弦铃声诺基亚3100免费铃声和弦铃声下载 mp3铃声下载 mp3手机铃声手机mp3铃声下载三星手机铃声诺基亚铃声诺基亚手机铃声下载诺基亚手机铃声手机特效铃声手机特效铃声下载移动手机铃声下载移动铃声原唱铃声下载手机原唱铃声下载 nokia铃声 nokia手机铃声下载 nokia手机铃声搞笑铃声下载搞笑手机铃声搞笑手机铃声下载免费搞笑铃声下载 nec手机铃声 nec免费手机铃声单音铃声下载手机单音铃声下载手机单音铃声波导手机铃声下载波导铃声下载波导手机铃声 nokia铃声下载 tcl手机铃声下载 tcl铃声下载 tcl手机铃声摩托罗拉铃声下载摩托罗拉手机铃声摩托罗拉铃声联想手机铃声下载联想手机铃声联想铃声下载 lg手机铃声下载 lg手机铃声免费下载 lg手机铃声海尔手机铃声下载海尔手机铃声海尔铃声下载夏新手机铃声下载夏新手机铃声夏新铃声下载托普手机铃声下载托普手机铃声托普铃声下载迪比特手机铃声下载迪比特铃声下载迪比特手机铃声康佳手机铃声下载康佳手机铃声康佳铃声下载 nec手机铃声下载 nec铃声下载松下手机铃声下载松下手机铃声松下手机铃声下载[/url[url=http://yidong256.nease.net/256/yd120.htm] 铃声飞利浦手机铃声下载飞利浦手机铃声飞利浦铃声下载铃声铃声铃声铃声铃声铃声铃声铃声铃声下载手机铃声手机铃声下载免费铃声下载手机铃声免费下载彩信铃声铃声下载手机铃声手机铃声下载免费铃声下载手机铃声免费下载彩信铃声彩信铃声下载手机铃声手机铃声下载免费铃声下载 mp3铃声 mp3铃声下载诺基亚铃声下载免费手机铃声和弦铃声三星铃声下载三星手机铃声特效铃声诺基亚手机铃声下载和弦铃声下载诺基亚铃声下载铃声下载 midi铃声波导手机铃声下载 mp3手机铃声 midi铃声下载诺基亚手机铃声特效铃声下载 tcl手机铃声下载联想手机铃声下载原唱铃声摩托罗拉铃声下载 mp3手机铃声下载移动铃声下载 mid铃声下载 cdma手机铃声下载 mid铃声 nokia铃声下载搞笑铃声 qq铃声原唱铃声下载诺基亚3100铃声下载和旋铃声 nec手机铃声下载单音铃声手机铃声免费下载海尔手机铃声下载单音铃声下载 tcl铃声下载铃声下载

Jump to:

All times are GMT - 6 Hours

Eclipse Plugin Central Forum Index » Editor » Sunshine Reports

	Digg
	EclipseZone
	InfoQ
	JavaLobby
	OnJava
	The Server Side
	SlashDot
	Other

Eclipse Plugins Central

Plugins (1083)

Training and Consulting (44)

EPIC Poll