drudini11

Been trying to setup the Sample: Google Map Dashboard as outlined in http://community.jaspersoft.com/wiki/creating-interactive-dashboards-using-javascript but get an error whenever I launch the dashboard. The google map itself renders in the left of the screen but the main report throws the following error: java.lang.IllegalStateException: Exception occurred rendering view org.springframework.web.servlet.view.JstlView: name 'modules/dashboard/dashboardViewer'; URL [/WEB-INF/jsp/modules/dashboard/dashboardViewer.jsp] I have repeated the steps a few times and always get the same result. I am trying to run this in Jasperserver 5.5 Professional. Just curious if anyone else has been able to implement this in version 5.5. Thanks

Wondering if you ever got this resolved? We are running into the same issue using 5.5. Works with a vanilla jasper install but we have some custom modifications and guessing may be related to thoise but saw your post and was curious if/how you were able to address this.

We have created a multi-select query input control that loads a list of product sizes that are defined as INT(11) in the database. Every other multi-select input control that we have created has been a VARCHAR and in iReport we create a parameter defined as a java.util.Collection and then add the following in the SQL script. $X{IN, AssetDimensionAssetView.AssetPrefix, assetPrefix} This works fine when used with a VARCHAR but when trying to use the same format above on the INT values it only retuns the 1st value in the list. So if the list box had values of 20,40,48,53,65 and the user selected all values the query would still only return where value = 20. I'd rather not make a database change to define this field as a varchar as it truly is an interger value but trying to determine how we can get this inoput control based on an INT to pass an INT to the database. Any suggestions would be welcome. I have triied changing the Parameter Class as well as tweekng the $X statement in the SQL but can't find anything that works. Thanks, Bob

We made a copy of DefaultParametersForm.jsp in 4.5 to add some customization to the Input Controls Frame. Upgraded to 4.7 and looks like Jasper completely refactored the code for this DefaultParametersForm.jsp. We are trying to determine where the logic that used to reside within DefaultParametersForm.jsp has moved to so we can look to try and recreate our custom jsp. Does anyine know what file(s) may now contain the code that used to reside with DefaultParametersForm.jsp? Not even sure if it's as simple as the code haveing been migrated to a new location but looking for some direction on this so any feedback would be appreciated.

