vsoneta

I got the reason why it's giving me an error as it's not able to execute the @sql so the results set is empty and it gives an error. But how to fix it so that it executes this storeproc. The issue is with the statement; SET @sql = ' SELECT OrderNumber, Line,OrderDate, PickUpDate, ERPDescription,QtyOrdered,ActualPrice,Tax,Department,StoreName,BTFirstName,BTLastName FROM OPENQUERY([hq1svrsql007\website], ''EXEC [hq1svrsql007\website].InSite.dbo.[reporting_StoreOrders] ' + '''''' + convert(varchar(10),@StoreNo) + ''''''') ' EXECUTE (@sql) Jasperserver is not executing the above sql statement -- basically query for linked server store proc... PLEASE HELP... and it works fine with the ireport PLEASE HELP I AM LIKE STUCK FROM LAST WEEK.. PLEASE

I digged more into the error and found that it also give this error : The statement did not return a result set. Please help

I digged more into the error and found that it also give this error : The statement did not return a result set. Please help

Do I need extra jar or anything do to do with OPENQUery.. Please help me...

Here is the sql 2000 query to call SQl 2005 sql server's store proc. Mind this is working fine when I execute the sql is sql 2000 server and also in ireport, it's just not in Jasperserver ? USE [Reporting] GO /****** Object: StoredProcedure [dbo].[reports_CurrentStoreOrders] Script Date: 10/23/2009 10:55:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[reports_CurrentStoreOrders] @StoreNo as varchar(10) AS BEGIN SET NOCOUNT ON; DECLARE @sql varchar(8000) SET @sql = ' SELECT OrderNumber, Line,OrderDate, PickUpDate, ERPDescription,QtyOrdered,ActualPrice,Tax,Department,StoreName,BTFirstName,BTLastName FROM OPENQUERY([hq1svrsql007\website], ''EXEC [hq1svrsql007\website].InSite.dbo.[reporting_StoreOrders] ' + '''''' + convert(varchar(10),@StoreNo) + ''''''') ' EXECUTE (@sql) END

Here is the sql 2000 query to call SQl 2005 sql server's store proc. Mind this is working fine when I execute the sql is sql 2000 server and also in ireport, it's just not in Jasperserver ? USE [Reporting] GO /****** Object: StoredProcedure [dbo].[reports_CurrentStoreOrders] Script Date: 10/23/2009 10:55:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[reports_CurrentStoreOrders] @StoreNo as varchar(10) AS BEGIN SET NOCOUNT ON; DECLARE @sql varchar(8000) SET @sql = ' SELECT OrderNumber, Line,OrderDate, PickUpDate, ERPDescription,QtyOrdered,ActualPrice,Tax,Department,StoreName,BTFirstName,BTLastName FROM OPENQUERY([hq1svrsql007\website], ''EXEC [hq1svrsql007\website].InSite.dbo.[reporting_StoreOrders] ' + '''''' + convert(varchar(10),@StoreNo) + ''''''') ' EXECUTE (@sql) END

Hello, I have created a jrxml which is very simple, takes one input parameter and passes the information to the SQL 2000 select query which calls 2005 sql database and displays the values. In Ireport when I click Preview it executes perfectly fine and my results gets displayed. But when I create the Report unit with the above jrxml and when I run this it gives me an error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : WebIntranetStoreOrdersReport at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) I make it sure my input has data to be displayed. This is happening only in Jasperserver. Please help.

Hello, I have created a jrxml which is very simple, takes one input parameter and passes the information to the SQL 2000 select query which calls 2005 sql database and displays the values. In Ireport when I click Preview it executes perfectly fine and my results gets displayed. But when I create the Report unit with the above jrxml and when I run this it gives me an error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : WebIntranetStoreOrdersReport at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) I make it sure my input has data to be displayed. This is happening only in Jasperserver. I have attached the jrxml Please help.

2) Show a blank line after TR=43 Added a logic to display a dotted line <line> <reportElement x="0" y="27" width="800" height="1"> <printWhenExpression><![CDATA[new Boolean(($F{TR}.toString()).equals( "43"))]]></printWhenExpression> </reportElement> <graphicElement> <pen lineStyle="Dotted" lineColor="#000000"/> </graphicElement> </line> Attached with the latest code that has answers to the questions

1) But still now logic to calc to SUM of the rows of that column expect the row that has TR=43 Changed Varuable expression of the the variable properties: <variableExpression><![CDATA[(!(($F{TR}.toString()).equals( "43"))?$F{Product}:null)]]></variableExpression> 2) Show a blank line after TR=43 STILL DON"T KNOW-- PLEASE HELP 3) Each new group should start in new page.. In Group Header selected the propertie: <group name="STR#" isStartNewPage="true"> The latest code is attached

what if I don't want else then ? I am getting an error if I have it ($F{TR}!=43 ?$F{Product}) What should be the extact syntax

I Got the total to display after each group based on STR# -- Using Group by when creating jrmxl. 1) But still now logic to calc to SUM of the rows of that column expect the row that has TR=43 2) Show a blank line after TR=43 3) Each new group should start in new page...

Hello, I need help.. I have query that returns this coulumns -- TR, STR#, Date, Product,Supplu,Allow, total RT,WH orderby STR# and WH So the records would be 43, 0602, 09-01-2009, 120945.36,0.00,0.00,120945.36 ,00,00 12, 0602, 09-01-2009, 17.16,0.00,.51,21.54,01,01 12, 0602, 09-01-2009, 17.16,0.00,.51,21.54,01,01 12, 0602, 09-01-2009, 17.16,0.00,.51,21.54,01,01 43, 0605, 09-01-2009, 120945.36,0.00,0.00,120945.36 ,00,00 12, 0605, 09-01-2009, 17.16,0.00,.51,21.54,01,01 12, 0605, 09-01-2009, 17.16,0.00,.51,21.54,01,01 12, 0605, 09-01-2009, 17.16,0.00,.51,21.54,01,01 .... So now in Ireport 1) it should a 2 blank rows as soon it TR =='43' and then continue 2) Should give the totals as soon as the previous ST# is not equal to next STR# Vertical which doesn't include row which is TR ==43 3) Once the above 2 is done then new group should start in new page. For eg the above will be shown as TR STR# Date Product Supply Allow total RT WH 43 0602 09-01-2009 -120945.36 0.00 0.00 120945.36 00 00 12 0602 09-01-2009 17.16 0.00 .51 21.54 01 01 01 0602 09-01-2009 17.16 0.00 .51 21.54 01 01 73 0602 09-01-2009 17.16 0.00 .51 21.54 01 01 * TOTAL * 51.48 0.00 1.53 53. 01 NEXT PAGE: TR STR# Date Product Supply Allow total RT WH 43 0605 09-01-2009 -120945.36 0.00 0.00 120945.36 00 00 12 0605 09-01-2009 17.16 0.00 .51 21.54 01 01 01 0605 09-01-2009 17.16 0.00 .51 21.54 01 01 73 0605 09-01-2009 17.16 0.00 .51 21.54 01 01 * TOTAL * 51.48 0.00 1.53 53. 01 Please suggest as to how this can be implemented

Hello, I need to schedule a report that send an email only when that file exist in other server location. Can this be possible in Jasperserver. Scheduler should only trigger based on the file availablity in that location?

Hello, But that's not good as Once I am done testing in ireport then I have to change the file to "repo:subreportname". the subreport should work same in irreport and jasperserver. Am I doing something wrong that I have to change everytime I deploy to jasperserver. In Ireport my subreportexpression is : $P{SUBREPORT_DIR}+"Users_jrxml_ContractsARRpt_Details.jasper" and it runs perfectly fine in ireport. But when I deploy the same jrxml with subreports it gives me cannot load from that location : .\Users_jrxml_ContractsARRpt_Details.jasper. After reading this thread I changed subreportexpression to "repo:Users_jrxml_ContractsARRpt_Details.jrxml" and then then created a report unit in UI of jasperserver and it worked fine, it found all the subreports as a resources and ran perfectly fine. But when I open the changed report on ireport, gives me error, cannot load from that location: repo:Users_jrxml_ContractsARRpt_Details.jrxml. So this means I have keep on changing if I need to test in jasperserver or in ireport. Please let me know if I am missing something or it has to be like this...