avu

I'm having the same issue. Can anyone help?

Not sure how you have your reports setup, but if you are using subreport, make sure that you pass in the parameters to the subreport and if you are using subdataset make sure you also pass in you parameters to your subdatasets. This has happened to me many time and it's because I forgot to pass in my input parameters to my subreports or subdatasets. However, if you are trying to pass dates into a store procedure --- I think there is a problem with it at this time. I hope this helps. Ann

Interesting ... I'm having the same problem. I'm trying to pass date parameters into a MySQL store procedure. The dates are select from Jasper Server calendar widget with the date format dd-mm-yyyy; however, it's passing this date format: 'Fri Jul 30 19:00:00 EST 6' to mysql? What's also strange is it's not even the date I selected from the calendar widget? Please help, Ann [file name=dateFormatError.txt size=2288]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/dateFormatError.txt[/file]

let me try it again ... it did not allow me to send a .log file??? [file name=storeProcError.txt size=4878]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/storeProcError.txt[/file]

oops -- let me try the attachment again.

Thanks for responding :) Please see error from jasperserver.log in the attachment --- basically the error only indicate that the dataset is empty and that it did not find the field it needs in the report. Below is the Report Query in my report: call reporting.sp_balance($P{SiteId}, $P{StartDate}, $P{EndDate}); NOTE: This works in iReport. In addition, instead of passing the parameters into the store procedure I actually passed in values into the store procedure (i.e. call reporting.sp_balance(1, '2007-01-01', '2007-03-31'); ) this works. Which implies that Jasper Server can execute MySQL store procedures; however, did not allow parameters to be pass into a store procedure. Hopefully this information is helpful and can help lead us to a solution. Many thanks in advance your you attention to this issue. Please let me know if you need any additonal information. Ann

I think the Jasper Server interface is very nice and provides a lot of GREAT reporting/scheduling functionality. Regarding developing your own webapps interface it really depends on what your users needs. The reason why we needed to develop our own code to interface with the JS repository is because we wanted reports to be integrated with our own web application. (i.e. we did want our users to have to log into another interface/application to access their reports). However, we wanted all of the reports to be stored in a central repository and wanted to take advantage of Jasper Server's scheduling capabilities. Hope this response helpful :) Ann

I was told that you should be able to use the Web Services 1.2 API to get any object from the repository. I haven't gotten a chance to try this yet. I will need to do this soon in the next couples of weeks. I will post an example once I have one working . However, in the interim I was able to run a report and have the PDF return to me as an attachment so our users can view the PDF file without having to log into Jasper Server. Eventually what we wanted to do is schedule a report and just get the PDF output for our users to view/save. Hope this information is helpful. Have a nice day, Ann

Hello, Has anyone been successful in executing a report in JS/JI that calls a MySQL Store Procedure passing it parameters? My report works for iReports but does not work in JS. I have created input controls that has the same name/datatype as the parameters expected in the store procedure. I was able to setup input controls to pass into other SQL queries; however, not been able to pass parameters to a store procedure. Am I missing something here OR is this a BUG? I have been tackling this issue for days, so if anyone has been success in passing PARAMETERS from into a store procedure in the Jasper Intelligence environment please let me know. Many thanks in advance for your response/input. Ann

I have downloaded the lastest version of JasperServer 1.2. I was able to get a ResourceDescriptor for a pdf object from the repository; however, it does not get the pdf file for me. Am I missing something? Please provide sample code if possible. Thanks, Ann

Great news! Thank you very much for your reply :) Could you provide us with a time-frame of when this new set of web services API would be available? It is days, weeks, or months? We desperately need the ability to get/put report outputs to/from JasperIntelligence for the project we are working on -- which is target for release in early April. In addition, when we use the Web Service API to runReport, is there parameters we can set so that the report output (i.e. pdf, html) be automatically be put in the JI repository? Or would we need to do a separate "put" to place the report output in the repository? Many thanks in advance for your time & response. Ann

Please help ... has anyone tried to get or put a pdf file from JasperIntelligence? Can we use Web Services API to do this? Or could we write code to select/insert data directly into the jicontentresource table? Please, please help ... Ann

We would like to be able to export pdf, html or xls files from Jasper Intelligence using Web Services. I've downloaded iReport 1.3 and installed the JasperIntelligence (JI) iReport plugin and noticed that I could not export a PDF file from JI; does this imply that it is not doable using Web Services because the iReport plugin uses web service to get/retrieve object from JI? I've submitted/posted a similar message on the JasperIntelligence and was directed to look at the documentation, which I have downloaded and was successful in running a report, retrieving images, etc ... However, I have not been able to get/retrieve a pdf file which is an object with a type of "Content Resource" from JI. Is this doable? If so please provide some instructions :) Many thanks in advance for your response, Ann

Thanks Sherman for your quick response :) I have reviewed/studied the JI documentation on Web Services and was able to write a java program to list, get and run reports; however, we would like to get a report output (i.e. html, pdf or xls) from the repository. Is this possible? An example/sample code would be helpful. Thanks, Ann

We would like to be able to schedule reports using JI; However, would like to display the output to our users to view using our own web application. Could we do this using the JI Web Services API? If so please provide an example/instruction on how this could be done. I was able to write a java class to list and get the ResourceDescriptor of the pdf/html file I want to view. But, what I'm suppose to do next with the ResourceDescriptor of the report output ...??? Please advise. thanks. Ann

We would like to bypass the JI login process (our users has already been authenticated), is there a way we can pass the username/password into JI and have it go directy into JI? Please advise, Ann