**AS INFO** This has formally been identifed as a DEFECT in 4.2.1 by Jasper Support (Defect#25541) and a fix is expected shortly.

I have some OLAP Client connections with Access Grant Schemas working in 4.1 applying filters based on JIProfileAttributes. Installed 4.2.1 onto a seperate server and loaded same OLAP connections / schemas and setup users and profile attributes same as well but in 4.2.1 it appears that the Access Grant Schema is simply being ignored and users can see all data. I have repeated these steps numerous times in both 4.1 and 4.2.1 making sure I was doing the exact same steps and definately something going on in the 4.2.1 install. The profile attributes are correctly working for the same users when accessing domains with security applied, just not when creating ad-hoc reports via the OLAP connection. Are there any known issues with the OLAP security grants not working in 4.2.1? Post Edited by drudini11 at 11/08/2011 22:31

Trying to support a security model within Jasper. The basic concept is that some users can view data for say multiple companies and often will analyze these companies side by side. When viewing for Company X they will see data perwsisted in all the available measures in the cube. When viewing for Company Y they will see data for all but 1 measure........that final measure we want to make the value appear as 0 or Blank. So let's say there are 2 measures in the cube called sales and revenue and one dimension called Company. If Company = Company X then the user would see data appearing in both the sales and revenue columns. If Company = Company Y then they would see the sales numbers but revenue would appear to them as blank. I have not been able to find any good examples of this type of security being done and was wondering if it can be accomplished either within the MDX code or in the access grant for the cube. Any feedback you may have that might point me in the right direction would be greatly appreciated.

Have constructed a basic crosstab report via the ad-hoc reproting tool. Crosstab is retuning a sum of sales by Region, State and City across Quarters. Is there anyway to display headers along the side for the Region, State and City.....by default these headers are not generated. For some reports the information may be intuitative enoght where these headers are not needed but there will be cases where I want to display these to the user when the report is run so they are not left the task on interpeting these. Is this possible via some xml config change on the back-end?

In 4.2 I have created an ad-hoc report over an OLAP connection. I saved the report to my jasperserver repository and want to add this as a section to a dashboard. When I attempt to drag this report to the dashboard frame in jasperserver the report doesn't display and I just get the spinning arrow like it's trying to process something and seems to just get hung up there. Is it even possible to add an OLAP report into a dashboard frame in 4.2? BTW....had tried with 4.1 and the behavior was a bit different.....added the report but brought the entire jasper UI into the dashboard frame along with it rather then just the report itself.

Looking for some general feedback regarding report development in ireport using SQL data source vs domain data source. As a report developer using domains as a data source seems limited and cumbersome to work with as it requires using the DomEL syntax as opposed to SQL which most of our report developers are very familiar with and provides some greater flexibility. Problem with using and SQL datasource is that you can't take advantage of the row/column level security that is pretty easy to setup in the domains. Seems like if you want to go down the road of using SQL you would need to embeed your security directly in the database (in our case MySQL) and there would not be anything within Jasper that you could take advantage of for this purpose. Just wanted to get a feel from ther community about how you enforce data security within jasper if developing reports in iReport using SQL vs Domains.

Is there a good way to identify dependent objects within the jasperserver? For example........get a listing of every ad-hoc report that is utilizing a specific domain? I am assuming that I may be able to construct some queries over the jasper repository database to identify these...........curious if anyone has written similar queries for this purpose.

Looked at JasperStudio as an option but unfortunately it doesn't currently have the ability to create a connection to jasperserver for building reports over domains which is a requirement for all our report development. Going to work with the subclipse plugin for iReport and see how to best implement this......

I was able to figure this out.......the target server to which I was importing only had organization_1 setup whereas the source server was setup with multiple organizations and therefore the import couldn't map the objects to their respective organizations. I updated the target server to include all the same organizations that were in the source and reran the import and it worked fine.

I have jasperserver installed on 2 seperate servers (DEV and TEST). I have been working in DEV to create our organizations, roles, users, domains, etc........and now I'd like to migrate these to the TEST server. Eventually we will look to automate this process but for now thought I'd try the js-export and js-import scripts from the buildomatic folder. The export from the DEV box seemed to run fine.......exported everything into a directory named myExport. I copied this myExport folder to the TEST box and ran the following script: js-import --input-dir myExport --update this script runs but doesn't import everything........only updates: see below from command prompt: C:\Program Files\jasperreports-server-4.1\buildomatic>js-import --input-dir myEx port Creating ActionModelService object. Creating action model infrastructure. Tenant organizations already exists, skipping Tenant organization_1 already exists, skipping Role ROLE_USER already exists, skipping. Role ROLE_ADMINISTRATOR already exists, skipping. Role ROLE_ANONYMOUS already exists, skipping. Role ROLE_PORTLET already exists, skipping. Role ROLE_SUPERMART_MANAGER already exists, skipping. Role ROLE_SUPERUSER already exists, skipping. Role ROLE_DEMO already exists, skipping. Role DRAY already exists, skipping. User jasperadmin of tenant organization_1 already exists, skipping. User joeuser of tenant organization_1 already exists, skipping. User anonymousUser already exists, skipping. User CaliforniaUser of tenant organization_1 already exists, skipping. User superuser already exists, skipping. User demo of tenant organization_1 already exists, skipping. Tenant not found with Tenant ID "ca" note that alot of these that were `skipped` are because I had run this a few times and it did at least partially work......I had a new ROLE that I had created in DEV that now appears in TEST......but I am not seeing any of the additional organizations that I setup or datasourses/domains. I am assuming that I must be missing a step in this process. Hoping someone could point me in the right direction. Thanks........

Is it possible to place restrictions to the `Public` folder based on User or Role? I know seems to defeat the purpose.........but we will be placing content into the public folder (data sources and domains) that can be shared by multiple organizations. We are also going to have some users logging into Jasper with `limited` access and functionality......for example one `type` of user will only have the ability to view static content such as PDF and XLS files. For this user type we would like to `Hide` the public folder......or at least hide some of the information in there such as the domains and data sources. Ideally when these users login I'd like to send them to a specific folder in Jasper and that would be the only folder they have access to........any ideas how I amy be able to accomplish this or at least get close to this behavior? Thanks.....

sorry about that....didn't realize I had selected the wrong forum......I copied the post to the jasperserver forum.

We are defining our organizational structure for jasperserver and was hoping to get some feedback on the use of organizations and sub organizations. My company operates on a SAS model so we will have multiple companies (aka Organizations) accessing jasperserver. The data sources and domains these organizations need to access will be common except we would put column/row level security into the domains. My company doesn't want to go the true multi-tenancy` route by setting up seperate domains, topics, etc.....for each organization. the preference would be to have a single high level organization which would be accessed by our jasper admins and then have all the other companies (organizations) setup as sub-organizations under the parent with each having permissions to access the parent's data sources/domains. I have been playing around with this model a bit but it seems that a sub-organization does not inherit all the objects of the parent. If logged in as a sub-org I can't see for example the data source or domain folder that resides under the parent org. I tried copying these folders to Public where they bercome visible but then when attempting to access one to build an ad-hoc I get a multi-tennancy error that staes 'you cannot access resources which do not belong to your organization'. I alse tried copying the domain and data source folders under the sub-org but get the same error so it appears that when the domain weas created under the parent org it doesn't assign permissions to any level lower? Hopefully this makes some sense.....if anyone has run into a similar requirement I'd be interested in how you handled it in your environment........any feedback would be greatly appreciated.

We are defining our organizational structure for jasperserver and was hoping to get some feedback on the use of organizations and sub organizations. My company operates on a SAS model so we will have multiple companies (aka Organizations) accessing jasperserver. The data sources and domains these organizations need to access will be common except we would put column/row level security into the domains. My company doesn't want to go the true multi-tenancy` route by setting up seperate domains, topics, etc.....for each organization. the preference would be to have a single high level organization which would be accessed by our jasper admins and then have all the other companies (organizations) setup as sub-organizations under the parent with each having permissions to access the parent's data sources/domains. I have been playing around with this model a bit but it seems that a sub-organization does not inherit all the objects of the parent. If logged in as a sub-org I can't see for example the data source or domain folder that resides under the parent org. I tried copying these folders to Public where they bercome visible but then when attempting to access one to build an ad-hoc I get a multi-tennancy error that staes 'you cannot access resources which do not belong to your organization'. I alse tried copying the domain and data source folders under the sub-org but get the same error so it appears that when the domain weas created under the parent org it doesn't assign permissions to any level lower? Hopefully this makes some sense.....if anyone has run into a similar requirement I'd be interested in how you handled it in your environment........any feedback would be greatly appreciated.

We are a recent jasper customer and have started looking at how our development process will work with regard to the iReport development tool. All our other `java` based development is done in the Eclipse IDE where we can check-out and check-in code from a centralized SVN repository. I am trying to figure out the best way to incoorporate iReport into this framework. So for instance lets say that a change request is received for a report that was published to Jasperserver. Ideally we would want to retreive the jrxml source from SVN, make the necessary changes and then commit back to svn where that code will get deployed to integration...test...staging....and eventually production. It would be great if this could all be managed via the iReport IDE but I can't seem to find a way within iReport to check in / check out code with svn. I'd be interested in hearing from some folks about how they are using version control for iReport development. I was hoping to avoid a ton of manual steps in this process but if that can't be avoided then would be nice to know how others have gotten this type of model to work. Thanks, Bob

I'm new to the Jasper community so please feel free to correct me if I'm not understanding this behavior correctly. When a user schedules a job and saves the report output to the repository......lets say a PDF....it appears to insert the PDF into a LONGBLOB field in the database and assigned that record a unique ID and filetype. When the user elects to `View` that PDF via the repository jasper will retreive the object from the longblob and present in the form of PDF. I have two questions regarding this behavior..... 1. Is the report converted to PDF and then inserted into the database or does jasper store the document in a more raw form and convert to PDF coming out of the database? 2. Is it possible to modify any of the java classes and redirect this output to a physical location on the server as opposed to storing the object in the longblob in the database? Again if I am mistaken about where this object is being stored please correct me. Still working my way through all the documentation and learning how everything pieces together. Thanks, Bob

I am in the process of evaluating Jaspersoft for my company. Currently I am looking at the ad-hoc reporting features in the tool and have come across something that I feel should be pretty straight forward but can't seem to find a solution for....I have searched the forums and not come up with anything so thought I'd toss this out to the community. I am building a basic crosstabe report from a domain that I created. The domain has 2 measures (days and counts) and 2 dimensional attributes (Program and Customer). My issue is that if you add 2 measures to the data panel in the crosstab report these meaures are by default stacked....and I want to display these side by side. I can't find any method for performing this and to be honest it seems odd that stacked measures are the default. Other BI tools I have worked with usually default to these appearing side by side (such as with an excel pivot table). The other issue I am finsing is that the crosstab forces you to have both row and column dimensions selected. There are times where I want to create a `pivot` with just side labels and the measures......no dimensional attribute across the top........from what I can tell you can neither save nor run the crosstab unless both the side and top have been defined. I certainly could be just missing something here but I would hope the crosstab functionaity would at least allow for these basic this that can be done in an excel pivot table. Any assistance that you could offer me would be greatly appreciated. I have been working with Hyperion Performance Suite and WebFocus for the past 10 years so the open source tools are a bit new to me and I am fighting with the fact they don't seem as `mature` as the tools I am used to working with. Thanks, Bob