neilelliott

Thanks for the help on this also. Had me stumped for a while.But after fixing this, I am still having issues with custom images not being copied to the respective folders in the sub-organisation themes. Any ideas on this (suppose I really should raise another case..) Post Edited by neilelliott at 10/11/2011 10:16

Thanks for the reply. Been on a long vacation so not been able to respond until now.. This is exactly the route I've taken and have created my own datasource following the examples given (just hadn't got around to updating this forum). fyi the XML document I wanted to point at was actually a Jasper Domain file. This can be accessed using the repository service. From all of this I've created a Domain report, describing the Jasper domain strucuture, mappings, descriptions and so on - turns out to be very useful for cataloging the domain.

I'm sure you can though haven't done so myself.. Take a look at the JasperServer Administrator Guide document regarding creating custom datasources.

You can output the internal orgnanization ID (tenant ID) for the logged in user. You can do this in iReport by selecting the 'Domain Parameters' element and dragging it to the report. You are then presented with a list of default input parameters. Select the ones you're interested ie LoggedInUserTenantId, and these are added to the available parameters seen in the report explorer. Then just drag this onto the report like any other parameter. Unfortunately this is not the company alias nor company name. You could maybe expand on the Jasper classes/Spring configuration to add these to the report, or use the 'LoggedInUserTenantId' as a lookup to get the actual value from a DB table. Hope this is at least a start. Neil

Hi Nichole Two ways of doing this :- I do this using ANT scripts - which could be called from a shell script. You need to look at the documentation around buildomatic which comes with Jasper. It basically is a bunch of ANT scripts for manually building/installing yourself such as ANT targets for creating and populating tables in the DB. Take a look at the JasperServer Install Guide and Installing from WAR File Distribution for more information. Or :- Take a look at the js-import/js-export command line tools for exporting/importing. You would need to use js-export anyway to export your reports to be able to install/import them. Cheers - hope this helps Neil

I've created a report which uses an XML Datasource and I want to deploy this to JasperServer so that people can run and view it. I cannot see how to do this as at the moment it looks like you can only deploy a report against a DB Datasource (JDBC or JNDI) or a Bean datasource. Can it be done and if so how ? Currently using JasperServer 3.7.1 and iReport 3.7.1.1 Thanks

Hi I am looking to generate user documentation from a JasperServer domain schema, showing the schema structure, fields, description of each field/folder and the tables & columns they map to. All this information is held schema xml file itself, so it should all be possible to do, probably using XSLT to convert to HTML. I was just wondering whether there was such a tool already that did this or similar ? Regards

Found the answer. Specifying viewAsDashboardFrame=true removes the menu bars & export icons.

Hi I'm creating a report to be used solely as a dashboard component which gives the user the option to switch between 2 different bar charts. I've implemented this by using subreports where each sub-report is the individual bar chart, and the main report has a parameter passed into it to signify which one to display. The subereport element expression has a condition to load the correct report depending on parameter passed in. On the main report are 2 textfields with hyperlinks pointing back to the same report (using the ReportExecution hyperlink type), so each textfield call the parent report but with different values for the hyperlink. All works well when viewing as report ! But when dropped as a dash, initially I just see the default chart. Clicking on the hyperlink, suddenly I get the menus and export option icons. After some digging around I can see that passing in 'decorate=no' as a hyperlink parameter will remove the menu bars. But I cannot see anything to remove the export options. Anyone able to help ? Thanks, Neil

Hi Matt As we have a license of Pro I've raised both enhancements with Jasper support, assuming that these will make it to the tracker. Thanks again. Neil

Hi Matt Thanks for the information. This does the job perfectly along with using a subdataset for the pie chart Just one query, and that is is it possible to use a parameter or variable to determine the maximum number of slices to show, so that it can be changed at runtime ? My requirement is to run a report to show the Top X of something, and then to show a pie chart to show the Top x relative to the rest. ? I've looked at the jrxml and see that the maximum slices is specified as the 'maxCount' attribute... I've tried specifying this using $P{..} etc.. but it doesn't seem to work. Also, looking at the Charts Pro Pie Chart, is there a similar option to limit the number of slices - there doesn't seem to be ? Regards Neil Post Edited by neilelliott at 03/22/2011 10:39 Post Edited by neilelliott at 03/22/2011 10:39

Hi Matt I'm trying to do something similar to this but I want to display the result as a pie chart ie show the top N records as separate 'slices' and group together the remainder in it's own slice. I see how you've done this with a table in that in the details, you are using the print when expression to tell it to stop printing after a certain point. But have you any tips how to do this in a Pie Chart ? Thanks Neil Post Edited by neilelliott at 03/21/2011 09:55

I've resolved the problem. The answer was quite straightforward, in that you just provide the parameter name in the query string, without the need for specifying $P{parameter1} Note also that the query value in the 'queryFilterString' is in DomEL, so you can use groovy or your own custom functions for specifying the query - see JasperServer User Guide, section 7.2 The DomEL Syntax, and Using Groovy in a filter Expression Example domain query using parameters and DomEL <query> <queryFields> <queryField id="PM.CompanyDescription"/> <queryField id="PM.CompanyCode"/> <queryField id="PM.SupplierDetails.SupplierCode"/> <queryField id="PM.SupplierDetails.SuppliedName"/>... <queryField id="PurchaseOrderProcessing.PurchaseOrders.Location"/> <queryField id="PurchaseOrderProcessing.PurchaseOrders.OrderCreateUser"/> <queryField id="PurchaseOrderProcessing.PurchaseOrders.Element"/> <queryField id="PurchaseOrderProcessing.PurchaseOrders.DocumentIndicator"/> <queryField id="PurchaseOrderProcessing.PurchaseOrders.OrderStatus"/> </queryFields> <queryFilterString> PurchaseOrderProcessing.PurchaseOrders.DocumentIndicator == 'O' and contains (PurchaseOrderProcessing.PurchaseOrders.OrderStatus,'0') and PurchaseOrderProcessing.PurchaseOrders.CreateDate <= Date( parameter1 ) </queryFilterString></query>[/code]Post Edited by neilelliott at 03/14/2011 09:17

I am using iReport to build reports against a domain I've created on JasperServer. When building the report Jasper creates a domain query in XML, based on what fields and filters you've chosen in the GUI. But iReport also gives you the facility to manually edit the query (like you can with SQL queries, and other languages) I'd like to know more about what else you can specify in the query language xml. For example, I know that there is an 'expression' attribute on the <queryfield> element but I'm not aware of what types of expressions you are allowed to specify in there. Can anybody point me to any documentation on what commands/elements/attributes are availabe in domain query language. Thanks example of the query language format :- <query xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema"> <queryFields> <queryField id="PM.SupplierDetails.CodeandName" /> <queryField id="PurchaseLedger.Transactions.AmountPaid" /> </queryFields></query><queryfilterstring>...</queryfilterstring>[/code]Post Edited by neilelliott at 03/09/2011 13:23

I'm wanting doing this as well.. Is there a base class you must inherit from (like scriptlets) or other general rules/best practise about adding functions? Is there any documentation on this subject ? Thanks Neil